OSP AWARD IDC Table
Award Underrecovery Information: on- and off-campus rates, source and destination cost collectors by fiscal year.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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 |
DESTINATION_COST_COLLECTOR_ID |
In the OSP_Award_IDC table, This field primarily provides historical data and may not be used in future. It was used in earlier versions of Coeus to identify the WBS element whose authorized total was increased by the amount provided by the Source Cost Collector. This practice of increasing the authorized total is changing and the field will no longer be used for this purpose, but may continue to provide useful information for historical analysis. In the OSP_Award_Costshare table, this field identifies the Cost Collector for which mandatory cost-sharing is provided by the Source Cost Collector. |
VARCHAR2 |
7 |
DESTINATION_COST_COLLECTOR_KEY |
Key used to join the Cost Collector Key from the Cost Collector table to the OSP_Award_IDC table or to the OSP_Award_Costshare table in order to retrieve the Destination Cost Collector. This field should be used only for joining data, NOT for reporting. |
VARCHAR2 |
12 |
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 |
IDC_RATE |
The indirect cost rate allowed by the sponsor for an award, expressed as a percentage (e.g., 10, 15, 63.5, etc). This may be a percentage of TDC, MTDC, or other subset of costs (see "IDC Rate Type" for costing sheet procedure). |
NUMBER |
22 |
IDC_RATE_END_DATE |
The end date of the fiscal period for which the IDC rate is effective. There may be more than one rate within a fiscal year, and the end date may also be null, in other words, the rate does not have an end date. |
DATE |
8 |
IDC_RATE_START_DATE |
The start date of the fiscal period for which the IDC rate is effective, not necessarily the start date of a fiscal year: there may be more than one rate effective within a fiscal year. |
DATE |
8 |
IDC_RATE_TYPE |
The MIT Costing Sheet procedure for an award, e.g., RESMN for Research MTDC on campus, RESEB for Research EB (No F&A), GENSN for General (No F&A), FUNSNX (Fund S&W (no fee), etc. |
VARCHAR2 |
100 |
MIT_AWARD_KEY |
Key used to join tables with facts about OSP Awards. This field should be used only for joining data, NOT for reporting. |
VARCHAR2 |
10 |
MIT_AWARD_NUMBER |
A unique 10 digit number assigned to an award by MIT (OSP). |
VARCHAR2 |
10 |
ON_OFF_CAMPUS_STATUS |
Indicates where research is performed: On Campus or Off Campus |
VARCHAR2 |
10 |
PROJECT_WBS_ID |
Project work breakdown structure element identifier. |
VARCHAR2 |
7 |
SOURCE_COST_COLLECTOR_ID |
In the OSP_Award_IDC table, The Cost Collector ID provided by the DLCs in the funding plan as the originally planned source of funding for underrecovery of F&A costs, at the time a proposal was submitted to a sponsor. DLC's may subsequently change the Cost Collector used to fund underrecovery. In the OSP_Award_Costshare table, The ID of the Cost Collector providing the required cost sharing funds. |
VARCHAR2 |
7 |
SOURCE_COST_COLLECTOR_KEY |
Key used to join the Cost Collector Key from the Cost Collector table to the OSP_Award_IDC table or to the OSP_Award_Costshare table in order to retrieve the Source Cost Collector. This field should be used only for joining data, NOT for reporting. |
VARCHAR2 |
12 |
UNDERRECOVERY_OF_IDC_AMOUNT |
If a sponsor does not pay the full MTDC rate in effect for the period of an award, this is the dollar amount of indirect costs (F&A) not recovered from the sponsor. |
NUMBER |
22 |
UPDATE_TIMESTAMP |
Date that a record was last updated by OSP. |
DATE |
8 |
UPDATE_USER |
Userid of the person who last updated this record. |
VARCHAR2 |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |