Tables [dbo].[QO_Classification_DE]
Non-Medication Orderable Items
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultBound DefaultDescription
Cluster Primary Key PK_QO_Classification_DE_ID: IDIndexes XAK4QuestionClassification, NIX_QOClassificationDE_CPT4Code, nix_QO_Classification_DE_ID_IsInactiveFLAG, TWstat_QO_Classification_DE_CPT4Code_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_IsClassificationOnlyFLAG_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_IsEnforcedPlanDefFLAG_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_IsPathEndFLAG_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_LabelTypeDE_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_QOModPicklist2Req_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_QOModPicklist3Req_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_QOModPicklistReq_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_SecurityCodeDE_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_SourceDE_EntryName_IsCurrentFLAG_ID(13)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the QO_Classification_DE table
EnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
DefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Entry[dbo].[dict_id]5NOT NULL(0)Calculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set.
Indexes NIX_QO_Classification_DE_EntryCode_WithIncludeColumns, NIX_QO_Classification_DE_EntryMnemonic_WithIncludeColumns, NIX_QO_Classification_DE_EntryName_WithIncludeColumns, NIX_QO_Classification_DE_OIDMode(4)EntryCode[dbo].[code]10NOT NULLEntry Code: The unique identifier assigned to each orderable item.
Indexes NIX_QO_Classification_DE_EntryCode_WithIncludeColumns, NIX_QO_Classification_DE_EntryMnemonic_WithIncludeColumns, NIX_QO_Classification_DE_EntryName_WithIncludeColumns, NIX_QO_Classification_DE_OIDMode, TWstat_QO_Classification_DE_CPT4Code_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_IsClassificationOnlyFLAG_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_IsEnforcedPlanDefFLAG_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_IsPathEndFLAG_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_LabelTypeDE_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_QOModPicklist2Req_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_QOModPicklist3Req_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_QOModPicklistReq_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_SecurityCodeDE_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_SourceDE_EntryName_IsCurrentFLAG_ID(14)EntryName[dbo].[name]255NOT NULLEntry Name: The descriptive identifier of the orderable item.
Indexes NIX_QO_Classification_DE_EntryCode_WithIncludeColumns, NIX_QO_Classification_DE_EntryMnemonic_WithIncludeColumns, NIX_QO_Classification_DE_EntryName_WithIncludeColumns, NIX_QO_Classification_DE_OIDMode(4)EntryMnemonic[dbo].[code]10NOT NULLEntry Mnemonic. The value will be unique to the orderable item, and it is usually the same as its code.
Indexes NIX_QO_Classification_DE_EntryCode_WithIncludeColumns, NIX_QO_Classification_DE_EntryMnemonic_WithIncludeColumns, NIX_QO_Classification_DE_EntryName_WithIncludeColumns, nix_QO_Classification_DE_ID_IsInactiveFLAG, NIX_QO_Classification_DE_OIDMode(5)Check Constraints CK_QO_Classification_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLIs the entry inactive (Y/N)? When Y then orderable item becomes inactive for ordering.
Check Constraints CK_QO_Classification_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLIs the entry Enforced (Y/N)? Enforced entries can not be modified by the application.
Indexes XAK4QuestionClassification, NIX_QO_Classification_DE_EntryCode_WithIncludeColumns, NIX_QO_Classification_DE_EntryMnemonic_WithIncludeColumns, NIX_QO_Classification_DE_EntryName_WithIncludeColumns, TWstat_QO_Classification_DE_CPT4Code_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_IsClassificationOnlyFLAG_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_IsEnforcedPlanDefFLAG_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_IsPathEndFLAG_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_LabelTypeDE_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_QOModPicklist2Req_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_QOModPicklist3Req_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_QOModPicklistReq_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_SecurityCodeDE_EntryName_IsCurrentFLAG_ID, TWstat_QO_Classification_DE_SourceDE_EntryName_IsCurrentFLAG_ID(14)Check Constraints CK_QO_Classification_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')IsCurrentFLAG[dbo].[BOOL]1NOT NULLIs the entry Current (Y/N)?
EffectiveDTdatetime8NULL allowedEffective Date is the last edited date.
Indexes NIX_QO_Classification_DE_SnoTermCODESnoTermCODEvarchar(18)18NULL allowedSnoMed code
Indexes TWstat_QO_Classification_DE_SecurityCodeDE_EntryName_IsCurrentFLAG_IDForeign Keys FK_QO_Classification_DE_SecurityCodeDE_Security_Code_DE_ID: [dbo].[Security_Code_DE].SecurityCodeDESecurityCodeDE[dbo].[dict_id]5NOT NULLSecurity Code. Link to Security_Code_DE.ID.
Foreign Keys FK_QO_Classification_DE_InstructionID_QO_Instruction_ID: [dbo].[QO_Instruction].InstructionIDInstructionIDnumeric(8,0)5NOT NULLInstruction. link to QO_Instruction.ID
TCGPIchar(14)14NOT NULL(' ')Theraputic Class GPI code
Indexes XAK4QuestionClassificationClassPathvarchar(255)255NOT NULLHierarchy. A comma separated list of  QO_Classification_DE.ID's that indicate the hierarchy
Indexes TWstat_QO_Classification_DE_IsPathEndFLAG_EntryName_IsCurrentFLAG_IDCheck Constraints CK_QO_Classification_DE_IsPathEndFLAG_Yes_Or_No : ([IsPathEndFLAG]='N' OR [IsPathEndFLAG]='Y')IsPathEndFLAG[dbo].[BOOL]1NOT NULLY = When ClassPath does not have children
Check Constraints CK_QO_Classification_DE_OrderDetailForParentFLAG_Yes_Or_No : ([OrderDetailForParentFLAG]='N' OR [OrderDetailForParentFLAG]='Y')OrderDetailForParentFLAG[dbo].[BOOL]1NOT NULLDtail for the parent Item?
Indexes NIX_QO_Classification_DE_OIDMode, TWstat_QO_Classification_DE_IsClassificationOnlyFLAG_EntryName_IsCurrentFLAG_ID(2)Check Constraints CK_QO_Classification_DE_IsClassificationOnlyFLAG_Yes_Or_No : ([IsClassificationOnlyFLAG]='N' OR [IsClassificationOnlyFLAG]='Y')IsClassificationOnlyFLAG[dbo].[BOOL]1NOT NULLIndicates whether OID is orderable or not.
Check Constraints CK_QO_Classification_DE_ItemType_Item_Type : ([ItemType]='OT' OR [ItemType]='IM' OR [ItemType]='RS' OR [ItemType]='ME' OR [ItemType]='PL' OR [ItemType]='CH' OR [ItemType]='PM' OR [ItemType]='CO' OR [ItemType]='AL' OR [ItemType]='RE' OR [ItemType]='FI')ItemTypechar(2)2NOT NULLRS - Results, FI - Findings, OT - Non Med Orders like Lab Imaging, Procedure etc
Indexes TWstat_QO_Classification_DE_IsEnforcedPlanDefFLAG_EntryName_IsCurrentFLAG_IDCheck Constraints CK_QO_Classification_DE_IsEnforcedPlanDefFLAG_Yes_Or_No : ([IsEnforcedPlanDefFLAG]='N' OR [IsEnforcedPlanDefFLAG]='Y')IsEnforcedPlanDefFLAG[dbo].[BOOL]1NOT NULLNot used
QOModPicklistID[dbo].[dict_id]5NOT NULL(0)Modifier 1 Picklist. Link to Picklist.ID
QOModPicklist2ID[dbo].[dict_id]5NOT NULL(0)Modifier 2 Picklist. Link to Picklist.ID
QOModPicklist3ID[dbo].[dict_id]5NOT NULL(0)Modifier 3 Picklist. Link to Picklist.ID
Indexes TWstat_QO_Classification_DE_QOModPicklistReq_EntryName_IsCurrentFLAG_IDCheck Constraints CK_QO_Classification_DE_QOModPicklistReq_Yes_Or_No : ([QOModPicklistReq]='N' OR [QOModPicklistReq]='Y')QOModPicklistReq[dbo].[BOOL]1NOT NULL('N')Is a Modifier 1  from the picklist required?
Indexes TWstat_QO_Classification_DE_QOModPicklist2Req_EntryName_IsCurrentFLAG_IDCheck Constraints CK_QO_Classification_DE_QOModPicklist2Req_Yes_Or_No : ([QOModPicklist2Req]='N' OR [QOModPicklist2Req]='Y')QOModPicklist2Req[dbo].[BOOL]1NOT NULL('N')Is a Modifier 2  from the picklist required?
Indexes TWstat_QO_Classification_DE_QOModPicklist3Req_EntryName_IsCurrentFLAG_IDCheck Constraints CK_QO_Classification_DE_QOModPicklist3Req_Yes_Or_No : ([QOModPicklist3Req]='N' OR [QOModPicklist3Req]='Y')QOModPicklist3Req[dbo].[BOOL]1NOT NULL('N')Is a Modifier 3  from the picklist required?
OrderInstructionsvarchar(2000)2000NULL allowedSet_To_Empty_StringOrder Instructions
Check Constraints CK_QO_Classification_DE_CreateRefAuthTask_Yes_Or_No : ([CreateRefAuthTask]='N' OR [CreateRefAuthTask]='Y')CreateRefAuthTask[dbo].[BOOL]1NOT NULLSet_To_Empty_StringCreate a Referral Authorization task
Check Constraints CK_QO_Classification_DE_DisplayOrderForm_Yes_Or_No : ([DisplayOrderForm]='N' OR [DisplayOrderForm]='Y')DisplayOrderForm[dbo].[BOOL]1NOT NULLSet_To_Empty_StringDisplay Order Form?
Indexes TWstat_QO_Classification_DE_SourceDE_EntryName_IsCurrentFLAG_IDForeign Keys FK_QO_Classification_DE_SourceDE_Source_DE_ID: [dbo].[Source_DE].SourceDESourceDEnumeric(8,0)5NOT NULL(0)Source. Link to Source_DE.ID
Check Constraints CK_QO_Classification_DE_SourceSingleOrDefault_SourceSingleOrDefault : ([SourceSingleOrDefault]='' OR [SourceSingleOrDefault]='D' OR [SourceSingleOrDefault]='S')SourceSingleOrDefaultvarchar(1)1NOT NULLSet_To_Empty_StringIs the source editable or the default?
Check Constraints CK_QO_Classification_DE_DisplayInCMS_DisplayInCMS : ([DisplayInCMS]='' OR [DisplayInCMS]='B' OR [DisplayInCMS]='I' OR [DisplayInCMS]='N')DisplayInCMSchar(1)1NOT NULL('B')No longer used
Foreign Keys FK_QO_Classification_DE_OrderTypeDE_Order_Type_DE_ID: [dbo].[Order_Type_DE].OrderTypeDEOrderTypeDEnumeric(8,0)5NOT NULL(0)Order Type. Link to Order_Type_DE.ID
Foreign Keys FK_QO_Classification_DE_CommunicationMethodDE_Communication_Method_DE_ID: [dbo].[Communication_Method_DE].CommunicationMethodDECommunicationMethodDEnumeric(8,0)5NOT NULL(0)Communication method. Link to Communication_Method_DE.ID
V4OrderingAuthorityint4NULL allowed(1)0 (low) to 10 (high) rating to control what kind of orders a provider can order.
PatientInstructionsvarchar(1000)1000NOT NULL('')Patient instructions
Indexes NIX_QOClassificationDE_CPT4Code, TWstat_QO_Classification_DE_CPT4Code_EntryName_IsCurrentFLAG_ID(2)CPT4Codechar(10)10NOT NULL('')CPT4 code for medical necessity checking if the order is not chargeable
CPT4Textvarchar(255)255NOT NULL('')CPT4 text for medical necessity checking if the order is not chargeable
Indexes TWstat_QO_Classification_DE_NeedActivationFlagCheck Constraints CK_QO_Classification_DE_NeedActivationFlag_Yes_Or_No : ([NeedActivationFlag]='N' OR [NeedActivationFlag]='Y')NeedActivationFlag[dbo].[BOOL]1NOT NULL('N')Does the order need to be activated?
Indexes TWstat_QO_Classification_DE_LabelTypeDE_EntryName_IsCurrentFLAG_IDLabelTypeDE[dbo].[dict_id]5NOT NULL(0)Label Type. Link to Label_Type_DE.ID
Indexes NIX_QO_Classification_DE_OCDIDOCDID[dbo].[dict_id]5NOT NULL(0)Orderable Concept. Link to OCD_Header.ID
Indexes NIX_QO_Classification_DE_OIDModeCheck Constraints CKQoClassOIDMode : ([OIDMode]='Active' OR [OIDMode]='No Longer Used' OR [OIDMode]='Draft')OIDModevarchar(30)30NOT NULL('')OID Mode in Initial section. Values will be
- "" [Blank]
- Draft
- No Longer Used
Indexes TWstat_QO_Classification_DE_ExtendedDetailFromParentFLAGCheck Constraints CK_QO_Classification_DE_ExtendedDetailFromParentFLAG_Yes_Or_No : ([ExtendedDetailFromParentFLAG]='N' OR [ExtendedDetailFromParentFLAG]='Y')ExtendedDetailFromParentFLAG[dbo].[BOOL]1NOT NULL('N')Detail from Parent
Indexes NIX_QO_Classification_DE_OIDMode, TWstat_QO_Classification_DE_ComplexOrderIndicator(2)Check Constraints CK_QO_Classification_DE_ComplexOrderIndicator_Yes_Or_No : ([ComplexOrderIndicator]='N' OR [ComplexOrderIndicator]='Y')ComplexOrderIndicator[dbo].[BOOL]1NOT NULL('N')Complex Order?
Indexes NIX_QO_Classification_DE_OIDModeOrderTypechar(1)1NOT NULL('')Order Type
I - Instruction
P - Precaution
R - Referral
L - Lab
U - Follow Up
X - Radiology
D - Other Diagnostic Imaging
S - Supply
F - Finding
Indexes TWstat_QO_Classification_DE_ReferralTypeDEReferralTypeDE[dbo].[dict_id]5NOT NULL(0)Referral Type. Link to Referral_Type_DE.ID
Indexes TWstat_QO_Classification_DE_ReferalReasonDEReferalReasonDE[dbo].[dict_id]5NOT NULL(0)Referral Reason. Link to Order_Reason_DE.ID
Indexes TWstat_QO_Classification_DE_SpecialtyDESpecialtyDE[dbo].[dict_id]5NOT NULL(0)Speciality. Link to Specialty_DE.ID
Check Constraints CK_QO_Classification_DE_FirstAvailableFLAG_Yes_Or_No : ([FirstAvailableFLAG]='N' OR [FirstAvailableFLAG]='Y')FirstAvailableFLAG[dbo].[BOOL]1NOT NULL('N')First Available?
Indexes TWstat_QO_Classification_DE_SpecimenTypeDESpecimenTypeDE[dbo].[dict_id]5NOT NULL(0)Link to Specimen_Type_DE.ID. Holds default specimen type.
SpecimenTypePickListID[dbo].[dict_id]5NOT NULL(0)Link to Picklist.ID. List of Valid Specimen Types.
SourcePickListID[dbo].[dict_id]5NOT NULL(0)Source Picklist. Link to Picklist.ID
Check Constraints CK_QO_Classification_DE_ClinicalSourceReqFlag_Yes_Or_No : ([ClinicalSourceReqFlag]='N' OR [ClinicalSourceReqFlag]='Y')ClinicalSourceReqFlag[dbo].[BOOL]1NOT NULL('N')When Y then Clinical Source is required.
Foreign Keys FK_Qo_Classification_DE_QO_Class_Instruction: [dbo].[QO_Class_Instruction].QoClassInstructionIDQoClassInstructionID[dbo].[dict_id]5NOT NULL(0)Instruction. Link to QO_Class_Instruction.ID
Indexes NIX_QO_Classification_DE_OIDModeLOINCCodevarchar(10)10NOT NULL('')LOINC Code
MedcinIDvarchar(10)10NOT NULL('')Link to Medcin Terminology
UPCvarchar(11)11NOT NULL('')Universal Product Code (UPC) for the orderable item.
HICPCSCodevarchar(10)10NOT NULL('')HCPCS code
AllscriptsGuidelineID[dbo].[uniqueid]9NOT NULL(0)Guideline Identifier
Indexes NIX_QO_Classification_DE_OIDMode, TWstat_QO_Classification_DE_GenderToExcludeSexDE(2)GenderToExcludeSexDE[dbo].[dict_id]5NOT NULL(0)Orderable item is not applicable to this gender. Link to Sex_DE.ID
Foreign Keys FK_QO_Classification_DE_DefaultPriorityDE_Clinical_Priority_DE_ID: [dbo].[Clinical_Priority_DE].DefaultPriorityDEDefaultPriorityDE[dbo].[dict_id]5NOT NULL(0)Defaiult Priority. Link to Clinical_Priority_DE.ID
ExpirationIntervalsmallint2NOT NULL(0)Expiration Interval value
Foreign Keys FK_QO_Classification_DE_ExpirationIntervalUnits_HMP_Freq_Unit_DE_ID: [dbo].[HMP_Freq_Unit_DE].ExpirationIntervalUnitsExpirationIntervalUnits[dbo].[dict_id]5NOT NULL(0)Expiration Interval units. Link to HMP_Freq_Unit_DE.ID
Indexes TWstat_QO_Classification_DE_UrgencyUrgencyvarchar(10)10NOT NULL('')Urgency Indicator.
'Urgent'
'Emergent'
'Call'
Indexes TWstat_QO_Classification_DE_AllscriptsPatientInstructionIDAllscriptsPatientInstructionID[dbo].[dict_id]5NOT NULL(0)Patient Instructions. Link to QO_Class_Instruction.ID
Indexes NIX_QO_Classification_DE_OIDModeFirstStringDefaultnvarchar(1024)2048NOT NULL('')Default First String for Instructions and precaution orders
Indexes TWstat_QO_Classification_DE_StandingOrderFLAGCheck Constraints CK_QO_Classification_DE_StandingOrderFLAG_Yes_Or_No : ([StandingOrderFLAG]='N' OR [StandingOrderFLAG]='Y')StandingOrderFLAG[dbo].[BOOL]1NOT NULL('N')Standing order for Instruction orderable items only.
DuplicateCheckingIntervalsmallint2NOT NULL(0)Duplicate chacking Interval Value
Indexes TWstat_QO_Classification_DE_DuplicateCheckingIntervalUnitsDEDuplicateCheckingIntervalUnitsDE[dbo].[dict_id]5NOT NULL(0)Duplicate chacking Interval Units. Link to HMP_Freq_Unit_DE.ID
Indexes NIX_QO_Classification_DE_OIDMode, TWstat_QO_Classification_DE_ResultableSource(2)ResultableSourcetinyint1NOT NULL(3)Resultable via:
1 - User Only
2 - Interface Only
3 - User and Interface
4 - Flowsheet only
Indexes NIX_QO_Classification_DE_OIDMode, TWstat_QO_Classification_DE_OrderableSource(2)OrderableSourcetinyint1NOT NULL(3)Orderable Source.
Indexes TWstat_QO_Classification_DE_OrgSharingDEOrgSharingDE[dbo].[dict_id]5NOT NULL(0)Organization Sharing Pool. Link to Org_Sharing_DE.ID
Check Constraints CK_QO_Classification_DE_DisplayResultsHistoryFLAG_Yes_Or_No : ([DisplayResultsHistoryFLAG]='N' OR [DisplayResultsHistoryFLAG]='Y')DisplayResultsHistoryFLAG[dbo].[BOOL]1NOT NULL('Y')Display Result History flag value from Results section.
Check Constraints CK_QO_Classification_DE_NeverCombineOnOtherReqFLAG_Yes_Or_No : ([NeverCombineOnOtherReqFLAG]='N' OR [NeverCombineOnOtherReqFLAG]='Y')NeverCombineOnOtherReqFLAG[dbo].[BOOL]1NOT NULL('N')When Y then never combine with other orders on the same requistion.
Foreign Keys FK_QO_CLASSIFICATION_DE_SubOrderTypeDe: [dbo].[SubOrder_Type_DE].SubOrderTypeDESubOrderTypeDE[dbo].[dict_id]5NOT NULL((0))Sub-Order type. Link to SubOrder_Type_DE.ID
Foreign Keys fk_QOClassificationDE_DoNotReleaseDE_DoNotReleaseDE_ID: [dbo].[Do_Not_Release_DE].DoNotReleaseDEDoNotReleaseDE[dbo].[dict_id]5NOT NULL((0))Do Not Releae. Link to Do_Not_Release_DE.ID
Indexes NIX_QO_Classification_DE_OIDModeToBeDoneDefaulttinyint1NOT NULL((1))1 For None
2 for Now
3 For Today date
4 for Fuzzy Date
5 For Future date
Indexes NIX_QO_Classification_DE_OIDModeToBeDoneFuzzyDatevarchar(50)50NOT NULL('')To be done default fuzzy date value when ToBeDoneDefault is 4.
Indexes NIX_QO_Classification_DE_OIDModeToBeDoneIntervalsmallint2NOT NULL((0))Future date interval value
Indexes NIX_QO_Classification_DE_OIDModeForeign Keys fk_QOClassificationDE_ToBeDoneIntervalUnitsDE_HMP_Freq_Unit_DE_ID: [dbo].[HMP_Freq_Unit_DE].ToBeDoneIntervalUnitsDEToBeDoneIntervalUnitsDE[dbo].[dict_id]5NOT NULL((0))Future date interval units. Link to HMP_Freq_Unit_DE.ID.
Indexes NIX_QO_Classification_DE_OIDModeCheck Constraints CK_QO_Classification_DE_FreeTextOrderFLAG_Yes_Or_No : ([FreeTextOrderFLAG]='N' OR [FreeTextOrderFLAG]='Y')FreeTextOrderFLAG[dbo].[BOOL]1NOT NULL('N')when set Y allow user to enter free text
Check Constraints CK_QO_Classification_DE_AllowDocumentAsResult_Yes_Or_No : ([AllowDocumentAsResult]='N' OR [AllowDocumentAsResult]='Y')AllowDocumentAsResult[dbo].[BOOL]1NOT NULL('Y')When Y then Enable Document for Results
Check Constraints CK_QO_Classification_DE_DoNotIncludeForMUReportingFLAG_Yes_Or_No : ([DoNotIncludeForMUReportingFLAG]='N' OR [DoNotIncludeForMUReportingFLAG]='Y')DoNotIncludeForMUReportingFLAG[dbo].[BOOL]1NOT NULL('N')When Y then prevents order for the orderable item from being included in Meaningful Use Reports.
Check Constraints CK_QO_Classification_DE_ImageAccessibleFLAG_Yes_Or_No : ([ImageAccessibleFLAG]='N' OR [ImageAccessibleFLAG]='Y')ImageAccessibleFLAG[dbo].[BOOL]1NOT NULL('N')There is an image?
IsFMHAchieveOrderFlag[dbo].[BOOL]1NOT NULL('N')Indicates whether the orderable item is onethat can be used with Allscripts FollowMyHealth Achieve.
Foreign Keys fk_GeneralAppropriatenessDE_GeneralAppropriatenessDE_ID: [dbo].[General_Appropriateness_DE].GeneralAppropriatenessDEGeneralAppropriatenessDE[dbo].[dict_id]5NOT NULL((0))Radiology Appropriateness. Link to General_Appropriateness_DE.ID
IsRequireGCodeModifierbit1NOT NULL((0))Is the G-Code Modifier Required
RequireAbnormalFlagforResultsEntry[dbo].[BOOL]1NOT NULL('N')Is the Abnormal Flag required for Results (Y/N)?
LinkProblemSnomedCodevarchar(18)18NULL allowedProblem Snomed code that can be linked to orders while ordering from POC Recommendations workflows if the problem exist.
GuidelineExamCodesvarchar(255)255NULL allowedExam codes (multiple) for Diagnostics and Imaging orders.
Foreign Keys FK_QO_Classification_DE_RegulatoryLoincDE_Regulatory_Loinc_DE_ID: [dbo].[Regulatory_Loinc_DE].RegulatoryLoincDERegulatoryLoincDE[dbo].[dict_id]5NOT NULL((0))Regulatory LOINC Code (different than regular LOINC Code). Link to Regulatory_LOINC_DE.ID