Person Demo is a table in the SID system that stores data pertinent to person demographics. The ultimate source of each data-item, or column is noted, in addition to any relevant calculations/logic to derive the data.
| COLUMN_NAME | data_type | MaxLength | Source_System | Source_Table | Source_Column_Name | MetaMart_Description | Notes_Logic | Meta_Mart_Link |
| TERMID | varchar | 8 | Run-time parameter | N/A | @TERMID' | N/A | Entered / passed through at run-time in ETL | |
| BENCH | varchar | 1 | Run-time parameter | N/A | @BENCH' (B, F, D, E) | N/A | Entered / passed through at run-time in ETL | |
| UID | varchar | 9 | DWHOUSE | PERSON_DEMO_VW | USF_ID or URESV_1 (starting at position 9 in field, if USF_ID is NULL) | |||
| REPT_INST | varchar | 4 | Literal | Via Query | USF | N/A | Stored Procedure - Proc-DataLoad_SID | |
| DEMO_DATA_SOURCE | varchar | 10 | DWHOUSE | PERSON_DEMO_VW | DEMO_DATA_SOURCE | |||
| BIRTH_YYYYMM_DT | varchar | 8 | DWHOUSE | PERSON_DEMO_VW | DT_BIRTH_YYYYMMDD | |||
| NAME_LAST | varchar | 22 | DWHOUSE | PERSON_DEMO_VW | NAME_LAST | |||
| NAME_FIRST | varchar | 14 | DWHOUSE | PERSON_DEMO_VW | NAME_FIRST | |||
| NAME_MI | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | NAME_MI | |||
| SUFFIX | varchar | 10 | DWHOUSE | PERSON_DEMO_VW | SUFFIX | |||
| GENDER | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | GENDER | |||
| RACE_ETHNICITY | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | Calculated values: O, H, X, M, I, A, B, P, W, X | Via CASE logic based on ethnic flags | ||
| HISPANIC_FLG | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | HISPANIC_FLG | |||
| AM_IND_ALASKAN_FLG | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | AM_IND_ALASKAN_FLG | |||
| ASIAN_FLG | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | ASIAN_FLG | |||
| BLACK_AFRICAN_AM_FLG | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | BLACK_AFRICAN_AM_FLG | |||
| NAT_HAWAII_PAC_IS_FLG | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | NAT_HAWAII_PAC_IS_FLG | |||
| WHITE_FLG | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | WHITE_FLG | |||
| NON_RES_ALIEN_FLG | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | NON_RES_ALIEN_FLG | |||
| NO_RACE_REPORT_FLG | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | NO_RACE_REPORT_FLG | |||
| U_RESV_1 | varchar | 50 | DWHOUSE | PERSON_DEMO_VW | U_RESV_1 | |||
| Oasis_PIDM | float | DWHOUSE | PERSON_DEMO_VW | OASIS_PIDM | ||||
| Context_Code | varchar | 5 | Run-time parameter | N/A | @context_code' (SIF, SIFP, SIFD) | N/A | Entered / passed through at run-time in ETL | |
| NAME_MIDDLE | varchar | 60 | DWHOUSE | PERSON_DEMO_VW | NAME_MIDDLE | |||
| CITZ_CODE | varchar | 2 | DWHOUSE | HUB_PERSON_CURRENT_V | CITZ_CODE | Via Stored Procedure Proc_DataLoad_SID_UpdateAuxFields | ||