SID Person Demo

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_Demo	TERMID	varchar	8	Run-time parameter	N/A	@TERMID'	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)	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	Stored Procedure - Proc-DataLoad_SID
dbo.SID_Person_Demo	DEMO_DATA_SOURCE	varchar	10	DWHOUSE	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_DEMO_VW	DT_BIRTH_YYYYMMDD		01024 - Date of Birth YYYY-MM-DD
dbo.SID_Person_Demo	NAME_LAST	varchar	22	DWHOUSE	PERSON_DEMO_VW	NAME_LAST		Person Name - Last
dbo.SID_Person_Demo	NAME_FIRST	varchar	14	DWHOUSE	PERSON_DEMO_VW	NAME_FIRST		Person Name - First
dbo.SID_Person_Demo	NAME_MI	varchar	1	DWHOUSE	PERSON_DEMO_VW	NAME_MI		Person Name - Middle Initial
dbo.SID_Person_Demo	SUFFIX	varchar	10	DWHOUSE	PERSON_DEMO_VW	SUFFIX		New field. Ex: JR, SR, III, MD, FAC, CRNA
dbo.SID_Person_Demo	GENDER	varchar	1	DWHOUSE	PERSON_DEMO_VW	GENDER		01048 - 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	01044 - Racial/Ethnic Group
dbo.SID_Person_Demo	HISPANIC_FLG	varchar	1	DWHOUSE	PERSON_DEMO_VW	HISPANIC_FLG		01491 - Ethnicity (Hispanic or Latino)
dbo.SID_Person_Demo	AM_IND_ALASKAN_FLG	varchar	1	DWHOUSE	PERSON_DEMO_VW	AM_IND_ALASKAN_FLG		01492 - American Indian or Alaskan Native
dbo.SID_Person_Demo	ASIAN_FLG	varchar	1	DWHOUSE	PERSON_DEMO_VW	ASIAN_FLG		01493 - Asian
dbo.SID_Person_Demo	BLACK_AFRICAN_AM_FLG	varchar	1	DWHOUSE	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_DEMO_VW	NAT_HAWAII_PAC_IS_FLG		01495 - Native Hawaiian or Other Pacific Islander
dbo.SID_Person_Demo	WHITE_FLG	varchar	1	DWHOUSE	PERSON_DEMO_VW	WHITE_FLG		01496 - White
dbo.SID_Person_Demo	NON_RES_ALIEN_FLG	varchar	1	DWHOUSE	PERSON_DEMO_VW	NON_RES_ALIEN_FLG		New field
dbo.SID_Person_Demo	NO_RACE_REPORT_FLG	varchar	1	DWHOUSE	PERSON_DEMO_VW	NO_RACE_REPORT_FLG		01497 - No Race Reported
dbo.SID_Person_Demo	U_RESV_1	varchar	50	DWHOUSE	PERSON_DEMO_VW	U_RESV_1		New Univ Reserved Area
dbo.SID_Person_Demo	Oasis_PIDM	float		DWHOUSE	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)	Entered/passed through at run-time in ETL
dbo.SID_Person_Demo	NAME_MIDDLE	varchar	60	DWHOUSE	PERSON_DEMO_VW	NAME_MIDDLE		Person Name - Middle I
dbo.SID_Person_Demo	CITZ_CODE	varchar	2	DWHOUSE	HUB_PERSON_CURRENT_V	CITZ_CODE	The current citizenship code for the person on OASIS or GEMS

USF Report Glossary

SID Person Demo

Analytics

TableName

COLUMN_NAME

data_type

MaxLength

Source_System

Source_Table

Source_Column_Name

Notes_Logic

Meta Mart Description

Related content