Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PROFIT CENTER ACCESSIBLE Table


View exposing accessible profit center records including profit center identifiers and related access attributes used in financial reporting and security filtering.


Field Name

Description

Data Type

Length

DEPARTMENT

Department associated with the record.

VARCHAR2

83

DEPARTMENT_SORT

Department sort associated with the record.

NUMBER

DLC_KEY

Surrogate key identifying the dlc.

VARCHAR2

180

PROFIT_CENTER_ID

Business identifier for the profit center.

VARCHAR2

7

PROFIT_CENTER_KEY

Surrogate key identifying the profit center.

VARCHAR2

11

PROFIT_CENTER_NAME

Profit center name associated with the record.

VARCHAR2

50

SCHOOL_AREA

School area associated with the record.

VARCHAR2

40

SCHOOL_AREA_SORT

School area sort associated with the record.

NUMBER

6

TOP_LEVEL_CATEGORY

Top level category associated with the record.

VARCHAR2

40

TOP_LEVEL_SORT

Top level sort associated with the record.

NUMBER

6