Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PROFIT CENTER Table


Profit Center Dimension. Master data information on Profit Centers including name and id.


Field Name

Description

Data Type

Length

DLC_KEY

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

VARCHAR2

15

DLC_NAME

The name of the DLC associated with this room set.

VARCHAR2

50

IS_INACTIVE_PROFIT_CENTER

Is this Profit Center inactive? Y or N.

VARCHAR2

1

ORGANIZATION_ID

The department, for example, Accounting.

VARCHAR2

6

ORGANIZATION_NAME

The name of the MIT Department or Unit to which the project is assigned, usually the home unit or the Principal Investigator or Co-Investigator.

VARCHAR2

40

PROFIT_CENTER_COUNTER

Used to count records withing a group on a report. Always contains a value of 1.

NUMBER

1

PROFIT_CENTER_EFFECTIVE_DATE

Date the Profit Center is available for use.

DATE

8

PROFIT_CENTER_EXPIRATION_DATE

Indicates when the profit center closes.

DATE

8

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

40

SCHOOL_AREA

XXX

VARCHAR2

75

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8