PTCS_SVC_SRCH

index back

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

PeopleSoft Field NameField TypeColumn TypeDescription
PTCS_SERVICEIDCharacter(30)VARCHAR2(30) NOT NULLServices ID (see PSPTCSSRVDEFN).
PTCS_SERVICENAMECharacter(18)VARCHAR2(18) NOT NULLService Name
PTCS_SERVICEURLTYPCharacter(4)VARCHAR2(4) NOT NULLService 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_BULKACTIONCharacter(1)VARCHAR2(1) NOT NULLBulk Action
N=No
Y=Yes
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19