PTCS_SVC_SRCH

(SQL View)
 Index Back

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

  • Related Language Record: PTCS_SVC_SRCHLG

    • # 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 PTCS_VALID_FROM Date(10) DATE Date From
    7 PTCS_VALID_TO Date(10) DATE Valid to date