RETURN TO BANNER EDW META DATA REPORTS LIST
Academic Outcome Star  

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_ACADEMIC_OUTCOME

Description Academic Outcome Fact table provides information and details for each academic outcome (award, degree, diploma, certificate, etc.) sought and awarded by the institution.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ACADEMIC_OUTCOME_COUNT_KEY Count for the academic outcomes for the person. NUMBER

ETL GENERATED

NA

NO

NO ACADEMIC OUTCOME
ACADEMIC_OUTCOME_GROUP_KEY Key for the academic outcome group for the person. NUMBER

ETL GENERATED

NA

NO

NO ACADEMIC OUTCOME
ACADEMIC_OUTCOME_KEY Key for the academic outcome dimension. NUMBER

ETL GENERATED

NA

NO

NO ACADEMIC OUTCOME
ACADEMIC_OUTCOME_RECORD_KEY Key for the academic outcome dimension. NUMBER

ETL GENERATED

NA

NO

NO ACADEMIC OUTCOME
ACADEMIC_STUDY_KEY Key for the academic study dimension. NUMBER

ETL GENERATED

NA

NO

NO ACADEMIC OUTCOME
ACADEMIC_TIME_KEY Key for the academic time dimension. NUMBER

ETL GENERATED

NA

NO

NO ACADEMIC OUTCOME
ACAD_OUTCOME_HONOR_GROUP_KEY Key for the academic study dimension. NUMBER

ETL GENERATED

NA

NO

NO ACADEMIC OUTCOME
CREDITS_ATTEMPTED Sum of credits attempted by a student for this academic outcome. NUMBER

ACADEMIC_OUTCOME

CREDITS_ATTEMPTED

NO

NO ACADEMIC OUTCOME
CREDITS_EARNED Credits earned as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student. NUMBER

ACADEMIC_OUTCOME

CREDITS_EARNED

NO

NO ACADEMIC OUTCOME
CREDITS_PASSED Sum of credits passed by a student for this academic outcome. NUMBER

ACADEMIC_OUTCOME

CREDITS_PASSED

NO

NO ACADEMIC OUTCOME
CURRICULUM_ORDER Unique sequence number that identifies this academic study or program for the student. NUMBER

ACADEMIC_OUTCOME

CURRICULUM_ORDER

NO

NO ACADEMIC OUTCOME
CURRICULUM_PRIORITY Identifies the significant ranking for a curricula as assigned by the institution. NUMBER

ACADEMIC_OUTCOME

CURRICULUM_PRIORITY_NUMBER

NO

NO ACADEMIC OUTCOME
DEMOGRAPHIC_KEY Key for the demographic dimension. NUMBER

ETL GENERATED

NA

NO

NO ACADEMIC OUTCOME
DEPARTMENTAL_HONOR_GROUP_KEY Key for the group of departmental honor assigned to this outcome. NUMBER

ETL GENERATED

NA

NO

NO ACADEMIC OUTCOME
GPA Calculated grade point average or average for the set of courses completed. NUMBER

ACADEMIC_OUTCOME

GPA

NO

NO ACADEMIC OUTCOME
GPA_CREDITS Credits used to calculate the average or grade point average for the courses used to complete the outcome requirements. NUMBER

ACADEMIC_OUTCOME

GPA_CREDITS

NO

NO ACADEMIC OUTCOME
GRADUATION_ACADEMIC_TIME_KEY Key for the graduation academic time dimension. NUMBER

ETL GENERATED

NA

NO

NO ACADEMIC OUTCOME
INSTITUTIONAL_HONOR_GROUP_KEY Key for the group of institutional honor assigned to this outcome. NUMBER

ETL GENERATED

NA

NO

NO ACADEMIC OUTCOME
MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL GENERATED

NA

NO

NO ACADEMIC OUTCOME
OUTCOME_APPLICATION_DATE Date that the student applied for graduation in this academic outcome. DATE

ACADEMIC_OUTCOME

OUTCOME_APPLICATION_DATE

NO

NO ACADEMIC OUTCOME
OUTCOME_GRADUATION_DATE Date for the formal graduation for this academic outcome. This is the date that the completion of this degree or award is confirmed. DATE

ACADEMIC_OUTCOME

OUTCOME_GRADUATION_DATE

NO

NO ACADEMIC OUTCOME
OUTCOME_NUMBER Outcome sequence number. NUMBER

ACADEMIC_OUTCOME

OUTCOME_NUMBER

NO

NO ACADEMIC OUTCOME
PERSON_UID System generated, unique, internal identification number assigned to the person. NUMBER

ETL GENERATED

NA

NO

NO ACADEMIC OUTCOME
QUALITY_POINTS Quality points used to calculate the grade point average for this academic outcome. NUMBER

ACADEMIC_OUTCOME

QUALITY_POINTS

NO

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

ETL GENERATED

NA

NO

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

ETL GENERATED

NA

NO

NO ACADEMIC OUTCOME


Ver: 9.0