FO_SOA_SRV_VW (SQL View)	Index Back
SOA Service View View of Open Integration SOA Services

FO_SOA_SRV_VW

(SQL View)

SOA Service View

View of Open Integration SOA Services

SELECT FO_TRANSACT_ID , FO_TRANS_NAME , DESCR254 , FO_SERVICE_DIR , FO_APPCLASSNAME FROM PS_FO_SOA_SRV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FO_TRANSACT_ID Character(30) VARCHAR2(30) NOT NULL Transaction ID

2 FO_TRANS_NAME Character(52) VARCHAR2(52) NOT NULL Transaction Name

3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

4 FO_SERVICE_DIR Character(3) VARCHAR2(3) NOT NULL Used to translate from the SOA framework from Local and Remote to Incoming and outgoing messages.

5 FO_APPCLASSNAME Character(190) VARCHAR2(190) NOT NULL Used to represent an application class as a single string. Usually RTRIM(PACKAGEROOT) + ':' + RTRIM(QUALIFYPATH) + ':' + RTRIM(APPCLASSID)

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