FUNDS REPORTING CC HISTORY Table
XXX
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 |
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 |
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_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_ID |
7-digit number which uniquely identifies the Cost Collector. |
VARCHAR2 |
7 |
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 |
60 |
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 |
5 |
PC_LEVEL1_CATEGORY |
Profit Center Group Category description. |
VARCHAR2 |
40 |
PC_LEVEL1_SORT |
Profit Center Group sort order. |
NUMBER |
6 |
PC_LEVEL2_CATEGORY |
Profit Center Group Category description. |
VARCHAR2 |
40 |
PC_LEVEL2_SORT |
Profit Center Group sort order. |
NUMBER |
6 |
PC_LEVEL3_CATEGORY |
Profit Center Group Category description. |
VARCHAR2 |
40 |
PC_LEVEL3_SORT |
Profit Center Group sort order. |
NUMBER |
6 |
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 |
SUPERVISOR |
The name of the person responsible for this project, cost center, internal order, or cost center. |
VARCHAR2 |
30 |
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 |
1 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |