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 | ||