Data Dictionary
Selected table: USERPOP
- Home
- Data Dictionary
- Table List
- USERPOP
id | Physical Name | Logical Name | Description | Category |
---|---|---|---|---|
1 | ACTIVE_FG | Active Flag | The flag indicates whether a registration was active for a specified user population reporting time period. A registration is flagged as active if there was a workload-reportable encounter during the specified time period. | N/A |
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 | FIRST_NM | First Name | First name of the patient; could also be an alias. | 3.0000 |
1 | GENDER_CD | Gender | Sex of Patient as provided by the patient's registration information. (M = Male, F = Female, U = Unknown) | 3.0000 |
1 | INDIAN_STATUS_FG | Indian Status Flag | Flag indicating whether a particular registration is to be considered an Indian for purposes of user population reporting. | N/A |
1 | INTEGRITY_ID | Integrity ID | A distinct integrity id identifies all registrations that are the same person. This id will then be utilized to identify a group of duplicate registrations so that the most current one may be selected according to the business rules. | N/A |
1 | LAST_NM | Last Name | Last name of the patient; could also be an alias. | 3.0000 |
1 | MID_NM | Middle Name | Middle name of the patient; could also be an alias. | 3.0000 |
Page 1 of 3