COST COLLECTOR Table
View exposing cost collector master data (e.g., cost centers, internal orders, projects) including identifiers, type and category attributes, organizational and profit center rollups, funding classifications, lifecycle dates, status indicators, and financial management attributes used for financial reporting and controlling.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESSEE |
Name of the designated contact responsible for communications related to the cost collector. |
VARCHAR2 |
30 |
ADDRESSEE_MIT_ID |
MIT institutional identifier of the designated contact for the cost collector. |
VARCHAR2 |
9 |
ADDRESSEE_ROOM |
Office or room location associated with the designated contact. |
VARCHAR2 |
10 |
ADMIN_FLAG |
Administrative indicator used for financial processing or reporting logic. |
VARCHAR2 |
2 |
AUTHORIZED_TOTAL_AMOUNT |
Authorized financial amount associated with the cost collector where applicable. |
NUMBER |
13,2 |
CALC_CODE |
Calculation code used for financial processing logic. |
VARCHAR2 |
1 |
COMPANY_CODE |
Financial company code under which the cost collector 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. |
VARCHAR2 |
6 |
COST_COLLECTOR_CATEGORY_CODE |
Code identifying the category classification of the cost collector. |
VARCHAR2 |
5 |
COST_COLLECTOR_CATEGORY_DESC |
Description of the cost collector category classification. |
VARCHAR2 |
30 |
COST_COLLECTOR_CONTINUED_FROM |
Identifier of the prior cost collector from which this record was continued. |
VARCHAR2 |
7 |
COST_COLLECTOR_CONTINUED_TO |
Identifier of the subsequent cost collector to which this record was continued. |
VARCHAR2 |
7 |
COST_COLLECTOR_COUNTER |
System-generated counter used for record versioning or internal tracking. |
NUMBER |
|
COST_COLLECTOR_CREATE_DATE |
Date the cost collector was created in the source system. |
DATE |
|
COST_COLLECTOR_CREATE_USER_ID |
Identifier of the user who created the cost collector in the source system. |
VARCHAR2 |
12 |
COST_COLLECTOR_CURRENCY |
Currency used for financial transactions associated with the cost collector. |
VARCHAR2 |
5 |
COST_COLLECTOR_EFFECTIVE_DATE |
Date on which the cost collector becomes active. |
DATE |
|
COST_COLLECTOR_EXPIRATION_DATE |
Date on which the cost collector becomes inactive or expires. |
DATE |
|
COST_COLLECTOR_ID |
Business identifier used to reference the cost collector in financial systems. |
VARCHAR2 |
7 |
COST_COLLECTOR_ID_WITH_TYPE |
Cost collector identifier combined with the cost collector type to form a composite identifier. |
VARCHAR2 |
8 |
COST_COLLECTOR_KEY |
Surrogate identifier for the cost collector record. |
VARCHAR2 |
12 |
COST_COLLECTOR_NAME |
Descriptive name of the cost collector. |
VARCHAR2 |
60 |
COST_COLLECTOR_PARENT_ID |
Identifier of the parent cost collector within the cost collector hierarchy. |
VARCHAR2 |
7 |
COST_COLLECTOR_TYPE_CODE |
Code identifying the cost collector type (e.g., cost center, internal order, project). |
VARCHAR2 |
2 |
COST_COLLECTOR_TYPE_DESC |
Description of the cost collector type. |
VARCHAR2 |
20 |
DLC_KEY |
Identifier of the department, lab, or center (DLC) associated with the cost collector. |
VARCHAR2 |
15 |
DLC_NAME |
Name of the department, lab, or center (DLC) associated with the cost collector. |
VARCHAR2 |
70 |
EB_ADJUSTMENT |
Description associated with EB Adjustment Key. |
VARCHAR2 |
30 |
EB_ADJUSTMENT_KEY |
IN SAP keys are used to specify particular EB, F&A, or Allocation rates to be associated with a Cost Collector. When a key is blank, MIT's standard EB or F&A rates apply, and there is no allocation. If the key is filled out, the special rates noted in the key description apply. |
VARCHAR2 |
6 |
FS_CODE |
Financial statement classification code associated with the cost collector. |
VARCHAR2 |
1 |
FUNDING_CLASS |
Code identifying the funding classification associated with the cost collector. |
VARCHAR2 |
3 |
FUNDING_CLASS_DESCRIPTION |
Description of the funding classification code. |
VARCHAR2 |
70 |
FUND_CENTER_ID |
Business identifier of the fund center associated with the cost collector. |
VARCHAR2 |
6 |
FUND_CENTER_KEY |
Surrogate identifier of the fund center associated with the cost collector. |
VARCHAR2 |
6 |
FUND_CENTER_NAME |
Name of the fund center associated with the cost collector. |
VARCHAR2 |
45 |
FUND_ID |
Business identifier of the fund associated with the cost collector. |
VARCHAR2 |
7 |
FUND_KEY |
Surrogate identifier of the fund associated with the cost collector. |
VARCHAR2 |
11 |
FUND_NAME |
Name of the fund associated with the cost collector. |
VARCHAR2 |
40 |
FUND_UNDERRECOVERY |
Underrecovery designation associated with the fund linked to the cost collector. |
VARCHAR2 |
30 |
HAS_CURRENT_FY_BASE_BUDGET |
XXX |
VARCHAR2 |
1 |
IS_CLOSED_COST_COLLECTOR |
Indicator identifying whether the cost collector is closed and no longer active. |
VARCHAR2 |
1 |
IS_DEPT_CHAIR_SWEB_ACCOUNT |
XXX |
VARCHAR2 |
1 |
IS_DOF_INTERNAL_ORDER |
XXX |
VARCHAR2 |
1 |
IS_FABRICATED_EQUIPMNT_ACCOUNT |
XXX |
VARCHAR2 |
1 |
IS_INST_CHAIR_SWEB_ACCOUNT |
XXX |
VARCHAR2 |
1 |
IS_INTERNAL_COST_SHARING_CO |
XXX |
VARCHAR2 |
1 |
IS_PAYROLL_SUSPENSE_CO |
XXX |
VARCHAR2 |
1 |
IS_SCHOOL_CHAIR_SWEB_ACCOUNT |
XXX |
VARCHAR2 |
1 |
LAB_ALLOCATION |
Description associated with Lab Allocation Key. |
VARCHAR2 |
30 |
LAB_ALLOCATION_KEY |
Code associated with a Cost Collector which points to an allocation rate which will be applied to this Cost Collector. |
VARCHAR2 |
6 |
MAIL_CODE |
Mail routing code associated with the cost collector. |
VARCHAR2 |
1 |
OH_ADJUSTMENT |
Description associated with OH Adjustment Key. |
VARCHAR2 |
30 |
OH_ADJUSTMENT_KEY |
Code associated with a Cost Collector which points to an overhead rate which will be applied to this Cost Collector. |
VARCHAR2 |
6 |
ON_OFF_CAMPUS_STATUS |
Indicator identifying whether the cost collector activity is on-campus or off-campus. |
VARCHAR2 |
10 |
ORGANIZATION_ID |
Identifier of the organization responsible for the cost collector. |
VARCHAR2 |
6 |
ORGANIZATION_NAME |
Name of the organization responsible for the cost collector. |
VARCHAR2 |
40 |
POOL_CODE |
Code identifying the financial pool classification associated with the cost collector. |
VARCHAR2 |
1 |
POOL_UNITS |
Number of pool units associated with the cost collector where applicable. |
NUMBER |
10,4 |
PROFIT_CENTER_ID |
Business identifier of the profit center associated with the cost collector. |
VARCHAR2 |
7 |
PROFIT_CENTER_KEY |
Surrogate identifier of the profit center associated with the cost collector. |
VARCHAR2 |
11 |
PROFIT_CENTER_NAME |
Name of the profit center associated with the cost collector. |
VARCHAR2 |
40 |
RELEASE_STRATEGY |
XXX |
VARCHAR2 |
100 |
SCHOOL_AREA |
School or administrative area associated with the cost collector for reporting and rollups. |
VARCHAR2 |
70 |
SECTION_CODE |
Code identifying the financial section classification associated with the cost collector. |
VARCHAR2 |
3 |
SECTION_NAME |
Description of the financial section classification associated with the cost collector. |
VARCHAR2 |
60 |
SUPERVISOR |
Name of the individual responsible for oversight of the cost collector. |
VARCHAR2 |
30 |
SUPERVISOR_MIT_ID |
MIT institutional identifier of the supervisor associated with the cost collector. |
VARCHAR2 |
9 |
SUPERVISOR_ROOM |
Office or room location associated with the supervisor. |
VARCHAR2 |
10 |
SURCHARGE_CALC_PATTERN_KEY |
Identifier of the surcharge calculation pattern associated with the cost collector. |
VARCHAR2 |
50 |
TERM_CODE |
Lifecycle status code associated with the cost collector. |
VARCHAR2 |
1 |
TERM_CODE_DESCRIPTION |
Description of the lifecycle status code associated with the cost collector. |
VARCHAR2 |
40 |
TREASURER_REPORT |
Code indicating treasurer reporting classification for the cost collector. |
VARCHAR2 |
3 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |