OPRIDRUN_CNTL_IDEMPLIDGM_XML_KEY_ADD(SQL View) |
Index Back |
|---|---|
xml PI NAME |
| SELECT DISTINCT A.OPRID , A.RUN_CNTL_ID , A.PROPOSAL_ID , A.VERSION_ID , A.EMPLID , F.ADDRESS1_OTHER , F.ADDRESS2_OTHER , F.CITY_OTHER , F.COUNTRY_OTHER , F.COUNTY_OTHER , F.POSTAL_OTHER , F.STATE_OTHER , P.STATE_FORMAT , P.COUNTRY_FORMAT FROM PS_GM_EC_PERS_KP A , PS_GM_PERS_ADDR_VW F , PS_GM_STATE_CTRY_V P WHERE F.EMPLID = A.EMPLID AND F.STATE_OTHER = P.STATE AND F.COUNTRY_OTHER = P.COUNTRY |
| # | 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 |
| 13 | STATE_FORMAT | Character(40) | VARCHAR2(40) NOT NULL | STATE FORMAT |
| 14 | COUNTRY_FORMAT | Character(40) | VARCHAR2(40) NOT NULL | COUNTRY FORMAT |