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.
TableName | COLUMN_NAME | data_type | MaxLength | Source_System | Source_Table | Source_Column_Name | Notes_Logic | Meta Mart Description |
dbo.SID_Person_Demo | TERMID | varchar | 8 | Run-time parameter | N/A | @TERMID' | Entered/passed through at run-time in ETL | |
dbo.SID_Person_Demo | BENCH | varchar | 1 | Run-time parameter | N/A | @BENCH' (B, F, D, E) | Entered/passed through at run-time in ETL | |
dbo.SID_Person_Demo | UID | varchar | 9 | DWHOUSE | PERSON_DEMO_VW | USF_ID or URESV_1 (starting at position 9 in field, if USF_ID is NULL) | ||
dbo.SID_Person_Demo | REPT_INST | varchar | 4 | Literal | Via Query | USF | Stored Procedure - Proc-DataLoad_SID | |
dbo.SID_Person_Demo | DEMO_DATA_SOURCE | varchar | 10 | DWHOUSE | PERSON_DEMO_VW | DEMO_DATA_SOURCE | ||
dbo.SID_Person_Demo | BIRTH_YYYYMM_DT | varchar | 8 | DWHOUSE | PERSON_DEMO_VW | DT_BIRTH_YYYYMMDD | ||
dbo.SID_Person_Demo | NAME_LAST | varchar | 22 | DWHOUSE | PERSON_DEMO_VW | NAME_LAST | ||
dbo.SID_Person_Demo | NAME_FIRST | varchar | 14 | DWHOUSE | PERSON_DEMO_VW | NAME_FIRST | ||
dbo.SID_Person_Demo | NAME_MI | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | NAME_MI | ||
dbo.SID_Person_Demo | SUFFIX | varchar | 10 | DWHOUSE | PERSON_DEMO_VW | SUFFIX | ||
dbo.SID_Person_Demo | GENDER | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | GENDER | ||
dbo.SID_Person_Demo | 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 | |
dbo.SID_Person_Demo | HISPANIC_FLG | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | HISPANIC_FLG | ||
dbo.SID_Person_Demo | AM_IND_ALASKAN_FLG | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | AM_IND_ALASKAN_FLG | ||
dbo.SID_Person_Demo | ASIAN_FLG | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | ASIAN_FLG | ||
dbo.SID_Person_Demo | BLACK_AFRICAN_AM_FLG | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | BLACK_AFRICAN_AM_FLG | ||
dbo.SID_Person_Demo | NAT_HAWAII_PAC_IS_FLG | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | NAT_HAWAII_PAC_IS_FLG | ||
dbo.SID_Person_Demo | WHITE_FLG | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | WHITE_FLG | ||
dbo.SID_Person_Demo | NON_RES_ALIEN_FLG | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | NON_RES_ALIEN_FLG | ||
dbo.SID_Person_Demo | NO_RACE_REPORT_FLG | varchar | 1 | DWHOUSE | PERSON_DEMO_VW | NO_RACE_REPORT_FLG | ||
dbo.SID_Person_Demo | U_RESV_1 | varchar | 50 | DWHOUSE | PERSON_DEMO_VW | U_RESV_1 | ||
dbo.SID_Person_Demo | Oasis_PIDM | float | DWHOUSE | PERSON_DEMO_VW | OASIS_PIDM | |||
dbo.SID_Person_Demo | Context_Code | varchar | 5 | Run-time parameter | N/A | @context_code' (SIF, SIFP, SIFD) | Entered/passed through at run-time in ETL | |
dbo.SID_Person_Demo | NAME_MIDDLE | varchar | 60 | DWHOUSE | PERSON_DEMO_VW | NAME_MIDDLE | ||
dbo.SID_Person_Demo | CITZ_CODE | varchar | 2 | DWHOUSE | HUB_PERSON_CURRENT_V | CITZ_CODE | Via Stored Procedure Proc_DataLoad_SID_UpdateAuxFields |