dbo.Regulatory_Loinc

[dbo].[Regulatory_Loinc_DE]

Regulatory Loinc Dictionary table of special LOINC Codes different than regular LOINC Codes

Name	Data Type	Max Length (Bytes)	Nullability	Identity	Description
ID	[dbo].[dict_id]	5	NOT NULL	1 - 1	Key to the Regulatory_Loinc_DE table
EnterpriseEntryID	[dbo].[uniqueid]	9	NOT NULL		Key to the dictionary_Entry table. This is a unique identifier across all dictionaries.
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.
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
IsInactiveFLAG	[dbo].[BOOL]	1	NOT NULL		Y=row is not active; N=row is active. (Rows are inactivated rather than deleted for history)
IsEnforcedFLAG	[dbo].[BOOL]	1	NOT NULL		Y=row is readonly; N=row is modifiable
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")
FHIRCategoryCode	varchar(30)	30	NULL allowed		FHIR Category code
AdditionalFHIRCategoryCode	varchar(30)	30	NULL allowed		Additional FHIR Category code
SNOMEDCode	varchar(18)	18	NULL allowed		SNOMED code
LOINCCode	varchar(10)	10	NULL allowed		LOINC code