RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: SPRIDEN Student Composite View Reports
SGHE Operational Data Store Composite View Source: SPRIDEN

Source Column Source Form Target Type Target Target Column Calculation Formula
SPRIDEN_ENTITY_IND NA COMPOSITE VIEW

AF_VENDOR

AT_ACCOUNT

ENTITY_TYPE

ACCOUNT_ENTITY_IND

NA
SPRIDEN_FIRST_NAME SPAIDEN COMPOSITE VIEW

AT_ACCOUNT

AS_INSTRUCTIONAL_ASSIGNMENT

AA_ORGANIZATION_CONTACT

AS_PERSON

FIRST_NAME

INSTRUCTOR_FIRST_NAME

CONTACT_FIRST_NAME

FIRST_NAME

NA
SPRIDEN_ID SPAIDEN COMPOSITE VIEW

AS_PERSON

AS_ORGANIZATION_ENTITY

AT_ACCOUNT

AS_INSTRUCTIONAL_ASSIGNMENT

ID_NUMBER

ID_NUMBER

ID

INSTRUCTOR_ID

NA
SPRIDEN_LAST_NAME SPAIDEN COMPOSITE VIEW

AS_ORGANIZATION_ENTITY

AS_PERSON

AT_ACCOUNT

AS_ORGANIZATION_ENTITY

AS_PERSON

AS_PERSON

AS_PERSON

AS_PERSON

AA_ORGANIZATION_CONTACT

MAILING_NAME_ORGANIZATION

NICKNAME

LAST_NAME

NAME

MAILING_NAME_FORMAL

MAILING_NAME_PREFERRED

MAILING_NAME_INFORMAL

LAST_NAME

CONTACT_LAST_NAME

NA
SPRIDEN_MI SPAIDEN COMPOSITE VIEW

AS_INSTRUCTIONAL_ASSIGNMENT

AA_ORGANIZATION_CONTACT

AT_ACCOUNT

AT_ACCOUNT

AS_PERSON

INSTRUCTOR_MIDDLE_NAME

CONTACT_MIDDLE_INITIAL

MIDDLE_INITIAL

MIDDLE_NAME

MIDDLE_NAME

NA
SPRIDEN_NAME_PREFIX SPAIDEN       NA
SPRIDEN_NAME_SUFFIX SPAIDEN       NA
SPRIDEN_NTYP_CODE SPAIDEN COMPOSITE VIEW

AS_PERSON

NAME_TYPE

NA
SPRIDEN_PIDM NA COMPOSITE VIEW

AT_ACCOUNT

AS_ORGANIZATION_ENTITY

AS_PERSON

ACCOUNT_UID

ENTITY_UID

PERSON_UID

NA


Ver: 3.1