PROJECT OSP Table
Contains both Project information from SAP and additional information from COEUS
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
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 |
ADDRESSEE |
The last and first name of the addressee: normally, the Administrative Officer, Financial Officer, or other departmental administrator responsible for monitoring expenses. |
VARCHAR2 |
30 |
ADDRESSEE_ROOM |
The MIT address, building and room number, of the addressee. |
VARCHAR2 |
10 |
AGREEMENT_TYPE |
A two digit code for the type of Sponsored Research agreement, e.g. 01 for Grant, 02 for Contract, etc. |
VARCHAR2 |
2 |
AGREEMENT_TYPE_DESCRIPTION |
The Sponsored Research Agreement Type, e.g., Grant, Contract, Fellowship, Fixed Price Agreement, etc. |
VARCHAR2 |
40 |
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 |
AUTHORIZED_TOTAL_AMOUNT |
The amount authorized to be expended for a cost collector, usually by a WBS project sponsor. |
NUMBER |
9 |
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 |
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 |
BILLING_FORM |
XXX |
VARCHAR2 |
100 |
BILLING_FORM_CODE |
XXX |
VARCHAR2 |
2 |
BILLING_TYPE |
Type of billing associated with this project: (Examples: cost reimbursement, letter of credit, scheduled billing, cash advance, internal, etc.) |
VARCHAR2 |
30 |
CFDANO |
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 |
7 |
COMPANY_CODE |
Shows to which "company" in SAP a cost collector is attached. MIT uses separate "companies" in SAP to differentiate financial transactions for different legal entities with differing business rules or reporting requirements. There are currently three company codes, "CUR" for main campus, "TECR" for MIT's alumni magazine, Technology Review, and "LCP1" for Lincoln Laboratory. |
VARCHAR2 |
4 |
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 |
COSTING_SHEET_DESCRIPTION |
Description of the Costing Sheet associated with this Cost Collector. In SAP, the costing sheet is the mechanism used to calculate and post secondary costs such as allocations, employee benefts, and facilities and administration charges to cost collectors. |
VARCHAR2 |
30 |
COSTING_SHEET_PROCEDURE |
Code designating the Costing Sheet associated with this Cost Collector. |
VARCHAR2 |
6 |
COST_COLLECTOR_CATEGORY_CODE |
Code identifying the categories of Cost Collectors: AUXIL (auxiliary), FNDNS (fund-nonsponsored), FNDSP (fund-sponsored), GENER (general), OTHER (other), RSRCH (research). See also COST_COLLECTOR_CATEGORY-DESC. |
VARCHAR2 |
5 |
COST_COLLECTOR_CATEGORY_DESC |
Description identifying the categories of Cost Collectors: Auxiliary, Fund -- Not Sponsored, Fund -- Sponsored, General, Other, Research. AUXILIARY cost centers are used by auxiliary enterprises (MIT Press, Housing & Dining, etc.) which are budgeted centrally but required to break even. FUNDS--NOT SPONSORED: those with non-sponsored revenue sources and contain MIT's endowments, loan funds, discretionary funds, and other accumulated net assets. All are internal orders. FUNDS--SPONSORED: have an external sponsor as the revenue source. Sponsored activity in the Fund range is non-organized research. All are WBS elements. GENERAL : All MIT Operating Cost Centers (cost objects budgeted centrally) except the Auxiliary cost centers defined above. RESEARCH: All of MIT's sponsored research activity is in this category. Revenue is assumed to be equal to expenses. All are WBS elements. OTHER: Internal Orders and WBS elements that hold activity that should not be part of MIT's revenues and expenses. This includes activity which will be distributed to General, Funds, and Research in the future using allocations, depreciation, or billings for services rendered, and activity being administered by MIT on behalf of others. |
VARCHAR2 |
30 |
COST_COLLECTOR_CURRENCY |
XXX |
VARCHAR2 |
5 |
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 |
CUSTOMER_KEY |
This key is to be used to join the FINANCIAL_DETAIL and the PROJECT or PROJECT_OSP tables. This field should only be used for linking tables together, NOT for reporting. |
VARCHAR2 |
11 |
EB_ADJUSTMENT |
Description associated with EB Adjustment Key. |
VARCHAR2 |
30 |
EB_ADJUSTMENT_KEY |
IN SAP keys are used to specify particular EB, F&A, or Allocation rates to be associated with a Cost Collector. When a key is blank, MIT's standard EB or F&A rates apply, and there is no allocation. If the key is filled out, the special rates noted in the key description apply. |
VARCHAR2 |
6 |
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 |
FINAL_INVOICE_FREQUENCY |
Specifies the frequency of final invoices, e.g., monthly, quarterly, annually, etc. |
VARCHAR2 |
100 |
FS_CODE |
Used to identify the restriction category for MIT's fund cost collectors. U is unrestricted, T is temporarily restricted, and P is permanently restricted. These categories are used in the preparation of MIT's annual financial statements, included in the Treasurer's Report. |
VARCHAR2 |
1 |
FUNDING_CLASS |
For OSP accounts (20000-49999), fund class 616 is used. For fund accounts (20000-49999), 644 is used for fellowship accounts; otherwise 616 is usually used. |
VARCHAR2 |
3 |
FUND_CENTER_ID |
Six-digit number identifying the fund center (example: 100088 Music, 100152 Division of Toxicology). |
VARCHAR2 |
6 |
FUND_CENTER_KEY |
Key used only for joining the FINANCIAL_DETAIL table with other tables, NOT for reporting. |
VARCHAR2 |
16 |
FUND_CENTER_NAME |
Name of the Fund Center/source of revenue. |
VARCHAR2 |
40 |
FUND_ID |
Identification number associated with the Fund (Example: 6779500) |
VARCHAR2 |
7 |
FUND_NAME |
* In the FINANCIAL tables: this represents the name of the fund/source of revenue (Example: Publications). * In STUDENT FINANCIAL AID: this is the descriptive title of a financial aid fund/award. Exampes: "Federal Perkins Loan" for PERKNL. |
VARCHAR2 |
40 |
GOVERNMENT_CONTRACT_NUMBER |
The sponsor- assigned identification number for a federal reserach project. This field is also used for non-federal sponsors. |
VARCHAR2 |
24 |
IS_ACCOUNT_ASSIGNMENT_ELEMENT |
Flag identifying whether or not this is an account assignment element (Values: Y or N). |
VARCHAR2 |
1 |
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_BILLING_ELEMENT |
Y= this is a billing element. |
VARCHAR2 |
1 |
IS_CLOSED_PROJECT_WBS |
Y= this PROJECT_WBS is closed. N= this PROJECT_WBS is open. |
VARCHAR2 |
1 |
IS_PLANNING_ELEMENT |
Y= this is a planning element. |
VARCHAR2 |
1 |
IS_SUBJECT_TO_E_VERIFY_CLAUSE |
XXX |
VARCHAR2 |
1 |
LAB_ALLOCATION |
Description associated with Lab Allocation Key. |
VARCHAR2 |
30 |
LAB_ALLOCATION_KEY |
Code associated with a Cost Collector which points to an allocation rate which will be applied to this Cost Collector. |
VARCHAR2 |
6 |
LEAD_UNIT_ID |
XXX |
VARCHAR2 |
8 |
LEAD_UNIT_NAME |
XXX |
VARCHAR2 |
60 |
MASTER_PROJECT_NAME |
Name (Project Title) of the top level (level 1) WBS Id in a WBS Hierarchy structure. Select this field if a roll-up of the activity on an entire WBS Hierarchy is desired. Colloquially known as the Parent in a Parent-Child hierarchy. |
VARCHAR2 |
40 |
MASTER_PROJECT_NUMBER |
WBS Id of the top level WBS Id (level 1) in a WBS Hierarchy structure. Select this field if a roll-up of the activity on an entire WBS Hierarchy is desired. Colloquially known as the Parent in a Parent-Child hierarchy. |
VARCHAR2 |
2 |
METHOD_OF_PAYMENT |
How this award is paid (Example: automatic, gift, advanced payment, cost invoice, etc.) |
VARCHAR2 |
100 |
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 |
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 |
OH_ADJUSTMENT |
Description associated with OH Adjustment Key. |
VARCHAR2 |
30 |
OH_ADJUSTMENT_KEY |
Code associated with a Cost Collector which points to an overhead rate which will be applied to this Cost Collector. |
VARCHAR2 |
6 |
ORGANIZATION_ID |
The department, for example, Accounting. |
VARCHAR2 |
6 |
ORGANIZATION_NAME |
The name of the MIT Department or Unit to which the project is assigned, usually the home unit or the Principal Investigator or Co-Investigator. |
VARCHAR2 |
40 |
OSP_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 |
OSP_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 |
OSP_PRIME_SPONSOR_CODE |
A code number identifying the Primary sponsor, assigned by OSP. |
VARCHAR2 |
5 |
OSP_PRIME_SPONSOR_NAME |
The name of the Prime Sponsor funding the research project, as recorded by OSP. Example: An MIT investigator has a project that is part of a larger parent project funded by a federal agency at another institution. S/he might receive a subcontract from that institution: In this case, the other institution would be listed as the Sponsor, and the federal agency would be listed as the Prime Sponsor. This field is left blank if there is no "sponsor hierarchy." |
VARCHAR2 |
60 |
OSP_SPONSOR_CODE |
Sponsor code assigned by OSP. |
VARCHAR2 |
5 |
OSP_SPONSOR_NAME |
The name of the Sponsor funding the project, as recorded by OSP. |
VARCHAR2 |
60 |
OSP_UPDATE_DATE |
Date the record was last updated by OSP. |
DATE |
8 |
OSP_UPDATE_USER |
Person within OSP who updated this project last. |
VARCHAR2 |
8 |
OSP_WAREHOUSE_LOAD_DATE |
Date data was last loaded from OSP into the Data Warehouse. |
DATE |
8 |
OVERRUN_FLAG |
Flag indicating whether cost collector is overrun. Values: Y and N. |
VARCHAR2 |
1 |
OVERRUN_WITH_COMMIT_FLAG |
Flag indicating whether cost collector is overrun by examining expenditures plus commitments. (It is possible for cost collectors to have a flag set for N for the Overrun_Flag but Y for Overrun_with_Commit_Flag.) Values: Y and N. |
VARCHAR2 |
1 |
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 |
POOL_CODE |
Indicates which investment pool the funds should placed in. |
VARCHAR2 |
1 |
POOL_UNIT |
The number of pool units; supplied by the Treasurer's Office. |
VARCHAR2 |
10 |
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 |
PROFIT_CENTER_ID |
A unique key that identifies the profit center. |
VARCHAR2 |
7 |
PROFIT_CENTER_KEY |
Key used to join the Profit Center 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 |
11 |
PROFIT_CENTER_NAME |
The text name of the profit center. |
VARCHAR2 |
40 |
PROGRAM_SOURCE_OF_FUNDS_CODE |
XXX |
VARCHAR2 |
120 |
PROGRAM_SOURCE_OF_FUNDS_DESC |
XXX |
VARCHAR2 |
400 |
PROJECT_PROFILE_CODE |
XXX |
VARCHAR2 |
7 |
PROJECT_PROFILE_DESC |
XXX |
VARCHAR2 |
40 |
PROJECT_WAREHOUSE_LOAD_DATE |
Date the project was loaded into the data warehouse. |
DATE |
8 |
PROJECT_WBS_COUNTER |
Used to count records withing a group on a report. Always contains a value of 1. |
NUMBER |
1 |
PROJECT_WBS_CREATE_DATE |
The date the sales document was created. |
DATE |
8 |
PROJECT_WBS_CREATE_USER_ID |
The name of the user who created the sales document. |
VARCHAR2 |
12 |
PROJECT_WBS_EFFECTIVE_DATE |
Begin date of the work breakdown structure for this project. |
DATE |
8 |
PROJECT_WBS_EXPIRATION_DATE |
End date of the work breakdown structure for this project. |
DATE |
8 |
PROJECT_WBS_ID |
Project work breakdown structure element identifier. |
VARCHAR2 |
7 |
PROJECT_WBS_NAME |
Work breakdown structure name. |
VARCHAR2 |
40 |
PROPOSAL_NUMBER |
A unique number assigned by OSP to each proposal submitted to a sponsor. |
VARCHAR2 |
8 |
SAP_DFAFS |
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 |
13 |
SAP_PRIME_ADMIN_ACTIVITY |
Associated with Federal Sponsors. Identifies what branch. |
VARCHAR2 |
30 |
SAP_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 |
SAP_PRIME_SPONSOR_COUNTRY |
Country of the primary sponsor. |
VARCHAR2 |
40 |
SAP_PRIME_SPONSOR_NAME |
Name of the primary sponsor. |
VARCHAR2 |
60 |
SAP_PRIME_SPONSOR_STATE |
State of the primary sponsor. |
VARCHAR2 |
30 |
SAP_PRIME_SPONSOR_TYPE |
The type of sponsor (Example: Federal, Private - Pofit, Private - Non-Profit, State, etc..) |
VARCHAR2 |
40 |
SAP_SPONSOR_ADMIN_ACTIVITY |
Associated with Federal Sponsors. Identifies the branch of the Federal Government funding the project (e.g., Navy, National Science Foundation, National Institutes of Health, etc.). This field is not currently populated for non-federal sponsors. |
VARCHAR2 |
30 |
SAP_SPONSOR_CODE |
Sponsor code generated and assigned by OSP. OSP accounts are coded. Fund accounts are coded if funds are provided by a sponsor who places restrictions in the award that make accounting and reporting system controls desirable. Contracts or grants from federal government and other sponsors requiring accounting and/or work progress reports are coded. |
VARCHAR2 |
6 |
SAP_SPONSOR_COUNTRY |
Country of the sponsor. |
VARCHAR2 |
40 |
SAP_SPONSOR_NAME |
Name of the sponsor. |
VARCHAR2 |
60 |
SAP_SPONSOR_STATE |
State of the sponsor. |
VARCHAR2 |
30 |
SAP_SPONSOR_TYPE |
The type of sponsor (Example: Federal, Private - Pofit, Private - Non-Profit, State, etc..) |
VARCHAR2 |
40 |
SECTION_CODE |
A code which classifies cost collectors into sections for financial statement reporting purposes |
VARCHAR2 |
3 |
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 |
SUB_PLAN |
"Y" = subplan "N" = Not a subplan |
VARCHAR2 |
1 |
SUB_PLAN_FLAG |
"Y" = subplan "N" = Not a subplan |
VARCHAR2 |
1 |
SUPERVISOR |
The name of the person responsible for this project, cost center, internal order, or cost center. |
VARCHAR2 |
30 |
SUPERVISOR_MIT_ID |
The 9 digit MIT identification number of the person responsible for this project, cost center, internal order, or cost center. |
VARCHAR2 |
9 |
SUPERVISOR_ROOM |
The building and room number assigned to the person responsible for this project, center, internal order, or cost center. |
VARCHAR2 |
10 |
TERM_CODE |
** For FINANCIAL DATA: the Term Code identifies the status of the cost collector. Blank - open for charges between start and end dates. Term Code = 1 - Closed. Pre-end date charges allowed. Term Code = 2 - No longer in use. Term Code = 3 - Terminated. Charges not allowed. ** For STUDENT DATA: the Term Code identifies one of the terms in an academic year; for example: 1999FA==>Fall Term of the 1998-99 academic year, and 1999SP==>Spring Term of the 1998-99 academic year. |
VARCHAR2 |
6 |
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 |
TREASURER_REPORT |
Not in use in SAP. |
VARCHAR2 |
3 |
UNDERRECOVERY_OF_IDC |
Amount of indirect cost recovery rate not recovered. |
NUMBER |
22 |
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 |
WBS_ELEMENT_PARENT_ID |
The Cost Collector ID of the "parent" of this Cost Collector. Normally found in WBS Elements, it is usually the next level up in the WBS Hierarchy Structure. |
VARCHAR2 |
7 |
WBS_TYPE |
XXX |
VARCHAR2 |
1 |