PTCS_SVCPRA_VW

(SQL View)
 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 PTCS_ISCOMPSERVICE = 'P' AND PTCS_URLTARGET <> 'RCF'

  • Related Language Record: PTCS_SVCPRALVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    2 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    3 PTCS_SERVICEID Character(30) VARCHAR2(30) NOT NULL Services ID (see PSPTCSSRVDEFN).

    Prompt Table: PSPTCSSRVDEFN

    4 PTCS_INSTANCEID Number(10,0) DECIMAL(10) NOT NULL Instance ID
    5 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 Value: P

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

    Prompt Table: PTCS_PNLLST_DVW

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    10 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
    11 HANDLERNAME Character(30) VARCHAR2(30) NOT NULL Handler Name
    12 PTCS_INSTANCELBL Character(50) VARCHAR2(50) NOT NULL Service Label
    13 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 Value: TGTF

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

    Default Value: N

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

    Default Value: N

    16 PTCS_SEQNUM_MMNU Number(3,0) SMALLINT NOT NULL Sequence Number
    17 PTCS_SEQNUM_RMNU Number(3,0) SMALLINT NOT NULL Sequence Number
    18 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

    Prompt Table: PSPACKAGROOT_VW

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

    Prompt Table: PSPACKAGPATH_VW

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

    Prompt Table: PSPACKAGCLAS_VW

    21 PTCS_INITMIN Character(1) VARCHAR2(1) NOT NULL Initially Minimized

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: Y

    23 PTCS_SRVOPENOPTION Character(4) VARCHAR2(4) NOT NULL Modal Window
    RIFM=Rel Info Fluid Modal
    24 PTCS_EMBEDDABLE Character(1) VARCHAR2(1) NOT NULL Embeddable

    Y/N Table Edit

    25 PTCS_SUOWSERV Character(1) VARCHAR2(1) NOT NULL Single Unit of Work
    26 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    27 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.
    28 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.
    29 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    30 PTCS_SRVCATTR Character(4) VARCHAR2(4) NOT NULL Template Based
    31 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    32 PTCS_MASTERTMPL Character(30) VARCHAR2(30) NOT NULL Master Template
    33 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    34 PTCS_CMPEVENT Character(4) VARCHAR2(4) NOT NULL Event Name
    POST=PostBuild
    PRE=PreBuild
    SPOS=SavePostChange
    SPRE=SavePreChange
    WFLO=Workflow
    35 PTCS_PROCSEQ Character(4) VARCHAR2(4) NOT NULL Processing Sequence
    OVER=Override/Replace
    POST=Post Process
    PRE=Pre Process
    36 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
    37 PTCS_ALLOWPERSONAL Character(1) VARCHAR2(1) NOT NULL Personalization Flag
    N=No Personalization
    Y=Yes Personalization

    Default Value: Y

    38 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).