OSP AWARD Table
Contains all project data for WBS Elements stored in COEUS.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_NUMBER |
The 7 digit General Ledger Cost Collector number assigned by OSP. |
VARCHAR2 |
5 |
ACCOUNT_TYPE |
Specifies the type of award, e.g., Regular, Off-Campus, Fabricated Equipment, etc. |
VARCHAR2 |
100 |
ACTIVITY_TYPE |
Type of activity billed against this award (Example: fellowship, organized research, other) |
VARCHAR2 |
100 |
ANTICIPATED_CHANGE_AMOUNT |
XXX |
NUMBER |
22 |
ANT_DISTRIBUTABLE_AMOUNT |
Anticipated dollar amount which can be distributed across accounts for this award. |
NUMBER |
22 |
ANT_DISTRIBUTED_AMOUNT |
Anticipated dollar amount distributed across accounts for this award. |
NUMBER |
22 |
ANT_TOTAL_AMOUNT |
Anticipated total dollar amount of this award (for all years if a multi-year award). |
NUMBER |
22 |
APPRVD_EQUIPMENT_AMOUNT |
Dollar amount allowed for equipment purchases on this award. |
NUMBER |
22 |
APPRVD_FOREIGN_TRIP_AMOUNT |
Dollar amount allowed for foreign travel expenses on this award. |
NUMBER |
22 |
APPRVD_SUBCONTRACT_AMOUNT |
Dollar amount allowed for subcontract expenses on this award. |
NUMBER |
22 |
AWARD_EFFECTIVE_DATE |
The beginning date of the award, from which expenses can be charged. |
DATE |
8 |
AWARD_EXECUTION_DATE |
The date the award was executed, issued, or signed off on. |
DATE |
8 |
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_TYPE |
Type of award (Example: Fellowship, Gift, Grant, Contract, Consortium Membership, Cooperative Agreement, etc.) |
VARCHAR2 |
100 |
AWARD_TYPE_CODE |
XXX |
VARCHAR2 |
12 |
BASIS_OF_PAYMENT |
Indicates how payments are received from a sponsor: e.g., whether fixed price, cost reimbursement, gift, or other type of payment. |
VARCHAR2 |
100 |
BEGIN_DATE |
Date when the transaction starts become effective. |
DATE |
8 |
CFDA_NUMBER |
Catalog of Federal Domestic Assistance number. The Catalog of Federal Domestic Assistance (CFDA) is a government-wide database of U.S. Federal programs, services, and activities. This database details assistance or benefits available to the American public, which includes research grants, community development programs, and scholarships. |
VARCHAR2 |
6 |
COMPETING_RENEWAL_PRPSL_DUE |
Indicates when the competitive renewal application will be due, e.g., "six months prior to to current expiration date," "30 days prior to expiration date," etc. |
VARCHAR2 |
100 |
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
DFAFS_NUMBER |
DHHS assigned document number for awards used to receive payment (not award numbers). Payments are made through the DHHS Payment Management System (PMS), administered by the Division of Federal Assistance Financing (DFAF). |
VARCHAR2 |
10 |
FAIN_ID |
XXX |
VARCHAR2 |
32 |
FINAL_EXPIRATION_DATE |
Last expiration date of the award. |
DATE |
8 |
FINAL_INVOICE_DUE |
Specifies when the final invoice on this award is due, e.g., 60 days after expiration, 6 months after expiration, etc. |
VARCHAR2 |
100 |
IDC_RATE_OFF_CAMPUS_START_DATE |
The date on which an off campus IDC rate became effective. There may be more than one rate within a fiscal year. |
DATE |
8 |
IDC_RATE_ON_CAMPUS_START_DATE |
The date on which an on campus IDC rate became effective. There may be more than one rate within a fiscal year. |
DATE |
8 |
IS_ARRA_FUNDING |
Funded by ARRA |
VARCHAR2 |
1 |
IS_ARRA_REPORTABLE |
Should be reported to the Federal Government as funded by ARRA |
VARCHAR2 |
1 |
IS_SUBJECT_TO_E_VERIFY_CLAUSE |
XXX |
VARCHAR2 |
1 |
LEAD_UNIT_ID |
XXX |
VARCHAR2 |
8 |
LEAD_UNIT_NAME |
XXX |
VARCHAR2 |
60 |
METHOD_OF_PAYMENT |
How this award is paid (Example: automatic, gift, advanced payment, cost invoice, etc.) |
VARCHAR2 |
100 |
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 |
MIT_AWARD_NUMBER |
A unique 10 digit number assigned to an award by MIT (OSP). |
VARCHAR2 |
10 |
MIT_MAJOR_INITIATIVE_CODE |
XXX |
VARCHAR2 |
120 |
MIT_MAJOR_INITIATIVE_DESC |
XXX |
VARCHAR2 |
400 |
MIT_MASTER_AWARD_NUMBER |
XXX |
VARCHAR2 |
6 |
NON_COMPETING_CONT_PRPSL_DUE |
Indicates when a non-competitive renewal application will be due, in days or months prior to the expiration date of the current segment, e.g., "60 days prior to current expiration date." |
VARCHAR2 |
100 |
NSF_CODE |
A four digit alphanumeric code defining a field of research, from a categorization table created by the National Science Foundation. Example: "B.02" stands for "Chemistry - Physical Sciences." See also NSF_CODE_DESCRIPTION. |
VARCHAR2 |
15 |
NSF_CODE_DESCRIPTION |
The broad scientific category into which a particular research project falls, based on a coding system used by the National Science Foundation. Examples: "Chemical - Engineering," "Chemistry - Physical Sciences." Each description is associated with a four digit alphanumeric code. |
VARCHAR2 |
100 |
OBLIGATED_CHANGE_AMOUNT |
The dollar amount, positive or negative, by which the obligated total amount of an award has changed. |
NUMBER |
22 |
OBLIGATION_EXPIRATION_DATE |
The end date of the current segment of an award. |
DATE |
8 |
OBLI_DISTRIBUTABLE_AMOUNT |
Total award dollars commited or spent which may be distributed across accounts. |
NUMBER |
22 |
OBLI_DISTRIBUTED_AMOUNT |
Total award dollars commited or spent which have been distributed across accounts. |
NUMBER |
22 |
OBLI_TOTAL_AMOUNT |
Total award dollars commited or spent. |
NUMBER |
22 |
ORIGINAL_CREATE_DATE |
XXX |
DATE |
7 |
PAYMENT_INVOICE_FREQUENCY |
How often invoices on this award are generated, e.g, Monthly, Quarterly, etc. |
VARCHAR2 |
100 |
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 |
60 |
PRE_AWARD_AUTHORIZED_AMOUNT |
Dollar amount, if any, authorized by a sponsor to be spent before the effective date of an award, usually also associated with a PRE_AWARD_EFFECTIVE_DATE. |
NUMBER |
22 |
PRE_AWARD_EFFECTIVE_DATE |
The earliest date against which expenses can be charge, if a sponsor allows pre-award expenses in advance of the effective date of the award. Usually associated with a PRE_AWARD_AUTHORIZED_AMOUNT. |
DATE |
8 |
PRIME_SPONSOR_KEY |
XXX |
VARCHAR2 |
10 |
PROGRAM_SOURCE_OF_FUNDS_CODE |
XXX |
VARCHAR2 |
120 |
PROGRAM_SOURCE_OF_FUNDS_DESC |
XXX |
VARCHAR2 |
400 |
PROJECT_JOIN_FLAG |
XXX |
VARCHAR2 |
1 |
PROJECT_WBS_ID |
Project work breakdown structure element identifier. |
VARCHAR2 |
7 |
PROPOSAL_NUMBER |
A unique number assigned by OSP to each proposal submitted to a sponsor. |
VARCHAR2 |
8 |
SPECIAL_EB_RATE_OFF_CAMPUS |
Employee benefit on campus rate. |
NUMBER |
22 |
SPECIAL_EB_RATE_ON_CAMPUS |
Employee benefit off campus rate. |
NUMBER |
22 |
SPEC_IDC_RATE_OFF_CAMPUS |
Indirect cost rate off campus for this award. |
NUMBER |
22 |
SPEC_IDC_RATE_OFF_CAMP_TYPE |
Type of off campus indirect cost rate. |
VARCHAR2 |
100 |
SPEC_IDC_RATE_ON_CAMPUS |
Indirect cost rate on campus for this award. |
NUMBER |
22 |
SPEC_IDC_RATE_ON_CAMP_TYPE |
Type of on campus indirect cost. |
VARCHAR2 |
100 |
SPONSOR_AWARD_NUMBER |
Award number assigned to a sponsor (May be the agreement signed date.) |
VARCHAR2 |
70 |
SPONSOR_KEY |
Key identifying an entry in the Sponsor master table. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
10 |
SUB_PLAN_FLAG |
"Y" = subplan "N" = Not a subplan |
VARCHAR2 |
1 |
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 |
50 |
UNDERRECOVERY_OF_IDC_AMOUNT |
If a sponsor does not pay the full MTDC rate in effect for the period of an award, this is the dollar amount of indirect costs (F&A) not recovered from the sponsor. |
NUMBER |
22 |
UPDATE_DATE |
Date this record was last updated by the source system. |
DATE |
8 |
UPDATE_USER |
Userid of the person who last updated this record. |
VARCHAR2 |
8 |
USE_OF_INTEREST_INCOME_CODE |
Use of Interest Income code for Interest Revenue from award custom data |
VARCHAR2 |
3 |
USE_OF_INTEREST_INCOME_DESC |
Use of Interest Income Description |
VARCHAR2 |
100 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |