OSP AWARD Table
View exposing awarded sponsored project records including award identifiers, sponsor information, funding amounts, award start and end dates, principal investigator details, project status, and award terms used for research administration and financial reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_NUMBER |
Account number associated with the record. |
VARCHAR2 |
7 |
ACCOUNT_TYPE |
Account type associated with the record. |
VARCHAR2 |
100 |
ACTIVITY_TYPE |
Activity type associated with the record. |
VARCHAR2 |
100 |
ANTICIPATED_CHANGE_AMOUNT |
Anticipated change amount associated with the record. |
NUMBER |
12,2 |
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 |
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 |
AWARD_TYPE_CODE |
Code identifying award type. |
VARCHAR2 |
12 |
BASIS_OF_PAYMENT |
Basis of payment associated with the record. |
VARCHAR2 |
100 |
BEGIN_DATE |
Date associated with begin. |
DATE |
|
CFDA_NUMBER |
Cfda number associated with the record. |
VARCHAR2 |
7 |
COMPETING_RENEWAL_PRPSL_DUE |
Competing renewal prpsl due associated with the record. |
VARCHAR2 |
100 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
DFAFS_NUMBER |
Dfafs number associated with the record. |
VARCHAR2 |
20 |
FAIN_ID |
Business identifier for the fain. |
VARCHAR2 |
32 |
FINAL_EXPIRATION_DATE |
Date associated with final expiration. |
DATE |
|
FINAL_INVOICE_DUE |
Final invoice due associated with the record. |
VARCHAR2 |
100 |
IDC_RATE_OFF_CAMPUS_START_DATE |
Date associated with idc rate off campus start. |
DATE |
|
IDC_RATE_ON_CAMPUS_START_DATE |
Date associated with idc rate on campus start. |
DATE |
|
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_SUBJECT_TO_E_VERIFY_CLAUSE |
Indicator identifying whether subject to e verify clause (Y/N). |
VARCHAR2 |
1 |
LEAD_UNIT_ID |
Business identifier for the lead unit. |
VARCHAR2 |
8 |
LEAD_UNIT_NAME |
Lead unit name associated with the record. |
VARCHAR2 |
60 |
METHOD_OF_PAYMENT |
Method of payment associated with the record. |
VARCHAR2 |
100 |
MIT_AWARD_KEY |
Surrogate key identifying the mit award. |
VARCHAR2 |
20 |
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 |
OBLIGATED_CHANGE_AMOUNT |
Obligated change amount associated with the record. |
NUMBER |
12,2 |
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 |
ORIGINAL_CREATE_DATE |
Date associated with original create. |
DATE |
|
PAYMENT_INVOICE_FREQUENCY |
Payment invoice frequency associated with the record. |
VARCHAR2 |
100 |
PI_ID |
Business identifier for the pi. |
VARCHAR2 |
9 |
PI_NAME |
Pi name associated with the record. |
VARCHAR2 |
90 |
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 |
|
PRIME_SPONSOR_KEY |
Surrogate key identifying the prime sponsor. |
VARCHAR2 |
10 |
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_JOIN_FLAG |
Indicator identifying whether project join (Y/N). |
VARCHAR2 |
1 |
PROJECT_WBS_ID |
Business identifier for the project wbs. |
VARCHAR2 |
7 |
PROPOSAL_NUMBER |
Proposal number associated with the record. |
VARCHAR2 |
8 |
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 |
SPONSOR_KEY |
Surrogate key identifying the sponsor. |
VARCHAR2 |
10 |
SUB_PLAN_FLAG |
Indicator identifying whether sub plan (Y/N). |
VARCHAR2 |
1 |
TITLE |
Title associated with the record. |
VARCHAR2 |
200 |
UNDERRECOVERY_OF_IDC_AMOUNT |
Underrecovery of idc amount associated with the record. |
NUMBER |
12,2 |
UPDATE_DATE |
Date associated with update. |
DATE |
|
UPDATE_USER |
Update user associated with the record. |
VARCHAR2 |
8 |
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 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |