RETURN TO BANNER EDW META DATA REPORTS LIST
Hold Star  

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_HOLD

Description Hold Fact table provides measures that may be used to compare and display hold information.

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

ETL GENERATED

NA

NO

NO HOLD
HOLD_AMOUNT Amount associated with hold. NUMBER

HOLD

HOLD_AMOUNT

NO

NO HOLD
HOLD_COUNT_KEY Key for the hold attribute count. NUMBER

ETL GENERATED

NA

NO

NO HOLD
HOLD_FROM_DATE Effective begin date of hold. DATE

HOLD

HOLD_FROM_DATE

NO

NO HOLD
HOLD_GROUP_KEY Unique identifier for all the Banner holds recorded for this person. NUMBER

REPORTING VIEW

ETL_GENERATED

NO

NO HOLD
HOLD_KEY Key of the hold dimension. NUMBER

ETL GENERATED

NA

NO

NO HOLD
HOLD_TO_DATE End date when the hold expires. DATE

HOLD

HOLD_TO_DATE

NO

NO HOLD
MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL GENERATED

NA

NO

NO HOLD
PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

HOLD

PERSON_UID

NO

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

ETL GENERATED

NA

NO

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

ETL GENERATED

NA

NO

NO HOLD


Ver: 9.0