OSP SUBAWARD Table
View exposing subaward records for sponsored projects including subawardee information, subaward amount, subaward period, and subaward status used for subcontractor tracking and financial management.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_NUMBER |
Account number associated with the record. |
VARCHAR2 |
100 |
AMOUNT_RELEASED |
Amount released associated with the record. |
NUMBER |
28,7 |
ANTICIPATED_AMOUNT |
Anticipated amount associated with the record. |
NUMBER |
12,2 |
ARCHIVE_LOCATION |
Archive location associated with the record. |
VARCHAR2 |
50 |
CLOSEOUT_DATE |
Date associated with closeout. |
DATE |
|
COMMENTS |
Comments associated with the record. |
CLOB |
|
COST_TYPE |
Cost type associated with the record. |
NUMBER |
|
COST_TYPE_DESC |
Description of cost type. |
VARCHAR2 |
200 |
DATE_OF_FULLY_EXECUTED |
Date of fully executed associated with the record. |
DATE |
|
EFFECTIVE_DATE |
Date associated with effective. |
DATE |
|
END_DATE |
Date associated with end. |
DATE |
|
MODIFICATION_EFFECTIVE_DATE |
Date associated with modification effective. |
DATE |
|
OBLIGATED_AMOUNT |
Obligated amount associated with the record. |
NUMBER |
12,2 |
ORGANIZATION_ID |
Business identifier for the organization. |
VARCHAR2 |
8 |
ORGANIZATION_NAME |
Organization name associated with the record. |
VARCHAR2 |
60 |
PERFORMANCE_END_DATE |
Date associated with performance end. |
DATE |
|
PERFORMANCE_START_DATE |
Date associated with performance start. |
DATE |
|
PURCHASE_ORDER_NUM |
Purchase order num associated with the record. |
VARCHAR2 |
10 |
REQUISITIONER_ID |
Business identifier for the requisitioner. |
VARCHAR2 |
40 |
REQUISITIONER_UNIT |
Requisitioner unit associated with the record. |
VARCHAR2 |
8 |
REQUISITION_NUMBER |
Requisition number associated with the record. |
VARCHAR2 |
50 |
SITE_INVESTIGATOR |
Site investigator associated with the record. |
NUMBER |
|
START_DATE |
Date associated with start. |
DATE |
|
STATUS_CODE |
Code identifying status. |
NUMBER |
|
SUBAWARD_CODE |
Code identifying subaward. |
VARCHAR2 |
20 |
SUBAWARD_STATUS_DESC |
Description of subaward status. |
VARCHAR2 |
200 |
SUBAWARD_TYPE_CODE |
Code identifying subaward type. |
NUMBER |
|
SUBAWARD_TYPE_DESC |
Description of subaward type. |
VARCHAR2 |
200 |
TITLE |
Title associated with the record. |
VARCHAR2 |
200 |
UPDATE_TIMESTAMP |
Timestamp associated with update. |
DATE |
|
UPDATE_USER |
Update user associated with the record. |
VARCHAR2 |
60 |
VENDOR_NUMBER |
Vendor number associated with the record. |
VARCHAR2 |
10 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |