Tables [dbo].[RCD_Item]
Resultable Concept Item
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_RCD_Item: IDID[dbo].[dict_id]5NOT NULLKey to the RCD_Item table
Indexes TWstat_RCD_Item_RCDHeaderIDForeign Keys FK_RCD_Item_RCD_Header_ID: [dbo].[RCD_Header].RCDHeaderIDRCDHeaderID[dbo].[dict_id]5NOT NULLResultable Concept Header. Link to RCD_Header.ID
Indexes TWstat_RCD_Item_EntryCodeEntryCode[dbo].[code]10NOT NULLCode
EntryName[dbo].[name]255NOT NULLName
EntryMnemonic[dbo].[code]10NOT NULLMnemonic
Check Constraints CK_RCD_Item_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLInactive (Y/N)
Check Constraints CK_RCD_Item_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLEnforced (Y/N)
Check Constraints CK_RCD_Item_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')IsCurrentFLAG[dbo].[BOOL]1NOT NULLCurrent (Y/N)
EffectiveDTdatetime8NULL allowedEffective Date
SecurityCodeDE[dbo].[dict_id]5NOT NULL(0)Security Code. Link to Security_Code_DE.ID
DisplayName[dbo].[name]255NOT NULLDisplay name
UnitsDE[dbo].[dict_id]5NOT NULL(0)Units. Link to Unit_Code_DE.ID
UnitsPicklistID[dbo].[dict_id]5NOT NULLUnits Picklist. Link to Picklist.ID
AnswerDataTypeDE[dbo].[dict_id]5NOT NULL(0)Answer Data Type. Link to Answer_Data_Type_DE.ID
AnswerPicklistID[dbo].[dict_id]5NOT NULL(0)Answer Picklist. Link to Picklist.ID
DateFormatDE[dbo].[dict_id]5NOT NULL(0)Date Format. Link to Date_Format_DE.ID
PicklistDefaultDE[dbo].[dict_id]5NOT NULL(0)Default Answer from the AnswerPickListID. Link to Answer_DE.ID
Incrementreal4NOT NULLIncrement for result
PrecisionValuereal4NOT NULLPrecision Value for result
NumericMinimumValuereal4NOT NULLMinimum Value
NumericMaximumValuereal4NOT NULLMaximum Value
LOINCvarchar(50)50NOT NULLLOINC Code
MaxCharInAnswersmallint2NOT NULLMaximum Characters for the result
LinesInAnswerDisplaysmallint2NOT NULLLines in answer for the result
TextInputCheckingDescriptionvarchar(255)255NOT NULLText input checking description
CreateDTTMdatetime8NOT NULLCreate time
UpdateIdentifiervarchar(255)255NOT NULLUpdate Indentifier
UpdateTypevarchar(25)25NOT NULLUpdate Type