HRS_VENDOR_IDHRS_VNDR_TRANS_IDHRS_VTRANS_DDWN(SQL View) |
Index Back |
|---|---|
Vendor Transaction DropDownA record used to populate the Vendor-Transaction Drop Down on the Vendor Page |
| SELECT DISTINCT A.HRS_VENDOR_ID , A.HRS_VNDR_TRANS_ID , A.HRS_TRANSACTION_ID , C.HRS_TRANS_NAME FROM PS_HRS_VNDR_TRANS A , PS_HRS_OI_VALMAP B , PS_HRS_SOA_SRV_VW C WHERE B.HRS_OBJECT_ID=A.HRS_VNDR_TRANS_ID AND B.HRS_OI_USE_TYPE='20' AND A.HRS_TRANSACTION_ID=C.HRS_TRANSACTION_ID AND A.HRS_VERSION = ( SELECT MAX (D.HRS_VERSION) FROM PS_HRS_VENDOR D WHERE D.HRS_VENDOR_ID=A.HRS_VENDOR_ID) |
| # | 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 |
| 3 | HRS_TRANSACTION_ID | Character(30) | VARCHAR2(30) NOT NULL | Transaction ID |
| 4 | HRS_TRANS_NAME | Character(52) | VARCHAR2(52) NOT NULL | Transaction Name |