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

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

AS_PERSON

BIRTH_DATE

NO

NA
SPBPERS_CITZ_CODE SPAPERS NO COMPOSITE VIEW

AS_PERSON

CITIZENSHIP_TYPE

NO

NA
SPBPERS_CITZ_IND STVCITZ NO         NA
SPBPERS_CONFID_IND SPAPERS NO COMPOSITE VIEW

AS_PERSON

CONFIDENTIALITY_IND

NO

NA
SPBPERS_CONFIRMED_RE_CDE SPAPERS NO COMPOSITE VIEW

AS_PERSON

RACE_ETHNICITY_CONFIRM_IND

NO

NA
SPBPERS_CONFIRMED_RE_DATE SPAPERS NO COMPOSITE VIEW

AS_PERSON

RACE_ETHNICITY_CONFIRM_DATE

NO

NA
SPBPERS_DEAD_DATE SPAPERS NO COMPOSITE VIEW

AS_PERSON

DECEASED_DATE

NO

NA
SPBPERS_DEAD_IND SPAPERS NO COMPOSITE VIEW

AS_PERSON

AA_ORGANIZATION_CONTACT

DECEASED_STATUS

CONTACT_DECEASED_IND

NO

NO

NA
SPBPERS_ETHN_CDE SPAPERS NO COMPOSITE VIEW

AS_PERSON

HISPANIC_LATINO_ETHNICITY_IND

NO

 
SPBPERS_ETHN_CODE SPAPERS NO COMPOSITE VIEW

AS_PERSON

PRIMARY_ETHNICITY

NO

NA
SPBPERS_GNDR_CODE SPAPERS NO COMPOSITE VIEW

AS_PERSON

GENDER_DESIGNATION

NO

NA
SPBPERS_LEGAL_NAME SPAPERS NO COMPOSITE VIEW

AS_PERSON

LEGAL_NAME

NO

NA
SPBPERS_LGCY_CODE SPAPERS NO COMPOSITE VIEW

AS_PERSON

LEGACY

NO

NA
SPBPERS_MRTL_CODE SPAPERS NO COMPOSITE VIEW

AS_PERSON

MARITAL_STATUS

NO

NA
SPBPERS_NAME_PREFIX SPAPERS NO COMPOSITE VIEW

AT_ACCOUNT

AS_PERSON

AA_ORGANIZATION_CONTACT

NAME_PREFIX

NAME_PREFIX

CONTACT_NAME_PREFIX

NO

NO

NO

NA
SPBPERS_NAME_SUFFIX SPAPERS NO COMPOSITE VIEW

AT_ACCOUNT

AS_PERSON

AA_ORGANIZATION_CONTACT

NAME_SUFFIX

NAME_SUFFIX

CONTACT_NAME_SUFFIX

NO

NO

NO

NA
SPBPERS_PIDM NA NO         NA
SPBPERS_PPRN_CODE SPAPERS NO COMPOSITE VIEW

AS_PERSON

PERSONAL_PRONOUN

NO

NA
SPBPERS_PREF_FIRST_NAME SPAPERS NO COMPOSITE VIEW

AS_PERSON

PREFERRED_FIRST_NAME

NO

NA
SPBPERS_RELG_CODE SPAPERS NO COMPOSITE VIEW

AS_PERSON

RELIGION

NO

NA
SPBPERS_SDVET_IND SPAPERS NO COMPOSITE VIEW

AS_PERSON

VETERAN_SPECIAL_DISABLED_IND

NO

NA
SPBPERS_SEX SPAPERS NO COMPOSITE VIEW

AS_PERSON

GENDER

NO

NA
SPBPERS_SSN SPAPERS NO COMPOSITE VIEW

AS_PERSON

AA_RELATIONSHIP

AT_ACCOUNT

TAX_ID

RELATED_CHILD_TAX_ID

SSN

NO

NO

NO

NA
SPBPERS_VERA_IND SPAPERS NO COMPOSITE VIEW

AS_PERSON

VETERAN_CATEGORY

NO

NA
SPBPERS_VETC_FILE_NUMBER SPAPERS NO COMPOSITE VIEW

AS_PERSON

VETERAN_FILE_NO

NO

NA


Ver: