Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
  | ID | [dbo].[uniqueid] | 9 | NOT NULL | Key to the dbo.goal table |
 ![Foreign Keys FK_Goal_ItemID: [dbo].[Item_Goal].ItemID Foreign Keys FK_Goal_ItemID: [dbo].[Item_Goal].ItemID](../../../../Images/fk.png) | ItemID | [dbo].[uniqueid] | 9 | NOT NULL | Item. link to Item_Goal.ID |
| NoteActivityID | [dbo].[uniqueid] | 9 | NOT NULL | Audit Note. Link to Act_Hdr_Note.ID. |
![Foreign Keys FK_Goal_GoalStatusDE: [dbo].[Order_Status_DE].GoalStatusDE Foreign Keys FK_Goal_GoalStatusDE: [dbo].[Order_Status_DE].GoalStatusDE](../../../../Images/fk.png) | GoalStatusDE | [dbo].[dict_id] | 5 | NOT NULL | Status. Link to Order_Status_DE.ID. |
![Foreign Keys FK_Goal_TargetAnswerDataTypeDE: [dbo].[Answer_Data_Type_DE].TargetAnswerDataTypeDE Foreign Keys FK_Goal_TargetAnswerDataTypeDE: [dbo].[Answer_Data_Type_DE].TargetAnswerDataTypeDE](../../../../Images/fk.png) | TargetAnswerDataTypeDE | [dbo].[dict_id] | 5 | NOT NULL | Data type. Link to Answer_Data_Type_DE.ID |
![Foreign Keys FK_Goal_TargetOperandDE: [dbo].[Operand_DE].TargetOperandDE Foreign Keys FK_Goal_TargetOperandDE: [dbo].[Operand_DE].TargetOperandDE](../../../../Images/fk.png) | TargetOperandDE | [dbo].[dict_id] | 5 | NOT NULL | Operand. link to Operand_DE.ID |
| TargetValue | varchar(255) | 255 | NOT NULL | The goal target. It's a varchar field but can also hold numeric values. App will treat it as text/numeric based on the TargetAnswerDataTypeDE column |
![Foreign Keys FK_Goal_TargetPicklistID: [dbo].[Picklist].TargetPicklistID Foreign Keys FK_Goal_TargetPicklistID: [dbo].[Picklist].TargetPicklistID](../../../../Images/fk.png) | TargetPicklistID | [dbo].[dict_id] | 5 | NOT NULL | Answer Picklist. Link to Picklist.ID |
![Foreign Keys FK_Goal_TargetPicklistAnswerDE: [dbo].[Answer_DE].TargetPicklistAnswerDE Foreign Keys FK_Goal_TargetPicklistAnswerDE: [dbo].[Answer_DE].TargetPicklistAnswerDE](../../../../Images/fk.png) | TargetPicklistAnswerDE | [dbo].[dict_id] | 5 | NOT NULL | Target Answer. Link to Answer_DE.ID |
| StartDateFuzzyWhen | varchar(50) | 50 | NOT NULL | Date goal started in fuzzy format (ie 04 Jan 2016) |
| StartDateFuzzySpecificity | varchar(1) | 1 | NOT NULL | Should be a D for "date" or "F" for fuzzy date. |
| StartDateFuzzySortAs | varchar(50) | 50 | NOT NULL | Start date in a date format. |
| DurationNumber | int | 4 | NOT NULL | A number for duration. Works along with DurationUnits |
| DurationUnits | varchar(2) | 2 | NOT NULL | Days/Months/Years |
| ToBeMetDTTM | datetime | 8 | NOT NULL | Calculated date based on DurationNumber and DurationUnits |
| BaseLineValue | varchar(255) | 255 | NOT NULL | The current value of the item the goal was set for. We store the last result saved prior to the goal being started. So if the patients Glucose was 150 when a goat was started to bring it to 120… the baseline would be 150. |
| ManagedByProviderID | [dbo].[uniqueid] | 9 | NOT NULL | When ManagedByProvidertype is P it would tie to provider.id. When R it would tie to referring_provider_de.id |
| ManagedByProviderType | char(1) | 1 | NOT NULL | P - Provider/R - Referring Provider |
| TrackedByID | [dbo].[uniqueid] | 9 | NOT NULL | Who is tracking the goal. Link to idx_user.id, or team_de.id, or referring_provider_de.id depending on the TrackedByType |
| TrackedByType | char(1) | 1 | NOT NULL | U/T/R (U for user/provider, T for Team, R for referringprovider. |
| PatientConfidenceLevel | int | 4 | NOT NULL | 0-10 rating of patient confidence |
| RecordedDTTM | datetime | 8 | NOT NULL | Date entry was recorded |
| OverdueDTTM | datetime | 8 | NOT NULL | Date entry is overdue |
![Foreign Keys FK_Goal_SiteDE: [dbo].[Site_DE].SiteDE Foreign Keys FK_Goal_SiteDE: [dbo].[Site_DE].SiteDE](../../../../Images/fk.png) | SiteDE | [dbo].[dict_id] | 5 | NOT NULL | Site. Link to Site_DE.ID. |
| WhoForID | [dbo].[uniqueid] | 9 | NOT NULL | user/provider the goal is tied to. Link to dbo.Idx_user.id |
| WhoDidItID | [dbo].[uniqueid] | 9 | NOT NULL | user/provider who added the goal. Link to dbo.Idx_user.id |
| LinkedItemType | char(2) | 2 | NOT NULL | PL/RS/FI (order, result, finding) |
| LinkedItemDE | [dbo].[dict_id] | 5 | NOT NULL | ItemID. When The LinkedItemType is 0 this corresponds to dbo.qo_classification_de. When it's RS or FI it corresponds to dbo.qo_de |
| ParentGoalItemID | [dbo].[uniqueid] | 9 | NOT NULL | ID of parent goal. Link to Item_Goal.id |
| ProblemLinkList | varchar(500) | 500 | NOT NULL | A piped list of problems the goal could be tied to. Each entry in the list links to dbo.Problem_header.id |
![Check Constraints CK_Goal_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y') Check Constraints CK_Goal_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y')](../../../../Images/c-constraint.png) | IsUnverifiedFLAG | [dbo].[BOOL] | 1 | NOT NULL | Unverified? Y/N |
| VerificationTaskOwnerID | [dbo].[uniqueid] | 9 | NOT NULL | ID of user/team who owns a task. Link to idx_user.id |
| VerificationTaskOwnerType | char(10) | 10 | NOT NULL | Type of owner. Would be U/T for user or team |
![Check Constraints CK_Goal_SaveAsDefault_Yes_Or_No : ([SaveAsDefault]='N' OR [SaveAsDefault]='Y') Check Constraints CK_Goal_SaveAsDefault_Yes_Or_No : ([SaveAsDefault]='N' OR [SaveAsDefault]='Y')](../../../../Images/c-constraint.png) | SaveAsDefault | [dbo].[BOOL] | 1 | NOT NULL | Y/N |