PSPTCSSRVDEFN

index back

Define Related Content Service

Define Related Content Service

  • Related language record: PSPTCSSRVDEFNLG
  • Parent record of PSPTCS_PARAMS
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTCS_SERVICEIDCharacter(30)VARCHAR2(30) NOT NULLServices ID
    PTCS_SERVICENAMECharacter(18)VARCHAR2(18) NOT NULLService Name
    DESCR254Character(254)VARCHAR2(254) NOT NULLDescription of length 254
    PTCS_INITIALHEIGHTNumber(3,0)SMALLINT NOT NULLInitial Height
    PTCS_SERVICEURLTYPCharacter(4)VARCHAR2(4) NOT NULLService URL Type: PSFT or Non PSFT
    PEP=Embeddable Pagelet
    POP=OBIEE Pagelet
    UAPC=Application Class
    UCON=Connector URL
    UEXT=Non-PeopleSoft URL
    UGEN=Generic PeopleSoft URL
    UPGE=Peoplesoft Component
    UQRY=PeopleSoft Query
    USCR=PeopleSoft Script

    Default: UPGE

    PTCS_SERVICETYPECharacter(1)VARCHAR2(1) NOT NULLService Type
    C=Content Reference
    P=Pagelet
    S=Service

    Default: S

    MSGNODENAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).

    Prompt Table: PORTAL_NODE_VW

    PORTAL_RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord Name
    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
    PC_EVENT_TYPECharacter(14)VARCHAR2(14) NOT NULLPeopleCode Event Name

    Default: FieldFormula

    PC_FUNCTION_NAMECharacter(30)VARCHAR2(30) NOT NULLPeopleCode Function Name

    Default: IScript_

    PORTAL_MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name

    Prompt Table: PTCSMENUDEFN_VW

    PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name

    Prompt Table: PTCSMENUCOMP_VW

    MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values
    PNLNAMECharacter(30)VARCHAR2(30) NOT NULLPage Name (see PSPNLDEFN).

    Prompt Table: PTCSPNLGROUP_VW

    PORTAL_URL_ADMLong CharacterCLOBPortal URL
    PTPPB_PAGELET_IDCharacter(30)VARCHAR2(30) NOT NULLPagelet ID

    Prompt Table: %EDITTABLE5

    PTCS_QUERYNAMECharacter(30)VARCHAR2(30) NOT NULLPS Query Name

    Prompt Table: %EDITTABLE4

    PORTAL_URI_TEXTLong Character(1024)VARCHAR2(1024)Portal URI Text
    PTCS_ESCAPEPARAMCharacter(1)VARCHAR2(1) NOT NULLEscape URL Parameters

    Y/N Table Edit

    Default: Y

    PTCS_POST_MAPDATACharacter(1)VARCHAR2(1) NOT NULLPost mapping definition data

    Y/N Table Edit

    Default: N

    PTCS_SECUSEEDITNumber(10,0)DECIMAL(10) NOT NULLField Use and Edit Flags
    USEEDITNumber(10,0)DECIMAL(10) NOT NULLField Use and Edit Flags- USEEDIT reference
    PTCS_SRVHELPTEXTLong Character(1024)VARCHAR2(1024)Related Content Service help text
    PACKAGEROOTCharacter(30)VARCHAR2(30) NOT NULLRoot Package ID

    Prompt Table: PSPACKAGROOT_VW

    QUALIFYPATHCharacter(127)VARCHAR2(127) NOT NULLQualified Package/Class Path

    Prompt Table: PSPACKAGPATH_VW

    APPCLASSIDCharacter(30)VARCHAR2(30) NOT NULLApplication Class ID

    Prompt Table: PSPACKAGCLAS_VW

    PTCS_BULKACTIONCharacter(1)VARCHAR2(1) NOT NULLBulk Action
    N=No
    Y=Yes
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference

    Default: 1

    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.
    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19