PSPTCSSRVDEFN

index back

Define Related Content Service

Define Related Content Service

  • Related language record: PSPTCSSRVDEFNLG
  • Parent record of PSPTCS_PARAMS
  • PeopleSoft Field Name Field Type Column Type Description
    PTCS_SERVICEID Character(30) VARCHAR2(30) NOT NULL Services ID
    PTCS_SERVICENAME Character(18) VARCHAR2(18) NOT NULL Service Name
    DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    PTCS_INITIALHEIGHT Number(3,0) SMALLINT NOT NULL Initial Height
    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

    Default: UPGE

    PTCS_SERVICETYPE Character(1) VARCHAR2(1) NOT NULL Service Type
    C=Content Reference
    G=Grouplet
    P=Pagelet
    S=Service

    Default: S

    MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).

    Prompt Table: PORTAL_NODE_VW

    PTTILECATEGORY Character(30) VARCHAR2(30) NOT NULL Fluid Content
    PORTAL_RECNAME Character(15) VARCHAR2(15) NOT NULL Record Name
    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    PC_EVENT_TYPE Character(14) VARCHAR2(14) NOT NULL PeopleCode Event Name

    Default: FieldFormula

    PC_FUNCTION_NAME Character(30) VARCHAR2(30) NOT NULL PeopleCode Function Name

    Default: IScript_

    PORTAL_MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name

    Prompt Table: PTCSMENUDEFN_VW

    PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

    Prompt Table: PTCSMENUCOMP_VW

    MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values
    PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

    Prompt Table: PTCSPNLGROUP_VW

    PORTAL_URL_ADM Long Character CLOB Portal URL
    PTPPB_PAGELET_ID Character(30) VARCHAR2(30) NOT NULL Pagelet ID

    Prompt Table: %EDITTABLE5

    PTCS_QUERYNAME Character(30) VARCHAR2(30) NOT NULL PS Query Name

    Prompt Table: %EDITTABLE4

    PORTAL_URI_TEXT Long Character(1024) VARCHAR2(1024) Portal URI Text
    PTCS_ESCAPEPARAM Character(1) VARCHAR2(1) NOT NULL Escape URL Parameters

    Y/N Table Edit

    Default: Y

    PTCS_POST_MAPDATA Character(1) VARCHAR2(1) NOT NULL Post mapping definition data

    Y/N Table Edit

    Default: N

    PTCS_SECUSEEDIT Number(10,0) DECIMAL(10) NOT NULL Field Use and Edit Flags
    USEEDIT Number(10,0) DECIMAL(10) NOT NULL Field Use and Edit Flags- USEEDIT reference
    PTCS_SRVHELPTEXT Long Character(1024) VARCHAR2(1024) Related Content Service help text
    PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

    Prompt Table: PSPACKAGROOT_VW

    QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path

    Prompt Table: PSPACKAGPATH_VW

    APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

    Prompt Table: PSPACKAGCLAS_VW

    PTCS_BULKACTION Character(1) VARCHAR2(1) NOT NULL Bulk Action
    N=No
    Y=Yes
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

    Default: 1

    LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    PTCS_SRVCATTR Character(4) VARCHAR2(4) NOT NULL Template Based

    Default: GNRL

    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 25-NOV-20