OSP PROP COSTSHARING DETAIL Table
OSP Proposal Cost Sharing
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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 |
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 |
OSP_COST_SHARING_TYPE_KEY |
XXX |
VARCHAR2 |
3 |
OSP_PROPOSAL_KEY |
XXX |
VARCHAR2 |
8 |
OSP_PROPOSAL_NUMBER |
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_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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |