OSP AWARD REPORT TRACKING Table
View exposing sponsored award reporting requirements and submission tracking including report type, due date, submission status, submission date, sponsor requirements, and compliance documentation used for research compliance management.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_NUMBER |
Account number associated with the record. |
VARCHAR2 |
7 |
AWARD_ID |
Business identifier for the award. |
NUMBER |
22 |
AWARD_NUMBER |
Award number associated with the record. |
VARCHAR2 |
12 |
AWARD_REPORT_TRACKING_ID |
Business identifier for the award report tracking. |
NUMBER |
22 |
AWARD_STATUS |
Award status associated with the record. |
VARCHAR2 |
100 |
AWARD_STATUS_CODE |
Code identifying award status. |
VARCHAR2 |
12 |
AWARD_TITLE |
Award title associated with the record. |
VARCHAR2 |
200 |
BASE_DATE |
Date associated with base. |
DATE |
|
COMMENTS |
Comments associated with the record. |
VARCHAR2 |
1000 |
DUE_DATE |
Date associated with due. |
DATE |
|
FINAL_EXPIRATION_DATE |
Date associated with final expiration. |
DATE |
|
FREQUENCY |
Frequency associated with the record. |
VARCHAR2 |
200 |
FREQUENCY_BASE |
Frequency base associated with the record. |
VARCHAR2 |
200 |
FREQUENCY_BASE_CODE |
Code identifying frequency base. |
VARCHAR2 |
3 |
FREQUENCY_CODE |
Code identifying frequency. |
VARCHAR2 |
3 |
LAST_UPDATE_DATE |
Date associated with last update. |
DATE |
|
LEAD_UNIT_ID |
Business identifier for the lead unit. |
VARCHAR2 |
8 |
LEAD_UNIT_NAME |
Lead unit name associated with the record. |
VARCHAR2 |
60 |
MIT_AWARD_KEY |
Surrogate key identifying the mit award. |
VARCHAR2 |
12 |
OSP_DISTRIBUTION |
Osp distribution associated with the record. |
VARCHAR2 |
200 |
OSP_DISTRIBUTION_CODE |
Code identifying osp distribution. |
VARCHAR2 |
3 |
PI_ID |
Business identifier for the pi. |
VARCHAR2 |
9 |
PI_NAME |
Pi name associated with the record. |
VARCHAR2 |
90 |
PRIME_SPONSOR_CODE |
Code identifying prime sponsor. |
VARCHAR2 |
6 |
PRIME_SPONSOR_NAME |
Prime sponsor name associated with the record. |
VARCHAR2 |
60 |
REPORT_CLASS |
Report class associated with the record. |
VARCHAR2 |
200 |
REPORT_CLASS_CODE |
Code identifying report class. |
VARCHAR2 |
3 |
REPORT_STATUS |
Report status associated with the record. |
VARCHAR2 |
200 |
REPORT_STATUS_CODE |
Code identifying report status. |
VARCHAR2 |
3 |
REPORT_TYPE |
Report type associated with the record. |
VARCHAR2 |
200 |
REPORT_TYPE_CODE |
Code identifying report type. |
VARCHAR2 |
3 |
SEQUENCE_NUMBER |
Sequence number associated with the record. |
VARCHAR2 |
4 |
SPONSOR_CODE |
Code identifying sponsor. |
VARCHAR2 |
6 |
SPONSOR_NAME |
Sponsor name associated with the record. |
VARCHAR2 |
200 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |