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 |