Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
  (8) | ID | [dbo].[dict_id] | 5 | NOT NULL | 1 - 1 | | Key to the Note_Type_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 |
 | EntryCode | [dbo].[code] | 10 | NOT NULL | | | Unique alphanumeric code. Brief but cryptic. |
 (6) | EntryName | [dbo].[name] | 255 | NOT NULL | | | Unique alphanumeric "friendly" display name |
 | EntryMnemonic | [dbo].[code] | 10 | NOT NULL | | | Typically the same as the Code value, but can be blank. If present, it must be unique. |
 ![Check Constraints CK_Note_Type_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_Note_Type_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_Note_Type_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y') Check Constraints CK_Note_Type_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 |
 (8)![Check Constraints CK_Note_Type_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y') Check Constraints CK_Note_Type_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 | NULL allowed | | | Time of last modification (not "when this row goes into effect") |
 ![Foreign Keys FK_Note_Type_DE_SecurityCodeDE_Security_Code_DE_ID: [dbo].[Security_Code_DE].SecurityCodeDE Foreign Keys FK_Note_Type_DE_SecurityCodeDE_Security_Code_DE_ID: [dbo].[Security_Code_DE].SecurityCodeDE](../../../../Images/fk.png) | SecurityCodeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Link to Security_Code_DE.ID to restrict access to this note type |
![Check Constraints CK_Note_Type_DE_CMSNoteSelectorFlag_Yes_Or_No : ([CMSNoteSelectorFlag]='N' OR [CMSNoteSelectorFlag]='Y') Check Constraints CK_Note_Type_DE_CMSNoteSelectorFlag_Yes_Or_No : ([CMSNoteSelectorFlag]='N' OR [CMSNoteSelectorFlag]='Y')](../../../../Images/c-constraint.png) | CMSNoteSelectorFlag | [dbo].[BOOL] | 1 | NOT NULL | | ('Y') | Y=appear on the note selector |
![Check Constraints CK_Note_Type_DE_UnsignedNotesRPTFlag_Yes_Or_No : ([UnsignedNotesRPTFlag]='N' OR [UnsignedNotesRPTFlag]='Y') Check Constraints CK_Note_Type_DE_UnsignedNotesRPTFlag_Yes_Or_No : ([UnsignedNotesRPTFlag]='N' OR [UnsignedNotesRPTFlag]='Y')](../../../../Images/c-constraint.png) | UnsignedNotesRPTFlag | [dbo].[BOOL] | 1 | NOT NULL | | ('Y') | Y=appear on the unsigned notes report; N=omit |