Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PAYROLL ROLES FUNCTION Table


View exposing payroll roles function data.


Field Name

Description

Data Type

Length

PAYROLL_ROLES_FUNCTION_DESC

Description of payroll roles function.

VARCHAR2

50

PAYROLL_ROLES_FUNCTION_KEY

Surrogate key identifying the payroll roles function.

NUMBER

PAYROLL_ROLES_FUNCTION_NAME

Payroll roles function name associated with the record.

VARCHAR2

30

PAYROLL_ROLES_FUNCTN_CATEGORY

Payroll roles functn category associated with the record.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE