Dimension Table Target: WDT_MULTI

RETURN TO BANNER EDW META DATA REPORTS LIST

Academic Outcome Star Academic Outcome Honor Star Academic Program Course Star Address Star Administrator Star Admissions Application Star Admissions Finaid Record Star Admissions Recruitment Star Adv Student Activity Star Advancement Activity Star Advancement Deg Conc Star Advancement Deg Dept Star Advancement Deg Honr Star Advancement Deg Majr Star Advancement Deg Minr Star Advancement Degree Star Advancement Gift Star Advisor Star Affiliation Star Analyze Fundraising Star Application Attribute Star Application Cohort Star Application Decision Star Application Rating Star Application Requirement Star Assignment Star Athletic Star Award Honor Star Banner Communication Star Combined Admissions Source Star Committee Star Constituent Employment Star Constituent Entity Star Constituent Entity Type Star Constituent Evaluation Star Constituent Interest Star Constituent Profile Star Contact Star Contact Report Star Contact Report Credit Star Course Instructor Star Course Registration Star Course Section Star Designation Attribute Star Email Star Employee Star Employee Degree Star Employee Position Star Employment Application Star Enrollment Star Exclusion Star Financial Aid Application Star Financial Aid Award By Academic Period Star Financial Aid Award By Aid Year Star Financial Aid Pre-Student Star Financial Aid Student Star General Ledger Star Geographic Region Star Gift Star Gift Society Star Gift Society Premium Star Giving Code Star Grade Change Star Graduation Completion Star Grant And Project Star Hold Star Institution Star Interest Star Mail Tracking Star Mailing History Star Mailing List Star Manage Prospect Pipeline Star Manage Prospect Pipeline A Star Manage Prospect Pipeline B Star Matching Claim Star Meeting Time Star Membership Star Membership Club Star Membership Interest Star Operating Ledger Star Phone Star Pledge Star Post Secondary School Star Proposal Star Proposal Purpose Star Proposal Purpose Result Star Proposal Purpose Stage Star Proposal Stage Star Prospect Star Prospect Entity Star Prospect Interest Star Prospect Stage Star Prospective Student Star Race Star Receivable Customer Star Receivable Revenue Star Recruiting And Admission Star Recruitment Attribute Star Recruitment Cohort Star Relationship Star Retention Multi Year Star Rqpp Entity Star Rqpp Yearly Des Coll Star Rqpp Yearly Des Dept Star Rqpp Yearly Institution Star Secondary School Subject Star Special Purpose Star Sport Star Student Star Student Activity Star Student Attribute Star Student Cohort Star Student Course Star Student Course Attribute Star Student Progress Star Test Star Variable Purpose Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_MULTI_SOURCE

Description Multi-source Dimension table provides information on the source(s) of information. This information is the multi-source code and its descriptions along with the process group and administrative 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)
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, 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

NA

NO
NO ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, COURSE INSTRUCTOR, COURSE REGISTRATION, COURSE SECTION, 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, GRADE CHANGE, GRADUATION COMPLETION, GRANT AND PROJECT, HOLD, INSTITUTION, INTEREST, MEETING TIME, OPERATING LEDGER, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, 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 OUTCOME, ACADEMIC OUTCOME HONOR, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, COURSE INSTRUCTOR, COURSE REGISTRATION, COURSE SECTION, 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, GRADE CHANGE, GRADUATION COMPLETION, GRANT AND PROJECT, HOLD, INSTITUTION, INTEREST, MEETING TIME, OPERATING LEDGER, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, 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 INSTRUCTOR, 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

NA

NO
NO ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, COURSE INSTRUCTOR, COURSE REGISTRATION, COURSE SECTION, 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, GRADE CHANGE, GRADUATION COMPLETION, GRANT AND PROJECT, HOLD, INSTITUTION, INTEREST, MEETING TIME, OPERATING LEDGER, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, 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 OUTCOME, ACADEMIC OUTCOME HONOR, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, COURSE INSTRUCTOR, COURSE REGISTRATION, COURSE SECTION, 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, GRADE CHANGE, GRADUATION COMPLETION, GRANT AND PROJECT, HOLD, INSTITUTION, INTEREST, MEETING TIME, OPERATING LEDGER, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, 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

Ver: 9.0

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, 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	NA	NO	NO	ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, COURSE INSTRUCTOR, COURSE REGISTRATION, COURSE SECTION, 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, GRADE CHANGE, GRADUATION COMPLETION, GRANT AND PROJECT, HOLD, INSTITUTION, INTEREST, MEETING TIME, OPERATING LEDGER, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, 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 OUTCOME, ACADEMIC OUTCOME HONOR, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, COURSE INSTRUCTOR, COURSE REGISTRATION, COURSE SECTION, 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, GRADE CHANGE, GRADUATION COMPLETION, GRANT AND PROJECT, HOLD, INSTITUTION, INTEREST, MEETING TIME, OPERATING LEDGER, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, 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 INSTRUCTOR, 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	NA	NO	NO	ACADEMIC OUTCOME, ACADEMIC OUTCOME HONOR, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, COURSE INSTRUCTOR, COURSE REGISTRATION, COURSE SECTION, 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, GRADE CHANGE, GRADUATION COMPLETION, GRANT AND PROJECT, HOLD, INSTITUTION, INTEREST, MEETING TIME, OPERATING LEDGER, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, 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 OUTCOME, ACADEMIC OUTCOME HONOR, ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS FINAID RECORD, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, COURSE INSTRUCTOR, COURSE REGISTRATION, COURSE SECTION, 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, GRADE CHANGE, GRADUATION COMPLETION, GRANT AND PROJECT, HOLD, INSTITUTION, INTEREST, MEETING TIME, OPERATING LEDGER, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECEIVABLE CUSTOMER, RECEIVABLE REVENUE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT COURSE ATTRIBUTE, STUDENT PROGRESS, 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