Px Type: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
m Text replacement - "|field_name" to "| CCMDB_tab = CCI |field_name"
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Data element
{{Data element
| CCMDB_tab = CCI
|field_name=Px Type
|field_name=Px Type
|CCMDB_label=Px Type
|CCMDB_label=Px Type
Line 17: Line 18:


=== Cross Checks ===
=== Cross Checks ===
* [[Query check_CCI_Date]]
{{Data Integrity Check List}}


===Related articles ===
===Related articles ===

Latest revision as of 00:41, 3 January 2019

Data Element (edit)
Field Name: Px Type
CCMDB Label: Px Type
CCMDB tab: CCI
Table: L_CCI_Picklist table, L_CCI_Component table
Data type: string
Length: not stated
Program: Med and CC
Created/Raw: Raw
Start Date: 1988-07-11
End Date: 2300-01-01
Sort Index: 10

The type of a CCI Procedure as per CCI Collection, ie admit or acquired

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


Additional Info

Cross Checks

Data Integrity Checks (automatic list)

 AppStatus
Query check CCI Picklist unfilledCCMDB.accdbimplemented
Query check CCI Component unfilledCCMDB.accdbimplemented
Query check CCI Component duplicatesCCMDB.accdbimplemented
Query check CCI Picklist duplicatesCCMDB.accdbimplemented
Query check CCI DateCCMDB.accdbimplemented

Related articles

Related articles: