...
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_NameMetaMart_Description | Notes_Logic | Meta_Mart_Link | ||||||||||
dbo.SID_Person_Demo | TERMID | varchar | 8 | Run-time parameter | N/A | @TERMID' | N/A | 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)N/A | 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 N/A | 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)N/A | 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 |