| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
ACADEMIC_STUDY_KEY
|
Key for the academic study dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION
|
|
AWARD_CATEGORY
|
Government reporting category that groups awards and degrees together to count students. For example, Less than 2 yr, 2 yr, Bachelor, etc. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star schema.
|
VARCHAR2(63)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
AWARD_CATEGORY AWARD_CATEGORY AWARD_CATEGORY AWARD_CATEGORY
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
AWARD_CATEGORY_LD
|
Long description that describes a particular award category for government reporting. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
AWARD_CATEGORY_DESC AWARD_CATEGORY_DESC AWARD_CATEGORY_DESC AWARD_CATEGORY_DESC
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
AWARD_CATEGORY_SD
|
Short description that Short describes a particular award category for government reporting.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
AWARD_CATEGORY_DESC AWARD_CATEGORY_DESC AWARD_CATEGORY_DESC AWARD_CATEGORY_DESC
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
CAMPUS
|
Campus associated with the student.
|
VARCHAR2(63)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
CAMPUS CAMPUS CAMPUS
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION ADMISSIONS APPLICATION
ADMISSIONS RECRUITMENT
|
|
CAMPUS_LD
|
Long description for the institution campus.
|
VARCHAR2(255)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
CAMPUS_DESC CAMPUS_DESC CAMPUS_DESC
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION ADMISSIONS APPLICATION
ADMISSIONS RECRUITMENT
|
|
CAMPUS_SD
|
Short description for the institution campus.
|
VARCHAR2(255)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
CAMPUS_DESC CAMPUS_DESC CAMPUS_DESC
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION ADMISSIONS APPLICATION
ADMISSIONS RECRUITMENT
|
|
COLLEGE
|
First level of the institution organization structure that owns the academic instruction responsibility for this student's academic study. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme.
|
VARCHAR2(63)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
COLLEGE COLLEGE COLLEGE COLLEGE
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
COLLEGE_LD
|
Long descriptive name for the first organization level at the institution. Examples include: School of Business, College of Medicine, Faculty of Arts and Sciences, Division of Education. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
COLLEGE_DESC COLLEGE_DESC COLLEGE_DESC COLLEGE_DESC
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
COLLEGE_SD
|
Short descriptive name for the first organization level at the institution. Examples include: School of Business, College of Medicine, Faculty of Arts and Sciences, Division of Education.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
COLLEGE_DESC COLLEGE_DESC COLLEGE_DESC COLLEGE_DESC
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
DEGREE
|
Outcome upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme.
|
VARCHAR2(63)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
DEGREE DEGREE DEGREE DEGREE
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
DEGREE_LD
|
Long descriptive name for the Degree. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
DEGREE_DESC DEGREE_DESC DEGREE_DESC DEGREE_DESC
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
DEGREE_SD
|
Short description of the Degree.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
DEGREE_DESC DEGREE_DESC DEGREE_DESC DEGREE_DESC
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
DEPARTMENT
|
Department responsible for the major subject area of academic study. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application.
|
VARCHAR2(63)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
DEPARTMENT DEPARTMENT DEPARTMENT DEPARTMENT
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
DEPARTMENT_LD
|
Long name of the department responsible for the major subject area. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
DEPARTMENT_SD
|
Short name of the department responsible for the major subject area.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
MAJOR
|
Major subject area of the person's academic study. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme.
|
VARCHAR2(63)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
MAJOR MAJOR MAJOR MAJOR
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
MAJOR_LD
|
Long name of the student's major subject area. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
MAJOR_DESC MAJOR_DESC MAJOR_DESC MAJOR_DESC
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
MAJOR_SD
|
Short name of the student's major subject area.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
MAJOR_DESC MAJOR_DESC MAJOR_DESC MAJOR_DESC
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
PROGRAM
|
Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements. This information will be taken from the ODS Academic Study or Academic Outcome, Admissions Application or Recruitment Information reporting view as appropriate for the star scheme.
|
VARCHAR2(63)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
PROGRAM PROGRAM PROGRAM PROGRAM
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
PROGRAM_CLASSIFICATION
|
Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.
|
VARCHAR2(63)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
PROGRAM_CLASSIFICATION PROGRAM_CLASSIFICATION PROGRAM_CLASSIFICATION PROGRAM_CLASSIFICATION
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
PROGRAM_CLASSIFICATION_LD
|
Long text describing the area of study. For example description associated with the CIP codes used in Integrated Postsecondary Education Data System (IPEDS) reporting in the US.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
PROGRAM_CLASSIFICATION_DESC PROGRAM_CLASSIFICATION_DESC PROGRAM_CLASSIFICATION_DESC PROGRAM_CLASSIFICATION_DESC
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
PROGRAM_CLASSIFICATION_SD
|
Short text describing the area of study. For example description associated with the CIP codes used in Integrated Postsecondary Education Data System (IPEDS) reporting in the US.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
PROGRAM_CLASSIFICATION_DESC PROGRAM_CLASSIFICATION_DESC PROGRAM_CLASSIFICATION_DESC PROGRAM_CLASSIFICATION_DESC
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
PROGRAM_LD
|
Long description of the responsible program. This information will be taken from the ODS Operating Ledger or Grant Ledger reporting view as appropriate for the star scheme.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
PROGRAM_DESC PROGRAM_DESC PROGRAM_DESC PROGRAM_DESC
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
PROGRAM_SD
|
Short description of the responsible program.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
PROGRAM_DESC PROGRAM_DESC PROGRAM_DESC PROGRAM_DESC
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
SECOND_DEPARTMENT
|
Department responsible for the major subject area of academic study.
|
VARCHAR2(63)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
SECOND_DEPARTMENT SECOND_DEPARTMENT SECOND_DEPARTMENT
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION ADMISSIONS APPLICATION
ADMISSIONS RECRUITMENT
|
|
SECOND_DEPARTMENT_LD
|
Long name of the department responsible for the major subject area.
|
VARCHAR2(255)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION ADMISSIONS APPLICATION
ADMISSIONS RECRUITMENT
|
|
SECOND_DEPARTMENT_SD
|
Short name of the department responsible for the major subject area.
|
VARCHAR2(255)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
DEPARTMENT_DESC DEPARTMENT_DESC DEPARTMENT_DESC
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION ADMISSIONS APPLICATION
ADMISSIONS RECRUITMENT
|
|
SECOND_MAJOR
|
Major subject area of the person's academic study.
|
VARCHAR2(63)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
SECOND_MAJOR SECOND_MAJOR SECOND_MAJOR
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION ADMISSIONS APPLICATION
ADMISSIONS RECRUITMENT
|
|
SECOND_MAJOR_LD
|
Long name of the student's major subject area.
|
VARCHAR2(255)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
MAJOR_DESC MAJOR_DESC MAJOR_DESC
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION ADMISSIONS APPLICATION
ADMISSIONS RECRUITMENT
|
|
SECOND_MAJOR_SD
|
Short name of the student's major subject area.
|
VARCHAR2(255)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
MAJOR_DESC MAJOR_DESC MAJOR_DESC
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION ADMISSIONS APPLICATION
ADMISSIONS RECRUITMENT
|
|
SECOND_PROG_CLASSIFICATION
|
Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting. For example CIP codes used in the Integrated Postsecondary Education Data System (IPEDS) reporting in the US.
|
VARCHAR2(63)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
SECOND_PROGRAM_CLASSIFICATION SECOND_PROGRAM_CLASSIFICATION SECOND_PROGRAM_CLASSIFICATION
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION ADMISSIONS APPLICATION
ADMISSIONS RECRUITMENT
|
|
SECOND_PROG_CLASSIFICATION_LD
|
Long text describing the area of study.
|
VARCHAR2(255)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
PROGRAM_CLASSIFICATION_DESC PROGRAM_CLASSIFICATION_DESC PROGRAM_CLASSIFICATION_DESC
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION ADMISSIONS APPLICATION
ADMISSIONS RECRUITMENT
|
|
SECOND_PROG_CLASSIFICATION_SD
|
Short text describing the area of study.
|
VARCHAR2(255)
|
ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
PROGRAM_CLASSIFICATION_DESC PROGRAM_CLASSIFICATION_DESC PROGRAM_CLASSIFICATION_DESC
|
NO NO NO
|
NO
|
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION ADMISSIONS APPLICATION
ADMISSIONS RECRUITMENT
|
|
STUDENT_LEVEL
|
Level of study for the student's program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme.
|
VARCHAR2(63)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
STUDENT_LEVEL_LD
|
Long description for the Level. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
STUDENT_LEVEL_DESC STUDENT_LEVEL_DESC STUDENT_LEVEL_DESC STUDENT_LEVEL_DESC
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
STUDENT_LEVEL_SD
|
Short description for the Level.
|
VARCHAR2(255)
|
ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION
|
STUDENT_LEVEL_DESC STUDENT_LEVEL_DESC STUDENT_LEVEL_DESC STUDENT_LEVEL_DESC
|
NO NO NO NO
|
NO
|
GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER ADMISSIONS APPLICATION, RECRUITING AND ADMISSION
ADMISSIONS RECRUITMENT
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION
|