PTCS_EVMAP_CFGS

(SQL View)
 Index Back

SELECT portal_name ,portal_objname ,ptcs_serviceid ,ptcs_instanceid ,ptcs_iscompservice ,pnlname , recname , fieldname ,ptcs_cmpevent , ptcs_cmprecevent ,ptcs_procseq ,ptcs_enable ,seqnum FROM PSPTCSSRVCONF WHERE portal_name LIKE '_PTCS_PTEVMAP'

  • Parent record: PSPTCS_SRVCFG

    • # 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 Event Type
    C=Services at Component Level
    F=Event Mapping Comp Rec Fld
    P=Services at Page level
    R=Event Mapping at Comp Rec
    6 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

    Prompt Table: PTCS_PNLLST_DVW

    7 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PTCS_RECVW

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

    Prompt Table: PTCS_RECFLDDVW

    9 PTCS_CMPEVENT Character(4) VARCHAR2(4) NOT NULL Event Name
    POST=PostBuild
    PRE=PreBuild
    SPOS=SavePostChange
    SPRE=SavePreChange
    WFLO=Workflow
    10 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
    11 PTCS_PROCSEQ Character(4) VARCHAR2(4) NOT NULL Processing Sequence
    OVER=Override/Replace
    POST=Post Process
    PRE=Pre Process

    Default Value: PRE

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

    Y/N Table Edit

    Default Value: Y

    13 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number