OSP AWARD REPORT TRACKING Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_NUMBER |
The 7 digit General Ledger Cost Collector number assigned by OSP. |
VARCHAR2 |
7 |
AWARD_ID |
XXX |
NUMBER |
22 |
AWARD_NUMBER |
XXX |
VARCHAR2 |
12 |
AWARD_REPORT_TRACKING_ID |
XXX |
NUMBER |
22 |
AWARD_STATUS |
Status of the award. For RESEARCH AWARDS, indicates whether the award is Active, Pending, Closed, Terminated, or Inactive. For GRADUATE AWARDS (RA/TA), the possible values are: active, inactive, terminated, closed, hold, or pending. For FINANCIAL AID AWARDS, possible values include: ACTL, APPR, CANC, DECL, ESTI, KEPT, etc. |
VARCHAR2 |
100 |
AWARD_STATUS_CODE |
XXX |
VARCHAR2 |
12 |
AWARD_TITLE |
XXX |
VARCHAR2 |
200 |
BASE_DATE |
XXX |
DATE |
|
COMMENTS |
Comments about the graduate appointment |
VARCHAR2 |
1000 |
DUE_DATE |
XXX |
DATE |
|
FINAL_EXPIRATION_DATE |
Last expiration date of the award. |
DATE |
|
FREQUENCY |
XXX |
VARCHAR2 |
200 |
FREQUENCY_BASE |
XXX |
VARCHAR2 |
200 |
FREQUENCY_BASE_CODE |
XXX |
VARCHAR2 |
3 |
FREQUENCY_CODE |
XXX |
VARCHAR2 |
3 |
LAST_UPDATE_DATE |
Date the description was created or last altered. |
DATE |
|
LEAD_UNIT_ID |
XXX |
VARCHAR2 |
8 |
LEAD_UNIT_NAME |
XXX |
VARCHAR2 |
60 |
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 |
12 |
OSP_DISTRIBUTION |
XXX |
VARCHAR2 |
200 |
OSP_DISTRIBUTION_CODE |
XXX |
VARCHAR2 |
3 |
PI_ID |
The nine-digit MIT ID number of the project's Principal Investigator. |
VARCHAR2 |
9 |
PI_NAME |
The full name of the project's Principal Investigator, in the format Last, First MI. |
VARCHAR2 |
90 |
PRIME_SPONSOR_CODE |
Primary Sponsor code. OSP accounts are coded. Fund accounts are coded if there are restrictions in the award that make accounting system controls desirable. Contracts or grants from federal government and other restrictive sponsors are coded. |
VARCHAR2 |
6 |
PRIME_SPONSOR_NAME |
The name used to identify a primary sponsor associated with a particular sponsor code. |
VARCHAR2 |
60 |
REPORT_CLASS |
XXX |
VARCHAR2 |
200 |
REPORT_CLASS_CODE |
XXX |
VARCHAR2 |
3 |
REPORT_STATUS |
XXX |
VARCHAR2 |
200 |
REPORT_STATUS_CODE |
XXX |
VARCHAR2 |
3 |
REPORT_TYPE |
Name of the report for which the GL Account grouping exists; MUST be specified when this table is used. |
VARCHAR2 |
200 |
REPORT_TYPE_CODE |
XXX |
VARCHAR2 |
3 |
SEQUENCE_NUMBER |
Numerical value identifying the position of this record for the person. |
VARCHAR2 |
4 |
SPONSOR_CODE |
Sponsor code. OSP accounts are coded. Fund accounts are coded if there are restrictions in the award that make accounting system controls desirable. Contracts or grants from federal government and other restrictive sponsors are coded. |
VARCHAR2 |
6 |
SPONSOR_NAME |
In the PROJECT and SPONSOR tables, identifies the sponsor, associated with a particular sponsor code, providing funding for a sponsored research project. In the personnel APPOINTMENT tables, identifies the sponsor providing financial support for a Fellow; this field is not currently populated by Human Resources. |
VARCHAR2 |
200 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |