RETURN TO BANNER EDW META DATA REPORTS LIST
Academic Outcome Honor Star  

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_ACADEMIC_OUTCOME_HONOR

Description Academic Outcome Honor Fact table provides data about honors or awards granted by the institution or the department that issued the outcome (degree, award or certificate, diploma) to the student.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ACADEMIC_OUTCOME_HONOR_KEY Key for the academic outcome honor dimension. NUMBER

ETL_GENERATED

NA

NO

NO ACADEMIC OUTCOME HONOR
ACAD_OUTCOME_DHONOR_COUNT_KEY Key for the student course attribute count. NUMBER

ETL_GENERATED

NA

NO

NO ACADEMIC OUTCOME HONOR
ACAD_OUTCOME_DHONOR_GROUP_KEY Key for the student course attribute group. NUMBER

ETL_GENERATED

NA

NO

NO ACADEMIC OUTCOME HONOR
ACAD_OUTCOME_HONOR_COUNT_KEY Key for the student course attribute count. NUMBER

ETL_GENERATED

NA

NO

NO ACADEMIC OUTCOME HONOR
ACAD_OUTCOME_HONOR_GROUP_KEY Key for the course dimension. NUMBER

ETL_GENERATED

NA

NO

NO ACADEMIC OUTCOME HONOR
ACAD_OUTCOME_IHONOR_COUNT_KEY Key for the course reference number. NUMBER

ETL_GENERATED

NA

NO

NO ACADEMIC OUTCOME HONOR
ACAD_OUTCOME_IHONOR_GROUP_KEY Key for the student course attribute dimension. NUMBER

ETL_GENERATED

NA

NO

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

ETL_GENERATED

NA

NO

NO ACADEMIC OUTCOME HONOR
OUTCOME_NUMBER Key for the course reference number. NUMBER

ETL_GENERATED

NA

NO

NO ACADEMIC OUTCOME HONOR
PERSON_UID Key for the person dimension. NUMBER

ETL_GENERATED

NA

NO

NO ACADEMIC OUTCOME HONOR
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 HONOR
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL_GENERATED

NA

NO

NO ACADEMIC OUTCOME HONOR


Ver: 9.0