HRS_SOA_SRV_VW2 (SQL View)	Index Back
SOA Service Reverse Lookup Allows a reverese lookup to find the transaction id associated with a string comprising the service name and version

HRS_SOA_SRV_VW2

(SQL View)

SOA Service Reverse Lookup

Allows a reverese lookup to find the transaction id associated with a string comprising the service name and version

SELECT HRS_TRANS_NAME , HRS_TRANSACTION_ID FROM PS_HRS_SOA_SRV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_TRANS_NAME Character(52) VARCHAR2(52) NOT NULL Transaction Name

2 HRS_TRANSACTION_ID Character(30) VARCHAR2(30) NOT NULL Transaction ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_TRANS_NAME	Character(52)	VARCHAR2(52) NOT NULL	Transaction Name
2	HRS_TRANSACTION_ID	Character(30)	VARCHAR2(30) NOT NULL	Transaction ID