| 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_AID_YEAR AWARD_BY_PERSON EMPLOYEE EMPLOYEE_POSITION ENROLLMENT FINAID_APPLICANT_STATUS GENERAL_LEDGER GIFT GRANT_VIEW HR_APPLICATION OPERATING_LEDGER RECEIVABLE_ACCOUNT_DETAIL STUDENT_COURSE
|
ADMINISTRATIVE_GROUP ADMINISTRATIVE_GROUP ADMINISTRATIVE_GROUP ADMINISTRATIVE_GROUP ADMINISTRATIVE_GROUP ADMINISTRATIVE_GROUP ADMINISTRATIVE_GROUP ADMINISTRATIVE_GROUP ADMINISTRATIVE_GROUP ADMINISTRATIVE_GROUP ADMINISTRATIVE_GROUP ADMINISTRATIVE_GROUP ADMINISTRATIVE_GROUP ADMINISTRATIVE_GROUP ADMINISTRATIVE_GROUP
|
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO
|
NO
|
GRADUATION COMPLETION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION FINANCIAL AID AWARD BY AID YEAR FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
EMPLOYEE, EMPLOYEE DEGREE EMPLOYEE POSITION ENROLLMENT FINANCIAL AID APPLICATION GENERAL LEDGER ADVANCEMENT GIFT
GRANT AND PROJECT EMPLOYMENT APPLICATION OPERATING LEDGER RECEIVABLE CUSTOMER, RECEIVABLE REVENUE ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, HOLD, INSTITUTION, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
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, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, HOLD, INSTITUTION, INTEREST, OPERATING LEDGER, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
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, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, HOLD, INSTITUTION, INTEREST, OPERATING LEDGER, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
ACADEMIC_OUTCOME ADMISSIONS_APPLICATION AWARD_BY_AID_YEAR AWARD_BY_PERSON EMPLOYEE EMPLOYEE_POSITION ENROLLMENT FINAID_APPLICANT_STATUS GENERAL_LEDGER GIFT GRANT_VIEW HR_APPLICATION OPERATING_LEDGER RECEIVABLE_ACCOUNT_DETAIL STUDENT_COURSE
|
MULTI_SOURCE MULTI_SOURCE MULTI_SOURCE MULTI_SOURCE MULTI_SOURCE MULTI_SOURCE MULTI_SOURCE MULTI_SOURCE MULTI_SOURCE MULTI_SOURCE MULTI_SOURCE MULTI_SOURCE MULTI_SOURCE MULTI_SOURCE MULTI_SOURCE
|
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO
|
NO
|
GRADUATION COMPLETION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION FINANCIAL AID AWARD BY AID YEAR FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
EMPLOYEE, EMPLOYEE DEGREE EMPLOYEE POSITION ENROLLMENT FINANCIAL AID APPLICATION GENERAL LEDGER ADVANCEMENT GIFT
GRANT AND PROJECT EMPLOYMENT APPLICATION OPERATING LEDGER RECEIVABLE CUSTOMER, RECEIVABLE REVENUE ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, HOLD, INSTITUTION, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
MULTI_SOURCE_KEY
|
Key for the multi-source dimension
|
NUMBER
|
ETL GENERATED ETL_GENERATED
|
NA NA
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, HOLD, INSTITUTION, INTEREST, OPERATING LEDGER, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
|
|
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_AID_YEAR AWARD_BY_PERSON EMPLOYEE EMPLOYEE_POSITION ENROLLMENT FINAID_APPLICANT_STATUS GENERAL_LEDGER GIFT GRANT_VIEW HR_APPLICATION OPERATING_LEDGER RECEIVABLE_ACCOUNT_DETAIL STUDENT_COURSE
|
MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC
|
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO
|
NO
|
GRADUATION COMPLETION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION FINANCIAL AID AWARD BY AID YEAR FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
EMPLOYEE, EMPLOYEE DEGREE EMPLOYEE POSITION ENROLLMENT FINANCIAL AID APPLICATION GENERAL LEDGER ADVANCEMENT GIFT
GRANT AND PROJECT EMPLOYMENT APPLICATION OPERATING LEDGER RECEIVABLE CUSTOMER, RECEIVABLE REVENUE ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, HOLD, INSTITUTION, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
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_AID_YEAR AWARD_BY_PERSON EMPLOYEE EMPLOYEE_POSITION ENROLLMENT FINAID_APPLICANT_STATUS GENERAL_LEDGER GIFT GRANT_VIEW HR_APPLICATION OPERATING_LEDGER RECEIVABLE_ACCOUNT_DETAIL STUDENT_COURSE
|
MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC MULTI_SOURCE_DESC
|
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO
|
NO
|
GRADUATION COMPLETION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION FINANCIAL AID AWARD BY AID YEAR FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
EMPLOYEE, EMPLOYEE DEGREE EMPLOYEE POSITION ENROLLMENT FINANCIAL AID APPLICATION GENERAL LEDGER ADVANCEMENT GIFT
GRANT AND PROJECT EMPLOYMENT APPLICATION OPERATING LEDGER RECEIVABLE CUSTOMER, RECEIVABLE REVENUE ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, HOLD, INSTITUTION, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
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_AID_YEAR AWARD_BY_PERSON EMPLOYEE EMPLOYEE_POSITION ENROLLMENT FINAID_APPLICANT_STATUS GENERAL_LEDGER GIFT GRANT_VIEW HR_APPLICATION OPERATING_LEDGER RECEIVABLE_ACCOUNT_DETAIL STUDENT_COURSE
|
PROCESS_GROUP PROCESS_GROUP PROCESS_GROUP PROCESS_GROUP PROCESS_GROUP PROCESS_GROUP PROCESS_GROUP PROCESS_GROUP PROCESS_GROUP PROCESS_GROUP PROCESS_GROUP PROCESS_GROUP PROCESS_GROUP PROCESS_GROUP PROCESS_GROUP
|
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO
|
NO
|
GRADUATION COMPLETION ADMISSIONS APPLICATION, RECRUITING AND ADMISSION FINANCIAL AID AWARD BY AID YEAR FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
EMPLOYEE, EMPLOYEE DEGREE EMPLOYEE POSITION ENROLLMENT FINANCIAL AID APPLICATION GENERAL LEDGER ADVANCEMENT GIFT
GRANT AND PROJECT EMPLOYMENT APPLICATION OPERATING LEDGER RECEIVABLE CUSTOMER, RECEIVABLE REVENUE ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, HOLD, INSTITUTION, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
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, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, HOLD, INSTITUTION, INTEREST, OPERATING LEDGER, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
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, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, HOLD, INSTITUTION, INTEREST, OPERATING LEDGER, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED ETL_GENERATED
|
NA NA
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, HOLD, INSTITUTION, INTEREST, OPERATING LEDGER, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED ETL_GENERATED
|
NA NA
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GRADUATION COMPLETION, GRANT AND PROJECT, HOLD, INSTITUTION, INTEREST, OPERATING LEDGER, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
|