OSP ACTIVE AWARDS Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_YEAR_EFFORT |
XXX |
NUMBER |
5,2 |
ACCOUNT_NUMBER |
The 7 digit General Ledger Cost Collector number assigned by OSP. |
VARCHAR2 |
7 |
ANT_DISTRIBUTABLE_AMOUNT |
Anticipated dollar amount which can be distributed across accounts for this award. |
NUMBER |
12,2 |
ANT_TOTAL_AMOUNT |
Anticipated total dollar amount of this award (for all years if a multi-year award). |
NUMBER |
12,2 |
AWARD_EFFECTIVE_DATE |
The beginning date of the award, from which expenses can be charged. |
DATE |
|
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_TYPE |
Type of award (Example: Fellowship, Gift, Grant, Contract, Consortium Membership, Cooperative Agreement, etc.) |
VARCHAR2 |
100 |
AWARD_TYPE_CODE |
XXX |
VARCHAR2 |
12 |
CALENDAR_YEAR_EFFORT |
XXX |
NUMBER |
5,2 |
FACULTY_FLAG |
Flag identifying whether or not an employee is a member of the faculty (yes or no). |
VARCHAR2 |
1 |
FINAL_EXPIRATION_DATE |
Last expiration date of the award. |
DATE |
|
HOME_UNIT |
The persons primary department. |
VARCHAR2 |
8 |
HOME_UNIT_NAME |
XXX |
VARCHAR2 |
60 |
LEAD_UNIT_ID |
XXX |
VARCHAR2 |
8 |
LEAD_UNIT_NAME |
XXX |
VARCHAR2 |
60 |
MIT_AWARD_NUMBER |
A unique 10 digit number assigned to an award by MIT (OSP). |
VARCHAR2 |
12 |
OBLI_DISTRIBUTABLE_AMOUNT |
Total award dollars commited or spent which may be distributed across accounts. |
NUMBER |
12,2 |
OBLI_TOTAL_AMOUNT |
Total award dollars commited or spent. |
NUMBER |
12,2 |
PERSON_ID |
XXX |
VARCHAR2 |
40 |
PERSON_NAME |
XXX |
VARCHAR2 |
90 |
PERSON_PROJECT_ROLE |
XXX |
VARCHAR2 |
60 |
PERSON_ROLE |
XXX |
VARCHAR2 |
12 |
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_COUNTRY_CODE |
XXX |
VARCHAR2 |
3 |
PRIME_SPONSOR_COUNTRY_NAME |
XXX |
VARCHAR2 |
255 |
PRIME_SPONSOR_NAME |
The name used to identify a primary sponsor associated with a particular sponsor code. |
VARCHAR2 |
60 |
PRIME_SPONSOR_TYPE |
Type of primary sponsor (Example: Federal, Private - Pofit, Private - Non-Profit, State, etc..) |
VARCHAR2 |
100 |
SPONSOR_AWARD_NUMBER |
Award number assigned to a sponsor (May be the agreement signed date.) |
VARCHAR2 |
70 |
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_COUNTRY_CODE |
XXX |
VARCHAR2 |
3 |
SPONSOR_COUNTRY_NAME |
XXX |
VARCHAR2 |
255 |
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 |
SPONSOR_TYPE |
The type of sponsor (Example: Federal, Private - Pofit, Private - Non-Profit, State, etc..) |
VARCHAR2 |
100 |
SUMMER_EFFORT |
XXX |
NUMBER |
5,2 |
TITLE |
In the OSP AWARD, COST COLLECTOR, and PROJECT OSP tables, this is the Title of a Research Proposal. In KRB_PERSON, TITLE is the position title of the person. In TIP_MATERIAL view it is a TITLE of the course material. |
VARCHAR2 |
200 |
TOTAL_EFFORT |
XXX |
NUMBER |
5,2 |
USER_NAME |
Kerberos ID of the person who entered the purchasing financial detail record in SAP, usually the purchasing agent |
VARCHAR2 |
60 |
WAREHOUSE_INSERT_TIMESTAMP |
XXX |
DATE |
|
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |