OSP AWARD COSTSHARE Table
View exposing cost-share commitment records for sponsored awards including committed share amounts, percentage contribution, commitment source, funding period, and commitment status used for project financial tracking and sponsor compliance reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDL_DESTINATION_DESCRIPTION |
Description of addl destination. |
VARCHAR2 |
17 |
ADDL_SOURCE_DESCRIPTION |
Description of addl source. |
VARCHAR2 |
25 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
100 |
COST_SHARING_AMOUNT |
Cost sharing amount associated with the record. |
NUMBER |
12,2 |
COST_SHARING_PERCENTAGE |
Cost sharing percentage associated with the record. |
NUMBER |
5,2 |
COST_SHARING_TYPE |
Cost sharing type associated with the record. |
VARCHAR2 |
200 |
DESTINATION_COST_COLLECTOR_ID |
Business identifier for the destination cost collector. |
VARCHAR2 |
32 |
DESTINATION_COST_COLLECTOR_KEY |
Surrogate key identifying the destination cost collector. |
VARCHAR2 |
100 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
4 |
MIT_AWARD_KEY |
Surrogate key identifying the mit award. |
VARCHAR2 |
12 |
MIT_AWARD_NUMBER |
Mit award number associated with the record. |
VARCHAR2 |
12 |
PROJECT_WBS_ID |
Business identifier for the project wbs. |
VARCHAR2 |
16 |
SOURCE_COST_COLLECTOR_ID |
Business identifier for the source cost collector. |
VARCHAR2 |
32 |
SOURCE_COST_COLLECTOR_KEY |
Surrogate key identifying the source cost collector. |
VARCHAR2 |
100 |
UNIT_NUMBER |
Unit number associated with the record. |
VARCHAR2 |
8 |
UPDATE_TIMESTAMP |
Timestamp associated with update. |
DATE |
|
UPDATE_USER |
Update user associated with the record. |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |