OSP AWARD Table
View exposing osp award data.
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 |