COST COLLECTOR Table
Stores cost collector master data, including identifiers, names, organizational and profit center rollups, funding attributes, effective/expiration dates, budget/authorization amounts, and administrative flags for financial reporting and processing.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESSEE |
Name of the addressee associated with the cost collector. |
VARCHAR2 |
30 |
ADDRESSEE_MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
ADDRESSEE_ROOM |
Room location for the addressee associated with the cost collector. |
VARCHAR2 |
10 |
ADMIN_FLAG |
Administrative flag associated with the cost collector. |
VARCHAR2 |
2 |
AUTHORIZED_TOTAL_AMOUNT |
Authorized total amount associated with the cost collector. |
NUMBER |
13,2 |
CALC_CODE |
Calculation code associated with the cost collector. |
VARCHAR2 |
1 |
COMPANY_CODE |
Company code associated with the cost collector. |
VARCHAR2 |
4 |
COSTING_SHEET_DESCRIPTION |
Description of the costing sheet procedure. |
VARCHAR2 |
30 |
COSTING_SHEET_PROCEDURE |
Procedure code for the costing sheet associated with the cost collector. |
VARCHAR2 |
6 |
COST_COLLECTOR_CATEGORY_CODE |
Code identifying the cost collector category. |
VARCHAR2 |
5 |
COST_COLLECTOR_CATEGORY_DESC |
Description of the cost collector category code. |
VARCHAR2 |
30 |
COST_COLLECTOR_CONTINUED_FROM |
Identifier of the cost collector from which this cost collector was continued. |
VARCHAR2 |
7 |
COST_COLLECTOR_CONTINUED_TO |
Identifier of the cost collector to which this cost collector was continued. |
VARCHAR2 |
7 |
COST_COLLECTOR_COUNTER |
System counter/version value for the cost collector record. |
NUMBER |
|
COST_COLLECTOR_CREATE_DATE |
Date the cost collector was created in the source system. |
DATE |
|
COST_COLLECTOR_CREATE_USER_ID |
User identifier indicating who created the cost collector record in the source system. |
VARCHAR2 |
12 |
COST_COLLECTOR_CURRENCY |
Currency code associated with the cost collector. |
VARCHAR2 |
5 |
COST_COLLECTOR_EFFECTIVE_DATE |
Date the cost collector becomes effective. |
DATE |
|
COST_COLLECTOR_EXPIRATION_DATE |
Date the cost collector expires. |
DATE |
|
COST_COLLECTOR_ID |
Business identifier for the cost collector. |
VARCHAR2 |
7 |
COST_COLLECTOR_ID_WITH_TYPE |
Cost collector identifier combined with the cost collector type. |
VARCHAR2 |
8 |
COST_COLLECTOR_KEY |
Surrogate/key identifier for the cost collector record. |
VARCHAR2 |
12 |
COST_COLLECTOR_NAME |
Name of the cost collector. |
VARCHAR2 |
60 |
COST_COLLECTOR_PARENT_ID |
Identifier of the parent cost collector, if applicable. |
VARCHAR2 |
7 |
COST_COLLECTOR_TYPE_CODE |
Code identifying the cost collector type. |
VARCHAR2 |
2 |
COST_COLLECTOR_TYPE_DESC |
Description of the cost collector type code. |
VARCHAR2 |
20 |
DLC_KEY |
Key identifier for the DLC (department, lab, or center) associated with the cost collector. |
VARCHAR2 |
15 |
DLC_NAME |
Name of the DLC (department, lab, or center) associated with the cost collector. |
VARCHAR2 |
70 |
EB_ADJUSTMENT |
Employee benefits adjustment designation associated with the cost collector. |
VARCHAR2 |
30 |
EB_ADJUSTMENT_KEY |
Key identifier for the EB (employee benefits) adjustment associated with the cost collector. |
VARCHAR2 |
6 |
FS_CODE |
Financial statement code associated with the cost collector. |
VARCHAR2 |
1 |
FUNDING_CLASS |
Code identifying the funding class associated with the cost collector. |
VARCHAR2 |
3 |
FUNDING_CLASS_DESCRIPTION |
Description of the funding class code. |
VARCHAR2 |
70 |
FUND_CENTER_ID |
Identifier for the fund center associated with the cost collector. |
VARCHAR2 |
6 |
FUND_CENTER_KEY |
Key identifier for 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 |
Identifier for the fund associated with the cost collector. |
VARCHAR2 |
7 |
FUND_KEY |
Key identifier for the fund associated with the cost collector. |
VARCHAR2 |
11 |
FUND_NAME |
Name of the fund associated with the cost collector. |
VARCHAR2 |
40 |
FUND_UNDERRECOVERY |
Fund underrecovery designation associated with the cost collector. |
VARCHAR2 |
30 |
HAS_CURRENT_FY_BASE_BUDGET |
Indicator identifying whether the cost collector has a current fiscal year base budget (Y/N). |
VARCHAR2 |
1 |
IS_CLOSED_COST_COLLECTOR |
Indicator identifying whether the cost collector is closed (Y/N). |
VARCHAR2 |
1 |
IS_DEPT_CHAIR_SWEB_ACCOUNT |
Indicator identifying whether the cost collector is a department chair SWEB account (Y/N). |
VARCHAR2 |
1 |
IS_DOF_INTERNAL_ORDER |
Indicator identifying whether the cost collector is a DOF internal order (Y/N). |
VARCHAR2 |
1 |
IS_FABRICATED_EQUIPMNT_ACCOUNT |
Indicator identifying whether the cost collector is a fabricated equipment account (Y/N). |
VARCHAR2 |
1 |
IS_INST_CHAIR_SWEB_ACCOUNT |
Indicator identifying whether the cost collector is an institute chair SWEB account (Y/N). |
VARCHAR2 |
1 |
IS_INTERNAL_COST_SHARING_CO |
Indicator identifying whether the cost collector is an internal cost sharing cost object (Y/N). |
VARCHAR2 |
1 |
IS_PAYROLL_SUSPENSE_CO |
Indicator identifying whether the cost collector is a payroll suspense cost object (Y/N). |
VARCHAR2 |
1 |
IS_SCHOOL_CHAIR_SWEB_ACCOUNT |
Indicator identifying whether the cost collector is a school chair SWEB account (Y/N). |
VARCHAR2 |
1 |
LAB_ALLOCATION |
Lab allocation designation associated with the cost collector. |
VARCHAR2 |
30 |
LAB_ALLOCATION_KEY |
Key identifier for the lab allocation associated with the cost collector. |
VARCHAR2 |
6 |
MAIL_CODE |
Mail code associated with the cost collector. |
VARCHAR2 |
1 |
OH_ADJUSTMENT |
Overhead adjustment designation associated with the cost collector. |
VARCHAR2 |
30 |
OH_ADJUSTMENT_KEY |
Key identifier for the OH (overhead) adjustment associated with the cost collector. |
VARCHAR2 |
6 |
ON_OFF_CAMPUS_STATUS |
On/off campus status associated with the cost collector. |
VARCHAR2 |
10 |
ORGANIZATION_ID |
Identifier for the organization associated with the cost collector. |
VARCHAR2 |
6 |
ORGANIZATION_NAME |
Name of the organization associated with the cost collector. |
VARCHAR2 |
40 |
POOL_CODE |
Code identifying the pool associated with the cost collector. |
VARCHAR2 |
1 |
POOL_UNITS |
Pool units associated with the cost collector. |
NUMBER |
10,4 |
PROFIT_CENTER_ID |
Identifier for the profit center associated with the cost collector. |
VARCHAR2 |
7 |
PROFIT_CENTER_KEY |
Key identifier for 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 |
Release strategy text associated with the cost collector. |
VARCHAR2 |
100 |
SCHOOL_AREA |
School/area associated with the cost collector for reporting and rollups. |
VARCHAR2 |
70 |
SECTION_CODE |
Code identifying the section associated with the cost collector. |
VARCHAR2 |
3 |
SECTION_NAME |
Name/description of the section associated with the cost collector. |
VARCHAR2 |
60 |
SUPERVISOR |
Name of the supervisor associated with the cost collector. |
VARCHAR2 |
30 |
SUPERVISOR_MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
SUPERVISOR_ROOM |
Room location for the supervisor associated with the cost collector. |
VARCHAR2 |
10 |
SURCHARGE_CALC_PATTERN_KEY |
Key identifying the surcharge calculation pattern associated with the cost collector. |
VARCHAR2 |
50 |
TERM_CODE |
Code identifying the term/status associated with the cost collector. |
VARCHAR2 |
1 |
TERM_CODE_DESCRIPTION |
Description of the term/status code associated with the cost collector. |
VARCHAR2 |
40 |
TREASURER_REPORT |
Code indicating treasurer report grouping/handling for the cost collector. |
VARCHAR2 |
3 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the warehouse. |
DATE |