Data Dictionary
Selected table: PAT_REG_SSN
- Home
- Data Dictionary
- Table List
- PAT_REG_SSN
id | Physical Name | Logical Name | Description | Category |
---|---|---|---|---|
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 | REG_ID | NDW Registration Record Identifier | This identifier is generated internally by the NDW and is used to uniquely identify a registration record. | N/A |
1 | REGION_ABBR_CD | Region Abbreviation Code | Alpha (3-char) designator indicating the IHS region (e.g. ALB for Albuquerque). | N/A |
1 | SSN | Social Security Number | Social Security Number of the patient. | 3.0000 |
1 | SUSP_SSN_FG | Suspect SSN Number Flag | This flag is set using the algorithm currently used by NPIRS to determine if an SSN is invalid and therefore should be excluded from the export to SSA. This way we only have to check the SSN one time. | 100.2000 |