Tables [dbo].[Item_Goal]
Item Level table for Goals
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Primary Key PK_Item_Goal_ID: IDIndexes XItem_Goal_CurID_IDID[dbo].[uniqueid]9NOT NULLKey to the Item_Goal table
Indexes NIX_Item_Goal_ActivityHeaderIDActivityHeaderID[dbo].[uniqueid]9NOT NULLActivity Header. Link to dbo.Act_Hdr_Other.ID
Cluster Key CIXItem_Goal_PatID: PatientIDForeign Keys FK_Item_Goal_PatientID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID
OrderItemEXTvarchar(20)20NOT NULLExternal Order Number
Indexes XItem_Goal_CurID_IDCurrentIDnumeric(16,0)9NOT NULLThis points to the current version of the goal in the dbo.Goal table.
QODE[dbo].[dict_id]5NOT NULLResultable Item. Link to QO_DE.ID. Always 0.
QODETvarchar(255)255NOT NULLResultable Item entryname. QO_DE.Entryname. Always blank.
QOMod1DE[dbo].[dict_id]5NOT NULLOrdable Item Modifier. Link to QO_Mod_DE.ID. Always 0.
QOMod2DE[dbo].[dict_id]5NOT NULLOrdable Item Modifier. Link to QO_Mod_DE.ID. Always 0.
QOMod3DE[dbo].[dict_id]5NOT NULLOrdable Item Modifier. Link to QO_Mod_DE.ID. Always 0.
QOModDETvarchar(255)255NOT NULLOrdable Item Modifier entryname. Link to QO_Mod_DE.Entryname. Always blank.
QOClassificationDE[dbo].[dict_id]5NOT NULLOrderable Item. Link to QO_Classification_DE.ID. Always 0.
QOClassificationDETvarchar(255)255NOT NULLOrdable Item entryname. Link to QO_Classification_DE.Entryname. Always blank.
DocFolderIDnumeric(16,0)9NOT NULLNot used, weill default to 0
EntryNamevarchar(255)255NOT NULLentryname (Not used though, will be blank)
CreateDTTMdatetime8NOT NULLdate Goal was added to the patient's chart
LastUpdateDTTMdatetime8NOT NULLdate Goal was last updated
Check Constraints CK_Item_Goal_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')HasSecurityFLAG[dbo].[BOOL]1NOT NULLSecurity? Y/N
Check Constraints CK_Item_Goal_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')HasAnnotationFLAG[dbo].[BOOL]1NOT NULLAnnotated? Y/N
Check Constraints CK_Item_Goal_IsAbnormalFLAG_Yes_Or_No : ([IsAbnormalFLAG]='N' OR [IsAbnormalFLAG]='Y')IsAbnormalFLAG[dbo].[BOOL]1NOT NULLAbnormal? Y/N
Check Constraints CK_Item_Goal_IsErrorFLAG_Yes_Or_No : ([IsErrorFLAG]='N' OR [IsErrorFLAG]='Y')IsErrorFLAG[dbo].[BOOL]1NOT NULLEntered in Error? Y/N
DetailTypechar(1)1NOT NULLNot used, will be blank
ItemTypechar(2)2NOT NULLGL for Goal
DecodedValuevarchar(255)255NOT NULLNot used, will be blank
PerformedDTTMdatetime8NOT NULLDate Goal was added to the patient's chart
ItemPlanID[dbo].[uniqueid]9NULL allowedGoal order ID to which the result was entered. Link to Item_Plan.ID