Tables [dbo].[Service_Location_DE]
Standard HealthCare Service Location entries provided by CDC. "Requested Performing location" and "Where performed" dictionaries are mapped to these values. When the Cancer Registry report is sent to Registry, CDW (AAP) team uses this mapping to send standard values of "Requested Performing location" and "Where performed".
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Service_Location_DE: IDID[dbo].[dict_id]5NOT NULL1 - 1Key to the Service_Location_DE table.
EnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
DefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Entry[dbo].[dict_id]5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Indexes NIX_Service_Location_DE_EntryCodeEntryCode[dbo].[code]10NOT NULLConcept Code Received from CDC
Indexes NIX_Service_Location_DE_EntryNameEntryName[dbo].[name]255NOT NULLConcept Name Received from CDC
Indexes NIX_Service_Location_DE_EntryMnemonicEntryMnemonic[dbo].[code]10NOT NULLConcept Code Received from CDC
Check Constraints CK_Service_Location_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLIs the entry inactive (Y/N)?
Check Constraints CK_Service_Location_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLIs the entry Enforced (Y/N)? Enforced entries can not be modified by the application.
Check Constraints CK_Service_Location_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')IsCurrentFLAG[dbo].[BOOL]1NOT NULLIs the entry Current (Y/N)?
EffectiveDTdatetime8NULL allowedEffective Date. This is the last edited date.
PrefEntryNamevarchar(250)250NULL allowedPreferred Concept Name Received from CDC
PrefAltCodevarchar(50)50NULL allowedConcept Code Received from CDC
CodeSystemOIDvarchar(50)50NULL allowed('2.16.840.1.113883.6.259')Code System ID received from CDC
CodeSystemNamevarchar(50)50NULL allowed('Healthcare Service Location (HL7)')Code System Name received from CDC
CodeSystemCodevarchar(50)50NULL allowed('PH_HealthcareServiceLoc_HL7_V3')Code System Code received from CDC
CodeSystemVervarchar(50)50NULL allowed('20100812')Code System Version received from CDC
HL7TableCodevarchar(50)50NULL allowed('HSLOC')HL7 code received from CDC