RETURN TO DIMENSION TABLE REPORTS LIST
Academic Program Course Star Advancement Gift Star Course Registration Star Employee Star Employee Degree Star Employee Position Star Employment Application Star Enrollment Star Financial Aid Pre-Student Star Financial Aid Student Star General Ledger Star Graduation Completion Star Grant And Project Star Operating Ledger Star Receivable Customer Star Receivable Revenue Star Recruiting And Admission Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_MULTI_SOURCE

Description Multi Source Dimension table provides an institution source value when the optional multi-source feature has been applied. Institution source VALUES have a short and long description. Data in this dimension may optionally include a process-oriented identifier and an administrative-oriented identifier for the record used to determine access authorization to this record. The cleansing rules are used in the EDW for the short and long descriptions.
Key & Frequency One row per multi_source per process group per admistrative group.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined VARCHAR2(255)

ACADEMIC_OUTCOME

ADMISSIONS_APPLICATION

AWARD_BY_PERSON

EMPLOYEE

EMPLOYEE_POSITION

ENROLLMENT

GENERAL_LEDGER

GIFT

GRANT_VIEW

HR_APPLICATION

OPERATING_LEDGER

RECEIVABLE_ACCOUNT_DETAIL

STUDENT_COURSE

ADMINISTRATIVE_GROUP

NO

NO

GRADUATION COMPLETION

RECRUITING AND ADMISSION

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

EMPLOYEE, EMPLOYEE DEGREE

EMPLOYEE POSITION

ENROLLMENT

GENERAL LEDGER

ADVANCEMENT GIFT

GRANT AND PROJECT

EMPLOYMENT APPLICATION

OPERATING LEDGER

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

ADMINISTRATIVE_GROUP_LD Long description for the administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

ADMINISTRATIVE_GROUP_SD Short description for the administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(255)

ACADEMIC_OUTCOME

ADMISSIONS_APPLICATION

AWARD_BY_PERSON

EMPLOYEE

EMPLOYEE_POSITION

ENROLLMENT

GENERAL_LEDGER

GIFT

GRANT_VIEW

HR_APPLICATION

OPERATING_LEDGER

RECEIVABLE_ACCOUNT_DETAIL

STUDENT_COURSE

MULTI_SOURCE

NO

NO

GRADUATION COMPLETION

RECRUITING AND ADMISSION

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

EMPLOYEE, EMPLOYEE DEGREE

EMPLOYEE POSITION

ENROLLMENT

GENERAL LEDGER

ADVANCEMENT GIFT

GRANT AND PROJECT

EMPLOYMENT APPLICATION

OPERATING LEDGER

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

MULTI_SOURCE_KEY Key for the multi source dimension VARCHAR2(255)

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

MULTI_SOURCE_LD Institution long description for the record when the optional multi-institution facility feature has been applied. VARCHAR2(255)

ACADEMIC_OUTCOME

ADMISSIONS_APPLICATION

AWARD_BY_PERSON

EMPLOYEE

EMPLOYEE_POSITION

ENROLLMENT

GENERAL_LEDGER

GIFT

GRANT_VIEW

HR_APPLICATION

OPERATING_LEDGER

RECEIVABLE_ACCOUNT_DETAIL

STUDENT_COURSE

MULTI_SOURCE_DESC

NO

NO

GRADUATION COMPLETION

RECRUITING AND ADMISSION

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

EMPLOYEE, EMPLOYEE DEGREE

EMPLOYEE POSITION

ENROLLMENT

GENERAL LEDGER

ADVANCEMENT GIFT

GRANT AND PROJECT

EMPLOYMENT APPLICATION

OPERATING LEDGER

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

MULTI_SOURCE_SD Institution short description for the record when the optional multi-institution facility feature has been applied. VARCHAR2(255)

ACADEMIC_OUTCOME

ADMISSIONS_APPLICATION

AWARD_BY_PERSON

EMPLOYEE

EMPLOYEE_POSITION

ENROLLMENT

GENERAL_LEDGER

GIFT

GRANT_VIEW

HR_APPLICATION

OPERATING_LEDGER

RECEIVABLE_ACCOUNT_DETAIL

STUDENT_COURSE

MULTI_SOURCE_DESC

NO

NO

GRADUATION COMPLETION

RECRUITING AND ADMISSION

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

EMPLOYEE, EMPLOYEE DEGREE

EMPLOYEE POSITION

ENROLLMENT

GENERAL LEDGER

ADVANCEMENT GIFT

GRANT AND PROJECT

EMPLOYMENT APPLICATION

OPERATING LEDGER

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

ACADEMIC_OUTCOME

ADMISSIONS_APPLICATION

AWARD_BY_PERSON

EMPLOYEE

EMPLOYEE_POSITION

ENROLLMENT

GENERAL_LEDGER

GIFT

GRANT_VIEW

HR_APPLICATION

OPERATING_LEDGER

RECEIVABLE_ACCOUNT_DETAIL

STUDENT_COURSE

PROCESS_GROUP

NO

NO

GRADUATION COMPLETION

RECRUITING AND ADMISSION

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

EMPLOYEE, EMPLOYEE DEGREE

EMPLOYEE POSITION

ENROLLMENT

GENERAL LEDGER

ADVANCEMENT GIFT

GRANT AND PROJECT

EMPLOYMENT APPLICATION

OPERATING LEDGER

RECEIVABLE CUSTOMER, RECEIVABLE REVENUE

ACADEMIC PROGRAM COURSE, COURSE REGISTRATION

PROCESS_GROUP_LD Long description for the process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

PROCESS_GROUP_SD Short description for the process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process VARCHAR2(255)

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. VARCHAR2(255)

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION



Ver: 3.1