OSP AWARD IDC Table
View exposing indirect cost (IDC/overhead) rate detail for sponsored awards including negotiated rate percentages, applicable cost bases, effective dates, and calculation methodology used for research cost analysis and financial planning.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
100 |
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 |
IDC_RATE |
Idc rate associated with the record. |
NUMBER |
5,2 |
IDC_RATE_END_DATE |
Date associated with idc rate end. |
DATE |
|
IDC_RATE_START_DATE |
Date associated with idc rate start. |
DATE |
|
IDC_RATE_TYPE |
Idc rate type associated with the record. |
VARCHAR2 |
200 |
MIT_AWARD_KEY |
Surrogate key identifying the mit award. |
VARCHAR2 |
12 |
MIT_AWARD_NUMBER |
Mit award number associated with the record. |
VARCHAR2 |
12 |
ON_OFF_CAMPUS_STATUS |
On off campus status associated with the record. |
VARCHAR2 |
10 |
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 |
UNDERRECOVERY_OF_IDC_AMOUNT |
Underrecovery of idc amount associated with the record. |
NUMBER |
12,2 |
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 |