HRS_SOA_SRV_VW

(SQL View)
Index Back

SOA Service View

View of Open Integration SOA Services

SELECT HRS_TRANSACTION_ID , HRS_TRANS_NAME , DESCR254 , HRS_SERVICE_DIR , HRS_APPCLASSNAME FROM PS_HRS_SOA_SRV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_TRANSACTION_ID Character(30) VARCHAR2(30) NOT NULL Transaction ID
2 HRS_TRANS_NAME Character(52) VARCHAR2(52) NOT NULL Transaction Name
3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
4 HRS_SERVICE_DIR Character(3) VARCHAR2(3) NOT NULL Used to translate from the SOA framework from Local and Remote to Incoming and outgoing messages.
LCL=Incoming
RMT=Outgoing
5 HRS_APPCLASSNAME Character(190) VARCHAR2(190) NOT NULL Used to represent an application class as a single string. Usually RTRIM(PACKAGEROOT) + ':' + RTRIM(QUALIFYPATH) + ':' + RTRIM(APPCLASSID)

Prompt Table: HRS_APPCLASS_PT