GM_XML_INSTITUT

(SQL View)
 Index Back

SELECT A.OPRID , A.RUN_CNTL_ID , A.PROPOSAL_ID , A.VERSION_ID , %Substring(B.DESCR, 1, 26) , B.SETID , B.INSTID , C.INS_TYP_DES_LNG , C.OTHER_SPEC , C.GM_WOMEN_OWNED , C.GM_SO_DIS_ADV , CASE B.ALASK_SER_INST WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , CASE B.COOPER_EXTEN WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , B.DHHS_PMS_PIN , CASE B.HHS_PMS_YN WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , CASE B.HISPAN_SEV_INST WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , CASE B.HISTOR_BLK_UNV WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , B.INS_KEYWORD , CASE B.MIN_SEV_INST WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , CASE B.NAT_HAW_INST WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , CASE B.PUB_NO_PROF_COMCOL WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , CASE B.PUB_SECON_SCHL WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , CASE B.SCH_OF_FORESTRY WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , CASE B.STATE_AGR_EXP_ST WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , CASE B.TRIBAL_COLLG WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , CASE B.VETER_SCH_COLLG WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , B.ORG_TYPE_DESC , B.ORG_TYPE , B.FEDERAL_EIN_GM , %Substring(B.DESCR120, 1, 60) , A.DUNS_NBR , D.EMAILID , D.PHONE , D.FAX , B.TAXPAYER_ID , ' ' , 'Project' , E.DESCRSHORT , B.ADD_TYPE , CASE B.AFFILIATE_USE WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , CASE B.GM_501_STATUS WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , CASE B.GM_AWARDED WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , CASE B.GM_FAITH_BASED WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , CASE B.GM_SECULAR WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , ' ' , ' ' , F.CFDA , F.DESCR254 FROM PS_GM_XML_PROP_TBL A , PS_GM_EC_INST B , PS_GM_EC_INST_TYPE C , PS_GM_IN_ADDR_VW D , PS_GM_INSTITUTION E , PS_GM_EC_HDR F WHERE A.OPRID = B.OPRID AND A.RUN_CNTL_ID = B.RUN_CNTL_ID AND A.OPRID = C.OPRID AND A.RUN_CNTL_ID = C.RUN_CNTL_ID AND B.SETID = C.SETID AND B.INSTID = C.INSTID AND B.SETID = D.SETID AND B.INSTID = D.INSTID AND B.SETID = E.SETID AND B.INSTID = E.INSTID AND F.OPRID = A.OPRID AND F.RUN_CNTL_ID = A.RUN_CNTL_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
4 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 INSTID Character(5) VARCHAR2(5) NOT NULL Institution ID
8 INS_TYP_DES_LNG Character(85) VARCHAR2(85) NOT NULL Long Description
9 OTHER_SPEC Character(50) VARCHAR2(50) NOT NULL Specification
10 GM_WOMEN_OWNED Character(1) VARCHAR2(1) NOT NULL Women Owned
11 GM_SO_DIS_ADV Character(1) VARCHAR2(1) NOT NULL Socially Economically
12 ALASK_SER_INST_D Character(14) VARCHAR2(14) NOT NULL Alaska Native Serving Institu
13 COOPER_EXTEN_D Character(14) VARCHAR2(14) NOT NULL Cooperative Extension Service
14 DHHS_PMS_PIN Character(8) VARCHAR2(8) NOT NULL DHHS-PMS PIN
15 HHS_PMS_YN_D Character(14) VARCHAR2(14) NOT NULL DHHS -PMS
16 HISPAN_SEV_INST_D Character(14) VARCHAR2(14) NOT NULL Hispanic Serving Institution
17 HISTOR_BLK_UNV_D Character(14) VARCHAR2(14) NOT NULL Historically Black College
18 INS_KEYWORD Character(100) VARCHAR2(100) NOT NULL KeyWords
19 MIN_SEV_INST_D Character(14) VARCHAR2(14) NOT NULL Minority Serving Institution
20 NAT_HAW_INST_D Character(14) VARCHAR2(14) NOT NULL Native Hawaiian Serving Instit
21 PUB_NO_PROF_COM_D Character(14) VARCHAR2(14) NOT NULL Public Nonprofit College
22 PUB_SECON_SCHL_D Character(14) VARCHAR2(14) NOT NULL Public Secondary School
23 SCH_OF_FORESTRY_D Character(14) VARCHAR2(14) NOT NULL School of Forestry
24 STATE_AGR_EXP_ST_D Character(14) VARCHAR2(14) NOT NULL State Agricultural Experiment
25 TRIBAL_COLLG_D Character(14) VARCHAR2(14) NOT NULL Tribal College
26 VETER_SCH_COLLG_D Character(14) VARCHAR2(14) NOT NULL Veterinary Scholar College
27 ORG_TYPE_DESC Character(60) VARCHAR2(60) NOT NULL Description
28 ORG_TYPE Character(4) VARCHAR2(4) NOT NULL OrganizationType
29 FEDERAL_EIN_GM Character(30) VARCHAR2(30) NOT NULL Federal EIN
30 ORG_LEG_NAME Character(60) VARCHAR2(60) NOT NULL Organization Legal Name
31 DUNS_NBR Character(40) VARCHAR2(40) NOT NULL DUNS
32 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
33 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
34 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
35 TAXPAYER_ID Character(14) VARCHAR2(14) NOT NULL Taxpayer ID
36 DEP_DESC Character(30) VARCHAR2(30) NOT NULL Department Description
37 GM_BUD_TYPE Character(20) VARCHAR2(20) NOT NULL Budget Type
38 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
39 ADD_TYPE Character(4) VARCHAR2(4) NOT NULL Additional Applicant Type
40 AFFILIATE_USE_D Character(10) VARCHAR2(10) NOT NULL Use Affiliate
41 GM_501_STATUS_D Character(10) VARCHAR2(10) NOT NULL Have 501(c)(3) status
42 GM_AWARDED_D Character(10) VARCHAR2(10) NOT NULL Ever received grant/contract
43 GM_FAITH_BASED_D Character(10) VARCHAR2(10) NOT NULL A faith-based organization
44 GM_SECULAR_D Character(10) VARCHAR2(10) NOT NULL A secular organization
45 GM_FULL_TIME_EE_D Character(50) VARCHAR2(50) NOT NULL Full-time equivalent employees
A=3 or fewer
B=4-5
C=6-14
D=15-50
E=51-100
F=Over 100
46 GM_ANNL_BUDGET_D Character(50) VARCHAR2(50) NOT NULL Size of the annual budget
A=Less Than $150,000
B=$150,000 - $299,999
C=$300,000 - $499,999
D=$500,000 - $999,999
E=$1,000,000 - $4,999,999
F=$5,000,000 or more
47 CFDA Character(15) VARCHAR2(15) NOT NULL CFDA
48 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254