PTCS_SVC_SRCHLG

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
    1 PTCS_SERVICEID Character(30) VARCHAR2(30) NOT NULL Services ID (see PSPTCSSRVDEFN).
    2 PTCS_SERVICENAME Character(18) VARCHAR2(18) NOT NULL Service Name
    3 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
    4 PTCS_BULKACTION Character(1) VARCHAR2(1) NOT NULL Bulk Action
    N=No
    Y=Yes
    5 PTCS_SRVCATTR Character(4) VARCHAR2(4) NOT NULL Template Based
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code