Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 | ItemID | [dbo].[uniqueid] | 9 | NOT NULL | | Order. Link to Item_Plan.ID, Item_Medication.ID, or Item_Immunization.ID |
 ![Foreign Keys FK_ORder_ABN_Status_ABNIntermediateStatusDE: [dbo].[ABN_Intermediate_Status_DE].ABNIntermediateStatusDE Foreign Keys FK_ORder_ABN_Status_ABNIntermediateStatusDE: [dbo].[ABN_Intermediate_Status_DE].ABNIntermediateStatusDE](../../../../Images/fk.png) | ABNIntermediateStatusDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Status. Link to ABN_Intermediate_Status_DE.ID |
| LMRP | int | 4 | NOT NULL | (0) | Local medical Review policy. Link to AHSCharge.dbo.LMRP.ID |
| PolicyNo | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Policy Number |
| ICD9DiagnosisDEList | varchar(255) | 255 | NOT NULL | ('') | List of ICD9 Diagnosis Dictionary IDs seperated by '~'. Link to dbo.ICD9_Diagnosis_DE.ID |
| CPT4Code | varchar(10) | 10 | NULL allowed | | Current Procedural Terminology code |
![Check Constraints Ch_Order_ABN_Status_ItemType : ([ItemType]='IM' OR [ItemType]='ME' OR [ItemType]='PL') Check Constraints Ch_Order_ABN_Status_ItemType : ([ItemType]='IM' OR [ItemType]='ME' OR [ItemType]='PL')](../../../../Images/c-constraint.png) | ItemType | char(2) | 2 | NULL allowed | ('PL') | IM - Immunization, ME - Medication, PL - Order |
| ICD10DiagnosisDEList | varchar(255) | 255 | NULL allowed | | List of ICD10 Diagnosis Dictionary IDs seperated by '~'. Link to dbo.ICD10_Diagnosis_DE.ID |
| ICD9DiagnosisCodeList | varchar(400) | 400 | NULL allowed | | List of ICD9 Diagnosis Codes seperated by ','. Link to dbo.ICD9_Diagnosis_DE.EntryCode. |
| ICD10DiagnosisCodeList | varchar(400) | 400 | NULL allowed | | List of ICD10 Diagnosis Codes seperated by ','. Link to dbo.ICD10_Diagnosis_DE.EntryCode. |