Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
  | ID | [dbo].[dict_id] | 5 | NOT NULL | 1 - 1 | | Key to the IDX_Suprt_Task_Action_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 | | | Calculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set |
(3) | EntryCode | [dbo].[code] | 10 | NOT NULL | | | Unique alphanumeric code. Brief but cryptic. |
(4) | EntryName | [dbo].[name] | 255 | NOT NULL | | | Unique alphanumeric "friendly" display name |
(3) | EntryMnemonic | [dbo].[code] | 10 | NOT NULL | | | Typically the same as the Code value, but can be blank. If present, it must be unique |
(3)![Check Constraints CK_IDX_Suprt_Task_Action_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_IDX_Suprt_Task_Action_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y=row is not active; N=row is active. (Rows are inactivated rather than deleted for history) |
![Check Constraints CK_IDX_Suprt_Task_Action_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y') Check Constraints CK_IDX_Suprt_Task_Action_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')](../../../../Images/c-constraint.png) | IsEnforcedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y=row is readonly; N=row is modifiable |
(4)![Check Constraints CK_IDX_Suprt_Task_Action_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y') Check Constraints CK_IDX_Suprt_Task_Action_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')](../../../../Images/c-constraint.png) | IsCurrentFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Usually 'Y' but occasionally used to subordinate rows. Not exposed to the end user. |
![Check Constraints CK_IDX_Suprt_Task_Action_DE_IsSystemGeneratedOnlyFLAG_Yes_Or_No : ([IsSystemGeneratedOnlyFLAG]='N' OR [IsSystemGeneratedOnlyFLAG]='Y') Check Constraints CK_IDX_Suprt_Task_Action_DE_IsSystemGeneratedOnlyFLAG_Yes_Or_No : ([IsSystemGeneratedOnlyFLAG]='N' OR [IsSystemGeneratedOnlyFLAG]='Y')](../../../../Images/c-constraint.png) | IsSystemGeneratedOnlyFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Indicates whether the task is generated only by System (Y/N)? |
 ![Check Constraints CK_IDX_Suprt_Task_Action_DE_NavigateFlag_Yes_Or_No : ([NavigateFlag]='N' OR [NavigateFlag]='Y') Check Constraints CK_IDX_Suprt_Task_Action_DE_NavigateFlag_Yes_Or_No : ([NavigateFlag]='N' OR [NavigateFlag]='Y')](../../../../Images/c-constraint.png) | NavigateFlag | [dbo].[BOOL] | 1 | NOT NULL | | | Can user open the respective modules (Rx renewal, Note etc) from this task(Y/N)? |
![Check Constraints CK_IDX_Suprt_Task_Action_DE_ManualCompleteFlag_Yes_Or_No : ([ManualCompleteFlag]='N' OR [ManualCompleteFlag]='Y') Check Constraints CK_IDX_Suprt_Task_Action_DE_ManualCompleteFlag_Yes_Or_No : ([ManualCompleteFlag]='N' OR [ManualCompleteFlag]='Y')](../../../../Images/c-constraint.png) | ManualCompleteFlag | [dbo].[BOOL] | 1 | NOT NULL | | | Can complete the task manually(Y/N)? |
| EffectiveDT | datetime | 8 | NOT NULL | | | Time of last modification (not "when this row goes into effect") |
| IDXSupportingApplicationID | [dbo].[dict_id] | 5 | NOT NULL | | | Application. Link to Application_DE.ID |
| DefaultTeamDE | [dbo].[dict_id] | 5 | NOT NULL | | | Default Team . Link to Team_DE.ID |
| TaskType | varchar(30) | 30 | NOT NULL | | | Task Type. Notify, Administer, Sign etc. |
| WorkType | varchar(30) | 30 | NOT NULL | | | Module. Order, Result, Note, Immunization etc. |
| DocumentProductID | varchar(30) | 30 | NULL allowed | | | Frame work Product Name |
| DocumentApplicationID | varchar(30) | 30 | NULL allowed | | | Frame work Application name |
| DocumentID | varchar(30) | 30 | NULL allowed | | | Workspace to navigate this task. |
| URL | varchar(2000) | 2000 | NULL allowed | | | Task Navigation URL |
| VersionCompatibilityMask | int | 4 | NULL allowed | | (16) | Version Compatibility. 8 - Version 3 16 - Version 4 32 - Version 11 |