PTCS_SVC_SRCH

index back

SELECT PTCS_SERVICEID , PTCS_SERVICENAME , PTCS_SERVICEURLTYP , PTCS_BULKACTION FROM %Table(PSPTCSSRVDEFN) WHERE PTCS_SERVICETYPE = 'S'

PeopleSoft Field Name Field Type Column Type Description
PTCS_SERVICEID Character(30) VARCHAR2(30) NOT NULL Services ID (see PSPTCSSRVDEFN).
PTCS_SERVICENAME Character(18) VARCHAR2(18) NOT NULL Service Name
PTCS_SERVICEURLTYP Character(4) VARCHAR2(4) NOT NULL Service URL Type: PSFT or Non PSFT
PEP=Embeddable Pagelet
POP=OBIEE Pagelet
UAPC=Application Class
UCON=Connector URL
UEXT=Non-PeopleSoft URL
UGEN=Generic PeopleSoft URL
UPGE=Peoplesoft Component
UQRY=PeopleSoft Query
USCR=PeopleSoft Script
PTCS_BULKACTION Character(1) VARCHAR2(1) NOT NULL Bulk Action
N=No
Y=Yes
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19