Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 | ID | [dbo].[dict_id] | 5 | NOT NULL | | Key to the RCD_Item table |
 ![Foreign Keys FK_RCD_Item_RCD_Header_ID: [dbo].[RCD_Header].RCDHeaderID Foreign Keys FK_RCD_Item_RCD_Header_ID: [dbo].[RCD_Header].RCDHeaderID](../../../../Images/fk.png) | RCDHeaderID | [dbo].[dict_id] | 5 | NOT NULL | | Resultable Concept Header. Link to RCD_Header.ID |
 | EntryCode | [dbo].[code] | 10 | NOT NULL | | Code |
| EntryName | [dbo].[name] | 255 | NOT NULL | | Name |
| EntryMnemonic | [dbo].[code] | 10 | NOT NULL | | Mnemonic |
![Check Constraints CK_RCD_Item_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_RCD_Item_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Inactive (Y/N) |
![Check Constraints CK_RCD_Item_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y') Check Constraints CK_RCD_Item_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')](../../../../Images/c-constraint.png) | IsEnforcedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Enforced (Y/N) |
![Check Constraints CK_RCD_Item_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y') Check Constraints CK_RCD_Item_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')](../../../../Images/c-constraint.png) | IsCurrentFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Current (Y/N) |
| EffectiveDT | datetime | 8 | NULL allowed | | Effective Date |
| SecurityCodeDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Security Code. Link to Security_Code_DE.ID |
| DisplayName | [dbo].[name] | 255 | NOT NULL | | Display name |
| UnitsDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Units. Link to Unit_Code_DE.ID |
| UnitsPicklistID | [dbo].[dict_id] | 5 | NOT NULL | | Units Picklist. Link to Picklist.ID |
| AnswerDataTypeDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Answer Data Type. Link to Answer_Data_Type_DE.ID |
| AnswerPicklistID | [dbo].[dict_id] | 5 | NOT NULL | (0) | Answer Picklist. Link to Picklist.ID |
| DateFormatDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Date Format. Link to Date_Format_DE.ID |
| PicklistDefaultDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Default Answer from the AnswerPickListID. Link to Answer_DE.ID |
| Increment | real | 4 | NOT NULL | | Increment for result |
| PrecisionValue | real | 4 | NOT NULL | | Precision Value for result |
| NumericMinimumValue | real | 4 | NOT NULL | | Minimum Value |
| NumericMaximumValue | real | 4 | NOT NULL | | Maximum Value |
| LOINC | varchar(50) | 50 | NOT NULL | | LOINC Code |
| MaxCharInAnswer | smallint | 2 | NOT NULL | | Maximum Characters for the result |
| LinesInAnswerDisplay | smallint | 2 | NOT NULL | | Lines in answer for the result |
| TextInputCheckingDescription | varchar(255) | 255 | NOT NULL | | Text input checking description |
| CreateDTTM | datetime | 8 | NOT NULL | | Create time |
| UpdateIdentifier | varchar(255) | 255 | NOT NULL | | Update Indentifier |
| UpdateType | varchar(25) | 25 | NOT NULL | | Update Type |