SID Person Demo

Owned by Michael Harvey (Deactivated)
Last updated: Sept 20, 2018 by Jayakumar Unnikrishnan

 

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_DemoTERMIDvarchar8Run-time parameterN/A@TERMID'

Entered/passed through at run-time in ETL

dbo.SID_Person_DemoBENCHvarchar1Run-time parameterN/A@BENCH' (B, F, D, E)Entered/passed through at run-time in ETL
dbo.SID_Person_DemoUIDvarchar9DWHOUSE PERSON_DEMO_VWUSF_ID or URESV_1 (starting at position 9 in field, if USF_ID is NULL)  
dbo.SID_Person_DemoREPT_INSTvarchar4LiteralVia QueryUSF Stored Procedure - Proc-DataLoad_SID 
dbo.SID_Person_DemoDEMO_DATA_SOURCEvarchar10DWHOUSE PERSON_DEMO_VWDEMO_DATA_SOURCE Source of the data stored in the current record.
dbo.SID_Person_DemoBIRTH_YYYYMM_DTvarchar8DWHOUSE PERSON_DEMO_VWDT_BIRTH_YYYYMMDD 01024 - Date of Birth YYYY-MM-DD
dbo.SID_Person_DemoNAME_LASTvarchar22DWHOUSE PERSON_DEMO_VWNAME_LAST Person Name - Last
dbo.SID_Person_DemoNAME_FIRSTvarchar14DWHOUSE PERSON_DEMO_VWNAME_FIRST Person Name - First
dbo.SID_Person_DemoNAME_MIvarchar1DWHOUSE PERSON_DEMO_VWNAME_MI Person Name - Middle Initial
dbo.SID_Person_DemoSUFFIXvarchar10DWHOUSE PERSON_DEMO_VWSUFFIX New field. Ex: JR, SR, III, MD, FAC, CRNA
dbo.SID_Person_DemoGENDERvarchar1DWHOUSE PERSON_DEMO_VWGENDER 01048 - Gender
dbo.SID_Person_DemoRACE_ETHNICITYvarchar1DWHOUSE PERSON_DEMO_VWCalculated values: O, H, X, M, I, A, B, P, W, XVia CASE logic based on ethnic flags01044 - Racial/Ethnic Group
dbo.SID_Person_DemoHISPANIC_FLGvarchar1DWHOUSE PERSON_DEMO_VWHISPANIC_FLG 01491 - Ethnicity (Hispanic or Latino)
dbo.SID_Person_DemoAM_IND_ALASKAN_FLGvarchar1DWHOUSE PERSON_DEMO_VWAM_IND_ALASKAN_FLG 01492 - American Indian or Alaskan Native
dbo.SID_Person_DemoASIAN_FLGvarchar1DWHOUSE PERSON_DEMO_VWASIAN_FLG 01493 - Asian
dbo.SID_Person_DemoBLACK_AFRICAN_AM_FLGvarchar1DWHOUSE PERSON_DEMO_VWBLACK_AFRICAN_AM_FLG 01494 - Black or African American
dbo.SID_Person_DemoNAT_HAWAII_PAC_IS_FLGvarchar1DWHOUSE PERSON_DEMO_VWNAT_HAWAII_PAC_IS_FLG 01495 - Native Hawaiian or Other Pacific Islander
dbo.SID_Person_DemoWHITE_FLGvarchar1DWHOUSE PERSON_DEMO_VWWHITE_FLG 01496 - White
dbo.SID_Person_DemoNON_RES_ALIEN_FLGvarchar1DWHOUSE PERSON_DEMO_VWNON_RES_ALIEN_FLG New field
dbo.SID_Person_DemoNO_RACE_REPORT_FLGvarchar1DWHOUSE PERSON_DEMO_VWNO_RACE_REPORT_FLG 01497 - No Race Reported
dbo.SID_Person_DemoU_RESV_1varchar50DWHOUSE PERSON_DEMO_VWU_RESV_1 New Univ Reserved Area
dbo.SID_Person_DemoOasis_PIDMfloat DWHOUSE PERSON_DEMO_VWOASIS_PIDM This field holds the OASIS internal identification number.
dbo.SID_Person_DemoContext_Codevarchar5Run-time parameterN/A@context_code' (SIF, SIFP, SIFD)Entered/passed through at run-time in ETL
dbo.SID_Person_DemoNAME_MIDDLEvarchar60DWHOUSE PERSON_DEMO_VWNAME_MIDDLE Person Name - Middle I
dbo.SID_Person_DemoCITZ_CODEvarchar2DWHOUSE HUB_PERSON_CURRENT_VCITZ_CODE

The current citizenship code for the person on OASIS or GEMS