Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (2) | ID | [dbo].[dict_id] | 5 | NOT NULL | | Key to the OCD_Item table |
 | OCDHeaderID | [dbo].[dict_id] | 5 | NOT NULL | | Header. Link to OCD_Header.ID |
| EntryCode | char(10) | 10 | NOT NULL | | Code |
| EntryName | varchar(255) | 255 | NOT NULL | | Name |
| EntryMnemonic | char(10) | 10 | NOT NULL | | Mnemonic |
 ![Check Constraints CK_OCD_Item_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_OCD_Item_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Inactive (Y/N)? |
![Check Constraints CK_OCD_Item_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y') Check Constraints CK_OCD_Item_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')](../../../../Images/c-constraint.png) | IsEnforcedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | End user modifyable (Y/N)? |
| CreateDTTM | datetime | 8 | NOT NULL | | creation time |
| DisplayName | varchar(255) | 255 | NOT NULL | | Display name |
| ClassPath | varchar(255) | 255 | NOT NULL | | Hierarchy within the OCD |
 | OrderType | varchar(10) | 10 | NOT NULL | | Order Type |
| QOModPicklistID | [dbo].[dict_id] | 5 | NOT NULL | | Modifier Picklist 1. Link to Picklist.ID |
| QOModPicklist2ID | [dbo].[dict_id] | 5 | NOT NULL | | Modifier Picklist 2. Link to Picklist.ID |
| QOModPicklist3ID | [dbo].[dict_id] | 5 | NOT NULL | | Modifier Picklist 3. Link to Picklist.ID |
![Check Constraints CK_OCD_Item_QOModPicklistReq_Yes_Or_No : ([QOModPicklistReq]='N' OR [QOModPicklistReq]='Y') Check Constraints CK_OCD_Item_QOModPicklistReq_Yes_Or_No : ([QOModPicklistReq]='N' OR [QOModPicklistReq]='Y')](../../../../Images/c-constraint.png) | QOModPicklistReq | [dbo].[BOOL] | 1 | NOT NULL | | Is Modifier Picklist 1 required (Y/N)? |
![Check Constraints CK_OCD_Item_QOModPicklist2Req_Yes_Or_No : ([QOModPicklist2Req]='N' OR [QOModPicklist2Req]='Y') Check Constraints CK_OCD_Item_QOModPicklist2Req_Yes_Or_No : ([QOModPicklist2Req]='N' OR [QOModPicklist2Req]='Y')](../../../../Images/c-constraint.png) | QOModPicklist2Req | [dbo].[BOOL] | 1 | NOT NULL | | Is Modifier Picklist 2 required (Y/N)? |
![Check Constraints CK_OCD_Item_QOModPicklist3Req_Yes_Or_No : ([QOModPicklist3Req]='N' OR [QOModPicklist3Req]='Y') Check Constraints CK_OCD_Item_QOModPicklist3Req_Yes_Or_No : ([QOModPicklist3Req]='N' OR [QOModPicklist3Req]='Y')](../../../../Images/c-constraint.png) | QOModPicklist3Req | [dbo].[BOOL] | 1 | NOT NULL | | Is Modifier Picklist 3 required (Y/N)? |
| QOModPicklistDefaultID | [dbo].[dict_id] | 5 | NOT NULL | | Modifier Picklist 1 default entry |
| QOModPicklist2DefaultID | [dbo].[dict_id] | 5 | NOT NULL | | Modifier Picklist 2 default entry |
| QOModPicklist3DefaultID | [dbo].[dict_id] | 5 | NOT NULL | | Modifier Picklist 3 default entry |
| OrderInstructions | varchar(2000) | 2000 | NOT NULL | | Instructions |
| PatientInstructionID | [dbo].[dict_id] | 5 | NOT NULL | | Patient Instruction. Link to OCD_Instruction.ID |
| CPT4Code | varchar(10) | 10 | NOT NULL | | CPT4 Code |
| MedcinID | int | 4 | NOT NULL | | MedcinID. Link to chMedcinsearch.dbo.Search.medcinid |
| LOINCCode | varchar(10) | 10 | NOT NULL | | LOINC Code |
| HICPCSCode | varchar(10) | 10 | NOT NULL | | HICPCS Code |
| UPC | varchar(11) | 11 | NOT NULL | | UPC (Universal Product Code) |
 | SNOMED | varchar(18) | 18 | NULL allowed | | SNOMED Code |
![Foreign Keys FK_OCD_Item_Specialty_DE: [dbo].[Specialty_DE].SpecialtyDE Foreign Keys FK_OCD_Item_Specialty_DE: [dbo].[Specialty_DE].SpecialtyDE](../../../../Images/fk.png) | SpecialtyDE | [dbo].[dict_id] | 5 | NOT NULL | | Specialty. Link to Specialty_DE.ID |
| ReferralTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | ReferralType. Link to Referral_Type_DE.ID |
| Urgency | varchar(10) | 10 | NOT NULL | | Urgency |
| AllscriptsGuidelineID | [dbo].[dict_id] | 5 | NOT NULL | | Guideline. Link to OCD_Guideline.ID |
| gendertoexcludeSEXDE | [dbo].[dict_id] | 5 | NOT NULL | | Gender for whuch this is not applicable. Link to Sex_DE.ID |
| OCDInstructionID | [dbo].[dict_id] | 5 | NOT NULL | | Instruction. Link to OCD_Instruction.ID |
![Check Constraints CK_OCD_Item_AlwaysDisplayDetailFLAG_Yes_Or_No : ([AlwaysDisplayDetailFLAG]='N' OR [AlwaysDisplayDetailFLAG]='Y') Check Constraints CK_OCD_Item_AlwaysDisplayDetailFLAG_Yes_Or_No : ([AlwaysDisplayDetailFLAG]='N' OR [AlwaysDisplayDetailFLAG]='Y')](../../../../Images/c-constraint.png) | AlwaysDisplayDetailFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Always Display the detail form (Y/N)? |
| OIDMode | varchar(30) | 30 | NOT NULL | | Mode (Active or No Longer Used) |
| FirstStringDefault | nvarchar(1024) | 2048 | NULL allowed | ('') | Deault First String for an instruction or Precaution order |
| DDI | int | 4 | NOT NULL | | Drug Description Identifier |
| SpecimenTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | Specimen Type. Link to Specimen _Type_DE.ID |
![Check Constraints CK_OCD_Item_SpecimenTypeReqFLAG_Yes_Or_No : ([SpecimenTypeReqFLAG]='N' OR [SpecimenTypeReqFLAG]='Y') Check Constraints CK_OCD_Item_SpecimenTypeReqFLAG_Yes_Or_No : ([SpecimenTypeReqFLAG]='N' OR [SpecimenTypeReqFLAG]='Y')](../../../../Images/c-constraint.png) | SpecimenTypeReqFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Is Specimen Type required (Y/N)? |
| SpecimenTypePickListID | [dbo].[dict_id] | 5 | NOT NULL | | Specimen Type PickList. Link to PickList.ID |
| SourcePickListID | [dbo].[dict_id] | 5 | NOT NULL | | Specimen Source PickList. Link to PickList.ID |
| LabelTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | Label Type. Link to Label_Type_DE.ID |
| SourceDE | [dbo].[dict_id] | 5 | NOT NULL | | Specimen Source. Link to Source_DE.ID |
| SourceSingleOrDefault | varchar(1) | 1 | NOT NULL | | Is this the only Source (S) or the Default Source (D) |
![Check Constraints CK_OCD_Item_ComplexOrderIndicator_Yes_Or_No : ([ComplexOrderIndicator]='N' OR [ComplexOrderIndicator]='Y') Check Constraints CK_OCD_Item_ComplexOrderIndicator_Yes_Or_No : ([ComplexOrderIndicator]='N' OR [ComplexOrderIndicator]='Y')](../../../../Images/c-constraint.png) | ComplexOrderIndicator | [dbo].[BOOL] | 1 | NOT NULL | | Is this s Complex Order (Y/N)? |
![Check Constraints CK_OCD_Item_StandingOrderFLAG_Yes_Or_No : ([StandingOrderFLAG]='N' OR [StandingOrderFLAG]='Y') Check Constraints CK_OCD_Item_StandingOrderFLAG_Yes_Or_No : ([StandingOrderFLAG]='N' OR [StandingOrderFLAG]='Y')](../../../../Images/c-constraint.png) | StandingOrderFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Standing Order (Y/N)? |
| VersionID | [dbo].[dict_id] | 5 | NOT NULL | (0) | Version. Link to OCD_Version.ID |
| UpdateType | char(1) | 1 | NOT NULL | ('') | Update Type |
| UpdateDTTM | datetime | 8 | NULL allowed | | Updated date and time |
![Check Constraints CK_OCD_Item_UsedInContentFLAG_Yes_Or_No : ([UsedInContentFLAG]='N' OR [UsedInContentFLAG]='Y') Check Constraints CK_OCD_Item_UsedInContentFLAG_Yes_Or_No : ([UsedInContentFLAG]='N' OR [UsedInContentFLAG]='Y')](../../../../Images/c-constraint.png) | UsedInContentFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Used in Allscripts delivered Care guides (Y/N)? |
![Check Constraints CK_OCD_Item_IsOrderableFlag_Yes_Or_No : ([IsOrderableFlag]='N' OR [IsOrderableFlag]='Y') Check Constraints CK_OCD_Item_IsOrderableFlag_Yes_Or_No : ([IsOrderableFlag]='N' OR [IsOrderableFlag]='Y')](../../../../Images/c-constraint.png) | IsOrderableFlag | [dbo].[BOOL] | 1 | NULL allowed | ('N') | Orderable (Y/N)? |
![Check Constraints CK_OCD_Item_IsResultableFlag_Yes_Or_No : ([IsResultableFlag]='N' OR [IsResultableFlag]='Y') Check Constraints CK_OCD_Item_IsResultableFlag_Yes_Or_No : ([IsResultableFlag]='N' OR [IsResultableFlag]='Y')](../../../../Images/c-constraint.png) | IsResultableFlag | [dbo].[BOOL] | 1 | NULL allowed | ('N') | Resultable (Y/N)? |