Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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

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

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