Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 (4) | ID | [dbo].[dict_id] | 5 | NOT NULL | 1 - 1 | | Key to the IDX_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. |
(7) | 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) | EntryCode | [dbo].[code] | 10 | NOT NULL | | | Unique alphanumeric code. Brief but cryptic. |
 | Entry | [dbo].[dict_id] | 5 | NOT NULL | | | Calculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set |
(4)![Check Constraints CK_IDX_Task_Action_DE_IsInactiveFlag_Yes_Or_No : ([IsInactiveFlag]='N' OR [IsInactiveFlag]='Y') Check Constraints CK_IDX_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_Task_Action_DE_IsEnforcedFlag_Yes_Or_No : ([IsEnforcedFlag]='N' OR [IsEnforcedFlag]='Y') Check Constraints CK_IDX_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 |
(7)![Check Constraints CK_IDX_Task_Action_DE_IsCurrentFlag_Yes_Or_No : ([IsCurrentFlag]='N' OR [IsCurrentFlag]='Y') Check Constraints CK_IDX_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. |
| EffectiveDT | datetime | 8 | NOT NULL | | | Time of last modification (not "when this row goes into effect") |
 | SecurityCodeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Security Code. |
![Foreign Keys FK_IDX_Task_Action_DE_IDXSuprtTaskActionDE_IDX_Suprt_Task_Action_DE_ID: [dbo].[IDX_Suprt_Task_Action_DE].IDXSuprtTaskActionDE Foreign Keys FK_IDX_Task_Action_DE_IDXSuprtTaskActionDE_IDX_Suprt_Task_Action_DE_ID: [dbo].[IDX_Suprt_Task_Action_DE].IDXSuprtTaskActionDE](../../../../Images/fk.png) | IDXSuprtTaskActionDE | [dbo].[dict_id] | 5 | NOT NULL | | | Task Action. Link to IDX_Suprt_Task_Action_DE.ID |
| URL | varchar(2000) | 2000 | NULL allowed | | | Task Navigation URL |
![Check Constraints CK_IDX_Task_Action_DE_ExpiringTaskFLAG_Yes_Or_No : ([ExpiringTaskFLAG]='N' OR [ExpiringTaskFLAG]='Y') Check Constraints CK_IDX_Task_Action_DE_ExpiringTaskFLAG_Yes_Or_No : ([ExpiringTaskFLAG]='N' OR [ExpiringTaskFLAG]='Y')](../../../../Images/c-constraint.png) | ExpiringTaskFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Auto complete the overdue tasks (Y/N)? |
![Check Constraints CK_IDX_Task_Action_DE_DelegateFLAG_Yes_Or_No : ([DelegateFLAG]='N' OR [DelegateFLAG]='Y') Check Constraints CK_IDX_Task_Action_DE_DelegateFLAG_Yes_Or_No : ([DelegateFLAG]='N' OR [DelegateFLAG]='Y')](../../../../Images/c-constraint.png) | DelegateFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Can delegate the Task (Y/N)? |
| UrgentDueDateDefault | smallint | 2 | NOT NULL | | (0) | Default Urgent Overdue days |
| UrgentDueTimeDefault | smallint | 2 | NOT NULL | | (360) | Default Urgent Overdue time in minutes |
| ASAPDueDateDefault | smallint | 2 | NOT NULL | | (2) | Default ASAP Overdue days |
| ASAPDueTimeDefault | smallint | 2 | NOT NULL | | (0) | Default ASAP Overdue time in minutes |
| RoutineDueDateDefault | smallint | 2 | NOT NULL | | (7) | Default Routine Overdue days |
| RoutineDueTimeDefault | smallint | 2 | NOT NULL | | (0) | Default Routine Overdue time in minutes |
![Check Constraints CK_IDX_Task_Action_DE_CompleteWhenCopyToNoteFLAG_Yes_Or_No : ([CompleteWhenCopyToNoteFLAG]='N' OR [CompleteWhenCopyToNoteFLAG]='Y') Check Constraints CK_IDX_Task_Action_DE_CompleteWhenCopyToNoteFLAG_Yes_Or_No : ([CompleteWhenCopyToNoteFLAG]='N' OR [CompleteWhenCopyToNoteFLAG]='Y')](../../../../Images/c-constraint.png) | CompleteWhenCopyToNoteFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Complete the Task when copy to Note |
![Foreign Keys FK_IDX_Task_Action_DE_DefaultEncounterTypeDE: [dbo].[Encounter_Type_DE].DefaultEncounterTypeDE Foreign Keys FK_IDX_Task_Action_DE_DefaultEncounterTypeDE: [dbo].[Encounter_Type_DE].DefaultEncounterTypeDE](../../../../Images/fk.png) | DefaultEncounterTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Default Encounter type. Link to Encounter_Type_DE.ID |
![Foreign Keys FK_IDX_Task_Action_DE_DefaultDocumentTypeDE: [dbo].[Document_Type_de].DefaultDocumentTypeDE Foreign Keys FK_IDX_Task_Action_DE_DefaultDocumentTypeDE: [dbo].[Document_Type_de].DefaultDocumentTypeDE](../../../../Images/fk.png) | DefaultDocumentTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Default Note type. Link to Document_Type_DE.ID |
| SequenceNumber | smallint | 2 | NULL allowed | | | Display sequence number for task name. |
| NotActiveUntilOverdueFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Task becomes active when overdue |