| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: GM_PROPOSAL.BUSINESS_UNIT
Prompt Table:
SP_BU_CA_NONVW
|
| 2 |
PROPOSAL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Proposal ID
Default Value: GM_PROPOSAL.PROPOSAL_ID
Prompt Table:
GM_PROP_ID_VW
|
| 3 |
VERSION_ID |
Character(7) |
VARCHAR2(7) NOT NULL |
Version ID
Default Value: GM_PROPOSAL.VERSION_ID
Prompt Table:
GM_PROPOSAL
|
| 4 |
IS_SUB_TO_OTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Submit to Other Agency
Y/N Table Edit
Default Value: N
|
| 5 |
OTHER_AGENCY |
Character(20) |
VARCHAR2(20) NOT NULL |
Other Agency name
|
| 6 |
IS_PROPRIE_INC |
Character(1) |
VARCHAR2(1) NOT NULL |
Proprietary/Privileged
Y/N Table Edit
Default Value: N
|
| 7 |
RRCOVERPAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
R&R Cover Page Form
Y/N Table Edit
Default Value: N
|
| 8 |
SUPPLEINFO |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplemental Information Form
Y/N Table Edit
Default Value: N
|
| 9 |
RRSENKEY |
Character(1) |
VARCHAR2(1) NOT NULL |
R&R Senior Key Person Form
Y/N Table Edit
Default Value: N
|
| 10 |
BIOSKETCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Biographical Sketch File
Y/N Table Edit
Default Value: N
|
| 11 |
SUPPORTFILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Current & Pending Support File
Y/N Table Edit
Default Value: N
|
| 12 |
ADDSENKEY |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional Senior Key Person
Y/N Table Edit
Default Value: N
|
| 13 |
ADDBIO |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional Bio. Sketches
Y/N Table Edit
Default Value: N
|
| 14 |
ADDSUPPOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional Current &Pend Sup
Y/N Table Edit
Default Value: N
|
| 15 |
OTHPRJINFO |
Character(1) |
VARCHAR2(1) NOT NULL |
RR Other Project Inform File
Y/N Table Edit
Default Value: N
|
| 16 |
PRJ_SUM_ABS |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Summary Abstract File
Y/N Table Edit
Default Value: N
|
| 17 |
PRJNAFL |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Narrative File
Y/N Table Edit
Default Value: N
|
| 18 |
BIO_REFERE |
Character(1) |
VARCHAR2(1) NOT NULL |
Bibliography References File
Y/N Table Edit
Default Value: N
|
| 19 |
OTH_ATTCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Other Attachments
Y/N Table Edit
Default Value: N
|
| 20 |
BUDGET_FORM |
Character(1) |
VARCHAR2(1) NOT NULL |
R&R Budget Form
Y/N Table Edit
Default Value: N
|
| 21 |
BUDGET_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Year 1
Y/N Table Edit
Default Value: N
|
| 22 |
BUDGET_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Year 2
Y/N Table Edit
Default Value: N
|
| 23 |
BUDGET_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Year 3
Y/N Table Edit
Default Value: N
|
| 24 |
BUDGET_4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Year 4
Y/N Table Edit
Default Value: N
|
| 25 |
BUDGET_5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Year 5
Y/N Table Edit
Default Value: N
|
| 26 |
ADD_KEY_ATT |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional Senior Key Persons
Y/N Table Edit
Default Value: N
|
| 27 |
ADD_EQU_ATT |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional Equipment Attach
Y/N Table Edit
Default Value: N
|
| 28 |
BUD_JUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Justification Form
Y/N Table Edit
Default Value: N
|
| 29 |
PERS_FORM |
Character(1) |
VARCHAR2(1) NOT NULL |
Personal Data Form
Y/N Table Edit
Default Value: N
|
| 30 |
REV_PRJ_OBJ |
Character(1) |
VARCHAR2(1) NOT NULL |
Revised Project Objectives
Y/N Table Edit
Default Value: N
|
| 31 |
APP_CERT |
Character(1) |
VARCHAR2(1) NOT NULL |
Applicant Certifies
Y/N Table Edit
Default Value: N
|
| 32 |
NRI_PROP_TYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
NRI Proposal Type
|
| 33 |
RES_PRP_PRJ_GRP |
Character(50) |
VARCHAR2(50) NOT NULL |
Project Proposal Group
|
| 34 |
POST_DOC_FEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Post doctoral Fellowship
Y/N Table Edit
Default Value: N
|
| 35 |
NEW_INV |
Character(1) |
VARCHAR2(1) NOT NULL |
New Investigator
Y/N Table Edit
Default Value: N
|
| 36 |
STR_TH |
Character(1) |
VARCHAR2(1) NOT NULL |
Strengthening
Y/N Table Edit
Default Value: N
|
| 37 |
STR_TH_GRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Strengthening Group
C=Career Enhancement
E=Equipment
G=Seed Grant
S=Standard Strengthening
|
| 38 |
PROG_NAME |
Character(60) |
VARCHAR2(60) NOT NULL |
*Program Name
|
| 39 |
PROG_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code
|
| 40 |
FED_ACT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
*Federal Action Type
A=CoopAgree
C=Contract
G=Grant
I=LoanInsurance
L=Loan
O=LoanGuarantee
Default Value: G
|
| 41 |
FED_ACT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
*Status of Federal Action
B=BidOffer
I=InitialAward
P=PostAward
Default Value: I
|
| 42 |
REP_TYPE_LNG |
Character(4) |
VARCHAR2(4) NOT NULL |
*Report Type
INIT=InitialFiling
MATC=MaterialChange
Default Value: INIT
|
| 43 |
REP_TYPES |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Type
C=MaterialChange
I=InitialFiling
Default Value: I
|
| 44 |
CHANGE_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Year
|
| 45 |
CHANGE_QT |
Number(1,0) |
SMALLINT NOT NULL |
Quarter
|
| 46 |
LAST_REPORT |
Date(10) |
DATE |
Last Report
|
| 47 |
CHECKSIGNDATE1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Sign Date SF424
Y/N Table Edit
Default Value: N
|
| 48 |
CHECKSIGNDATE2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Sign Date PHS5161-1
Y/N Table Edit
Default Value: N
|
| 49 |
CHECKSIGNDATE3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Sign Date SF424BD
Y/N Table Edit
Default Value: N
|
| 50 |
CIVILRIGHTASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Civil Right Assurance
Y/N Table Edit
Default Value: N
|
| 51 |
CIVIL_ASS_DT |
Date(10) |
DATE |
Civil Right Assurance Sign
|
| 52 |
HANDI_ASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Handicapped Assurance
Y/N Table Edit
Default Value: N
|
| 53 |
HANDI_ASS_DT |
Date(10) |
DATE |
Handicapped Assurance Sign
|
| 54 |
AGE_ASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Age Assurance
Y/N Table Edit
Default Value: N
|
| 55 |
AGE_ASS_DT |
Date(10) |
DATE |
Age Assurance Sign Date
|
| 56 |
HUM_SUB_CERT |
Character(1) |
VARCHAR2(1) NOT NULL |
Human Subject Certification
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 57 |
PHS_IMPACT |
Character(1) |
VARCHAR2(1) NOT NULL |
PHS Impact Statement
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 58 |
INTER_GOV_REV |
Character(1) |
VARCHAR2(1) NOT NULL |
Intergrovern mental Review
Y/N Table Edit
Default Value: N
|
| 59 |
PROJ_IDENTIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Identify
Y/N Table Edit
Default Value: N
|
| 60 |
BIO_SKETCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Biographical Sketch
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 61 |
SF424AC |
Character(1) |
VARCHAR2(1) NOT NULL |
SF424AC
Y/N Table Edit
Default Value: N
|
| 62 |
MONTH_12_DTL |
Character(1) |
VARCHAR2(1) NOT NULL |
12 Month Detailed Budget
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 63 |
PROJ_DTL |
Character(1) |
VARCHAR2(1) NOT NULL |
Has Detail Project Budget
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 64 |
ONLY_ADD_FIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Address Only Additional Funds
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 65 |
PROGRESS_REP |
Character(1) |
VARCHAR2(1) NOT NULL |
Progress Report
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 66 |
SEX_ASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Sex Assurance
Y/N Table Edit
Default Value: N
|
| 67 |
SEX_ASS_DT |
Date(10) |
DATE |
Sex Assurance Sign Date
|
| 68 |
IRSL_LIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Reference IRS List
Y/N Table Edit
Default Value: N
|
| 69 |
IRS_CERT |
Character(1) |
VARCHAR2(1) NOT NULL |
IRS Certification
Y/N Table Edit
Default Value: N
|
| 70 |
STATE_CERT |
Character(1) |
VARCHAR2(1) NOT NULL |
State Tax Certification
Y/N Table Edit
Default Value: N
|
| 71 |
INCOR_CERT |
Character(1) |
VARCHAR2(1) NOT NULL |
Incorporation Certification
Y/N Table Edit
Default Value: N
|
| 72 |
PARENT_CERT |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent Org.Certification
Y/N Table Edit
Default Value: N
|
| 73 |
PRE_AGE_NAME |
Character(60) |
VARCHAR2(60) NOT NULL |
Previsouly Filed with
|
| 74 |
PRE_FILED_DT |
Date(10) |
DATE |
Filed Date
|
| 75 |
COVER_SHET_RR |
Character(1) |
VARCHAR2(1) NOT NULL |
SF 424 (R&R) Cover Sheet
Y/N Table Edit
Default Value: N
|
| 76 |
CHECK_RENEWA |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Renewal
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 77 |
CHECK_FULLAPP |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Full App
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 78 |
CHECK_TYPEAPP |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Type App
Y/N Table Edit
Default Value: N
|
| 79 |
CHECK_APPCERT |
Character(1) |
VARCHAR2(1) NOT NULL |
Check App Cert
Y/N Table Edit
Default Value: N
|
| 80 |
CHECK_RRSITE |
Character(1) |
VARCHAR2(1) NOT NULL |
Check RR Site
Y/N Table Edit
Default Value: N
|
| 81 |
CHECK_RROTHER |
Character(1) |
VARCHAR2(1) NOT NULL |
Check RR Other Info
Y/N Table Edit
Default Value: N
|
| 82 |
CHECK_PROJ_SUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Project Summary
Y/N Table Edit
Default Value: N
|
| 83 |
CHECK_PROJ_NAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Project Narrative
Y/N Table Edit
Default Value: N
|
| 84 |
CHECK_MERIT_REW |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Merit Review
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 85 |
CHECK_PRIOR_SUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Prior Support
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 86 |
CHECK_HR_INFO |
Character(1) |
VARCHAR2(1) NOT NULL |
Check HR Info
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 87 |
CHECK_URL |
Character(1) |
VARCHAR2(1) NOT NULL |
Check URL
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 88 |
CHECK_BIB |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Biblio
Y/N Table Edit
Default Value: N
|
| 89 |
CHECK_FACILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Facilities
Y/N Table Edit
Default Value: N
|
| 90 |
CHECK_EQU |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Equipment
Y/N Table Edit
Default Value: N
|
| 91 |
CHECK_SUP_DOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Supp Doc
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 92 |
CHECK_ADD_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Additional Items
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 93 |
CHECK_RR_PROF |
Character(1) |
VARCHAR2(1) NOT NULL |
Check RR Sr.Profile
Y/N Table Edit
Default Value: N
|
| 94 |
CHECK_BIO_SKECH |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Bio Sketch
A=Not Applicable
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 95 |
CHECK_CUR_PEND_SUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Current Pending Support
A=Not Applicable
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 96 |
CHECK_RR_PERS |
Character(1) |
VARCHAR2(1) NOT NULL |
Check RR Personal Data
Y/N Table Edit
Default Value: N
|
| 97 |
CHECK_RR_BUDGET |
Character(1) |
VARCHAR2(1) NOT NULL |
Check RR Budget
Y/N Table Edit
Default Value: N
|
| 98 |
CHECK_RR_BUD_JUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Check RR Budget Justification
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 99 |
CHECK_COST_SHAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Cost Sharing
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 100 |
CHECK_NSF_COV |
Character(1) |
VARCHAR2(1) NOT NULL |
Check NSF Cover
Y/N Table Edit
Default Value: N
|
| 101 |
CHECK_NSF_UNIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Check NSF Unit
A=Not Applicable
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 102 |
CHECK_NSF_OTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Check NSF Other Info
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 103 |
CHECK_NSF_FILL |
Character(1) |
VARCHAR2(1) NOT NULL |
Check NSF FILL
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 104 |
CHECK_NSF_DEV_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Check NSF Dev Auth
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 105 |
CHECK_NSF_REG |
Character(1) |
VARCHAR2(1) NOT NULL |
Check NSF Reg
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 106 |
CHECK_NOT_INC |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Do Not Include
A=NOT APPLICABLE
N=NO
Y=YES
Default Value: A
|
| 107 |
NSF_DIV_CODE |
Character(8) |
VARCHAR2(8) NOT NULL |
NSF Division Code
|
| 108 |
NSF_DIV_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
NSF Division Name
|
| 109 |
INCLUE_FIRST_PI |
Character(1) |
VARCHAR2(1) NOT NULL |
Beginning Investigator
Y/N Table Edit
Default Value: N
|
| 110 |
INCLUE_LOBB_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Disclosure of Lobbying
Y/N Table Edit
Default Value: N
|
| 111 |
INCLUE_EXPLOR_RSH |
Character(1) |
VARCHAR2(1) NOT NULL |
Is Exploratory Research
Y/N Table Edit
Default Value: N
|
| 112 |
INCLUE_HIS_PLCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Is Historic Places
Y/N Table Edit
Default Value: N
|
| 113 |
INCLUE_ACC_RENV |
Character(1) |
VARCHAR2(1) NOT NULL |
Is Accomplishment Renewal
Y/N Table Edit
Default Value: N
|
| 114 |
INCLUE_HIG_RESLU |
Character(1) |
VARCHAR2(1) NOT NULL |
Is High Resolution Graphics
Y/N Table Edit
Default Value: N
|
| 115 |
IS_SMALL_BUS_ELIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Small Business Eligibility
Y/N Table Edit
Default Value: N
|
| 116 |
SUB_CONTRCT_INCL |
Character(1) |
VARCHAR2(1) NOT NULL |
Subcontracts Included
Y/N Table Edit
Default Value: N
|
| 117 |
SUB_CONTRACT_NAME |
Character(250) |
VARCHAR2(250) NOT NULL |
Subcontract Names
|
| 118 |
LOCAL_HUB_ZONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Located In HUB Zone
Y/N Table Edit
Default Value: N
|
| 119 |
DOMESTIC_PERF |
Character(1) |
VARCHAR2(1) NOT NULL |
Domestic Performance
Y/N Table Edit
Default Value: N
|
| 120 |
DISCLOSURE_PERM |
Character(1) |
VARCHAR2(1) NOT NULL |
Disclosure Permission
Y/N Table Edit
Default Value: N
|
| 121 |
SBIR_PDPI_COMMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Disclosure Permission
Y/N Table Edit
|
| 122 |
SBIR_PDPI_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Disclosure Permission
Y/N Table Edit
|
| 123 |
SBIR_PDPI_JOINT |
Character(1) |
VARCHAR2(1) NOT NULL |
Disclosure Permission
Y/N Table Edit
|
| 124 |
SBIR_PHASE2AWARDS |
Character(1) |
VARCHAR2(1) NOT NULL |
Disclosure Permission
Y/N Table Edit
Default Value: N
|
| 125 |
NASA_CIVIL_SEV |
Character(1) |
VARCHAR2(1) NOT NULL |
NASA_CIVIL_SEV
Y/N Table Edit
Default Value: N
|
| 126 |
DEVIATION_AUTH |
Long Character(4000) |
CLOB |
Deviation Authorization
|
| 127 |
FED_AGENCY_NAMES |
Character(250) |
VARCHAR2(250) NOT NULL |
Federal Agency Names
|
| 128 |
FED_ACT |
Character(110) |
VARCHAR2(110) NOT NULL |
Federal Action Number
|
| 129 |
FED_AG_DEPT |
Character(40) |
VARCHAR2(40) NOT NULL |
*Federal Agency Department
|
| 130 |
FED_PROG_NAME |
Character(120) |
VARCHAR2(120) NOT NULL |
Federal Program Name
|
| 131 |
AWD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Award Amount
|
| 132 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 133 |
NASA_FY1 |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year1
|
| 134 |
NASA_FY2 |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year2
|
| 135 |
NASA_FY3 |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year3
|
| 136 |
NASA_FY4 |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year4
|
| 137 |
NASA_FY5 |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year5
|
| 138 |
NASA_FY6 |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year6
|
| 139 |
NASA_FTE1 |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Year 1
|
| 140 |
NASA_FTE2 |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Year 2
|
| 141 |
NASA_FTE3 |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Year 3
|
| 142 |
NASA_FTE4 |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Year 4
|
| 143 |
NASA_FTE5 |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Year 5
|
| 144 |
NASA_FTE6 |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Year 6
|
| 145 |
HIS_IMPACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Hispanic Impact
Y/N Table Edit
Default Value: N
|
| 146 |
HIS_IMPACT_DESC |
Character(250) |
VARCHAR2(250) NOT NULL |
Description
|
| 147 |
INTER_PART |
Character(1) |
VARCHAR2(1) NOT NULL |
International Participation
Y/N Table Edit
Default Value: N
|
| 148 |
Y_PI |
Character(1) |
VARCHAR2(1) NOT NULL |
PI
Y/N Table Edit
Default Value: N
|
| 149 |
USER_FLG1 |
Character(1) |
VARCHAR2(1) NOT NULL |
USR FLAG
|
| 150 |
USER_FLG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
USR FLAG
|
| 151 |
USER_FLG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
USR FLAG
|
| 152 |
USER_FLG4 |
Character(1) |
VARCHAR2(1) NOT NULL |
USR FLAG
|
| 153 |
USER_FLG5 |
Character(1) |
VARCHAR2(1) NOT NULL |
USR FLAG
|
| 154 |
USER_FIELD_1 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Field 1
|
| 155 |
USER_FIELD_2 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Field 2
|
| 156 |
USER_FIELD_3 |
Character(15) |
VARCHAR2(15) NOT NULL |
User Field 3
|
| 157 |
USER_FIELD_4 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Field 4
|
| 158 |
USER_FIELD_5 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Field 5
|
| 159 |
USER_DATE1 |
Date(10) |
DATE |
User Date Field 1
|
| 160 |
USER_DATE2 |
Date(10) |
DATE |
User Date Field 2
|
| 161 |
USER_DATE3 |
Date(10) |
DATE |
User Date Field 3
|
| 162 |
Y_COPI |
Character(1) |
VARCHAR2(1) NOT NULL |
CO-PI
Y/N Table Edit
Default Value: N
|
| 163 |
Y_COLL |
Character(1) |
VARCHAR2(1) NOT NULL |
Collaborator
Y/N Table Edit
Default Value: N
|
| 164 |
Y_EQU |
Character(1) |
VARCHAR2(1) NOT NULL |
Equipment
Y/N Table Edit
Default Value: N
|
| 165 |
Y_FAC |
Character(1) |
VARCHAR2(1) NOT NULL |
Facility
Y/N Table Edit
Default Value: N
|
| 166 |
Y_EX |
Character(250) |
VARCHAR2(250) NOT NULL |
Explanation
|
| 167 |
GM_PROG_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Program Code ChartField
|
| 168 |
GM_PROG_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Program Name
|
| 169 |
ENV_IMPACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Env Impact
Y/N Table Edit
Default Value: N
|
| 170 |
ENV_IMPACT_EXPL |
Character(55) |
VARCHAR2(55) NOT NULL |
Env Impact Explanation
|
| 171 |
ENV_IMP_EXEMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Exempt
Y/N Table Edit
Default Value: N
|
| 172 |
EQV_PROP_SUBMITED |
Character(1) |
VARCHAR2(1) NOT NULL |
Equivalent Proposal Submitted
Y/N Table Edit
Default Value: N
|
| 173 |
ENV_IMP_EXEMT_EXPL |
Character(55) |
VARCHAR2(55) NOT NULL |
Exempt
|
| 174 |
IS_HUM_STM_CEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Human Stem Cells
Y/N Table Edit
Default Value: N
|
| 175 |
STEM_CELL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Stem Cell
Y/N Table Edit
Default Value: N
|
| 176 |
OUTSIDE_US_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Outside US Indicator
Y/N Table Edit
Default Value: N
|
| 177 |
OUTSIDE_US_EXP |
Character(55) |
VARCHAR2(55) NOT NULL |
Outside US Explanation
|
| 178 |
OUTSIDE_US_OPT_EXP |
Character(55) |
VARCHAR2(55) NOT NULL |
Outside US Explanation
|
| 179 |
DIS_PERMI |
Character(1) |
VARCHAR2(1) NOT NULL |
Disclosure Permission
Y/N Table Edit
Default Value: N
|
| 180 |
SBIR_PII_RECE |
Character(1) |
VARCHAR2(1) NOT NULL |
SBIR PhaseII Awards Received
Y/N Table Edit
|
| 181 |
SBIR_PDPI_E |
Character(1) |
VARCHAR2(1) NOT NULL |
SBIR PDPI Primarily Employed
Y/N Table Edit
Default Value: N
|
| 182 |
STTR_PDPI_C |
Character(1) |
VARCHAR2(1) NOT NULL |
STTR PDPI Commitment
Y/N Table Edit
Default Value: N
|
| 183 |
STTR_PDPI_J |
Character(1) |
VARCHAR2(1) NOT NULL |
STTR Joint Performance %
Y/N Table Edit
Default Value: N
|
| 184 |
IS_PRO_INCOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Program Income
Y/N Table Edit
Default Value: N
|
| 185 |
IS_PRE_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Is Previously Reported
Y/N Table Edit
|
| 186 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
GM_PERS_DATA_VW
|
| 187 |
IS_INV_PATEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Is Inventions And Patents
Y/N Table Edit
|
| 188 |
PRIMARY_REP_ENTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Primary Reporting Entity
N=SubAwardee
Y=Primary
Default Value: Y
|
| 189 |
REV_12372 |
Character(1) |
VARCHAR2(1) NOT NULL |
Review
C=Not Covered
S=Not Selected
Y=Yes
|
| 190 |
REV_12372_DT |
Date(10) |
DATE |
Review Date
|