Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

 

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. 

 

TableNameCOLUMN_NAMEdata_typeMaxLengthSource_SystemSource_TableSource_Column_NameNotes_LogicMeta 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  
dbo.SID_Person_DemoBIRTH_YYYYMM_DTvarchar8DWHOUSE PERSON_DEMO_VWDT_BIRTH_YYYYMMDD  
dbo.SID_Person_DemoNAME_LASTvarchar22DWHOUSE PERSON_DEMO_VWNAME_LAST  
dbo.SID_Person_DemoNAME_FIRSTvarchar14DWHOUSE PERSON_DEMO_VWNAME_FIRST  
dbo.SID_Person_DemoNAME_MIvarchar1DWHOUSE PERSON_DEMO_VWNAME_MI  
dbo.SID_Person_DemoSUFFIXvarchar10DWHOUSE PERSON_DEMO_VWSUFFIX  
dbo.SID_Person_DemoGENDERvarchar1DWHOUSE PERSON_DEMO_VWGENDER  
dbo.SID_Person_DemoRACE_ETHNICITYvarchar1DWHOUSE PERSON_DEMO_VWCalculated values: O, H, X, M, I, A, B, P, W, XVia CASE logic based on ethnic flags 
dbo.SID_Person_DemoHISPANIC_FLGvarchar1DWHOUSE PERSON_DEMO_VWHISPANIC_FLG  
dbo.SID_Person_DemoAM_IND_ALASKAN_FLGvarchar1DWHOUSE PERSON_DEMO_VWAM_IND_ALASKAN_FLG  
dbo.SID_Person_DemoASIAN_FLGvarchar1DWHOUSE PERSON_DEMO_VWASIAN_FLG  
dbo.SID_Person_DemoBLACK_AFRICAN_AM_FLGvarchar1DWHOUSE PERSON_DEMO_VWBLACK_AFRICAN_AM_FLG  
dbo.SID_Person_DemoNAT_HAWAII_PAC_IS_FLGvarchar1DWHOUSE PERSON_DEMO_VWNAT_HAWAII_PAC_IS_FLG  
dbo.SID_Person_DemoWHITE_FLGvarchar1DWHOUSE PERSON_DEMO_VWWHITE_FLG  
dbo.SID_Person_DemoNON_RES_ALIEN_FLGvarchar1DWHOUSE PERSON_DEMO_VWNON_RES_ALIEN_FLG  
dbo.SID_Person_DemoNO_RACE_REPORT_FLGvarchar1DWHOUSE PERSON_DEMO_VWNO_RACE_REPORT_FLG  
dbo.SID_Person_DemoU_RESV_1varchar50DWHOUSE PERSON_DEMO_VWU_RESV_1  
dbo.SID_Person_DemoOasis_PIDMfloat DWHOUSE PERSON_DEMO_VWOASIS_PIDM  
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  
dbo.SID_Person_DemoCITZ_CODEvarchar2DWHOUSE HUB_PERSON_CURRENT_VCITZ_CODE

Via Stored Procedure

Proc_DataLoad_SID_UpdateAuxFields

  • No labels