W3EB_LE_SERV_VW

(SQL View)
 Index Back

ServiceID lookup

Service ID lookup of the related content service for an action item

SELECT PTCS_SERVICEID , %Substring(DESCR254,1,40) , MARKET , PTCS_SERVICEURLTYP FROM PSPTCSSRVDEFN WHERE PTCS_SERVICEID LIKE 'EF%' AND PTCS_SERVICEID NOT LIKE '%_FL' AND PTCS_SERVICEID NOT LIKE '%_FLU'

  • Related Language Record: W3EB_LE_SR_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTCS_SERVICEID Character(30) VARCHAR2(30) NOT NULL Services ID (see PSPTCSSRVDEFN).
    2 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    3 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    4 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