OSP AWARD SPEC REVIEW DETAIL Table
OSP Award Special Review Details
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPLICATION_DATE |
XXX |
DATE |
8 |
APPROVAL_DATE |
XXX |
DATE |
8 |
APPROVAL_TYPE |
XXX |
VARCHAR2 |
100 |
APPROVAL_TYPE_CODE |
XXX |
VARCHAR2 |
3 |
COMMENTS |
Comments about the graduate appointment |
VARCHAR2 |
255 |
MIT_AWARD_KEY |
Key used to join tables with facts about OSP Awards. This field should be used only for joining data, NOT for reporting. |
VARCHAR2 |
10 |
PROTOCOL_NUMBER |
XXX |
VARCHAR2 |
20 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
SPECIAL_REVIEW |
XXX |
VARCHAR2 |
100 |
SPECIAL_REVIEW_CODE |
XXX |
VARCHAR2 |
3 |
SPECIAL_REVIEW_NUMBER |
XXX |
VARCHAR2 |
3 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |