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_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	TBD	COMPOSITE VIEW	AS_INSTRUCTIONAL_ASSIGNMENT AS_DESTINATION_KENT_KSU AA_ORGANIZATION_CONTACT AT_ACCOUNT AS_PERSON AS_INSTRUCTIONAL_ASSIGNMENT AS_DESTINATION_KENT_KSU AA_ORGANIZATION_CONTACT AT_ACCOUNT AS_PERSON AS_INSTRUCTIONAL_ASSIGNMENT AS_DESTINATION_KENT_KSU AA_ORGANIZATION_CONTACT AT_ACCOUNT AS_PERSON	INSTRUCTOR_FIRST_NAME FIRST_NAME CONTACT_FIRST_NAME FIRST_NAME FIRST_NAME INSTRUCTOR_FIRST_NAME FIRST_NAME CONTACT_FIRST_NAME FIRST_NAME FIRST_NAME INSTRUCTOR_FIRST_NAME FIRST_NAME CONTACT_FIRST_NAME FIRST_NAME FIRST_NAME
SPRIDEN_ID	TBD	COMPOSITE VIEW	AS_ORGANIZATION_ENTITY AT_ACCOUNT AS_PERSON AS_DESTINATION_KENT_KSU AS_INSTRUCTIONAL_ASSIGNMENT AS_FACULTY_FEEDBACK AS_FACULTY_FEEDBACK AS_ORGANIZATION_ENTITY AT_ACCOUNT AS_PERSON AS_DESTINATION_KENT_KSU AS_INSTRUCTIONAL_ASSIGNMENT AS_FACULTY_FEEDBACK AS_FACULTY_FEEDBACK AS_ORGANIZATION_ENTITY AT_ACCOUNT AS_PERSON AS_DESTINATION_KENT_KSU AS_INSTRUCTIONAL_ASSIGNMENT AS_FACULTY_FEEDBACK AS_FACULTY_FEEDBACK AS_ORGANIZATION_ENTITY AT_ACCOUNT AS_PERSON AS_DESTINATION_KENT_KSU AS_INSTRUCTIONAL_ASSIGNMENT AS_FACULTY_FEEDBACK AS_FACULTY_FEEDBACK AS_ORGANIZATION_ENTITY AT_ACCOUNT AS_PERSON AS_DESTINATION_KENT_KSU AS_INSTRUCTIONAL_ASSIGNMENT AS_FACULTY_FEEDBACK AS_FACULTY_FEEDBACK	ID_NUMBER ID ID_NUMBER ID INSTRUCTOR_ID ID INSTRUCTOR_ID ID_NUMBER ID ID_NUMBER ID INSTRUCTOR_ID ID INSTRUCTOR_ID ID_NUMBER ID ID_NUMBER ID INSTRUCTOR_ID ID INSTRUCTOR_ID ID_NUMBER ID ID_NUMBER ID INSTRUCTOR_ID ID INSTRUCTOR_ID ID_NUMBER ID ID_NUMBER ID INSTRUCTOR_ID ID INSTRUCTOR_ID
SPRIDEN_LAST_NAME	TBD	COMPOSITE VIEW	AS_ORGANIZATION_ENTITY AS_PERSON AS_PERSON AS_PERSON AS_DESTINATION_KENT_KSU AS_PERSON AT_ACCOUNT AS_ORGANIZATION_ENTITY AS_PERSON AA_ORGANIZATION_CONTACT AS_ORGANIZATION_ENTITY AS_PERSON AS_PERSON AS_PERSON AS_DESTINATION_KENT_KSU AS_PERSON AT_ACCOUNT AS_ORGANIZATION_ENTITY AS_PERSON AA_ORGANIZATION_CONTACT AS_ORGANIZATION_ENTITY AS_PERSON AS_PERSON AS_PERSON AS_DESTINATION_KENT_KSU AS_PERSON AT_ACCOUNT AS_ORGANIZATION_ENTITY AS_PERSON AA_ORGANIZATION_CONTACT	MAILING_NAME_ORGANIZATION LAST_NAME MAILING_NAME_FORMAL MAILING_NAME_PREFERRED LAST_NAME NICKNAME LAST_NAME NAME MAILING_NAME_INFORMAL CONTACT_LAST_NAME MAILING_NAME_ORGANIZATION LAST_NAME MAILING_NAME_FORMAL MAILING_NAME_PREFERRED LAST_NAME NICKNAME LAST_NAME NAME MAILING_NAME_INFORMAL CONTACT_LAST_NAME MAILING_NAME_ORGANIZATION LAST_NAME MAILING_NAME_FORMAL MAILING_NAME_PREFERRED LAST_NAME NICKNAME LAST_NAME NAME MAILING_NAME_INFORMAL CONTACT_LAST_NAME
SPRIDEN_LAST_NAME \|\| SPRIDEN_FIRST_NAME \|\| SPRIDEN_MI	SPAIDEN
SPRIDEN_MI	TBD	COMPOSITE VIEW	AT_ACCOUNT AA_ORGANIZATION_CONTACT AT_ACCOUNT AS_PERSON AS_INSTRUCTIONAL_ASSIGNMENT AT_ACCOUNT AA_ORGANIZATION_CONTACT AT_ACCOUNT AS_PERSON AS_INSTRUCTIONAL_ASSIGNMENT AT_ACCOUNT AA_ORGANIZATION_CONTACT AT_ACCOUNT AS_PERSON AS_INSTRUCTIONAL_ASSIGNMENT	MIDDLE_NAME CONTACT_MIDDLE_INITIAL MIDDLE_INITIAL MIDDLE_NAME INSTRUCTOR_MIDDLE_NAME MIDDLE_NAME CONTACT_MIDDLE_INITIAL MIDDLE_INITIAL MIDDLE_NAME INSTRUCTOR_MIDDLE_NAME MIDDLE_NAME CONTACT_MIDDLE_INITIAL 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 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 PERSON_RESPONSIBLE_UID PRIMARY_STAFF_UID ENTITY_UID ACCOUNT_UID PERSON_UID	NA
SPRIDEN_SURNAME_PREFIX	TBD	COMPOSITE VIEW	AS_PERSON	LAST_NAME_PREFIX
SPRIDEN_USER	NA	COMPOSITE VIEW	AS_PERSON AS_ORGANIZATION_ENTITY	ENTITY_UPDATE_USER ENTITY_UPDATE_USER

Ver: