Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Bound Default | Description |
---|
 (13) | ID | [dbo].[dict_id] | 5 | NOT NULL | 1 - 1 | | | Key to the QO_Classification_DE table |
| EnterpriseEntryID | [dbo].[uniqueid] | 9 | NOT NULL | | | | Master (enterprise) dictionary surrogate key. Points to Dictionary_Entry.EnterpriseEntryID |
| DefinitionSetID | [dbo].[dict_id] | 5 | NOT NULL | | | | Points to Dict_Definition_Set.DefinitionSetID but is typically zero. |
| Entry | [dbo].[dict_id] | 5 | NOT NULL | | (0) | | Calculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set. |
(4) | EntryCode | [dbo].[code] | 10 | NOT NULL | | | | Entry Code: The unique identifier assigned to each orderable item. |
(14) | EntryName | [dbo].[name] | 255 | NOT NULL | | | | Entry Name: The descriptive identifier of the orderable item. |
(4) | EntryMnemonic | [dbo].[code] | 10 | NOT NULL | | | | Entry Mnemonic. The value will be unique to the orderable item, and it is usually the same as its code. |
(5)![Check Constraints CK_QO_Classification_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_QO_Classification_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | | Is 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') Check Constraints CK_QO_Classification_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')](../../../../Images/c-constraint.png) | IsEnforcedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | | Is the entry Enforced (Y/N)? Enforced entries can not be modified by the application. |
(14)![Check Constraints CK_QO_Classification_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y') Check Constraints CK_QO_Classification_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')](../../../../Images/c-constraint.png) | IsCurrentFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | | Is the entry Current (Y/N)? |
| EffectiveDT | datetime | 8 | NULL allowed | | | | Effective Date is the last edited date. |
 | SnoTermCODE | varchar(18) | 18 | NULL allowed | | | | SnoMed code |
 ![Foreign Keys FK_QO_Classification_DE_SecurityCodeDE_Security_Code_DE_ID: [dbo].[Security_Code_DE].SecurityCodeDE Foreign Keys FK_QO_Classification_DE_SecurityCodeDE_Security_Code_DE_ID: [dbo].[Security_Code_DE].SecurityCodeDE](../../../../Images/fk.png) | SecurityCodeDE | [dbo].[dict_id] | 5 | NOT NULL | | | | Security Code. Link to Security_Code_DE.ID. |
![Foreign Keys FK_QO_Classification_DE_InstructionID_QO_Instruction_ID: [dbo].[QO_Instruction].InstructionID Foreign Keys FK_QO_Classification_DE_InstructionID_QO_Instruction_ID: [dbo].[QO_Instruction].InstructionID](../../../../Images/fk.png) | InstructionID | numeric(8,0) | 5 | NOT NULL | | | | Instruction. link to QO_Instruction.ID |
| TCGPI | char(14) | 14 | NOT NULL | | (' ') | | Theraputic Class GPI code |
 | ClassPath | varchar(255) | 255 | NOT NULL | | | | Hierarchy. A comma separated list of QO_Classification_DE.ID's that indicate the hierarchy |
 ![Check Constraints CK_QO_Classification_DE_IsPathEndFLAG_Yes_Or_No : ([IsPathEndFLAG]='N' OR [IsPathEndFLAG]='Y') Check Constraints CK_QO_Classification_DE_IsPathEndFLAG_Yes_Or_No : ([IsPathEndFLAG]='N' OR [IsPathEndFLAG]='Y')](../../../../Images/c-constraint.png) | IsPathEndFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | | Y = When ClassPath does not have children |
![Check Constraints CK_QO_Classification_DE_OrderDetailForParentFLAG_Yes_Or_No : ([OrderDetailForParentFLAG]='N' OR [OrderDetailForParentFLAG]='Y') Check Constraints CK_QO_Classification_DE_OrderDetailForParentFLAG_Yes_Or_No : ([OrderDetailForParentFLAG]='N' OR [OrderDetailForParentFLAG]='Y')](../../../../Images/c-constraint.png) | OrderDetailForParentFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | | Dtail for the parent Item? |
(2)![Check Constraints CK_QO_Classification_DE_IsClassificationOnlyFLAG_Yes_Or_No : ([IsClassificationOnlyFLAG]='N' OR [IsClassificationOnlyFLAG]='Y') Check Constraints CK_QO_Classification_DE_IsClassificationOnlyFLAG_Yes_Or_No : ([IsClassificationOnlyFLAG]='N' OR [IsClassificationOnlyFLAG]='Y')](../../../../Images/c-constraint.png) | IsClassificationOnlyFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | | Indicates 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') 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')](../../../../Images/c-constraint.png) | ItemType | char(2) | 2 | NOT NULL | | | | RS - Results, FI - Findings, OT - Non Med Orders like Lab Imaging, Procedure etc |
 ![Check Constraints CK_QO_Classification_DE_IsEnforcedPlanDefFLAG_Yes_Or_No : ([IsEnforcedPlanDefFLAG]='N' OR [IsEnforcedPlanDefFLAG]='Y') Check Constraints CK_QO_Classification_DE_IsEnforcedPlanDefFLAG_Yes_Or_No : ([IsEnforcedPlanDefFLAG]='N' OR [IsEnforcedPlanDefFLAG]='Y')](../../../../Images/c-constraint.png) | IsEnforcedPlanDefFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | | Not used |
| QOModPicklistID | [dbo].[dict_id] | 5 | NOT NULL | | (0) | | Modifier 1 Picklist. Link to Picklist.ID |
| QOModPicklist2ID | [dbo].[dict_id] | 5 | NOT NULL | | (0) | | Modifier 2 Picklist. Link to Picklist.ID |
| QOModPicklist3ID | [dbo].[dict_id] | 5 | NOT NULL | | (0) | | Modifier 3 Picklist. Link to Picklist.ID |
 ![Check Constraints CK_QO_Classification_DE_QOModPicklistReq_Yes_Or_No : ([QOModPicklistReq]='N' OR [QOModPicklistReq]='Y') Check Constraints CK_QO_Classification_DE_QOModPicklistReq_Yes_Or_No : ([QOModPicklistReq]='N' OR [QOModPicklistReq]='Y')](../../../../Images/c-constraint.png) | QOModPicklistReq | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | | Is a Modifier 1 from the picklist required? |
 ![Check Constraints CK_QO_Classification_DE_QOModPicklist2Req_Yes_Or_No : ([QOModPicklist2Req]='N' OR [QOModPicklist2Req]='Y') Check Constraints CK_QO_Classification_DE_QOModPicklist2Req_Yes_Or_No : ([QOModPicklist2Req]='N' OR [QOModPicklist2Req]='Y')](../../../../Images/c-constraint.png) | QOModPicklist2Req | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | | Is a Modifier 2 from the picklist required? |
 ![Check Constraints CK_QO_Classification_DE_QOModPicklist3Req_Yes_Or_No : ([QOModPicklist3Req]='N' OR [QOModPicklist3Req]='Y') Check Constraints CK_QO_Classification_DE_QOModPicklist3Req_Yes_Or_No : ([QOModPicklist3Req]='N' OR [QOModPicklist3Req]='Y')](../../../../Images/c-constraint.png) | QOModPicklist3Req | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | | Is a Modifier 3 from the picklist required? |
| OrderInstructions | varchar(2000) | 2000 | NULL allowed | | | Set_To_Empty_String | Order Instructions |
![Check Constraints CK_QO_Classification_DE_CreateRefAuthTask_Yes_Or_No : ([CreateRefAuthTask]='N' OR [CreateRefAuthTask]='Y') Check Constraints CK_QO_Classification_DE_CreateRefAuthTask_Yes_Or_No : ([CreateRefAuthTask]='N' OR [CreateRefAuthTask]='Y')](../../../../Images/c-constraint.png) | CreateRefAuthTask | [dbo].[BOOL] | 1 | NOT NULL | | | Set_To_Empty_String | Create a Referral Authorization task |
![Check Constraints CK_QO_Classification_DE_DisplayOrderForm_Yes_Or_No : ([DisplayOrderForm]='N' OR [DisplayOrderForm]='Y') Check Constraints CK_QO_Classification_DE_DisplayOrderForm_Yes_Or_No : ([DisplayOrderForm]='N' OR [DisplayOrderForm]='Y')](../../../../Images/c-constraint.png) | DisplayOrderForm | [dbo].[BOOL] | 1 | NOT NULL | | | Set_To_Empty_String | Display Order Form? |
 ![Foreign Keys FK_QO_Classification_DE_SourceDE_Source_DE_ID: [dbo].[Source_DE].SourceDE Foreign Keys FK_QO_Classification_DE_SourceDE_Source_DE_ID: [dbo].[Source_DE].SourceDE](../../../../Images/fk.png) | SourceDE | numeric(8,0) | 5 | NOT NULL | | (0) | | Source. Link to Source_DE.ID |
![Check Constraints CK_QO_Classification_DE_SourceSingleOrDefault_SourceSingleOrDefault : ([SourceSingleOrDefault]='' OR [SourceSingleOrDefault]='D' OR [SourceSingleOrDefault]='S') Check Constraints CK_QO_Classification_DE_SourceSingleOrDefault_SourceSingleOrDefault : ([SourceSingleOrDefault]='' OR [SourceSingleOrDefault]='D' OR [SourceSingleOrDefault]='S')](../../../../Images/c-constraint.png) | SourceSingleOrDefault | varchar(1) | 1 | NOT NULL | | | Set_To_Empty_String | Is the source editable or the default? |
![Check Constraints CK_QO_Classification_DE_DisplayInCMS_DisplayInCMS : ([DisplayInCMS]='' OR [DisplayInCMS]='B' OR [DisplayInCMS]='I' OR [DisplayInCMS]='N') Check Constraints CK_QO_Classification_DE_DisplayInCMS_DisplayInCMS : ([DisplayInCMS]='' OR [DisplayInCMS]='B' OR [DisplayInCMS]='I' OR [DisplayInCMS]='N')](../../../../Images/c-constraint.png) | DisplayInCMS | char(1) | 1 | NOT NULL | | ('B') | | No longer used |
![Foreign Keys FK_QO_Classification_DE_OrderTypeDE_Order_Type_DE_ID: [dbo].[Order_Type_DE].OrderTypeDE Foreign Keys FK_QO_Classification_DE_OrderTypeDE_Order_Type_DE_ID: [dbo].[Order_Type_DE].OrderTypeDE](../../../../Images/fk.png) | OrderTypeDE | numeric(8,0) | 5 | NOT 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].CommunicationMethodDE Foreign Keys FK_QO_Classification_DE_CommunicationMethodDE_Communication_Method_DE_ID: [dbo].[Communication_Method_DE].CommunicationMethodDE](../../../../Images/fk.png) | CommunicationMethodDE | numeric(8,0) | 5 | NOT NULL | | (0) | | Communication method. Link to Communication_Method_DE.ID |
| V4OrderingAuthority | int | 4 | NULL allowed | | (1) | | 0 (low) to 10 (high) rating to control what kind of orders a provider can order. |
| PatientInstructions | varchar(1000) | 1000 | NOT NULL | | ('') | | Patient instructions |
(2) | CPT4Code | char(10) | 10 | NOT NULL | | ('') | | CPT4 code for medical necessity checking if the order is not chargeable |
| CPT4Text | varchar(255) | 255 | NOT NULL | | ('') | | CPT4 text for medical necessity checking if the order is not chargeable |
 ![Check Constraints CK_QO_Classification_DE_NeedActivationFlag_Yes_Or_No : ([NeedActivationFlag]='N' OR [NeedActivationFlag]='Y') Check Constraints CK_QO_Classification_DE_NeedActivationFlag_Yes_Or_No : ([NeedActivationFlag]='N' OR [NeedActivationFlag]='Y')](../../../../Images/c-constraint.png) | NeedActivationFlag | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | | Does the order need to be activated? |
 | LabelTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | | Label Type. Link to Label_Type_DE.ID |
 | OCDID | [dbo].[dict_id] | 5 | NOT NULL | | (0) | | Orderable Concept. Link to OCD_Header.ID |
 ![Check Constraints CKQoClassOIDMode : ([OIDMode]='Active' OR [OIDMode]='No Longer Used' OR [OIDMode]='Draft') Check Constraints CKQoClassOIDMode : ([OIDMode]='Active' OR [OIDMode]='No Longer Used' OR [OIDMode]='Draft')](../../../../Images/c-constraint.png) | OIDMode | varchar(30) | 30 | NOT NULL | | ('') | | OID Mode in Initial section. Values will be - "" [Blank] - Draft - No Longer Used |
 ![Check Constraints CK_QO_Classification_DE_ExtendedDetailFromParentFLAG_Yes_Or_No : ([ExtendedDetailFromParentFLAG]='N' OR [ExtendedDetailFromParentFLAG]='Y') Check Constraints CK_QO_Classification_DE_ExtendedDetailFromParentFLAG_Yes_Or_No : ([ExtendedDetailFromParentFLAG]='N' OR [ExtendedDetailFromParentFLAG]='Y')](../../../../Images/c-constraint.png) | ExtendedDetailFromParentFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | | Detail from Parent |
(2)![Check Constraints CK_QO_Classification_DE_ComplexOrderIndicator_Yes_Or_No : ([ComplexOrderIndicator]='N' OR [ComplexOrderIndicator]='Y') Check Constraints CK_QO_Classification_DE_ComplexOrderIndicator_Yes_Or_No : ([ComplexOrderIndicator]='N' OR [ComplexOrderIndicator]='Y')](../../../../Images/c-constraint.png) | ComplexOrderIndicator | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | | Complex Order? |
 | OrderType | char(1) | 1 | NOT NULL | | ('') | | Order Type I - Instruction P - Precaution R - Referral L - Lab U - Follow Up X - Radiology D - Other Diagnostic Imaging S - Supply F - Finding |
 | ReferralTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | | Referral Type. Link to Referral_Type_DE.ID |
 | ReferalReasonDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | | Referral Reason. Link to Order_Reason_DE.ID |
 | SpecialtyDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | | Speciality. Link to Specialty_DE.ID |
![Check Constraints CK_QO_Classification_DE_FirstAvailableFLAG_Yes_Or_No : ([FirstAvailableFLAG]='N' OR [FirstAvailableFLAG]='Y') Check Constraints CK_QO_Classification_DE_FirstAvailableFLAG_Yes_Or_No : ([FirstAvailableFLAG]='N' OR [FirstAvailableFLAG]='Y')](../../../../Images/c-constraint.png) | FirstAvailableFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | | First Available? |
 | SpecimenTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | | Link to Specimen_Type_DE.ID. Holds default specimen type. |
| SpecimenTypePickListID | [dbo].[dict_id] | 5 | NOT NULL | | (0) | | Link to Picklist.ID. List of Valid Specimen Types. |
| SourcePickListID | [dbo].[dict_id] | 5 | NOT NULL | | (0) | | Source Picklist. Link to Picklist.ID |
![Check Constraints CK_QO_Classification_DE_ClinicalSourceReqFlag_Yes_Or_No : ([ClinicalSourceReqFlag]='N' OR [ClinicalSourceReqFlag]='Y') Check Constraints CK_QO_Classification_DE_ClinicalSourceReqFlag_Yes_Or_No : ([ClinicalSourceReqFlag]='N' OR [ClinicalSourceReqFlag]='Y')](../../../../Images/c-constraint.png) | ClinicalSourceReqFlag | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | | When Y then Clinical Source is required. |
![Foreign Keys FK_Qo_Classification_DE_QO_Class_Instruction: [dbo].[QO_Class_Instruction].QoClassInstructionID Foreign Keys FK_Qo_Classification_DE_QO_Class_Instruction: [dbo].[QO_Class_Instruction].QoClassInstructionID](../../../../Images/fk.png) | QoClassInstructionID | [dbo].[dict_id] | 5 | NOT NULL | | (0) | | Instruction. Link to QO_Class_Instruction.ID |
 | LOINCCode | varchar(10) | 10 | NOT NULL | | ('') | | LOINC Code |
| MedcinID | varchar(10) | 10 | NOT NULL | | ('') | | Link to Medcin Terminology |
| UPC | varchar(11) | 11 | NOT NULL | | ('') | | Universal Product Code (UPC) for the orderable item. |
| HICPCSCode | varchar(10) | 10 | NOT NULL | | ('') | | HCPCS code |
| AllscriptsGuidelineID | [dbo].[uniqueid] | 9 | NOT NULL | | (0) | | Guideline Identifier |
(2) | GenderToExcludeSexDE | [dbo].[dict_id] | 5 | NOT 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].DefaultPriorityDE Foreign Keys FK_QO_Classification_DE_DefaultPriorityDE_Clinical_Priority_DE_ID: [dbo].[Clinical_Priority_DE].DefaultPriorityDE](../../../../Images/fk.png) | DefaultPriorityDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | | Defaiult Priority. Link to Clinical_Priority_DE.ID |
| ExpirationInterval | smallint | 2 | NOT NULL | | (0) | | Expiration Interval value |
![Foreign Keys FK_QO_Classification_DE_ExpirationIntervalUnits_HMP_Freq_Unit_DE_ID: [dbo].[HMP_Freq_Unit_DE].ExpirationIntervalUnits Foreign Keys FK_QO_Classification_DE_ExpirationIntervalUnits_HMP_Freq_Unit_DE_ID: [dbo].[HMP_Freq_Unit_DE].ExpirationIntervalUnits](../../../../Images/fk.png) | ExpirationIntervalUnits | [dbo].[dict_id] | 5 | NOT NULL | | (0) | | Expiration Interval units. Link to HMP_Freq_Unit_DE.ID |
 | Urgency | varchar(10) | 10 | NOT NULL | | ('') | | Urgency Indicator. 'Urgent' 'Emergent' 'Call' |
 | AllscriptsPatientInstructionID | [dbo].[dict_id] | 5 | NOT NULL | | (0) | | Patient Instructions. Link to QO_Class_Instruction.ID |
 | FirstStringDefault | nvarchar(1024) | 2048 | NOT NULL | | ('') | | Default First String for Instructions and precaution orders |
 ![Check Constraints CK_QO_Classification_DE_StandingOrderFLAG_Yes_Or_No : ([StandingOrderFLAG]='N' OR [StandingOrderFLAG]='Y') Check Constraints CK_QO_Classification_DE_StandingOrderFLAG_Yes_Or_No : ([StandingOrderFLAG]='N' OR [StandingOrderFLAG]='Y')](../../../../Images/c-constraint.png) | StandingOrderFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | | Standing order for Instruction orderable items only. |
| DuplicateCheckingInterval | smallint | 2 | NOT NULL | | (0) | | Duplicate chacking Interval Value |
 | DuplicateCheckingIntervalUnitsDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | | Duplicate chacking Interval Units. Link to HMP_Freq_Unit_DE.ID |
(2) | ResultableSource | tinyint | 1 | NOT NULL | | (3) | | Resultable via: 1 - User Only 2 - Interface Only 3 - User and Interface 4 - Flowsheet only |
(2) | OrderableSource | tinyint | 1 | NOT NULL | | (3) | | Orderable Source. |
 | OrgSharingDE | [dbo].[dict_id] | 5 | NOT 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') Check Constraints CK_QO_Classification_DE_DisplayResultsHistoryFLAG_Yes_Or_No : ([DisplayResultsHistoryFLAG]='N' OR [DisplayResultsHistoryFLAG]='Y')](../../../../Images/c-constraint.png) | DisplayResultsHistoryFLAG | [dbo].[BOOL] | 1 | NOT 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') Check Constraints CK_QO_Classification_DE_NeverCombineOnOtherReqFLAG_Yes_Or_No : ([NeverCombineOnOtherReqFLAG]='N' OR [NeverCombineOnOtherReqFLAG]='Y')](../../../../Images/c-constraint.png) | NeverCombineOnOtherReqFLAG | [dbo].[BOOL] | 1 | NOT 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].SubOrderTypeDE Foreign Keys FK_QO_CLASSIFICATION_DE_SubOrderTypeDe: [dbo].[SubOrder_Type_DE].SubOrderTypeDE](../../../../Images/fk.png) | SubOrderTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | | Sub-Order type. Link to SubOrder_Type_DE.ID |
![Foreign Keys fk_QOClassificationDE_DoNotReleaseDE_DoNotReleaseDE_ID: [dbo].[Do_Not_Release_DE].DoNotReleaseDE Foreign Keys fk_QOClassificationDE_DoNotReleaseDE_DoNotReleaseDE_ID: [dbo].[Do_Not_Release_DE].DoNotReleaseDE](../../../../Images/fk.png) | DoNotReleaseDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | | Do Not Releae. Link to Do_Not_Release_DE.ID |
 | ToBeDoneDefault | tinyint | 1 | NOT NULL | | ((1)) | | 1 For None 2 for Now 3 For Today date 4 for Fuzzy Date 5 For Future date |
 | ToBeDoneFuzzyDate | varchar(50) | 50 | NOT NULL | | ('') | | To be done default fuzzy date value when ToBeDoneDefault is 4. |
 | ToBeDoneInterval | smallint | 2 | NOT NULL | | ((0)) | | Future date interval value |
 ![Foreign Keys fk_QOClassificationDE_ToBeDoneIntervalUnitsDE_HMP_Freq_Unit_DE_ID: [dbo].[HMP_Freq_Unit_DE].ToBeDoneIntervalUnitsDE Foreign Keys fk_QOClassificationDE_ToBeDoneIntervalUnitsDE_HMP_Freq_Unit_DE_ID: [dbo].[HMP_Freq_Unit_DE].ToBeDoneIntervalUnitsDE](../../../../Images/fk.png) | ToBeDoneIntervalUnitsDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | | Future date interval units. Link to HMP_Freq_Unit_DE.ID. |
 ![Check Constraints CK_QO_Classification_DE_FreeTextOrderFLAG_Yes_Or_No : ([FreeTextOrderFLAG]='N' OR [FreeTextOrderFLAG]='Y') Check Constraints CK_QO_Classification_DE_FreeTextOrderFLAG_Yes_Or_No : ([FreeTextOrderFLAG]='N' OR [FreeTextOrderFLAG]='Y')](../../../../Images/c-constraint.png) | FreeTextOrderFLAG | [dbo].[BOOL] | 1 | NOT 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') Check Constraints CK_QO_Classification_DE_AllowDocumentAsResult_Yes_Or_No : ([AllowDocumentAsResult]='N' OR [AllowDocumentAsResult]='Y')](../../../../Images/c-constraint.png) | AllowDocumentAsResult | [dbo].[BOOL] | 1 | NOT NULL | | ('Y') | | When Y then Enable Document for Results |
![Check Constraints CK_QO_Classification_DE_DoNotIncludeForMUReportingFLAG_Yes_Or_No : ([DoNotIncludeForMUReportingFLAG]='N' OR [DoNotIncludeForMUReportingFLAG]='Y') Check Constraints CK_QO_Classification_DE_DoNotIncludeForMUReportingFLAG_Yes_Or_No : ([DoNotIncludeForMUReportingFLAG]='N' OR [DoNotIncludeForMUReportingFLAG]='Y')](../../../../Images/c-constraint.png) | DoNotIncludeForMUReportingFLAG | [dbo].[BOOL] | 1 | NOT 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') Check Constraints CK_QO_Classification_DE_ImageAccessibleFLAG_Yes_Or_No : ([ImageAccessibleFLAG]='N' OR [ImageAccessibleFLAG]='Y')](../../../../Images/c-constraint.png) | ImageAccessibleFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | | There is an image? |
| IsFMHAchieveOrderFlag | [dbo].[BOOL] | 1 | NOT 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].GeneralAppropriatenessDE Foreign Keys fk_GeneralAppropriatenessDE_GeneralAppropriatenessDE_ID: [dbo].[General_Appropriateness_DE].GeneralAppropriatenessDE](../../../../Images/fk.png) | GeneralAppropriatenessDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | | Radiology Appropriateness. Link to General_Appropriateness_DE.ID |
| IsRequireGCodeModifier | bit | 1 | NOT NULL | | ((0)) | | Is the G-Code Modifier Required |
| RequireAbnormalFlagforResultsEntry | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | | Is the Abnormal Flag required for Results (Y/N)? |
| LinkProblemSnomedCode | varchar(18) | 18 | NULL allowed | | | | Problem Snomed code that can be linked to orders while ordering from POC Recommendations workflows if the problem exist. |
| GuidelineExamCodes | varchar(255) | 255 | NULL allowed | | | | Exam codes (multiple) for Diagnostics and Imaging orders. |
![Foreign Keys FK_QO_Classification_DE_RegulatoryLoincDE_Regulatory_Loinc_DE_ID: [dbo].[Regulatory_Loinc_DE].RegulatoryLoincDE Foreign Keys FK_QO_Classification_DE_RegulatoryLoincDE_Regulatory_Loinc_DE_ID: [dbo].[Regulatory_Loinc_DE].RegulatoryLoincDE](../../../../Images/fk.png) | RegulatoryLoincDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | | Regulatory LOINC Code (different than regular LOINC Code). Link to Regulatory_LOINC_DE.ID |