Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SALARY DIST FP ACL Table


View exposing access control records for salary distribution by fiscal period including usernames, access control sequence values, and personnel keys.


Field Name

Description

Data Type

Length

ACL_SEQ

Acl seq associated with the record.

NUMBER

10

PERSONNEL_KEY

Surrogate key identifying the personnel.

VARCHAR2

96

USERNAME

Username associated with the record.

VARCHAR2

300

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE