Versions Compared

Old Version 3

changes.mady.by.user Michael Harvey

Saved on

compared with

New Version 4

changes.mady.by.user Michael Harvey

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 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 PERSON_DEMO_VWDT_BIRTH_YYYYMMDD  01024 - Date of Birth YYYY-MM-DD
dbo.SID_Person_DemoNAME_LASTvarchar22DWHOUSE PERSON PERSON_DEMO_VWNAME_LAST  Person Name - Last
dbo.SID_Person_DemoNAME_FIRSTvarchar14DWHOUSE PERSON PERSON_DEMO_VWNAME_FIRST  Person Name - First
dbo.SID_Person_DemoNAME_MIvarchar1DWHOUSE PERSON PERSON_DEMO_VWNAME_MI  Person Name - Middle Initial
dbo.SID_Person_DemoSUFFIXvarchar10DWHOUSE PERSON PERSON_DEMO_VWSUFFIX  New field. Ex: JR, SR, III, MD, FAC, CRNA
dbo.SID_Person_DemoGENDERvarchar1DWHOUSE PERSON PERSON_DEMO_VWGENDER  01048 - Gender
dbo.SID_Person_DemoRACE_ETHNICITYvarchar1DWHOUSE PERSON PERSON_DEMO_VWCalculated values: O, H, X, M, I, A, B, P, W, XVia CASE logic based on ethnic flags 01044 - Racial/Ethnic Group
dbo.SID_Person_DemoHISPANIC_FLGvarchar1DWHOUSE PERSON PERSON_DEMO_VWHISPANIC_FLG  01491 - Ethnicity (Hispanic or Latino)
dbo.SID_Person_DemoAM_IND_ALASKAN_FLGvarchar1DWHOUSE PERSON PERSON_DEMO_VWAM_IND_ALASKAN_FLG  01492 - American Indian or Alaskan Native
dbo.SID_Person_DemoASIAN_FLGvarchar1DWHOUSE PERSON PERSON_DEMO_VWASIAN_FLG  01493 - Asian
dbo.SID_Person_DemoBLACK_AFRICAN_AM_FLGvarchar1DWHOUSE PERSON PERSON_DEMO_VWBLACK_AFRICAN_AM_FLG  01494 - Black or African American
dbo.SID_Person_DemoNAT_HAWAII_PAC_IS_FLGvarchar1DWHOUSE PERSON PERSON_DEMO_VWNAT_HAWAII_PAC_IS_FLG  01495 - Native Hawaiian or Other Pacific Islander
dbo.SID_Person_DemoWHITE_FLGvarchar1DWHOUSE PERSON PERSON_DEMO_VWWHITE_FLG  01496 - White
dbo.SID_Person_DemoNON_RES_ALIEN_FLGvarchar1DWHOUSE PERSON PERSON_DEMO_VWNON_RES_ALIEN_FLG  New field
dbo.SID_Person_DemoNO_RACE_REPORT_FLGvarchar1DWHOUSE PERSON PERSON_DEMO_VWNO_RACE_REPORT_FLG  01497 - No Race Reported
dbo.SID_Person_DemoU_RESV_1varchar50DWHOUSE PERSON PERSON_DEMO_VWU_RESV_1  New Univ Reserved Area
dbo.SID_Person_DemoOasis_PIDMfloat DWHOUSE PERSON 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 PERSON_DEMO_VWNAME_MIDDLE  Person Name - Middle I
dbo.SID_Person_DemoCITZ_CODEvarchar2DWHOUSE HUB HUB_PERSON_CURRENT_VCITZ_CODE

Via Stored Procedure

Proc_DataLoad_SID_UpdateAuxFieldsThe current citizenship code for the person on OASIS or GEMS