OSP PROPOSAL IDC RATE DETAIL Table
View exposing OSP proposal indirect cost rate detail records including proposed IDC rates, rate bases, calculation amounts, and sponsor rate agreements used for proposal budgeting and cost analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPLICABLE_IDC_RATE |
Applicable idc rate associated with the record. |
NUMBER |
5,2 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
100 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
4 |
ON_CAMPUS_FLAG |
Indicator identifying whether on campus (Y/N). |
VARCHAR2 |
1 |
ON_OFF_CAMPUS_STATUS |
On off campus status associated with the record. |
VARCHAR2 |
10 |
OSP_IDC_RATE_TYPE_KEY |
Surrogate key identifying the osp idc rate type. |
NUMBER |
|
OSP_PROPOSAL_KEY |
Surrogate key identifying the osp proposal. |
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_KEY |
Surrogate key identifying the source cost collector. |
VARCHAR2 |
100 |
SOURCE_WBS_ID |
Business identifier for the source wbs. |
VARCHAR2 |
32 |
UNDERRECOVERY_OF_IDC_AMOUNT |
Underrecovery of idc amount associated with the record. |
NUMBER |
12,2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |