NAME1PMT_PAYEE_NM_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.NAME1 , B.XLATLONGNAME , A.PARTY_SETID , A.PARTY_ID FROM PS_PMT_DETAIL_TBL A , PSXLATITEM B WHERE B.FIELDNAME='PARTY_ID_TYPE' AND B.FIELDVALUE=A.PARTY_ID_TYPE AND B.EFF_STATUS='A' AND B.EFFDT=( SELECT MAX(EFFDT) FROM PSXLATITEM WHERE FIELDNAME=B.FIELDNAME AND FIELDVALUE=B.FIELDVALUE AND EFFDT<=%CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NAME1 |
Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 2 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 3 | PARTY_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | PARTY_ID | Character(30) | VARCHAR2(30) NOT NULL | Payee ID |