...
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_LinkMart Description | ||||||||||
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 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 PERSON_DEMO_VW | DEMO_DATA_SOURCE | Source of the data stored in the current record. | |||||||||||
dbo.SID_Person_Demo | BIRTH_YYYYMM_DT | varchar | 8 | DWHOUSE | PERSON PERSON_DEMO_VW | DT_BIRTH_YYYYMMDD | 01024 - Date of Birth YYYY-MM-DD | |||||||||||
dbo.SID_Person_Demo | NAME_LAST | varchar | 22 | DWHOUSE | PERSON PERSON_DEMO_VW | NAME_LAST | Person Name - Last | |||||||||||
dbo.SID_Person_Demo | NAME_FIRST | varchar | 14 | DWHOUSE | PERSON PERSON_DEMO_VW | NAME_FIRST | Person Name - First | |||||||||||
dbo.SID_Person_Demo | NAME_MI | varchar | 1 | DWHOUSE | PERSON PERSON_DEMO_VW | NAME_MI | Person Name - Middle Initial | |||||||||||
dbo.SID_Person_Demo | SUFFIX | varchar | 10 | DWHOUSE | PERSON PERSON_DEMO_VW | SUFFIX | New field. Ex: JR, SR, III, MD, FAC, CRNA | |||||||||||
dbo.SID_Person_Demo | GENDER | varchar | 1 | DWHOUSE | PERSON PERSON_DEMO_VW | GENDER | 01048 - Gender | |||||||||||
dbo.SID_Person_Demo | RACE_ETHNICITY | varchar | 1 | DWHOUSE | PERSON PERSON_DEMO_VW | Calculated values: O, H, X, M, I, A, B, P, W, X | Via CASE logic based on ethnic flags | 01044 - Racial/Ethnic Group | ||||||||||
dbo.SID_Person_Demo | HISPANIC_FLG | varchar | 1 | DWHOUSE | PERSON PERSON_DEMO_VW | HISPANIC_FLG | 01491 - Ethnicity (Hispanic or Latino) | |||||||||||
dbo.SID_Person_Demo | AM_IND_ALASKAN_FLG | varchar | 1 | DWHOUSE | PERSON PERSON_DEMO_VW | AM_IND_ALASKAN_FLG | 01492 - American Indian or Alaskan Native | |||||||||||
dbo.SID_Person_Demo | ASIAN_FLG | varchar | 1 | DWHOUSE | PERSON PERSON_DEMO_VW | ASIAN_FLG | 01493 - Asian | |||||||||||
dbo.SID_Person_Demo | BLACK_AFRICAN_AM_FLG | varchar | 1 | DWHOUSE | PERSON PERSON_DEMO_VW | BLACK_AFRICAN_AM_FLG | 01494 - Black or African American | |||||||||||
dbo.SID_Person_Demo | NAT_HAWAII_PAC_IS_FLG | varchar | 1 | DWHOUSE | PERSON PERSON_DEMO_VW | NAT_HAWAII_PAC_IS_FLG | 01495 - Native Hawaiian or Other Pacific Islander | |||||||||||
dbo.SID_Person_Demo | WHITE_FLG | varchar | 1 | DWHOUSE | PERSON PERSON_DEMO_VW | WHITE_FLG | 01496 - White | |||||||||||
dbo.SID_Person_Demo | NON_RES_ALIEN_FLG | varchar | 1 | DWHOUSE | PERSON PERSON_DEMO_VW | NON_RES_ALIEN_FLG | New field | |||||||||||
dbo.SID_Person_Demo | NO_RACE_REPORT_FLG | varchar | 1 | DWHOUSE | PERSON PERSON_DEMO_VW | NO_RACE_REPORT_FLG | 01497 - No Race Reported | |||||||||||
dbo.SID_Person_Demo | U_RESV_1 | varchar | 50 | DWHOUSE | PERSON PERSON_DEMO_VW | U_RESV_1 | New Univ Reserved Area | |||||||||||
dbo.SID_Person_Demo | Oasis_PIDM | float | DWHOUSE | PERSON PERSON_DEMO_VW | OASIS_PIDM | This field holds the OASIS internal identification number. | ||||||||||||
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 PERSON_DEMO_VW | NAME_MIDDLE | Person Name - Middle I | |||||||||||
dbo.SID_Person_Demo | CITZ_CODE | varchar | 2 | DWHOUSE | HUB HUB_PERSON_CURRENT_V | CITZ_CODE | Via Stored Procedure Proc_DataLoad_SID_UpdateAuxFields | The current citizenship code for the person on OASIS or GEMS
|