OSP PROPOSAL IDC RATE DETAIL Table
OSP Proposal Inderect Cost Detail: on- and off-campus rates, source and destination cost collectors by fiscal year.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPLICABLE_IDC_RATE |
XXX |
NUMBER |
22 |
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 |
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 |
ON_CAMPUS_FLAG |
XXX |
CHAR |
1 |
ON_OFF_CAMPUS_STATUS |
Indicates where research is performed: On Campus or Off Campus |
VARCHAR2 |
10 |
OSP_IDC_RATE_TYPE_KEY |
XXX |
VARCHAR2 |
3 |
OSP_PROPOSAL_KEY |
XXX |
VARCHAR2 |
8 |
PROJECT_WBS_ID |
Project work breakdown structure element identifier. |
VARCHAR2 |
7 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
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 |
SOURCE_WBS_ID |
XXX |
VARCHAR2 |
7 |
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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |