COST CENTER Table
View exposing cost center master data derived from cost collectors, including identifiers, organizational rollups, profit center relationships, administrative attributes, and operational reporting fields used for financial management and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESSEE |
Name of the designated contact responsible for communications related to the cost center. |
VARCHAR2 |
30 |
ADDRESSEE_MIT_ID |
MIT institutional identifier of the designated addressee contact. |
VARCHAR2 |
9 |
ADDRESSEE_ROOM |
Office or room location associated with the addressee contact. |
VARCHAR2 |
10 |
ADMIN_FLAG |
Administrative indicator used for financial processing or reporting logic. |
VARCHAR2 |
2 |
AREA_OF_RESP_CODE |
Code identifying the organizational area responsible for the cost center. |
VARCHAR2 |
2 |
CALC_CODE |
Calculation code used for internal financial processing logic. |
VARCHAR2 |
1 |
COMPANY_CODE |
Financial company code under which the cost center operates. |
VARCHAR2 |
4 |
COSTING_SHEET_DESCRIPTION |
Description of the costing sheet procedure. |
VARCHAR2 |
30 |
COSTING_SHEET_PROCEDURE |
Costing sheet procedure used for overhead or allocation calculations associated with the cost center. |
VARCHAR2 |
6 |
COST_CENTER_COUNTER |
System-generated counter used for record versioning or internal tracking. |
NUMBER |
10 |
COST_CENTER_EFFECTIVE_DATE |
Date on which the cost center becomes active and available for financial use. |
DATE |
|
COST_CENTER_EXPIRATION_DATE |
Date on which the cost center becomes inactive or expires. |
DATE |
|
COST_CENTER_ID |
Business identifier of the cost center used in financial systems. |
VARCHAR2 |
7 |
COST_CENTER_NAME |
Descriptive name of the cost center. |
VARCHAR2 |
42 |
COST_CENTER_PARENT_ID |
Identifier of the parent cost center within the cost center hierarchy. |
VARCHAR2 |
7 |
COST_COLLECTOR_CATEGORY_CODE |
Code identifying the category of cost collector associated with the cost center. |
VARCHAR2 |
5 |
COST_COLLECTOR_CATEGORY_DESC |
Description of the cost collector category. |
VARCHAR2 |
30 |
COST_COLLECTOR_CURRENCY |
Currency used for financial transactions associated with the cost center. |
VARCHAR2 |
5 |
COST_COLLECTOR_KEY |
Surrogate identifier for the cost collector associated with the cost center record. |
VARCHAR2 |
12 |
EB_ADJUSTMENT |
Employee benefits adjustment designation associated with the cost center. |
VARCHAR2 |
30 |
EB_ADJUSTMENT_KEY |
Identifier representing the employee benefits adjustment structure associated with the cost center. |
VARCHAR2 |
6 |
FUND_CENTER_ID |
Identifier of the fund center associated with the cost center. |
VARCHAR2 |
6 |
FUND_ID |
Identifier of the fund associated with the cost center. |
VARCHAR2 |
7 |
IS_CLOSED_COST_CENTER |
Indicator identifying whether the cost center is closed and no longer active. |
VARCHAR2 |
1 |
LAB_ALLOCATION |
Laboratory allocation designation associated with the cost center. |
VARCHAR2 |
30 |
LAB_ALLOCATION_KEY |
Identifier representing the laboratory allocation structure associated with the cost center. |
VARCHAR2 |
6 |
MAIL_CODE |
Mail routing code associated with the cost center. |
VARCHAR2 |
1 |
OH_ADJUSTMENT |
Overhead adjustment designation associated with the cost center. |
VARCHAR2 |
30 |
OH_ADJUSTMENT_KEY |
Identifier representing the overhead adjustment structure associated with the cost center. |
VARCHAR2 |
6 |
ON_OFF_CAMPUS_STATUS |
Indicator identifying whether the activity associated with the cost center is on-campus or off-campus. |
VARCHAR2 |
10 |
ORGANIZATION_ID |
Identifier of the organization responsible for the cost center. |
VARCHAR2 |
6 |
ORGANIZATION_NAME |
Name of the organization responsible for the cost center. |
VARCHAR2 |
40 |
POOL_CODE |
Code identifying the financial pool classification associated with the cost center. |
VARCHAR2 |
1 |
PROFIT_CENTER_ID |
Business identifier of the profit center associated with the cost center. |
VARCHAR2 |
7 |
PROFIT_CENTER_KEY |
Surrogate identifier of the profit center associated with the cost center. |
VARCHAR2 |
11 |
PROFIT_CENTER_NAME |
Name of the profit center associated with the cost center. |
VARCHAR2 |
40 |
SECTION_CODE |
Code identifying the financial section or classification associated with the cost center. |
VARCHAR2 |
3 |
SECTION_NAME |
Description of the financial section classification associated with the cost center. |
VARCHAR2 |
60 |
SUPERVISOR |
Name of the individual responsible for oversight of the cost center. |
VARCHAR2 |
30 |
SUPERVISOR_MIT_ID |
MIT institutional identifier of the supervisor associated with the cost center. |
VARCHAR2 |
9 |
SUPERVISOR_ROOM |
Office or room location associated with the supervisor. |
VARCHAR2 |
10 |
TERM_CODE |
Status or term code associated with the lifecycle state of the cost center. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |