GM_XML_OTHER_BK

(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 ,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 ,CASE A.CHECK_BIB WHEN 'Y' THEN 'YES' ELSE 'NO' END ,CASE A.CHECK_FACILITY WHEN 'Y' THEN 'YES' ELSE 'NO' END ,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 CHECK_RRSITE_D Character(14) VARCHAR2(14) NOT NULL Check RR Site
72 CHECK_RROTHER_D Character(14) VARCHAR2(14) NOT NULL Check RR Other Info
73 CHECK_PROJ_SUM_D Character(14) VARCHAR2(14) NOT NULL Check Project Summary
74 CHECK_BIB_D Character(14) VARCHAR2(14) NOT NULL Check Biblio
75 CHECK_FACILITY_D Character(14) VARCHAR2(14) NOT NULL Check Facilities
76 INCLUE_FIRST_PI Character(1) VARCHAR2(1) NOT NULL Beginning Investigator
77 INCLUE_LOBB_ACT Character(1) VARCHAR2(1) NOT NULL Disclosure of Lobbying
78 INCLUE_EXPLOR_RSH Character(1) VARCHAR2(1) NOT NULL Is Exploratory Research
79 INCLUE_HIS_PLCE Character(1) VARCHAR2(1) NOT NULL Is Historic Places
80 INCLUE_ACC_RENV Character(1) VARCHAR2(1) NOT NULL Is Accomplishment Renewal
81 INCLUE_HIG_RESLU Character(1) VARCHAR2(1) NOT NULL Is High Resolution Graphics
82 DEVIATION_AUTH Long Character(4000) CLOB Deviation Authorization
83 IS_HUM_STM_CEL Character(1) VARCHAR2(1) NOT NULL Human Stem Cells
84 IS_HUM_STM_CEL_D Character(14) VARCHAR2(14) NOT NULL Human Stem Cells
85 STEM_CELL_IND Character(1) VARCHAR2(1) NOT NULL Stem Cell
86 STEM_CELL_IND_D Character(14) VARCHAR2(14) NOT NULL Stem Cell
87 INTER_PART_DESC Character(14) VARCHAR2(14) NOT NULL International Participation
88 NASA_FY1 Number(4,0) SMALLINT NOT NULL Fiscal Year1
89 NASA_FY2 Number(4,0) SMALLINT NOT NULL Fiscal Year2
90 NASA_FY3 Number(4,0) SMALLINT NOT NULL Fiscal Year3
91 NASA_FY4 Number(4,0) SMALLINT NOT NULL Fiscal Year4
92 NASA_FY5 Number(4,0) SMALLINT NOT NULL Fiscal Year5
93 NASA_FY6 Number(4,0) SMALLINT NOT NULL Fiscal Year6
94 NASA_FTE1 Number(8,2) DECIMAL(7,2) NOT NULL Year 1
95 NASA_FTE2 Number(8,2) DECIMAL(7,2) NOT NULL Year 2
96 NASA_FTE3 Number(8,2) DECIMAL(7,2) NOT NULL Year 3
97 NASA_FTE4 Number(8,2) DECIMAL(7,2) NOT NULL Year 4
98 NASA_FTE5 Number(8,2) DECIMAL(7,2) NOT NULL Year 5
99 NASA_FTE6 Number(8,2) DECIMAL(7,2) NOT NULL Year 6
100 NSF_DIV_CODE Character(8) VARCHAR2(8) NOT NULL NSF Division Code
101 NSF_DIV_NAME Character(30) VARCHAR2(30) NOT NULL NSF Division Name
102 GM_PROG_NAME Character(30) VARCHAR2(30) NOT NULL Program Name
103 GM_PROG_CODE Character(4) VARCHAR2(4) NOT NULL Program Code ChartField