HRS_VENDOR_IDHRS_VNDRADMN_VW(SQL View) |
Index Back |
|---|
| SELECT A.HRS_VENDOR_ID , C.HRS_VNDR_TRANS_ID FROM PS_HRS_VENDOR A , PS_HRS_VNDR_TRANS C WHERE A.HRS_VERSION = ( SELECT MAX (B.HRS_VERSION) FROM PS_HRS_VENDOR B WHERE B.HRS_VENDOR_ID=A.HRS_VENDOR_ID) AND A.HRS_VENDOR_STATUS='10' AND A.HRS_VENDOR_ID=C.HRS_VENDOR_ID AND A.HRS_VERSION=C.HRS_VERSION AND C.HRS_TRANSACTION_ID='HC_UUID_94316430022052004' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_VENDOR_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Integration Vendor ID |
| 2 | HRS_VNDR_TRANS_ID | Number(15,0) | DECIMAL(15) NOT NULL | Id specific to a Vendor and Transaction |