Skip to site content

Data Dictionary

There are 21 matches.
id Physical Name Logical Name Description Category
1 BIRTH_DC Date of Birth (character format) Patient's Date of Birth. Expected format is CCYYMMDD. 3.0000
1 BIRTH_DT Date of Birth (date format) Patient's Date of Birth. Date field. 3.0000
1 DATE_LAST_MOD_TS Date of Last Update Date this record was last modified by the local registration/encounter system. Date format is CCYYMMDD. 2.0000
1 DEATH_DC Date of Death (character format) Patient's Date of Death. Expected format is CCYYMMDD. 3.0000
1 DEATH_DT Date of Death (date format) Patient's Date of Death. Date field. 3.0000
1 DEATH_ICD9_DX_CD Cause of Death ICD-9 code for cause of death. Preferred format is to include the dot. Nationally recognized standard code set. 3.0000
1 EXPORT_ID Export ID Each export file that is received by the DW will be assigned a unique export ID number. This will allow us to track each record back to the "raw data file" if necessary. It also allows us to track certain information specific to each export such as number of records, date received, etc. 100.0000
1 FATHER_FIRST_NM Father's First Name Father's First Name. 3.0000
1 FATHER_LAST_NM Father's Last Name Father's Last Name. 3.0000
1 FATHER_MID_NM Father's Middle Name Father's Middle Name. 3.0000
Page 1 of 3