RETURN TO FACT TABLE REPORTS LIST
Academic Program Course Star

SGHE Enterprise Data Warehouse
Fact Table Target: WFV_ACADEMIC_PROGRAM_COURSE

Description Academic Program Course Fact table provides measures that may be compared and displayed based on the dimensions in this star schema. This set of measures is stored per person per time frame per course reference number per academic program for the schedule offering.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ACADEMIC_PROGRAM_KEY Key for the academic program dimension. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

AGE Calculated by a function that subtracts the birth date from the load date. NUMBER

PERSON

FUNCTION

NO

NO

ACADEMIC PROGRAM COURSE

CONCENTRATION_COUNT Number of concentrations in this academic program. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

CONCENTRATION_GROUP_KEY Key for the concentration group dimension. VARCHAR2 (1000)

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

CONCENTRATION_GROUP_NO_ORDER Concentration group keys not by first, second etc but by alphabetical sequence. VARCHAR2 (1000)

FUNCTION

F_GET_ORDER

NO

NO

ACADEMIC PROGRAM COURSE

CONCENTRATION_KEY Key for the concentration dimension. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

CONCENTRATION_ORDER Concentration sequence within this academic program - first, second, third etc. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

CONC_GROUP_NO_ORDER_DESC Concentration group key description not by first, second etc but by alphabetical sequence. VARCHAR2 (4000)

FUNCTION

F_GET_GROUP_DESC

NO

NO

ACADEMIC PROGRAM COURSE

CONC_MAJOR_COUNT Number of concentrations within this major within this academic program. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

CONC_MAJOR_GROUP Concentration group key within an associated major. VARCHAR2 (500)

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

CONC_MAJOR_GROUP_NO_ORDER Concentration group keys within an associated major group not by first, second etc but by alphabetical sequence. VARCHAR2 (500)

FUNCTION

F_GET_ORDER

NO

NO

ACADEMIC PROGRAM COURSE

CONC_MAJOR_GROUP_NO_ORDER_DESC Concentration group key descriptions within an associated major group not by first, second etc but by alphabetical sequence. VARCHAR2 (4000)

FUNCTION

F_GET_GROUP_DESC

NO

NO

ACADEMIC PROGRAM COURSE

CONC_MAJOR_ORDER Concentration sequence within this major within this academic program - first, second, third etc. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

COURSE_KEY Key for the course dimension NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

COURSE_REFERENCE_NUMBER System internally generated ID to uniquely identify the schedule offering. VARCHAR2 (63)

STUDENT_COURSE

COURSE_REFERENCE_NUMBER

NO

NO

ACADEMIC PROGRAM COURSE

CURRICULUM_PRIORITY_NUMBER System internally generated ID to uniquely identify the curriculum priority. NUMBER

ACADEMIC_STUDY

CURRICULUM_PRIORITY_NUMBER

NO

NO

ACADEMIC PROGRAM COURSE

DEMOGRAPHIC_KEY Key for the demographic dimension. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

ENROLLMENT_STATUS_KEY Key for the enrollment dimension. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

INSTRUCTOR_KEY Key for the instructor dimension NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

MAJOR_COUNT Number of majors in this academic program. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

MAJOR_GROUP_KEY Key for the major group dimension. VARCHAR2 (500)

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

MAJOR_GROUP_NO_ORDER Major group keys not by first, second etc but by alphabetical sequence. VARCHAR2 (500)

FUNCTION

F_GET_ORDER

NO

NO

ACADEMIC PROGRAM COURSE

MAJOR_GROUP_NO_ORDER_DESC Major group key descriptions not by first, second etc but by alphabetical sequence. VARCHAR2 (4000)

FUNCTION

F_GET_GROUP_DESC

NO

NO

ACADEMIC PROGRAM COURSE

MAJOR_KEY Key for the major dimension. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

MAJOR_ORDER Major sequence within this academic program - first, second, third etc. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

MINOR_COUNT Number of minors in this academic program. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

MINOR_GROUP_KEY Key for the minor group dimension. VARCHAR2 (500)

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

MINOR_GROUP_NO_ORDER Minor group keys not by first, second etc but by alphabetical sequence. VARCHAR2 (500)

FUNCTION

F_GET_ORDER

NO

NO

ACADEMIC PROGRAM COURSE

MINOR_GROUP_NO_ORDER_DESC Minor group key descriptions not by first, second etc but by alphabetical sequence. VARCHAR2 (4000)

FUNCTION

F_GET_GROUP_DESC

NO

NO

ACADEMIC PROGRAM COURSE

MINOR_KEY Key for the minor dimension. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

MINOR_ORDER Minor sequence within this academic program - first, second, third etc. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

PERSON_UID System internally generated ID to uniquely identify the person. NUMBER

PERSON

PERSON_UID

NO

NO

ACADEMIC PROGRAM COURSE

REGISTRATION_KEY Key for the registration dimension. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

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

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE

TIME_KEY Key for the time dimension. NUMBER

ETL GENERATED

NA

NO

NO

ACADEMIC PROGRAM COURSE



Ver: 3.1