| 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)
|
STUDENT_COURSE
|
ADMINISTRATIVE_GROUP
|
NO
|
NO
|
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, STUDENT COURSE, 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 EDW CLEANSING PROCESS
|
NA NA
|
NO NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION COHORT, APPLICATION DECISION, APPLICATION DECISION, APPLICATION RATING, APPLICATION RATING, APPLICATION REQUIREMENT, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, CONTACT, COURSE INSTRUCTOR, COURSE REGISTRATION, COURSE REGISTRATION, COURSE SECTION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADE CHANGE, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, HOLD, HOLD, INSTITUTION, INSTITUTION, INTEREST, INTEREST, MEETING TIME, OPERATING LEDGER, OPERATING LEDGER, POST SECONDARY SCHOOL, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, PROSPECTIVE STUDENT, RACE, RACE, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, TEST, TEST
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION COHORT, APPLICATION DECISION, APPLICATION DECISION, APPLICATION RATING, APPLICATION RATING, APPLICATION REQUIREMENT, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, CONTACT, COURSE INSTRUCTOR, COURSE REGISTRATION, COURSE REGISTRATION, COURSE SECTION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADE CHANGE, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, HOLD, HOLD, INSTITUTION, INSTITUTION, INTEREST, INTEREST, MEETING TIME, OPERATING LEDGER, OPERATING LEDGER, POST SECONDARY SCHOOL, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, PROSPECTIVE STUDENT, RACE, RACE, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, TEST, 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 EDW CLEANSING PROCESS
|
NA NA
|
NO NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION COHORT, APPLICATION DECISION, APPLICATION DECISION, APPLICATION RATING, APPLICATION RATING, APPLICATION REQUIREMENT, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, CONTACT, COURSE INSTRUCTOR, COURSE REGISTRATION, COURSE REGISTRATION, COURSE SECTION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADE CHANGE, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, HOLD, HOLD, INSTITUTION, INSTITUTION, INTEREST, INTEREST, MEETING TIME, OPERATING LEDGER, OPERATING LEDGER, POST SECONDARY SCHOOL, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, PROSPECTIVE STUDENT, RACE, RACE, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, TEST, TEST
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION COHORT, APPLICATION DECISION, APPLICATION DECISION, APPLICATION RATING, APPLICATION RATING, APPLICATION REQUIREMENT, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, CONTACT, COURSE INSTRUCTOR, COURSE REGISTRATION, COURSE REGISTRATION, COURSE SECTION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADE CHANGE, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, HOLD, HOLD, INSTITUTION, INSTITUTION, INTEREST, INTEREST, MEETING TIME, OPERATING LEDGER, OPERATING LEDGER, POST SECONDARY SCHOOL, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, PROSPECTIVE STUDENT, RACE, RACE, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, TEST, TEST
|
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
STUDENT_COURSE
|
MULTI_SOURCE
|
NO
|
NO
|
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, STUDENT COURSE, TEST
|
|
MULTI_SOURCE_KEY
|
Key for the multi source dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, BANNER COMMUNICATION, 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, RACE, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, STUDENT, TEST
|
|
MULTI_SOURCE_LD
|
Institution long description for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
STUDENT_COURSE
|
MULTI_SOURCE_DESC
|
NO
|
NO
|
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, STUDENT COURSE, TEST
|
|
MULTI_SOURCE_SD
|
Institution short description for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
STUDENT_COURSE
|
MULTI_SOURCE_DESC
|
NO
|
NO
|
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, STUDENT COURSE, TEST
|
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
STUDENT_COURSE
|
PROCESS_GROUP
|
NO
|
NO
|
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, STUDENT COURSE, 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 EDW CLEANSING PROCESS
|
NA NA
|
NO NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION COHORT, APPLICATION DECISION, APPLICATION DECISION, APPLICATION RATING, APPLICATION RATING, APPLICATION REQUIREMENT, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, CONTACT, COURSE INSTRUCTOR, COURSE REGISTRATION, COURSE REGISTRATION, COURSE SECTION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADE CHANGE, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, HOLD, HOLD, INSTITUTION, INSTITUTION, INTEREST, INTEREST, MEETING TIME, OPERATING LEDGER, OPERATING LEDGER, POST SECONDARY SCHOOL, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, PROSPECTIVE STUDENT, RACE, RACE, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, TEST, TEST
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION COHORT, APPLICATION DECISION, APPLICATION DECISION, APPLICATION RATING, APPLICATION RATING, APPLICATION REQUIREMENT, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, CONTACT, COURSE INSTRUCTOR, COURSE REGISTRATION, COURSE REGISTRATION, COURSE SECTION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADE CHANGE, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, HOLD, HOLD, INSTITUTION, INSTITUTION, INTEREST, INTEREST, MEETING TIME, OPERATING LEDGER, OPERATING LEDGER, POST SECONDARY SCHOOL, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, PROSPECTIVE STUDENT, RACE, RACE, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, TEST, 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 EDW CLEANSING PROCESS
|
NA NA
|
NO NO
|
NO
|
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION COHORT, APPLICATION DECISION, APPLICATION DECISION, APPLICATION RATING, APPLICATION RATING, APPLICATION REQUIREMENT, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, CONTACT, COURSE INSTRUCTOR, COURSE REGISTRATION, COURSE REGISTRATION, COURSE SECTION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADE CHANGE, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, HOLD, HOLD, INSTITUTION, INSTITUTION, INTEREST, INTEREST, MEETING TIME, OPERATING LEDGER, OPERATING LEDGER, POST SECONDARY SCHOOL, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, PROSPECTIVE STUDENT, RACE, RACE, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, TEST, TEST
ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION COHORT, APPLICATION DECISION, APPLICATION DECISION, APPLICATION RATING, APPLICATION RATING, APPLICATION REQUIREMENT, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, CONTACT, COURSE INSTRUCTOR, COURSE REGISTRATION, COURSE REGISTRATION, COURSE SECTION, EMPLOYEE, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION, ENROLLMENT, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, FINANCIAL AID STUDENT, GENERAL LEDGER, GENERAL LEDGER, GRADE CHANGE, GRADUATION COMPLETION, GRADUATION COMPLETION, GRANT AND PROJECT, GRANT AND PROJECT, HOLD, HOLD, INSTITUTION, INSTITUTION, INTEREST, INTEREST, MEETING TIME, OPERATING LEDGER, OPERATING LEDGER, POST SECONDARY SCHOOL, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, PROSPECTIVE STUDENT, RACE, RACE, RECEIVABLE CUSTOMER, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, TEST, TEST
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, BANNER COMMUNICATION, 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, RACE, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT PROGRESS, TEST
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, BANNER COMMUNICATION, 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, RACE, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT PROGRESS, TEST
|