COST COLLECTORS ACCESSIBLE Table
Contains Master data information about all three types of cost objects (Cost Centers, Internal Orders, & Projects/WBS Elements). It contains the fields common to all three, and additional fields such as surcharge percentage and overrun information. This table will only return information about cost collectors that you have been granted access to.
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 |
AUTHORIZED_TOTAL_AMOUNT |
The amount authorized to be expended for a cost collector, usually by a WBS project sponsor. |
NUMBER |
9 |
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_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_DESC |
Description identifying the categories of Cost Collectors: Auxiliary, Fund -- Not Sponsored, Fund -- Sponsored, General, Other, Research. AUXILIARY cost centers are used by auxiliary enterprises (MIT Press, Housing & Dining, etc.) which are budgeted centrally but required to break even. FUNDS--NOT SPONSORED: those with non-sponsored revenue sources and contain MIT's endowments, loan funds, discretionary funds, and other accumulated net assets. All are internal orders. FUNDS--SPONSORED: have an external sponsor as the revenue source. Sponsored activity in the Fund range is non-organized research. All are WBS elements. GENERAL : All MIT Operating Cost Centers (cost objects budgeted centrally) except the Auxiliary cost centers defined above. RESEARCH: All of MIT's sponsored research activity is in this category. Revenue is assumed to be equal to expenses. All are WBS elements. OTHER: Internal Orders and WBS elements that hold activity that should not be part of MIT's revenues and expenses. This includes activity which will be distributed to General, Funds, and Research in the future using allocations, depreciation, or billings for services rendered, and activity being administered by MIT on behalf of others. |
VARCHAR2 |
30 |
COST_COLLECTOR_CONTINUED_FROM |
The Cost Collector ID of this project's predecessor project (usually WBS). |
VARCHAR2 |
7 |
COST_COLLECTOR_CONTINUED_TO |
The Cost Collector ID of this project's sucessor or continuation cost collector. |
VARCHAR2 |
7 |
COST_COLLECTOR_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
COST_COLLECTOR_CREATE_DATE |
The date the Cost Collector was identified to SAP. |
DATE |
8 |
COST_COLLECTOR_CREATE_USER_ID |
The User ID of the person who created the Cost Collector in SAP. |
VARCHAR2 |
12 |
COST_COLLECTOR_CURRENCY |
XXX |
VARCHAR2 |
5 |
COST_COLLECTOR_EFFECTIVE_DATE |
Effective date or starting date of the cost collector. |
DATE |
8 |
COST_COLLECTOR_EXPIRATION_DATE |
Date the cost collector expires (is no longer available). |
DATE |
8 |
COST_COLLECTOR_ID |
7-digit number which uniquely identifies the Cost Collector. |
VARCHAR2 |
7 |
COST_COLLECTOR_ID_WITH_TYPE |
Contains the first digit of the Cost Collector Type Code and the seven digit Cost Collector ID. |
VARCHAR2 |
8 |
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 |
COST_COLLECTOR_NAME |
The name of the Cost Collector. |
VARCHAR2 |
40 |
COST_COLLECTOR_PARENT_ID |
The Cost Collector ID of the "parent" of this Cost Collector (a master data field available for all Cost Collector types). For WBS elements, usually the level 1 parent in a project hierarchy. |
VARCHAR2 |
7 |
COST_COLLECTOR_TYPE_CODE |
A two-character code identifying the type of Cost Collector. CC=Cost Center, IO=Internal Order, PR=Project or WBS Element. |
VARCHAR2 |
2 |
COST_COLLECTOR_TYPE_DESC |
The full name of the cost collector type |
VARCHAR2 |
20 |
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 |
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 |
Used to identify the restriction category for MIT's fund cost collectors. U is unrestricted, T is temporarily restricted, and P is permanently restricted. These categories are used in the preparation of MIT's annual financial statements, included in the Treasurer's Report. |
VARCHAR2 |
1 |
FUNDING_CLASS |
For OSP accounts (20000-49999), fund class 616 is used. For fund accounts (20000-49999), 644 is used for fellowship accounts; otherwise 616 is usually used. |
VARCHAR2 |
3 |
FUNDING_CLASS_DESCRIPTION |
Identifies whether the Fund Cost Collector is Endowment or Expendable, and also whether it is completely discretionary or was established for a specific purpose such as Equipment, Professorships, Prizes & Awards, Student Loans, etc. |
VARCHAR2 |
70 |
FUND_CENTER_ID |
Six-digit number identifying the fund center (example: 100088 Music, 100152 Division of Toxicology). |
VARCHAR2 |
6 |
FUND_CENTER_NAME |
Name of the Fund Center/source of revenue. |
VARCHAR2 |
40 |
FUND_ID |
Identification number associated with the Fund (Example: 6779500) |
VARCHAR2 |
7 |
FUND_KEY |
Key is used only for joining the FUND table with the FINANCIAL_DETAIL table, NOT for reporting. |
VARCHAR2 |
10 |
FUND_NAME |
* In the FINANCIAL tables: this represents the name of the fund/source of revenue (Example: Publications). * In STUDENT FINANCIAL AID: this is the descriptive title of a financial aid fund/award. Exampes: "Federal Perkins Loan" for PERKNL. |
VARCHAR2 |
40 |
FUND_UNDERRECOVERY |
XXX |
VARCHAR2 |
30 |
HAS_CURRENT_FY_BASE_BUDGET |
XXX |
VARCHAR2 |
1 |
IS_CLOSED_COST_COLLECTOR |
Y= the cost collector is closed. The cost collector has a term code value of 3. N = the cost collector is open. The cost collector has a term code value of null, 1, or 2. |
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 |
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 |
OVERRUN_AMOUNT |
Dollar amount, calculated nightly in the warehouse, of overrun amount. Includes current month amount and estimated surcharges on that amount. |
NUMBER |
22 |
OVERRUN_FLAG |
Flag indicating whether cost collector is overrun. Values: Y and N. |
VARCHAR2 |
1 |
OVERRUN_WITH_COMMIT_AMOUNT |
Dollar amount, calculated nightly in the warehouse, of overrun amount including commitments. Includes current month amount and commitment amount, and estimated surcharges on that amount. |
NUMBER |
22 |
OVERRUN_WITH_COMMIT_FLAG |
Flag indicating whether cost collector is overrun by examining expenditures plus commitments. (It is possible for cost collectors to have a flag set for N for the Overrun_Flag but Y for Overrun_with_Commit_Flag.) Values: Y and N. |
VARCHAR2 |
1 |
POOL_CODE |
Indicates which investment pool the funds should placed in. |
VARCHAR2 |
1 |
POOL_UNITS |
The number of pool units allocated to a Fund Cost Collector; supplied by the Treasurer's Office. |
VARCHAR2 |
14 |
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 |
RELEASE_STRATEGY |
XXX |
VARCHAR2 |
2 |
SCHOOL_AREA |
XXX |
VARCHAR2 |
75 |
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 |
SUPERVISR_MIT_ID |
XXX |
VARCHAR2 |
9 |
SURCHARGE_CALC_PATTERN_KEY |
Key used to join the COST_COLLECTORS_ACCESSIBLE table to the SURCHARGE_PERCENTAGES and SURCHARGE_POSTINGS tables. |
NUMBER |
22 |
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 |
TREASURER_REPORT |
Not in use in SAP. |
VARCHAR2 |
3 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |