GM_XML_OTHERBK2

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT ,A.PROPOSAL_ID ,A.VERSION_ID ,A.IS_SUB_TO_OTH ,CASE A.IS_SUB_TO_OTH WHEN 'Y' THEN A.OTHER_AGENCY ELSE ' ' END ,A.RRCOVERPAGE ,A.SUPPLEINFO ,A.RRSENKEY ,A.BIOSKETCH ,A.SUPPORTFILE ,A.ADDSENKEY ,A.ADDBIO ,A.ADDSUPPOR ,A.OTHPRJINFO ,A.PRJ_SUM_ABS ,A.PRJNAFL ,A.BIO_REFERE ,A.OTH_ATTCH ,A.BUDGET_FORM ,A.BUDGET_1 ,A.BUDGET_2 ,A.BUDGET_3 ,A.BUDGET_4 ,A.BUDGET_5 ,A.ADD_KEY_ATT ,A.ADD_EQU_ATT ,A.BUD_JUST ,A.PERS_FORM ,A.REV_PRJ_OBJ ,A.NRI_PROP_TYPE ,A.RES_PRP_PRJ_GRP ,A.POST_DOC_FEL ,A.NEW_INV ,A.STR_TH ,F.XLATLONGNAME ,A.PROG_NAME ,A.PROG_CODE ,D.XLATLONGNAME ,E.XLATLONGNAME ,A.CHANGE_YEAR ,A.CHANGE_QT ,A.LAST_REPORT ,A.CHECKSIGNDATE1 ,A.CHECKSIGNDATE2 ,A.CHECKSIGNDATE3 ,A.CIVILRIGHTASS ,A.CIVIL_ASS_DT ,A.HANDI_ASS ,A.HANDI_ASS_DT ,A.SEX_ASS ,A.SEX_ASS_DT ,A.AGE_ASS ,A.AGE_ASS_DT ,A.HUM_SUB_CERT ,A.PHS_IMPACT ,A.INTER_GOV_REV ,A.PROJ_IDENTIFY ,A.BIO_SKETCH ,A.SF424AC ,A.MONTH_12_DTL ,A.PROJ_DTL ,A.ONLY_ADD_FIN ,A.PROGRESS_REP ,A.IRSL_LIST ,A.IRS_CERT ,A.STATE_CERT ,A.INCOR_CERT ,A.PARENT_CERT ,A.PRE_AGE_NAME ,A.PRE_FILED_DT ,A.COVER_SHET_RR ,A.CHECK_RENEWA ,A.CHECK_FULLAPP ,A.CHECK_TYPEAPP ,A.CHECK_APPCERT ,CASE A.CHECK_RRSITE WHEN 'Y' THEN 'YES' ELSE 'NO' END , CASE A.CHECK_RROTHER WHEN 'Y' THEN 'YES' ELSE 'NO' END ,CASE A.CHECK_PROJ_SUM WHEN 'Y' THEN 'YES' ELSE 'NO' END ,A.CHECK_PROJ_NAR ,A.CHECK_MERIT_REW ,A.CHECK_PRIOR_SUP ,A.CHECK_HR_INFO ,A.CHECK_URL ,CASE A.CHECK_BIB WHEN 'Y' THEN 'YES' ELSE 'NO' END ,CASE A.CHECK_FACILITY WHEN 'Y' THEN 'YES' ELSE 'NO' END ,A.CHECK_EQU ,A.CHECK_SUP_DOC ,A.CHECK_ADD_ITEM ,A.CHECK_RR_PROF ,A.CHECK_BIO_SKECH ,A.CHECK_CUR_PEND_SUP ,A.CHECK_RR_PERS ,A.CHECK_RR_BUDGET ,A.CHECK_RR_BUD_JUST ,A.CHECK_COST_SHAR ,A.CHECK_NSF_COV ,A.CHECK_NSF_UNIT ,A.CHECK_NSF_OTH ,A.CHECK_NSF_FILL ,A.CHECK_NSF_DEV_AUTH ,A.CHECK_NSF_REG ,A.CHECK_NOT_INC ,A.INCLUE_FIRST_PI ,A.INCLUE_LOBB_ACT ,A.INCLUE_EXPLOR_RSH ,A.INCLUE_HIS_PLCE ,A.INCLUE_ACC_RENV ,A.INCLUE_HIG_RESLU ,A.DEVIATION_AUTH ,A.IS_HUM_STM_CEL , CASE A.IS_HUM_STM_CEL WHEN 'Y' THEN 'YES' ELSE 'NO' END ,A.STEM_CELL_IND , CASE A.STEM_CELL_IND WHEN 'Y' THEN 'YES' ELSE 'NO' END ,CASE A.NASA_CIVIL_SEV WHEN 'Y' THEN 'YES' ELSE 'NO' END ,A.NASA_FY1 ,A.NASA_FY2 ,A.NASA_FY3 ,A.NASA_FY4 ,A.NASA_FY5 ,A.NASA_FY6 ,A.NASA_FTE1 ,A.NASA_FTE2 ,A.NASA_FTE3 ,A.NASA_FTE4 ,A.NASA_FTE5 ,A.NASA_FTE6 ,A.NSF_DIV_CODE , A.NSF_DIV_NAME , A.GM_PROG_NAME , A.GM_PROG_CODE FROM PS_GM_PROPSL_FORMS A , PS_GM_ACT_TYP_VW D , PS_GM_FED_STATS_VW E , PS_GM_STR_GPVAL_VW F WHERE D.FIELDVALUE = A.FED_ACT_TYPE AND E.FIELDVALUE = A.FED_ACT_STATUS AND F.FIELDVALUE = A.STR_TH_GRP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
3 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID
4 IS_SUB_TO_OTH Character(1) VARCHAR2(1) NOT NULL Submit to Other Agency
5 OTHER_AGENCY Character(20) VARCHAR2(20) NOT NULL Other Agency name
6 RRCOVERPAGE Character(1) VARCHAR2(1) NOT NULL R&R Cover Page Form
7 SUPPLEINFO Character(1) VARCHAR2(1) NOT NULL Supplemental Information Form
8 RRSENKEY Character(1) VARCHAR2(1) NOT NULL R&R Senior Key Person Form
9 BIOSKETCH Character(1) VARCHAR2(1) NOT NULL Biographical Sketch File
10 SUPPORTFILE Character(1) VARCHAR2(1) NOT NULL Current & Pending Support File
11 ADDSENKEY Character(1) VARCHAR2(1) NOT NULL Additional Senior Key Person
12 ADDBIO Character(1) VARCHAR2(1) NOT NULL Additional Bio. Sketches
13 ADDSUPPOR Character(1) VARCHAR2(1) NOT NULL Additional Current &Pend Sup
14 OTHPRJINFO Character(1) VARCHAR2(1) NOT NULL RR Other Project Inform File
15 PRJ_SUM_ABS Character(1) VARCHAR2(1) NOT NULL Project Summary Abstract File
16 PRJNAFL Character(1) VARCHAR2(1) NOT NULL Project Narrative File
17 BIO_REFERE Character(1) VARCHAR2(1) NOT NULL Bibliography References File
18 OTH_ATTCH Character(1) VARCHAR2(1) NOT NULL Other Attachments
19 BUDGET_FORM Character(1) VARCHAR2(1) NOT NULL R&R Budget Form
20 BUDGET_1 Character(1) VARCHAR2(1) NOT NULL Budget Year 1
21 BUDGET_2 Character(1) VARCHAR2(1) NOT NULL Budget Year 2
22 BUDGET_3 Character(1) VARCHAR2(1) NOT NULL Budget Year 3
23 BUDGET_4 Character(1) VARCHAR2(1) NOT NULL Budget Year 4
24 BUDGET_5 Character(1) VARCHAR2(1) NOT NULL Budget Year 5
25 ADD_KEY_ATT Character(1) VARCHAR2(1) NOT NULL Additional Senior Key Persons
26 ADD_EQU_ATT Character(1) VARCHAR2(1) NOT NULL Additional Equipment Attach
27 BUD_JUST Character(1) VARCHAR2(1) NOT NULL Budget Justification Form
28 PERS_FORM Character(1) VARCHAR2(1) NOT NULL Personal Data Form
29 REV_PRJ_OBJ Character(1) VARCHAR2(1) NOT NULL Revised Project Objectives
30 NRI_PROP_TYPE Character(30) VARCHAR2(30) NOT NULL NRI Proposal Type
31 RES_PRP_PRJ_GRP Character(50) VARCHAR2(50) NOT NULL Project Proposal Group
32 POST_DOC_FEL Character(1) VARCHAR2(1) NOT NULL Post doctoral Fellowship
33 NEW_INV Character(1) VARCHAR2(1) NOT NULL New Investigator
34 STR_TH Character(1) VARCHAR2(1) NOT NULL Strengthening
35 STR_GP_VALUE Character(30) VARCHAR2(30) NOT NULL Strengthening Group
36 PROG_NAME Character(60) VARCHAR2(60) NOT NULL *Program Name
37 PROG_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
38 FED_ACT_TYPE_LNG Character(30) VARCHAR2(30) NOT NULL FED LONG DESCR
39 FED_ACT_STAT_LNG Character(30) VARCHAR2(30) NOT NULL FED ACT STATUS
40 CHANGE_YEAR Number(4,0) SMALLINT NOT NULL Year
41 CHANGE_QT Number(1,0) SMALLINT NOT NULL Quarter
42 LAST_REPORT Date(10) DATE Last Report
43 CHECKSIGNDATE1 Character(1) VARCHAR2(1) NOT NULL Sign Date SF424
44 CHECKSIGNDATE2 Character(1) VARCHAR2(1) NOT NULL Sign Date PHS5161-1
45 CHECKSIGNDATE3 Character(1) VARCHAR2(1) NOT NULL Sign Date SF424BD
46 CIVILRIGHTASS Character(1) VARCHAR2(1) NOT NULL Civil Right Assurance
47 CIVIL_ASS_DT Date(10) DATE Civil Right Assurance Sign
48 HANDI_ASS Character(1) VARCHAR2(1) NOT NULL Handicapped Assurance
49 HANDI_ASS_DT Date(10) DATE Handicapped Assurance Sign
50 SEX_ASS Character(1) VARCHAR2(1) NOT NULL Sex Assurance
51 SEX_ASS_DT Date(10) DATE Sex Assurance Sign Date
52 AGE_ASS Character(1) VARCHAR2(1) NOT NULL Age Assurance
53 AGE_ASS_DT Date(10) DATE Age Assurance Sign Date
54 HUM_SUB_CERT Character(1) VARCHAR2(1) NOT NULL Human Subject Certification
A=NOT APPLICABLE
N=NO
Y=YES
55 PHS_IMPACT Character(1) VARCHAR2(1) NOT NULL PHS Impact Statement
A=NOT APPLICABLE
N=NO
Y=YES
56 INTER_GOV_REV Character(1) VARCHAR2(1) NOT NULL Intergrovern mental Review
57 PROJ_IDENTIFY Character(1) VARCHAR2(1) NOT NULL Project Identify
58 BIO_SKETCH Character(1) VARCHAR2(1) NOT NULL Biographical Sketch
A=NOT APPLICABLE
N=NO
Y=YES
59 SF424AC Character(1) VARCHAR2(1) NOT NULL SF424AC
60 MONTH_12_DTL Character(1) VARCHAR2(1) NOT NULL 12 Month Detailed Budget
A=NOT APPLICABLE
N=NO
Y=YES
61 PROJ_DTL Character(1) VARCHAR2(1) NOT NULL Has Detail Project Budget
A=NOT APPLICABLE
N=NO
Y=YES
62 ONLY_ADD_FIN Character(1) VARCHAR2(1) NOT NULL Address Only Additional Funds
A=NOT APPLICABLE
N=NO
Y=YES
63 PROGRESS_REP Character(1) VARCHAR2(1) NOT NULL Progress Report
A=NOT APPLICABLE
N=NO
Y=YES
64 IRSL_LIST Character(1) VARCHAR2(1) NOT NULL Reference IRS List
65 IRS_CERT Character(1) VARCHAR2(1) NOT NULL IRS Certification
66 STATE_CERT Character(1) VARCHAR2(1) NOT NULL State Tax Certification
67 INCOR_CERT Character(1) VARCHAR2(1) NOT NULL Incorporation Certification
68 PARENT_CERT Character(1) VARCHAR2(1) NOT NULL Parent Org.Certification
69 PRE_AGE_NAME Character(60) VARCHAR2(60) NOT NULL Previsouly Filed with
70 PRE_FILED_DT Date(10) DATE Filed Date
71 COVER_SHET_RR Character(1) VARCHAR2(1) NOT NULL SF 424 (R&R) Cover Sheet
72 CHECK_RENEWA Character(1) VARCHAR2(1) NOT NULL Check Renewal
A=NOT APPLICABLE
N=NO
Y=YES
73 CHECK_FULLAPP Character(1) VARCHAR2(1) NOT NULL Check Full App
A=NOT APPLICABLE
N=NO
Y=YES
74 CHECK_TYPEAPP Character(1) VARCHAR2(1) NOT NULL Check Type App
75 CHECK_APPCERT Character(1) VARCHAR2(1) NOT NULL Check App Cert
76 CHECK_RRSITE_D Character(14) VARCHAR2(14) NOT NULL Check RR Site
77 CHECK_RROTHER_D Character(14) VARCHAR2(14) NOT NULL Check RR Other Info
78 CHECK_PROJ_SUM_D Character(14) VARCHAR2(14) NOT NULL Check Project Summary
79 CHECK_PROJ_NAR Character(1) VARCHAR2(1) NOT NULL Check Project Narrative
80 CHECK_MERIT_REW Character(1) VARCHAR2(1) NOT NULL Check Merit Review
A=NOT APPLICABLE
N=NO
Y=YES
81 CHECK_PRIOR_SUP Character(1) VARCHAR2(1) NOT NULL Check Prior Support
A=NOT APPLICABLE
N=NO
Y=YES
82 CHECK_HR_INFO Character(1) VARCHAR2(1) NOT NULL Check HR Info
A=NOT APPLICABLE
N=NO
Y=YES
83 CHECK_URL Character(1) VARCHAR2(1) NOT NULL Check URL
A=NOT APPLICABLE
N=NO
Y=YES
84 CHECK_BIB_D Character(14) VARCHAR2(14) NOT NULL Check Biblio
85 CHECK_FACILITY_D Character(14) VARCHAR2(14) NOT NULL Check Facilities
86 CHECK_EQU Character(1) VARCHAR2(1) NOT NULL Check Equipment
87 CHECK_SUP_DOC Character(1) VARCHAR2(1) NOT NULL Check Supp Doc
A=NOT APPLICABLE
N=NO
Y=YES
88 CHECK_ADD_ITEM Character(1) VARCHAR2(1) NOT NULL Check Additional Items
A=NOT APPLICABLE
N=NO
Y=YES
89 CHECK_RR_PROF Character(1) VARCHAR2(1) NOT NULL Check RR Sr.Profile
90 CHECK_BIO_SKECH Character(1) VARCHAR2(1) NOT NULL Check Bio Sketch
A=Not Applicable
N=No
Y=Yes
91 CHECK_CUR_PEND_SUP Character(1) VARCHAR2(1) NOT NULL Check Current Pending Support
A=Not Applicable
N=No
Y=Yes
92 CHECK_RR_PERS Character(1) VARCHAR2(1) NOT NULL Check RR Personal Data
93 CHECK_RR_BUDGET Character(1) VARCHAR2(1) NOT NULL Check RR Budget
94 CHECK_RR_BUD_JUST Character(1) VARCHAR2(1) NOT NULL Check RR Budget Justification
A=NOT APPLICABLE
N=NO
Y=YES
95 CHECK_COST_SHAR Character(1) VARCHAR2(1) NOT NULL Check Cost Sharing
A=NOT APPLICABLE
N=NO
Y=YES
96 CHECK_NSF_COV Character(1) VARCHAR2(1) NOT NULL Check NSF Cover
97 CHECK_NSF_UNIT Character(1) VARCHAR2(1) NOT NULL Check NSF Unit
A=Not Applicable
N=No
Y=Yes
98 CHECK_NSF_OTH Character(1) VARCHAR2(1) NOT NULL Check NSF Other Info
A=NOT APPLICABLE
N=NO
Y=YES
99 CHECK_NSF_FILL Character(1) VARCHAR2(1) NOT NULL Check NSF FILL
A=NOT APPLICABLE
N=NO
Y=YES
100 CHECK_NSF_DEV_AUTH Character(1) VARCHAR2(1) NOT NULL Check NSF Dev Auth
A=NOT APPLICABLE
N=NO
Y=YES
101 CHECK_NSF_REG Character(1) VARCHAR2(1) NOT NULL Check NSF Reg
A=NOT APPLICABLE
N=NO
Y=YES
102 CHECK_NOT_INC Character(1) VARCHAR2(1) NOT NULL Check Do Not Include
A=NOT APPLICABLE
N=NO
Y=YES
103 INCLUE_FIRST_PI Character(1) VARCHAR2(1) NOT NULL Beginning Investigator
104 INCLUE_LOBB_ACT Character(1) VARCHAR2(1) NOT NULL Disclosure of Lobbying
105 INCLUE_EXPLOR_RSH Character(1) VARCHAR2(1) NOT NULL Is Exploratory Research
106 INCLUE_HIS_PLCE Character(1) VARCHAR2(1) NOT NULL Is Historic Places
107 INCLUE_ACC_RENV Character(1) VARCHAR2(1) NOT NULL Is Accomplishment Renewal
108 INCLUE_HIG_RESLU Character(1) VARCHAR2(1) NOT NULL Is High Resolution Graphics
109 DEVIATION_AUTH Long Character(4000) CLOB Deviation Authorization
110 IS_HUM_STM_CEL Character(1) VARCHAR2(1) NOT NULL Human Stem Cells
111 IS_HUM_STM_CEL_D Character(14) VARCHAR2(14) NOT NULL Human Stem Cells
112 STEM_CELL_IND Character(1) VARCHAR2(1) NOT NULL Stem Cell
113 STEM_CELL_IND_D Character(14) VARCHAR2(14) NOT NULL Stem Cell
114 INTER_PART_DESC Character(14) VARCHAR2(14) NOT NULL International Participation
115 NASA_FY1 Number(4,0) SMALLINT NOT NULL Fiscal Year1
116 NASA_FY2 Number(4,0) SMALLINT NOT NULL Fiscal Year2
117 NASA_FY3 Number(4,0) SMALLINT NOT NULL Fiscal Year3
118 NASA_FY4 Number(4,0) SMALLINT NOT NULL Fiscal Year4
119 NASA_FY5 Number(4,0) SMALLINT NOT NULL Fiscal Year5
120 NASA_FY6 Number(4,0) SMALLINT NOT NULL Fiscal Year6
121 NASA_FTE1 Number(8,2) DECIMAL(7,2) NOT NULL Year 1
122 NASA_FTE2 Number(8,2) DECIMAL(7,2) NOT NULL Year 2
123 NASA_FTE3 Number(8,2) DECIMAL(7,2) NOT NULL Year 3
124 NASA_FTE4 Number(8,2) DECIMAL(7,2) NOT NULL Year 4
125 NASA_FTE5 Number(8,2) DECIMAL(7,2) NOT NULL Year 5
126 NASA_FTE6 Number(8,2) DECIMAL(7,2) NOT NULL Year 6
127 NSF_DIV_CODE Character(8) VARCHAR2(8) NOT NULL NSF Division Code
128 NSF_DIV_NAME Character(30) VARCHAR2(30) NOT NULL NSF Division Name
129 GM_PROG_NAME Character(30) VARCHAR2(30) NOT NULL Program Name
130 GM_PROG_CODE Character(4) VARCHAR2(4) NOT NULL Program Code ChartField