RETURN TO BANNER EDW META DATA REPORTS LIST
Operating Ledger Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_FINANCE_ACTIVITY

Description Finance Activity Dimension table provides information for the activity codes defined by the institution. This information includes activity code and description. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ACTIVITY Code used to identify accounting data by activity. VARCHAR2(63)

OPERATING_LEDGER

ACTIVITY

NO

NO OPERATING LEDGER
ACTIVITY_LD Long description or title associated with the activity code. VARCHAR2(255)

OPERATING_LEDGER

ACTIVITY_DESC

NO

NO OPERATING LEDGER
ACTIVITY_SD Short description or title associated with the activity code. VARCHAR2(255)

OPERATING_LEDGER

ACTIVITY_DESC

NO

NO OPERATING LEDGER
FINANCE_ACTIVITY_KEY Key for the finance activity dimension. NUMBER

ETL GENERATED

NA

NO

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

ETL GENERATED

NA

NO

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

ETL GENERATED

NA

NO

NO OPERATING LEDGER


Ver: 9.0