OSP PROP COSTSHARING DETAIL Table
View exposing proposed cost-sharing detail for proposals including proposed institutional commitments, external commitments, and in-kind contributions used for cost-share planning and budget development.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDL_SOURCE_DESCRIPTION |
Description of addl source. |
VARCHAR2 |
15 |
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 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
4 |
OSP_COST_SHARING_TYPE_KEY |
Surrogate key identifying the osp cost sharing type. |
NUMBER |
|
OSP_PROPOSAL_KEY |
Surrogate key identifying the osp proposal. |
VARCHAR2 |
8 |
OSP_PROPOSAL_NUMBER |
Osp proposal number associated with the record. |
VARCHAR2 |
8 |
PROJECT_WBS_ID |
Business identifier for the project wbs. |
VARCHAR2 |
7 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
28 |
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 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |