OPRIDRUN_CNTL_IDGM_XML_PROPSL2(SQL View) |
Index Back |
|---|---|
xml file proposal header infor |
| SELECT A.OPRID , A.RUN_CNTL_ID , A.PROPOSAL_ID , A.VERSION_ID , B.TITLE56 , B.CFDA , %Substring(G.DESCR254, 1, 200) , H.NAME1 , ' ' FROM PS_GM_XML_PROP_TBL A , PS_GM_EC_HDR B , PS_GM_EC_INST D , PS_GM_PROP_PROJ G , PS_CUSTOMER H WHERE A.OPRID = B.OPRID AND A.RUN_CNTL_ID = B.RUN_CNTL_ID AND B.ECTRANSID = D.ECTRANSID AND B.ECQUEUEINSTANCE = D.ECQUEUEINSTANCE AND B.ECTRANSINOUTSW = D.ECTRANSINOUTSW AND B.OPRID = D.OPRID AND B.RUN_CNTL_ID = D.RUN_CNTL_ID AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.PROPOSAL_ID = D.PROPOSAL_ID AND B.BUSINESS_UNIT = G.BUSINESS_UNIT AND B.PROPOSAL_ID = G.PROPOSAL_ID AND B.VERSION_ID = G.VERSION_ID AND G.PRIMARY_FLAG = 'Y' AND D.SETID = H.SETID AND B.CUST_ID = H.CUST_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 | TITLE56 | Character(56) | VARCHAR2(56) NOT NULL | TITLE56 |
| 6 | CFDA | Character(15) | VARCHAR2(15) NOT NULL | CFDA |
| 7 | GM_PROJ_DESC | Character(254) | VARCHAR2(254) NOT NULL | Project Description |
| 8 | GM_AGENCY_NAME | Character(60) | VARCHAR2(60) NOT NULL | Agency Name |
| 9 | EFF_LOC | Character(45) | VARCHAR2(45) NOT NULL | Location |