RETURN TO FACT TABLE REPORTS LIST
Employee Degree Star

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_EMPLOYEE_DEGREE

Description Employee Degree 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 non-terminated employee per primary position assignment.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ADMINISTRATION_KEY Key for the administration dimension. NUMBER

ETL GENERATED

NA

NO

NO

EMPLOYEE DEGREE

DEMOGRAPHIC_KEY Key for the demographic dimension. NUMBER

ETL GENERATED

NA

NO

NO

EMPLOYEE DEGREE

EMPLOYEE_KEY Key for the employee dimension. NUMBER

ETL GENERATED

NA

NO

NO

EMPLOYEE DEGREE

MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL GENERATED

NA

NO

NO

EMPLOYEE DEGREE

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

EMPLOYEE

PERSON_UID

NO

NO

EMPLOYEE DEGREE

POST_SECONDARY_SCHOOL_KEY Key for the post secondary dimension. NUMBER

ETL GENERATED

NA

NO

NO

EMPLOYEE DEGREE

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

ETL GENERATED

NA

NO

NO

EMPLOYEE DEGREE

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

ETL GENERATED

NA

NO

NO

EMPLOYEE DEGREE

TIME_KEY Key for the time dimension. NUMBER

ETL GENERATED

NA

NO

NO

EMPLOYEE DEGREE



Ver: 3.1