Data Dictionary
Selected table: PAT_REG
- Home
- Data Dictionary
- Table List
- PAT_REG
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