Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PERSON AUTH AREA Table


View exposing person authorization area reference records used to classify service or access domains associated with person records.


Field Name

Description

Data Type

Length

HAS_FINANCIAL_AUTH

Has financial auth associated with the record.

VARCHAR2

1

HAS_HR_FULL_AUTH

Has hr full auth associated with the record.

VARCHAR2

1

HAS_HR_LIMITED_AUTH

Has hr limited auth associated with the record.

VARCHAR2

1

HAS_PAYROLL_AUTH

Has payroll auth associated with the record.

VARCHAR2

1

USER_NAME

User name associated with the record.

VARCHAR2

8

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE