Composite View Source: SPRIDEN

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: SPRIDEN Student

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
SPRIDEN_ACTIVITY_DATE	NA	COMPOSITE VIEW	AS_PERSON AS_ORGANIZATION_ENTITY	ENTITY_ACTIVITY_DATE ENTITY_ACTIVITY_DATE
SPRIDEN_CREATE_DATE	NA	COMPOSITE VIEW	AS_ORGANIZATION_ENTITY AS_PERSON	ENTITY_CREATE_DATE ENTITY_CREATE_DATE
SPRIDEN_CREATE_USER	NA	COMPOSITE VIEW	AS_ORGANIZATION_ENTITY AS_PERSON	ENTITY_CREATE_USER ENTITY_CREATE_USER
SPRIDEN_DATA_ORIGIN	NA	COMPOSITE VIEW	AS_PERSON AS_ORGANIZATION_ENTITY	ENTITY_CREATE_DATA_ORIGIN ENTITY_CREATE_DATA_ORIGIN
SPRIDEN_ENTITY_IND	NA	COMPOSITE VIEW	AF_VENDOR AT_ACCOUNT	ENTITY_TYPE ACCOUNT_ENTITY_IND	NA
SPRIDEN_FIRST_NAME	SPAIDEN	COMPOSITE VIEW	AS_INSTRUCTIONAL_ASSIGNMENT AA_ORGANIZATION_CONTACT AT_ACCOUNT AS_PERSON AS_INSTRUCTIONAL_ASSIGNMENT AA_ORGANIZATION_CONTACT AT_ACCOUNT AS_PERSON AS_INSTRUCTIONAL_ASSIGNMENT AA_ORGANIZATION_CONTACT AT_ACCOUNT AS_PERSON	INSTRUCTOR_FIRST_NAME CONTACT_FIRST_NAME FIRST_NAME FIRST_NAME INSTRUCTOR_FIRST_NAME CONTACT_FIRST_NAME FIRST_NAME FIRST_NAME INSTRUCTOR_FIRST_NAME CONTACT_FIRST_NAME FIRST_NAME FIRST_NAME
SPRIDEN_ID	SPAIDEN	COMPOSITE VIEW	AS_ORGANIZATION_ENTITY AT_ACCOUNT AS_PERSON AS_INSTRUCTIONAL_ASSIGNMENT AS_FACULTY_FEEDBACK AS_FACULTY_FEEDBACK AS_ORGANIZATION_ENTITY AT_ACCOUNT AS_PERSON AS_INSTRUCTIONAL_ASSIGNMENT AS_FACULTY_FEEDBACK AS_FACULTY_FEEDBACK AS_ORGANIZATION_ENTITY AT_ACCOUNT AS_PERSON AS_INSTRUCTIONAL_ASSIGNMENT AS_FACULTY_FEEDBACK AS_FACULTY_FEEDBACK AS_ORGANIZATION_ENTITY AT_ACCOUNT AS_PERSON AS_INSTRUCTIONAL_ASSIGNMENT AS_FACULTY_FEEDBACK AS_FACULTY_FEEDBACK AS_ORGANIZATION_ENTITY AT_ACCOUNT AS_PERSON AS_INSTRUCTIONAL_ASSIGNMENT AS_FACULTY_FEEDBACK AS_FACULTY_FEEDBACK	ID_NUMBER ID ID_NUMBER INSTRUCTOR_ID ID INSTRUCTOR_ID ID_NUMBER ID ID_NUMBER INSTRUCTOR_ID ID INSTRUCTOR_ID ID_NUMBER ID ID_NUMBER INSTRUCTOR_ID ID INSTRUCTOR_ID ID_NUMBER ID ID_NUMBER INSTRUCTOR_ID ID INSTRUCTOR_ID ID_NUMBER ID ID_NUMBER INSTRUCTOR_ID ID INSTRUCTOR_ID
SPRIDEN_LAST_NAME	SPAIDEN	COMPOSITE VIEW	AS_ORGANIZATION_ENTITY AS_PERSON AS_PERSON AS_PERSON AS_PERSON AT_ACCOUNT AS_ORGANIZATION_ENTITY AA_ORGANIZATION_CONTACT AS_PERSON AS_ORGANIZATION_ENTITY AS_PERSON AS_PERSON AS_PERSON AS_PERSON AT_ACCOUNT AS_ORGANIZATION_ENTITY AA_ORGANIZATION_CONTACT AS_PERSON AS_ORGANIZATION_ENTITY AS_PERSON AS_PERSON AS_PERSON AS_PERSON AT_ACCOUNT AS_ORGANIZATION_ENTITY AA_ORGANIZATION_CONTACT AS_PERSON	MAILING_NAME_ORGANIZATION LAST_NAME MAILING_NAME_FORMAL MAILING_NAME_PREFERRED NICKNAME LAST_NAME NAME CONTACT_LAST_NAME MAILING_NAME_INFORMAL MAILING_NAME_ORGANIZATION LAST_NAME MAILING_NAME_FORMAL MAILING_NAME_PREFERRED NICKNAME LAST_NAME NAME CONTACT_LAST_NAME MAILING_NAME_INFORMAL MAILING_NAME_ORGANIZATION LAST_NAME MAILING_NAME_FORMAL MAILING_NAME_PREFERRED NICKNAME LAST_NAME NAME CONTACT_LAST_NAME MAILING_NAME_INFORMAL	NA
SPRIDEN_LAST_NAME \|\| SPRIDEN_FIRST_NAME \|\| SPRIDEN_MI	SPAIDEN
SPRIDEN_MI	SPAIDEN	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AT_ACCOUNT AT_ACCOUNT AS_PERSON AS_INSTRUCTIONAL_ASSIGNMENT AA_ORGANIZATION_CONTACT AT_ACCOUNT AT_ACCOUNT AS_PERSON AS_INSTRUCTIONAL_ASSIGNMENT AA_ORGANIZATION_CONTACT AT_ACCOUNT AT_ACCOUNT AS_PERSON AS_INSTRUCTIONAL_ASSIGNMENT	CONTACT_MIDDLE_INITIAL MIDDLE_NAME MIDDLE_INITIAL MIDDLE_NAME INSTRUCTOR_MIDDLE_NAME CONTACT_MIDDLE_INITIAL MIDDLE_NAME MIDDLE_INITIAL MIDDLE_NAME INSTRUCTOR_MIDDLE_NAME CONTACT_MIDDLE_INITIAL MIDDLE_NAME MIDDLE_INITIAL MIDDLE_NAME INSTRUCTOR_MIDDLE_NAME
SPRIDEN_NAME_PREFIX	SPAIDEN				NA
SPRIDEN_NAME_SUFFIX	SPAIDEN				NA
SPRIDEN_NTYP_CODE	SPAIDEN	COMPOSITE VIEW	AS_PERSON	NAME_TYPE	NA
SPRIDEN_ORIGIN	NA	COMPOSITE VIEW	AS_ORGANIZATION_ENTITY AS_PERSON	ENTITY_ORIGIN ENTITY_ORIGIN
SPRIDEN_PIDM	NA	COMPOSITE VIEW	AA_CONSTITUENT_CONTACT AA_PROSPECT_MOVES_MANAGEMENT AS_ORGANIZATION_ENTITY AT_ACCOUNT AS_PERSON	PERSON_RESPONSIBLE_UID PRIMARY_STAFF_UID ENTITY_UID ACCOUNT_UID PERSON_UID	NA
SPRIDEN_SURNAME_PREFIX	TBD	COMPOSITE VIEW	AS_PERSON AA_ORGANIZATION_CONTACT AS_PERSON AA_ORGANIZATION_CONTACT	LAST_NAME_PREFIX CONTACT_LAST_NAME_PREFIX LAST_NAME_PREFIX CONTACT_LAST_NAME_PREFIX
SPRIDEN_USER	NA	COMPOSITE VIEW	AS_PERSON AS_ORGANIZATION_ENTITY	ENTITY_UPDATE_USER ENTITY_UPDATE_USER

Ver: