GM_XML_COPI_ADD(SQL View) |
Index Back |
---|---|
xml PI NAME |
SELECT A.OPRID , A.RUN_CNTL_ID , A.PROPOSAL_ID , A.VERSION_ID , B.EMPLID , F.ADDRESS1_OTHER , F.ADDRESS2_OTHER , F.CITY_OTHER , F.COUNTRY_OTHER , F.COUNTY_OTHER , F.POSTAL_OTHER , F.STATE_OTHER FROM PS_GM_XML_PROP_TBL A , PS_GM_EC_PERS_PI B , PS_GM_EC_PROJ_PI_2 G , PS_GM_PERS_ADDR_VW F WHERE A.OPRID = B.OPRID AND A.RUN_CNTL_ID = B.RUN_CNTL_ID AND F.EMPLID = B.EMPLID AND B.ECTRANSID = G.ECTRANSID AND B.ECQUEUEINSTANCE = G.ECQUEUEINSTANCE AND B.ECTRANSINOUTSW = G.ECTRANSINOUTSW AND B.OPRID = G.OPRID AND B.RUN_CNTL_ID = G.RUN_CNTL_ID AND B.BUSINESS_UNIT = G.BUSINESS_UNIT AND B.PROPOSAL_ID = G.PROPOSAL_ID AND B.EMPLID = G.EMPLID AND A.SUB_PROP_NBR = G.SUB_PROP_NBR AND G.PROF_ROLE_TYPE = 'CPI' |
# | 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 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
6 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
7 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
8 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
9 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
10 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
11 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
12 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |