PTCSPG_SVC_VW

index back

SELECT PORTAL_NAME , PORTAL_OBJNAME , PTCS_SERVICEID , PTCS_INSTANCEID , PTCS_ISCOMPSERVICE , PNLNAME , SEQNUM , PTCS_HIDEFROMSRCH , IS_DEFAULT , PTCS_MAPSECOPTIONS , HANDLERNAME , PTCS_INSTANCELBL , PTCS_URLTARGET , PTCS_RCMENUOPT , PTCS_MAINMENUOPT , PTCS_SEQNUM_MMNU , PTCS_SEQNUM_RMNU , PACKAGEROOT , QUALIFYPATH , APPCLASSID , PTCS_INITMIN , PTCS_ENABLE , PTCS_SRVOPENOPTION , PTCS_EMBEDDABLE , PTCS_SUOWSERV , VERSION , LASTUPDDTTM , LASTUPDOPRID , OBJECTOWNERID , PTCS_SRVCATTR , OPRID , PTCS_MASTERTMPL , RECNAME , PTCS_CMPEVENT , PTCS_PROCSEQ , PTCS_CMPRECEVENT , PTCS_ALLOWPERSONAL , FIELDNAME FROM %Table(PSPTCSSRVCONF) WHERE PORTAL_NAME = '_PTCS_PTPG'

  • Related language record: PTCSPG_SVC_LVW
  • PeopleSoft Field Name Field Type Column Type Description
    PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).

    Default: _PTCS_PTPG

    PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    PTCS_SERVICEID Character(30) VARCHAR2(30) NOT NULL Services ID (see PSPTCSSRVDEFN).

    Prompt Table: PSPTCSSRVDEFN

    PTCS_INSTANCEID Number(10,0) DECIMAL(10) NOT NULL Instance ID
    PTCS_ISCOMPSERVICE Character(1) VARCHAR2(1) NOT NULL Component Service
    C=Services at Component Level
    F=Event Mapping Comp Rec Fld
    P=Services at Page level
    R=Event Mapping at Comp Rec

    Default: C

    PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

    Prompt Table: PTCS_PNLLST_DVW

    SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    PTCS_HIDEFROMSRCH Character(1) VARCHAR2(1) NOT NULL Private Data

    Y/N Table Edit

    Default: N

    IS_DEFAULT Character(1) VARCHAR2(1) NOT NULL Default Template
    N=No
    Y=Yes

    Y/N Table Edit

    Default: N

    PTCS_MAPSECOPTIONS Character(1) VARCHAR2(1) NOT NULL Security options to display Map fields page
    P=Public Access
    R=Related Content Security
    T=Transaction Security
    HANDLERNAME Character(30) VARCHAR2(30) NOT NULL Handler Name
    PTCS_INSTANCELBL Character(50) VARCHAR2(50) NOT NULL Service Label
    PTCS_URLTARGET Character(4) VARCHAR2(4) NOT NULL Service Target
    MDLW=Modal Window
    NWIN=New Window
    RCF=Related Content
    SRCF=Right Frame
    TGTF=Target Content
    TOPF=Replace Window
    USRD=User Defined

    Default: TGTF

    PTCS_RCMENUOPT Character(1) VARCHAR2(1) NOT NULL Related Content Menu
    N=No
    Y=Yes

    Default: N

    PTCS_MAINMENUOPT Character(1) VARCHAR2(1) NOT NULL Related Actions Menu
    N=No
    Y=Yes

    Default: Y

    PTCS_SEQNUM_MMNU Number(3,0) SMALLINT NOT NULL Sequence Number
    PTCS_SEQNUM_RMNU Number(3,0) SMALLINT NOT NULL Sequence Number
    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_INITMIN Character(1) VARCHAR2(1) NOT NULL Initially Minimized

    Y/N Table Edit

    PTCS_ENABLE Character(1) VARCHAR2(1) NOT NULL Enable

    Y/N Table Edit

    Default: Y

    PTCS_SRVOPENOPTION Character(4) VARCHAR2(4) NOT NULL Modal Window
    RIFM=Rel Info Fluid Modal
    PTCS_EMBEDDABLE Character(1) VARCHAR2(1) NOT NULL Embeddable
    PTCS_SUOWSERV Character(1) VARCHAR2(1) NOT NULL Single Unit of Work
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    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
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    PTCS_MASTERTMPL Character(30) VARCHAR2(30) NOT NULL Master Template
    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    PTCS_CMPEVENT Character(4) VARCHAR2(4) NOT NULL Event Name
    POST=PostBuild
    PRE=PreBuild
    SPOS=SavePostChange
    SPRE=SavePreChange
    WFLO=Workflow
    PTCS_PROCSEQ Character(4) VARCHAR2(4) NOT NULL Processing Sequence
    POST=Post Process
    PRE=Pre Process
    PTCS_CMPRECEVENT Character(4) VARCHAR2(4) NOT NULL Event Name
    PACT=Activate
    RDEL=RowDelete
    RFCH=FieldChange
    RFDT=FieldDefault
    RFED=FieldEdit
    RINI=RowInit
    RINS=RowInsert
    RSEL=RowSelect
    SEDT=SaveEdit
    SINT=SearchInit
    SPOS=SavePostChange
    SPRE=SavePreChange
    SSVE=SearchSave
    PTCS_ALLOWPERSONAL Character(1) VARCHAR2(1) NOT NULL Personalization Flag
    N=No Personalization
    Y=Yes Personalization

    Default: Y

    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20