PTCS_SVC_SRCH

index back

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

  • Related language record: PTCS_SVC_SRCHLG
  • 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
    UESP=Embeddable SubPage
    UEXT=Non-PeopleSoft URL
    UGEN=Generic PeopleSoft URL
    UPGE=Peoplesoft Component
    UQRY=PeopleSoft Query
    USCR=PeopleSoft Script
    UTIL=PeopleSoft Tile
    PTCS_BULKACTION Character(1) VARCHAR2(1) NOT NULL Bulk Action
    N=No
    Y=Yes
    PTCS_SRVCATTR Character(4) VARCHAR2(4) NOT NULL Template Based
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20