W3EB_EVNT_STEPS

(SQL View)
 Index Back

Life Event step summary

Shows a summary of the steps in a Life Event as well as the status of each step for an employee.

SELECT A.OBJNAME , A.OBJTYPE , A.COMPNAME , A.COMPTYPE , B.ACTIVITYNAME , B.STEPNAME , A.DESCR60 , A.DESCRLONG , B.STEPNO , B.PATHNO , B.CONTNAME , B.CONTNAMEDISABLE , B.CONTNAMEWORK , B.CONTNAMEPROC , B.MENUNAME , B.BARNAME , B.ITEMNAME , B.PANELITEMNAME , B.DFLTACTION FROM PSBUSPROCITEM A , PSSTEPDEFN B WHERE A.OBJNAME = B.ACTIVITYNAME AND A.OBJTYPE = 1 AND A.COMPNAME = B.STEPNAME AND A.COMPTYPE= 6

  • Related Language Record: W3EB_EVTSTPLANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OBJNAME Character(30) VARCHAR2(30) NOT NULL Object Name
    2 OBJTYPE Number(2,0) SMALLINT NOT NULL Object Type
    3 COMPNAME Character(30) VARCHAR2(30) NOT NULL Component Name
    4 COMPTYPE Number(2,0) SMALLINT NOT NULL Component Type
    5 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
    6 STEPNAME Character(30) VARCHAR2(30) NOT NULL Step Name
    7 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    8 DESCRLONG Long Character CLOB Long Description
    9 STEPNO Number(5,0) INTEGER NOT NULL Step Number
    10 PATHNO Number(5,0) INTEGER NOT NULL Path Number
    11 CONTNAME Character(30) VARCHAR2(30) NOT NULL Content Name
    12 CONTNAMEDISABLE Character(30) VARCHAR2(30) NOT NULL Content Name Disabled
    13 CONTNAMEWORK Character(30) VARCHAR2(30) NOT NULL Content name when worked
    14 CONTNAMEPROC Character(30) VARCHAR2(30) NOT NULL Processing image
    15 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
    16 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
    17 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
    18 PANELITEMNAME Character(30) VARCHAR2(30) NOT NULL Panel Item Name
    19 DFLTACTION Number(5,0) INTEGER NOT NULL Default srch action-internet