PROJECT OSP Table
View exposing project records associated with OSP-related project accounting including project identifiers, sponsored project attributes, and related financial management details.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_TYPE |
Account type associated with the record. |
VARCHAR2 |
100 |
ACTIVITY_TYPE |
Activity type associated with the record. |
VARCHAR2 |
100 |
ADDRESSEE |
Addressee associated with the record. |
VARCHAR2 |
30 |
ADDRESSEE_ROOM |
Addressee room associated with the record. |
VARCHAR2 |
10 |
AGREEMENT_TYPE |
Agreement type associated with the record. |
VARCHAR2 |
2 |
AGREEMENT_TYPE_DESCRIPTION |
Description of agreement type. |
VARCHAR2 |
40 |
ANT_DISTRIBUTABLE_AMOUNT |
Ant distributable amount associated with the record. |
NUMBER |
12,2 |
ANT_DISTRIBUTED_AMOUNT |
Ant distributed amount associated with the record. |
NUMBER |
12,2 |
ANT_TOTAL_AMOUNT |
Ant total amount associated with the record. |
NUMBER |
12,2 |
APPRVD_EQUIPMENT_AMOUNT |
Apprvd equipment amount associated with the record. |
NUMBER |
12,2 |
APPRVD_FOREIGN_TRIP_AMOUNT |
Apprvd foreign trip amount associated with the record. |
NUMBER |
12,2 |
APPRVD_SUBCONTRACT_AMOUNT |
Apprvd subcontract amount associated with the record. |
NUMBER |
12,2 |
AUTHORIZED_TOTAL_AMOUNT |
Authorized total amount associated with the record. |
NUMBER |
13,2 |
AWARD_EFFECTIVE_DATE |
Date associated with award effective. |
DATE |
|
AWARD_EXECUTION_DATE |
Date associated with award execution. |
DATE |
|
AWARD_STATUS |
Award status associated with the record. |
VARCHAR2 |
100 |
AWARD_TYPE |
Award type associated with the record. |
VARCHAR2 |
100 |
BASIS_OF_PAYMENT |
Basis of payment associated with the record. |
VARCHAR2 |
100 |
BEGIN_DATE |
Date associated with begin. |
DATE |
|
BILLING_FORM |
Billing form associated with the record. |
VARCHAR2 |
100 |
BILLING_FORM_CODE |
Code identifying billing form. |
VARCHAR2 |
2 |
BILLING_TYPE |
Billing type associated with the record. |
VARCHAR2 |
30 |
CFDANO |
Cfdano associated with the record. |
VARCHAR2 |
7 |
COMPANY_CODE |
Code identifying company. |
VARCHAR2 |
4 |
COMPETING_RENEWAL_PRPSL_DUE |
Competing renewal prpsl due associated with the record. |
VARCHAR2 |
100 |
COSTING_SHEET_DESCRIPTION |
Description of costing sheet. |
VARCHAR2 |
30 |
COSTING_SHEET_PROCEDURE |
Costing sheet procedure associated with the record. |
VARCHAR2 |
6 |
COST_COLLECTOR_CATEGORY_CODE |
Code identifying cost collector category. |
VARCHAR2 |
5 |
COST_COLLECTOR_CATEGORY_DESC |
Description of cost collector category. |
VARCHAR2 |
30 |
COST_COLLECTOR_CURRENCY |
Cost collector currency associated with the record. |
VARCHAR2 |
5 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
CUSTOMER_KEY |
Surrogate key identifying the customer. |
VARCHAR2 |
11 |
EB_ADJUSTMENT |
Eb adjustment associated with the record. |
VARCHAR2 |
30 |
EB_ADJUSTMENT_KEY |
Surrogate key identifying the eb adjustment. |
VARCHAR2 |
6 |
FINAL_EXPIRATION_DATE |
Date associated with final expiration. |
DATE |
|
FINAL_INVOICE_DUE |
Final invoice due associated with the record. |
VARCHAR2 |
100 |
FINAL_INVOICE_FREQUENCY |
Final invoice frequency associated with the record. |
VARCHAR2 |
100 |
FS_CODE |
Code identifying fs. |
VARCHAR2 |
1 |
FUNDING_CLASS |
Funding class associated with the record. |
VARCHAR2 |
3 |
FUND_CENTER_ID |
Business identifier for the fund center. |
VARCHAR2 |
6 |
FUND_CENTER_KEY |
Surrogate key identifying the fund center. |
VARCHAR2 |
6 |
FUND_CENTER_NAME |
Fund center name associated with the record. |
VARCHAR2 |
40 |
FUND_ID |
Business identifier for the fund. |
VARCHAR2 |
7 |
FUND_NAME |
Fund name associated with the record. |
VARCHAR2 |
40 |
GOVERNMENT_CONTRACT_NUMBER |
Government contract number associated with the record. |
VARCHAR2 |
70 |
IS_ACCOUNT_ASSIGNMENT_ELEMENT |
Indicator identifying whether account assignment element (Y/N). |
VARCHAR2 |
1 |
IS_ARRA_FUNDING |
Indicator identifying whether arra funding (Y/N). |
VARCHAR2 |
1 |
IS_ARRA_REPORTABLE |
Indicator identifying whether arra reportable (Y/N). |
VARCHAR2 |
1 |
IS_BILLING_ELEMENT |
Indicator identifying whether billing element (Y/N). |
VARCHAR2 |
1 |
IS_CLOSED_PROJECT_WBS |
Indicator identifying whether closed project wbs (Y/N). |
VARCHAR2 |
1 |
IS_PLANNING_ELEMENT |
Indicator identifying whether planning element (Y/N). |
VARCHAR2 |
1 |
IS_SUBJECT_TO_E_VERIFY_CLAUSE |
Indicator identifying whether subject to e verify clause (Y/N). |
VARCHAR2 |
1 |
LAB_ALLOCATION |
Lab allocation associated with the record. |
VARCHAR2 |
30 |
LAB_ALLOCATION_KEY |
Surrogate key identifying the lab allocation. |
VARCHAR2 |
6 |
LEAD_UNIT_ID |
Business identifier for the lead unit. |
VARCHAR2 |
8 |
LEAD_UNIT_NAME |
Lead unit name associated with the record. |
VARCHAR2 |
60 |
MASTER_PROJECT_NAME |
Master project name associated with the record. |
VARCHAR2 |
40 |
MASTER_PROJECT_NUMBER |
Master project number associated with the record. |
VARCHAR2 |
7 |
METHOD_OF_PAYMENT |
Method of payment associated with the record. |
VARCHAR2 |
100 |
MIT_AWARD_NUMBER |
Mit award number associated with the record. |
VARCHAR2 |
20 |
MIT_MAJOR_INITIATIVE_CODE |
Code identifying mit major initiative. |
VARCHAR2 |
30 |
MIT_MAJOR_INITIATIVE_DESC |
Description of mit major initiative. |
VARCHAR2 |
100 |
MIT_MASTER_AWARD_NUMBER |
Mit master award number associated with the record. |
VARCHAR2 |
6 |
NON_COMPETING_CONT_PRPSL_DUE |
Non competing cont prpsl due associated with the record. |
VARCHAR2 |
100 |
NSF_CODE |
Code identifying nsf. |
VARCHAR2 |
15 |
NSF_CODE_DESCRIPTION |
Description of nsf code. |
VARCHAR2 |
100 |
OBLIGATION_EXPIRATION_DATE |
Date associated with obligation expiration. |
DATE |
|
OBLI_DISTRIBUTABLE_AMOUNT |
Obli distributable amount associated with the record. |
NUMBER |
12,2 |
OBLI_DISTRIBUTED_AMOUNT |
Obli distributed amount associated with the record. |
NUMBER |
12,2 |
OBLI_TOTAL_AMOUNT |
Obli total amount associated with the record. |
NUMBER |
12,2 |
OH_ADJUSTMENT |
Oh adjustment associated with the record. |
VARCHAR2 |
30 |
OH_ADJUSTMENT_KEY |
Surrogate key identifying the oh adjustment. |
VARCHAR2 |
6 |
ORGANIZATION_ID |
Business identifier for the organization. |
VARCHAR2 |
6 |
ORGANIZATION_NAME |
Organization name associated with the record. |
VARCHAR2 |
40 |
OSP_CFDA_NUMBER |
Osp cfda number associated with the record. |
VARCHAR2 |
7 |
OSP_DFAFS_NUMBER |
Osp dfafs number associated with the record. |
VARCHAR2 |
20 |
OSP_PRIME_SPONSOR_CODE |
Code identifying osp prime sponsor. |
VARCHAR2 |
6 |
OSP_PRIME_SPONSOR_NAME |
Osp prime sponsor name associated with the record. |
VARCHAR2 |
60 |
OSP_SPONSOR_CODE |
Code identifying osp sponsor. |
VARCHAR2 |
6 |
OSP_SPONSOR_NAME |
Osp sponsor name associated with the record. |
VARCHAR2 |
200 |
OSP_UPDATE_DATE |
Date associated with osp update. |
DATE |
|
OSP_UPDATE_USER |
Osp update user associated with the record. |
VARCHAR2 |
8 |
OSP_WAREHOUSE_LOAD_DATE |
Date associated with osp warehouse load. |
DATE |
|
OVERRUN_FLAG |
Indicator identifying whether overrun (Y/N). |
VARCHAR2 |
1 |
OVERRUN_WITH_COMMIT_FLAG |
Indicator identifying whether overrun with commit (Y/N). |
VARCHAR2 |
1 |
PI_ID |
Business identifier for the pi. |
VARCHAR2 |
9 |
PI_NAME |
Pi name associated with the record. |
VARCHAR2 |
90 |
POOL_CODE |
Code identifying pool. |
VARCHAR2 |
1 |
POOL_UNIT |
Pool unit associated with the record. |
NUMBER |
10,4 |
PRE_AWARD_AUTHORIZED_AMOUNT |
Pre award authorized amount associated with the record. |
NUMBER |
12,2 |
PRE_AWARD_EFFECTIVE_DATE |
Date associated with pre award effective. |
DATE |
|
PROFIT_CENTER_ID |
Business identifier for the profit center. |
VARCHAR2 |
7 |
PROFIT_CENTER_KEY |
Surrogate key identifying the profit center. |
VARCHAR2 |
11 |
PROFIT_CENTER_NAME |
Profit center name associated with the record. |
VARCHAR2 |
40 |
PROGRAM_SOURCE_OF_FUNDS_CODE |
Code identifying program source of funds. |
VARCHAR2 |
30 |
PROGRAM_SOURCE_OF_FUNDS_DESC |
Description of program source of funds. |
VARCHAR2 |
100 |
PROJECT_PROFILE_CODE |
Code identifying project profile. |
VARCHAR2 |
7 |
PROJECT_PROFILE_DESC |
Description of project profile. |
VARCHAR2 |
40 |
PROJECT_WAREHOUSE_LOAD_DATE |
Date associated with project warehouse load. |
DATE |
|
PROJECT_WBS_COUNTER |
Project wbs counter associated with the record. |
NUMBER |
|
PROJECT_WBS_CREATE_DATE |
Date associated with project wbs create. |
DATE |
|
PROJECT_WBS_CREATE_USER_ID |
Business identifier for the project wbs create user. |
VARCHAR2 |
12 |
PROJECT_WBS_EFFECTIVE_DATE |
Date associated with project wbs effective. |
DATE |
|
PROJECT_WBS_EXPIRATION_DATE |
Date associated with project wbs expiration. |
DATE |
|
PROJECT_WBS_ID |
Business identifier for the project wbs. |
VARCHAR2 |
7 |
PROJECT_WBS_NAME |
Project wbs name associated with the record. |
VARCHAR2 |
40 |
PROPOSAL_NUMBER |
Proposal number associated with the record. |
VARCHAR2 |
8 |
SAP_DFAFS |
Sap dfafs associated with the record. |
VARCHAR2 |
20 |
SAP_PRIME_ADMIN_ACTIVITY |
Sap prime admin activity associated with the record. |
VARCHAR2 |
30 |
SAP_PRIME_SPONSOR_CODE |
Code identifying sap prime sponsor. |
VARCHAR2 |
6 |
SAP_PRIME_SPONSOR_COUNTRY |
Sap prime sponsor country associated with the record. |
VARCHAR2 |
40 |
SAP_PRIME_SPONSOR_NAME |
Sap prime sponsor name associated with the record. |
VARCHAR2 |
200 |
SAP_PRIME_SPONSOR_STATE |
Sap prime sponsor state associated with the record. |
VARCHAR2 |
30 |
SAP_PRIME_SPONSOR_TYPE |
Sap prime sponsor type associated with the record. |
VARCHAR2 |
40 |
SAP_SPONSOR_ADMIN_ACTIVITY |
Sap sponsor admin activity associated with the record. |
VARCHAR2 |
30 |
SAP_SPONSOR_CODE |
Code identifying sap sponsor. |
VARCHAR2 |
6 |
SAP_SPONSOR_COUNTRY |
Sap sponsor country associated with the record. |
VARCHAR2 |
40 |
SAP_SPONSOR_NAME |
Sap sponsor name associated with the record. |
VARCHAR2 |
200 |
SAP_SPONSOR_STATE |
Sap sponsor state associated with the record. |
VARCHAR2 |
30 |
SAP_SPONSOR_TYPE |
Sap sponsor type associated with the record. |
VARCHAR2 |
40 |
SECTION_CODE |
Code identifying section. |
VARCHAR2 |
3 |
SPECIAL_EB_RATE_OFF_CAMPUS |
Special eb rate off campus associated with the record. |
NUMBER |
5,2 |
SPECIAL_EB_RATE_ON_CAMPUS |
Special eb rate on campus associated with the record. |
NUMBER |
5,2 |
SPEC_IDC_RATE_OFF_CAMPUS |
Spec idc rate off campus associated with the record. |
NUMBER |
5,2 |
SPEC_IDC_RATE_OFF_CAMP_TYPE |
Spec idc rate off camp type associated with the record. |
VARCHAR2 |
100 |
SPEC_IDC_RATE_ON_CAMPUS |
Spec idc rate on campus associated with the record. |
NUMBER |
5,2 |
SPEC_IDC_RATE_ON_CAMP_TYPE |
Spec idc rate on camp type associated with the record. |
VARCHAR2 |
100 |
SPONSOR_AWARD_NUMBER |
Sponsor award number associated with the record. |
VARCHAR2 |
70 |
SUB_PLAN |
Sub plan associated with the record. |
VARCHAR2 |
1 |
SUB_PLAN_FLAG |
Indicator identifying whether sub plan (Y/N). |
VARCHAR2 |
1 |
SUPERVISOR |
Supervisor associated with the record. |
VARCHAR2 |
30 |
SUPERVISOR_MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
SUPERVISOR_ROOM |
Supervisor room associated with the record. |
VARCHAR2 |
10 |
TERM_CODE |
Term code associated with the record. |
VARCHAR2 |
1 |
TITLE |
Title associated with the record. |
VARCHAR2 |
200 |
TREASURER_REPORT |
Treasurer report associated with the record. |
VARCHAR2 |
3 |
UNDERRECOVERY_OF_IDC |
Underrecovery of idc associated with the record. |
NUMBER |
12,2 |
USE_OF_INTEREST_INCOME_CODE |
Code identifying use of interest income. |
VARCHAR2 |
30 |
USE_OF_INTEREST_INCOME_DESC |
Description of use of interest income. |
VARCHAR2 |
100 |
WBS_ELEMENT_PARENT_ID |
Business identifier for the wbs element parent. |
VARCHAR2 |
7 |
WBS_TYPE |
Wbs type associated with the record. |
VARCHAR2 |
1 |