Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PROFIT CENTER ACCESSIBLE Table


XXX


Field Name

Description

Data Type

Length

DEPARTMENT

The department of the primary Course/major: 6, 10, HIST, etc.

VARCHAR2

83

DEPARTMENT_SORT

XXX

NUMBER

DLC_KEY

a unigue key to enable joining information stored with other forms of Department Key

VARCHAR2

180

PROFIT_CENTER_ID

A unique key that identifies the profit center.

VARCHAR2

7

PROFIT_CENTER_KEY

Key used to join the Profit Center to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting.

VARCHAR2

11

PROFIT_CENTER_NAME

The text name of the profit center.

VARCHAR2

50

SCHOOL_AREA

XXX

VARCHAR2

40

SCHOOL_AREA_SORT

XXX

NUMBER

6

TOP_LEVEL_CATEGORY

XXX

VARCHAR2

40

TOP_LEVEL_SORT

XXX

NUMBER

6