RETURN TO DIMENSION TABLE REPORTS LIST
Course Registration Star Enrollment Star Financial Aid Student Star Graduation Completion Star Receivable Customer Star Recruiting And Admission Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_ACADEMIC_STUDY

Description Academic Study Dimension table provides information for the program of study for the individual. This may be the data on the admission application or the academic outcome record that identifies the major subject area and sought award or degree, etc.. It uses the cleansing rules in the EDW for the short and long descriptions.

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

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

AWARD_CATEGORY

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

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

AWARD_CATEGORY_DESC

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

AWARD_CATEGORY_SD Short description that Short describes a particular award category for government reporting. VARCHAR2(255)

ACADEMIC_OUTCOME

ACADEMIC_STUDY

ADMISSIONS_APPLICATION

AWARD_CATEGORY_DESC

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

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

COLLEGE

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

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

COLLEGE_DESC

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

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

COLLEGE_DESC

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

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

DEGREE

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

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

DEGREE_DESC

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

DEGREE_SD Short description of the Degree. VARCHAR2(255)

ACADEMIC_OUTCOME

ACADEMIC_STUDY

ADMISSIONS_APPLICATION

DEGREE_DESC

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

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

DEPARTMENT

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

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

DEPARTMENT_DESC

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

DEPARTMENT_SD Short name of the department responsible for the major subject area. VARCHAR2(255)

ACADEMIC_OUTCOME

ACADEMIC_STUDY

ADMISSIONS_APPLICATION

DEPARTMENT_DESC

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

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

MAJOR

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

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

MAJOR_DESC

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

MAJOR_SD Short name of the student's major subject area. VARCHAR2(255)

ACADEMIC_OUTCOME

ACADEMIC_STUDY

ADMISSIONS_APPLICATION

MAJOR_DESC

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

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

PROGRAM

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

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

PROGRAM_CLASSIFICATION

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

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

PROGRAM_CLASSIFICATION_DESC

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

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

PROGRAM_CLASSIFICATION_DESC

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

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

PROGRAM_DESC

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

PROGRAM_SD Short description of the responsible program. VARCHAR2(255)

ACADEMIC_OUTCOME

ACADEMIC_STUDY

ADMISSIONS_APPLICATION

PROGRAM_DESC

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

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

STUDENT_LEVEL

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

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

STUDENT_LEVEL_DESC

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

STUDENT_LEVEL_SD Short description for the Level. VARCHAR2(255)

ACADEMIC_OUTCOME

ACADEMIC_STUDY

ADMISSIONS_APPLICATION

STUDENT_LEVEL_DESC

NO

NO

GRADUATION COMPLETION

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, RECEIVABLE CUSTOMER

RECRUITING AND ADMISSION

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

ETL GENERATED

NA

NO

NO

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

COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECEIVABLE CUSTOMER, RECRUITING AND ADMISSION



Ver: 3.1