Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: SPBPERS Student
SGHE Banner Operational Data Store Composite View Source: SPBPERS - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
SPBPERS_ACTIVE_DUTY_SEPR_DATE TBD        
SPBPERS_BIRTH_DATE SPAPERS COMPOSITE VIEW

AS_PERSON

BIRTH_DATE

NA
SPBPERS_CITZ_CODE SPAPERS COMPOSITE VIEW

AS_PERSON

CITIZENSHIP_TYPE

NA
SPBPERS_CITZ_IND STVCITZ       NA
SPBPERS_CONFID_IND SPAPERS COMPOSITE VIEW

AS_PERSON

CONFIDENTIALITY_IND

NA
SPBPERS_CONFIRMED_RE_CDE SPAPERS COMPOSITE VIEW

AS_PERSON

RACE_ETHNICITY_CONFIRM_IND

NA
SPBPERS_CONFIRMED_RE_DATE SPAPERS COMPOSITE VIEW

AS_PERSON

RACE_ETHNICITY_CONFIRM_DATE

NA
SPBPERS_DEAD_DATE SPAPERS COMPOSITE VIEW

AS_PERSON

DECEASED_DATE

NA
SPBPERS_DEAD_IND SPAPERS COMPOSITE VIEW

AS_PERSON

AA_ORGANIZATION_CONTACT

DECEASED_STATUS

CONTACT_DECEASED_IND

NA
SPBPERS_ETHN_CDE SPAPERS COMPOSITE VIEW

AS_PERSON

HISPANIC_LATINO_ETHNICITY_IND

 
SPBPERS_ETHN_CODE SPAPERS COMPOSITE VIEW

AS_PERSON

PRIMARY_ETHNICITY

NA
SPBPERS_LEGAL_NAME SPAPERS COMPOSITE VIEW

AS_PERSON

LEGAL_NAME

NA
SPBPERS_LGCY_CODE SPAPERS COMPOSITE VIEW

AS_PERSON

LEGACY

NA
SPBPERS_MRTL_CODE SPAPERS COMPOSITE VIEW

AS_PERSON

MARITAL_STATUS

NA
SPBPERS_NAME_PREFIX SPAPERS COMPOSITE VIEW

AT_ACCOUNT

AS_PERSON

AA_ORGANIZATION_CONTACT

NAME_PREFIX

NAME_PREFIX

CONTACT_NAME_PREFIX

NA
SPBPERS_NAME_SUFFIX SPAPERS COMPOSITE VIEW

AT_ACCOUNT

AS_PERSON

AA_ORGANIZATION_CONTACT

NAME_SUFFIX

NAME_SUFFIX

CONTACT_NAME_SUFFIX

NA
SPBPERS_PIDM NA       NA
SPBPERS_PREF_FIRST_NAME SPAPERS COMPOSITE VIEW

AS_PERSON

PREFERRED_FIRST_NAME

NA
SPBPERS_RELG_CODE SPAPERS COMPOSITE VIEW

AS_PERSON

RELIGION

NA
SPBPERS_SDVET_IND SPAPERS COMPOSITE VIEW

AS_PERSON

VETERAN_SPECIAL_DISABLED_IND

NA
SPBPERS_SEX SPAPERS COMPOSITE VIEW

AS_PERSON

GENDER

NA
SPBPERS_SSN SPAPERS COMPOSITE VIEW

AS_PERSON

AA_RELATIONSHIP

AT_ACCOUNT

TAX_ID

RELATED_CHILD_TAX_ID

SSN

NA
SPBPERS_VERA_IND SPAPERS COMPOSITE VIEW

AS_PERSON

VETERAN_CATEGORY

NA
SPBPERS_VETC_FILE_NUMBER SPAPERS COMPOSITE VIEW

AS_PERSON

VETERAN_FILE_NO

NA


Ver: