Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
  | ID | [dbo].[uniqueid] | 9 | NOT NULL | Key to the Item_Goal table |
 | ActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | Activity Header. Link to dbo.Act_Hdr_Other.ID |
 ![Foreign Keys FK_Item_Goal_PatientID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Item_Goal_PatientID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | Patient. Link to Patient_Member.ID |
| OrderItemEXT | varchar(20) | 20 | NOT NULL | External Order Number |
 | CurrentID | numeric(16,0) | 9 | NOT NULL | This points to the current version of the goal in the dbo.Goal table. |
| QODE | [dbo].[dict_id] | 5 | NOT NULL | Resultable Item. Link to QO_DE.ID. Always 0. |
| QODET | varchar(255) | 255 | NOT NULL | Resultable Item entryname. QO_DE.Entryname. Always blank. |
| QOMod1DE | [dbo].[dict_id] | 5 | NOT NULL | Ordable Item Modifier. Link to QO_Mod_DE.ID. Always 0. |
| QOMod2DE | [dbo].[dict_id] | 5 | NOT NULL | Ordable Item Modifier. Link to QO_Mod_DE.ID. Always 0. |
| QOMod3DE | [dbo].[dict_id] | 5 | NOT NULL | Ordable Item Modifier. Link to QO_Mod_DE.ID. Always 0. |
| QOModDET | varchar(255) | 255 | NOT NULL | Ordable Item Modifier entryname. Link to QO_Mod_DE.Entryname. Always blank. |
| QOClassificationDE | [dbo].[dict_id] | 5 | NOT NULL | Orderable Item. Link to QO_Classification_DE.ID. Always 0. |
| QOClassificationDET | varchar(255) | 255 | NOT NULL | Ordable Item entryname. Link to QO_Classification_DE.Entryname. Always blank. |
| DocFolderID | numeric(16,0) | 9 | NOT NULL | Not used, weill default to 0 |
| EntryName | varchar(255) | 255 | NOT NULL | entryname (Not used though, will be blank) |
| CreateDTTM | datetime | 8 | NOT NULL | date Goal was added to the patient's chart |
| LastUpdateDTTM | datetime | 8 | NOT NULL | date Goal was last updated |
![Check Constraints CK_Item_Goal_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y') Check Constraints CK_Item_Goal_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')](../../../../Images/c-constraint.png) | HasSecurityFLAG | [dbo].[BOOL] | 1 | NOT NULL | Security? Y/N |
![Check Constraints CK_Item_Goal_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y') Check Constraints CK_Item_Goal_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')](../../../../Images/c-constraint.png) | HasAnnotationFLAG | [dbo].[BOOL] | 1 | NOT NULL | Annotated? Y/N |
![Check Constraints CK_Item_Goal_IsAbnormalFLAG_Yes_Or_No : ([IsAbnormalFLAG]='N' OR [IsAbnormalFLAG]='Y') Check Constraints CK_Item_Goal_IsAbnormalFLAG_Yes_Or_No : ([IsAbnormalFLAG]='N' OR [IsAbnormalFLAG]='Y')](../../../../Images/c-constraint.png) | IsAbnormalFLAG | [dbo].[BOOL] | 1 | NOT NULL | Abnormal? Y/N |
![Check Constraints CK_Item_Goal_IsErrorFLAG_Yes_Or_No : ([IsErrorFLAG]='N' OR [IsErrorFLAG]='Y') Check Constraints CK_Item_Goal_IsErrorFLAG_Yes_Or_No : ([IsErrorFLAG]='N' OR [IsErrorFLAG]='Y')](../../../../Images/c-constraint.png) | IsErrorFLAG | [dbo].[BOOL] | 1 | NOT NULL | Entered in Error? Y/N |
| DetailType | char(1) | 1 | NOT NULL | Not used, will be blank |
| ItemType | char(2) | 2 | NOT NULL | GL for Goal |
| DecodedValue | varchar(255) | 255 | NOT NULL | Not used, will be blank |
| PerformedDTTM | datetime | 8 | NOT NULL | Date Goal was added to the patient's chart |
| ItemPlanID | [dbo].[uniqueid] | 9 | NULL allowed | Goal order ID to which the result was entered. Link to Item_Plan.ID |