OSP AWARD COSTSHARE Table
COEUS award cost sharing data
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDL_DESTINATION_DESCRIPTION |
Contains additional information about the Destination Cost Collector which cannot be derived from the Destination Cost Collector Id. If the Destination Cost Collector Id doesn't exist in the warehouse, this field contains "Invalid". |
VARCHAR2 |
40 |
ADDL_SOURCE_DESCRIPTION |
Contains additional information about the Source Cost Collector which cannot be derived from the Source Cost Collector Id. Examples include "Provost", "School", Third Party", "Invalid" (if the Cost Collector Id does not exist in the warehouse). |
VARCHAR2 |
40 |
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_SHARING_AMOUNT |
Cost Sharing Amount |
NUMBER |
22 |
COST_SHARING_PERCENTAGE |
Cost Sharing Percentage ( 0 to 100) |
NUMBER |
22 |
COST_SHARING_TYPE |
Description of the Cost Sharing Type |
VARCHAR2 |
100 |
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 |
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 |
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 |
UNIT_NUMBER |
XXX |
UNDEFINED |
0 |
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 |