Tables [dbo].[OCD_Item]
Orderable Concept Dictionary Item
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_OCD_Item: IDIndexes NIX_OCD_Item_OrderTypeID, NIX_ocd_item_SNOMED(2)ID[dbo].[dict_id]5NOT NULLKey to the OCD_Item table
Indexes nix_OCD_Item_OCDHeaderIDOCDHeaderID[dbo].[dict_id]5NOT NULLHeader. Link to OCD_Header.ID
EntryCodechar(10)10NOT NULLCode
EntryNamevarchar(255)255NOT NULLName
EntryMnemonicchar(10)10NOT NULLMnemonic
Indexes TWstat_OCD_Item_IsInactiveFLAGCheck Constraints CK_OCD_Item_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLInactive (Y/N)?
Check Constraints CK_OCD_Item_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLEnd user modifyable (Y/N)?
CreateDTTMdatetime8NOT NULLcreation time
DisplayNamevarchar(255)255NOT NULLDisplay name
ClassPathvarchar(255)255NOT NULLHierarchy within the OCD
Indexes NIX_OCD_Item_OrderTypeIDOrderTypevarchar(10)10NOT NULLOrder Type
QOModPicklistID[dbo].[dict_id]5NOT NULLModifier Picklist 1. Link to Picklist.ID
QOModPicklist2ID[dbo].[dict_id]5NOT NULLModifier Picklist 2. Link to Picklist.ID
QOModPicklist3ID[dbo].[dict_id]5NOT NULLModifier Picklist 3. Link to Picklist.ID
Check Constraints CK_OCD_Item_QOModPicklistReq_Yes_Or_No : ([QOModPicklistReq]='N' OR [QOModPicklistReq]='Y')QOModPicklistReq[dbo].[BOOL]1NOT NULLIs Modifier Picklist 1 required (Y/N)?
Check Constraints CK_OCD_Item_QOModPicklist2Req_Yes_Or_No : ([QOModPicklist2Req]='N' OR [QOModPicklist2Req]='Y')QOModPicklist2Req[dbo].[BOOL]1NOT NULLIs Modifier Picklist 2 required (Y/N)?
Check Constraints CK_OCD_Item_QOModPicklist3Req_Yes_Or_No : ([QOModPicklist3Req]='N' OR [QOModPicklist3Req]='Y')QOModPicklist3Req[dbo].[BOOL]1NOT NULLIs Modifier Picklist 3 required (Y/N)?
QOModPicklistDefaultID[dbo].[dict_id]5NOT NULLModifier Picklist 1 default entry
QOModPicklist2DefaultID[dbo].[dict_id]5NOT NULLModifier Picklist 2 default entry
QOModPicklist3DefaultID[dbo].[dict_id]5NOT NULLModifier Picklist 3 default entry
OrderInstructionsvarchar(2000)2000NOT NULLInstructions
PatientInstructionID[dbo].[dict_id]5NOT NULLPatient Instruction. Link to OCD_Instruction.ID
CPT4Codevarchar(10)10NOT NULLCPT4 Code
MedcinIDint4NOT NULLMedcinID. Link to chMedcinsearch.dbo.Search.medcinid
LOINCCodevarchar(10)10NOT NULLLOINC Code
HICPCSCodevarchar(10)10NOT NULLHICPCS Code
UPCvarchar(11)11NOT NULLUPC (Universal Product Code)
Indexes NIX_ocd_item_SNOMEDSNOMEDvarchar(18)18NULL allowed SNOMED Code
Foreign Keys FK_OCD_Item_Specialty_DE: [dbo].[Specialty_DE].SpecialtyDESpecialtyDE[dbo].[dict_id]5NOT NULLSpecialty. Link to Specialty_DE.ID
ReferralTypeDE[dbo].[dict_id]5NOT NULLReferralType. Link to Referral_Type_DE.ID
Urgencyvarchar(10)10NOT NULLUrgency
AllscriptsGuidelineID[dbo].[dict_id]5NOT NULLGuideline. Link to OCD_Guideline.ID
gendertoexcludeSEXDE[dbo].[dict_id]5NOT NULLGender for whuch this is not applicable. Link to Sex_DE.ID
OCDInstructionID[dbo].[dict_id]5NOT NULLInstruction. Link to OCD_Instruction.ID
Check Constraints CK_OCD_Item_AlwaysDisplayDetailFLAG_Yes_Or_No : ([AlwaysDisplayDetailFLAG]='N' OR [AlwaysDisplayDetailFLAG]='Y')AlwaysDisplayDetailFLAG[dbo].[BOOL]1NOT NULLAlways Display the detail form (Y/N)?
OIDModevarchar(30)30NOT NULLMode (Active or No Longer Used)
FirstStringDefaultnvarchar(1024)2048NULL allowed('')Deault First String for an instruction or Precaution order
DDIint4NOT NULLDrug Description Identifier
SpecimenTypeDE[dbo].[dict_id]5NOT NULLSpecimen Type. Link to Specimen _Type_DE.ID
Check Constraints CK_OCD_Item_SpecimenTypeReqFLAG_Yes_Or_No : ([SpecimenTypeReqFLAG]='N' OR [SpecimenTypeReqFLAG]='Y')SpecimenTypeReqFLAG[dbo].[BOOL]1NOT NULLIs Specimen Type required (Y/N)?
SpecimenTypePickListID[dbo].[dict_id]5NOT NULLSpecimen Type PickList. Link to PickList.ID
SourcePickListID[dbo].[dict_id]5NOT NULLSpecimen Source PickList. Link to PickList.ID
LabelTypeDE[dbo].[dict_id]5NOT NULLLabel Type. Link to Label_Type_DE.ID
SourceDE[dbo].[dict_id]5NOT NULLSpecimen Source. Link to Source_DE.ID
SourceSingleOrDefaultvarchar(1)1NOT NULLIs this the only Source (S) or the Default Source (D)
Check Constraints CK_OCD_Item_ComplexOrderIndicator_Yes_Or_No : ([ComplexOrderIndicator]='N' OR [ComplexOrderIndicator]='Y')ComplexOrderIndicator[dbo].[BOOL]1NOT NULLIs this s Complex Order (Y/N)?
Check Constraints CK_OCD_Item_StandingOrderFLAG_Yes_Or_No : ([StandingOrderFLAG]='N' OR [StandingOrderFLAG]='Y')StandingOrderFLAG[dbo].[BOOL]1NOT NULL('N')Standing Order (Y/N)?
VersionID[dbo].[dict_id]5NOT NULL(0)Version. Link to OCD_Version.ID
UpdateTypechar(1)1NOT NULL('')Update Type
UpdateDTTMdatetime8NULL allowedUpdated date and time
Check Constraints CK_OCD_Item_UsedInContentFLAG_Yes_Or_No : ([UsedInContentFLAG]='N' OR [UsedInContentFLAG]='Y')UsedInContentFLAG[dbo].[BOOL]1NOT NULL('N')Used in Allscripts delivered Care guides (Y/N)?
Check Constraints CK_OCD_Item_IsOrderableFlag_Yes_Or_No : ([IsOrderableFlag]='N' OR [IsOrderableFlag]='Y')IsOrderableFlag[dbo].[BOOL]1NULL allowed('N')Orderable (Y/N)?
Check Constraints CK_OCD_Item_IsResultableFlag_Yes_Or_No : ([IsResultableFlag]='N' OR [IsResultableFlag]='Y')IsResultableFlag[dbo].[BOOL]1NULL allowed('N')Resultable (Y/N)?