Composite View Source: SPRIDEN

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: SPRIDEN Travel And Expense

**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_PERSON AS_ORGANIZATION_ENTITY	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_ORGANIZATION_ENTITY AS_PERSON	ENTITY_CREATE_DATA_ORIGIN ENTITY_CREATE_DATA_ORIGIN
SPRIDEN_ENTITY_IND	NA	COMPOSITE VIEW	AT_ACCOUNT AF_VENDOR	ACCOUNT_ENTITY_IND ENTITY_TYPE	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_FACULTY_FEEDBACK AT_ACCOUNT AS_PERSON AS_FACULTY_FEEDBACK AS_INSTRUCTIONAL_ASSIGNMENT AS_ORGANIZATION_ENTITY AS_FACULTY_FEEDBACK AT_ACCOUNT AS_PERSON AS_FACULTY_FEEDBACK AS_INSTRUCTIONAL_ASSIGNMENT AS_ORGANIZATION_ENTITY AS_FACULTY_FEEDBACK AT_ACCOUNT AS_PERSON AS_FACULTY_FEEDBACK AS_INSTRUCTIONAL_ASSIGNMENT AS_ORGANIZATION_ENTITY AS_FACULTY_FEEDBACK AT_ACCOUNT AS_PERSON AS_FACULTY_FEEDBACK AS_INSTRUCTIONAL_ASSIGNMENT AS_ORGANIZATION_ENTITY AS_FACULTY_FEEDBACK AT_ACCOUNT AS_PERSON AS_FACULTY_FEEDBACK AS_INSTRUCTIONAL_ASSIGNMENT AS_ORGANIZATION_ENTITY	INSTRUCTOR_ID ID ID_NUMBER ID INSTRUCTOR_ID ID_NUMBER INSTRUCTOR_ID ID ID_NUMBER ID INSTRUCTOR_ID ID_NUMBER INSTRUCTOR_ID ID ID_NUMBER ID INSTRUCTOR_ID ID_NUMBER INSTRUCTOR_ID ID ID_NUMBER ID INSTRUCTOR_ID ID_NUMBER INSTRUCTOR_ID ID ID_NUMBER ID INSTRUCTOR_ID ID_NUMBER
SPRIDEN_LAST_NAME	SPAIDEN	COMPOSITE VIEW	AT_ACCOUNT AS_PERSON AS_ORGANIZATION_ENTITY AS_ORGANIZATION_ENTITY AS_PERSON AA_ORGANIZATION_CONTACT AS_PERSON AS_PERSON AS_PERSON AT_ACCOUNT AS_PERSON AS_ORGANIZATION_ENTITY AS_ORGANIZATION_ENTITY AS_PERSON AA_ORGANIZATION_CONTACT AS_PERSON AS_PERSON AS_PERSON AT_ACCOUNT AS_PERSON AS_ORGANIZATION_ENTITY AS_ORGANIZATION_ENTITY AS_PERSON AA_ORGANIZATION_CONTACT AS_PERSON AS_PERSON AS_PERSON	LAST_NAME MAILING_NAME_INFORMAL MAILING_NAME_ORGANIZATION NAME LAST_NAME CONTACT_LAST_NAME MAILING_NAME_PREFERRED NICKNAME MAILING_NAME_FORMAL LAST_NAME MAILING_NAME_INFORMAL MAILING_NAME_ORGANIZATION NAME LAST_NAME CONTACT_LAST_NAME MAILING_NAME_PREFERRED NICKNAME MAILING_NAME_FORMAL LAST_NAME MAILING_NAME_INFORMAL MAILING_NAME_ORGANIZATION NAME LAST_NAME CONTACT_LAST_NAME MAILING_NAME_PREFERRED NICKNAME MAILING_NAME_FORMAL
SPRIDEN_LAST_NAME \|\| SPRIDEN_FIRST_NAME \|\| SPRIDEN_MI	SPAIDEN
SPRIDEN_MI	SPAIDEN	COMPOSITE VIEW	AS_PERSON AT_ACCOUNT AT_ACCOUNT AA_ORGANIZATION_CONTACT AS_INSTRUCTIONAL_ASSIGNMENT AS_PERSON AT_ACCOUNT AT_ACCOUNT AA_ORGANIZATION_CONTACT AS_INSTRUCTIONAL_ASSIGNMENT AS_PERSON AT_ACCOUNT AT_ACCOUNT AA_ORGANIZATION_CONTACT AS_INSTRUCTIONAL_ASSIGNMENT	MIDDLE_NAME MIDDLE_NAME MIDDLE_INITIAL CONTACT_MIDDLE_INITIAL INSTRUCTOR_MIDDLE_NAME MIDDLE_NAME MIDDLE_NAME MIDDLE_INITIAL CONTACT_MIDDLE_INITIAL INSTRUCTOR_MIDDLE_NAME MIDDLE_NAME MIDDLE_NAME MIDDLE_INITIAL CONTACT_MIDDLE_INITIAL INSTRUCTOR_MIDDLE_NAME	NA
SPRIDEN_NTYP_CODE	SPAIDEN	COMPOSITE VIEW	AS_PERSON	NAME_TYPE	NA
SPRIDEN_ORIGIN	NA	COMPOSITE VIEW	AS_PERSON AS_ORGANIZATION_ENTITY	ENTITY_ORIGIN ENTITY_ORIGIN
SPRIDEN_PIDM	NA	COMPOSITE VIEW	AA_PROSPECT_MOVES_MANAGEMENT AT_ACCOUNT AA_CONSTITUENT_CONTACT AS_PERSON AS_ORGANIZATION_ENTITY	PRIMARY_STAFF_UID ACCOUNT_UID PERSON_RESPONSIBLE_UID PERSON_UID ENTITY_UID	NA
SPRIDEN_SURNAME_PREFIX	TBD	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_PERSON AA_ORGANIZATION_CONTACT AS_PERSON	CONTACT_LAST_NAME_PREFIX LAST_NAME_PREFIX CONTACT_LAST_NAME_PREFIX LAST_NAME_PREFIX
SPRIDEN_USER	NA	COMPOSITE VIEW	AS_PERSON AS_ORGANIZATION_ENTITY	ENTITY_UPDATE_USER ENTITY_UPDATE_USER

Ver: