PTCS_SVC_SRCHLG

 index back

SELECT A.PTCS_SERVICEID , B.PTCS_SERVICENAME , A.PTCS_SERVICEURLTYP , A.PTCS_BULKACTION , A.PTCS_SRVCATTR , B.LANGUAGE_CD FROM %Table(PSPTCSSRVDEFN) A , %Table(PSPTCSSRVDEFNLG) B WHERE A.PTCS_SERVICEID=B.PTCS_SERVICEID AND A.PTCS_SERVICETYPE = 'S'

  • Related language record for PTCS_SVC_SRCH

    • 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
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20