COST CENTER HISTORY Table
Contains the history of Cost Center Data for each fiscal period and fiscal year.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESSEE |
The last and first name of the addressee: normally, the Administrative Officer, Financial Officer, or other departmental administrator responsible for monitoring expenses. |
VARCHAR2 |
30 |
ADDRESSEE_ROOM |
The MIT address, building and room number, of the addressee. |
VARCHAR2 |
10 |
ADMIN_FLAG |
A two character code identifying how a cost collector is administered: AL for allocation cost objects; DP for DLC administered; FC for Faculty administered; RA for RA support; RT for Research Telephone; NS for NSF Shortfall; SP for service provider (facilities); CG for Core Grant (administrative component); CR for Custodial (central) responsibility. |
VARCHAR2 |
2 |
AREA_OF_RESP_CODE |
XXX |
VARCHAR2 |
2 |
CALC_CODE |
Classic system term relating to overhead. Not in use in SAP. |
VARCHAR2 |
1 |
COMPANY_CODE |
Shows to which "company" in SAP a cost collector is attached. MIT uses separate "companies" in SAP to differentiate financial transactions for different legal entities with differing business rules or reporting requirements. There are currently three company codes, "CUR" for main campus, "TECR" for MIT's alumni magazine, Technology Review, and "LCP1" for Lincoln Laboratory. |
VARCHAR2 |
4 |
COSTING_SHEET_DESCRIPTION |
Description of the Costing Sheet associated with this Cost Collector. In SAP, the costing sheet is the mechanism used to calculate and post secondary costs such as allocations, employee benefts, and facilities and administration charges to cost collectors. |
VARCHAR2 |
30 |
COSTING_SHEET_PROCEDURE |
Code designating the Costing Sheet associated with this Cost Collector. |
VARCHAR2 |
6 |
COST_CENTER_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
COST_CENTER_EFFECTIVE_DATE |
The beginning date of the cost center. |
DATE |
8 |
COST_CENTER_EXPIRATION_DATE |
The date when a cost collector is no longer in use. |
DATE |
8 |
COST_CENTER_ID |
Identifies the Cost Center. The Cost Center identifies the locations where the costs occur. |
VARCHAR2 |
7 |
COST_CENTER_NAME |
Cost Center description. |
VARCHAR2 |
40 |
COST_CENTER_PARENT_ID |
Gives the 7 digit cost collector ID of the Cost Center's Parent Cost Object, if it has one |
VARCHAR2 |
7 |
COST_COLLECTOR_CATEGORY_CODE |
Code identifying the categories of Cost Collectors: AUXIL (auxiliary), FNDNS (fund-nonsponsored), FNDSP (fund-sponsored), GENER (general), OTHER (other), RSRCH (research). See also COST_COLLECTOR_CATEGORY-DESC. |
VARCHAR2 |
5 |
COST_COLLECTOR_CATEGORY_NAME |
Defines the category of the Cost Center: Auxiliary or General |
VARCHAR2 |
30 |
COST_COLLECTOR_FP_KEY |
Key used to join historical Cost Collector tables and a fact table (Balances by Fiscal Period, Summary Statement Detail) when you want to bring up the cost collector data matching the fiscal period on the fact table. For the current fiscal period, the most recent data will be brought in. |
VARCHAR2 |
12 |
COST_COLLECTOR_FY_KEY |
Key used to join historical Cost Collector tables and a fact table (Balances, Balances by Fiscal Period, Summary Statement Detail) when you want to bring in cost collector data as it was at the end of fiscal year of the fact data. For the current fiscal year, the most recent data will be brought in. |
VARCHAR2 |
12 |
COST_COLLECTOR_KEY |
Key used to join the Cost Collector 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 |
12 |
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 |
FISCAL_PERIOD |
The fiscal year and month. For example: 199709 = March 1997. |
VARCHAR2 |
6 |
FISCAL_YEAR |
The 4 digit year. The fiscal year at MIT runs from July 1st through June 30th. (e.g.: June 30, 1997 would be fiscal year 1997, July 1, 1997 would be fiscal year 1998) |
VARCHAR2 |
4 |
FUND_CENTER_ID |
Six-digit number identifying the fund center (example: 100088 Music, 100152 Division of Toxicology). |
VARCHAR2 |
6 |
FUND_ID |
Identification number associated with the Fund (Example: 6779500) |
VARCHAR2 |
7 |
IS_CLOSED_COST_CENTER |
Y= the cost center is closed. |
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 |
Numerical codes describing distribution of Cost Collector statements. 1: Supervisor gets a copy of the Statement and the backup for the Cost Collector; Addressee gets a copy of the Statement only. 2: Supervisor gets a copy of the Statement only. Addressee gets a copy of the Statement and the backup for the Cost Collector. 3: Supervisor gets nothing; Addressee gets the ONLY copy of the Statement and the backup for the Cost Collector. 4: Supervisor gets the ONLY copy of the Statement and the backup for the Cost Collector; Addressee gets nothing. 5: Supervisor does NOT get Statement; Addressee does NOT get Statement but will get backup for the Cost Collector if there were charges. |
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 |
Indicates where research is performed: On Campus or Off Campus |
VARCHAR2 |
10 |
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 |
POOL_CODE |
Indicates which investment pool the funds should placed in. |
VARCHAR2 |
1 |
PROFIT_CENTER_ID |
A unique key that identifies the profit center. |
VARCHAR2 |
7 |
PROFIT_CENTER_NAME |
The text name of the profit center. |
VARCHAR2 |
40 |
RECORD_TYPE |
This field can contain different values in different tables. In the Summary Statement Detail table, it contains either "Posted" or "Calculated", referring to the nature of the record. In the Estimated Surcharges table, field values are "ACT"(actual) or "EST" (estimated). |
VARCHAR2 |
3 |
SECTION_CODE |
A code which classifies cost collectors into sections for financial statement reporting purposes |
VARCHAR2 |
3 |
SECTION_NAME |
Description associated with the Section Code. |
VARCHAR2 |
60 |
SUPERVISOR |
The name of the person responsible for this project, cost center, internal order, or cost center. |
VARCHAR2 |
30 |
SUPERVISOR_ROOM |
The building and room number assigned to the person responsible for this project, center, internal order, or cost center. |
VARCHAR2 |
10 |
TERM_CODE |
** For FINANCIAL DATA: the Term Code identifies the status of the cost collector. Blank - open for charges between start and end dates. Term Code = 1 - Closed. Pre-end date charges allowed. Term Code = 2 - No longer in use. Term Code = 3 - Terminated. Charges not allowed. ** For STUDENT DATA: the Term Code identifies one of the terms in an academic year; for example: 1999FA==>Fall Term of the 1998-99 academic year, and 1999SP==>Spring Term of the 1998-99 academic year. |
VARCHAR2 |
6 |
TERM_CODE_DESCRIPTION |
Description of the academic term. |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |