ACTION_TBL_VW

(SQL View)
 Index Back

Current Actions

Contains all the ACTIONS that are possible to be applied to a JOB row. If the row is defined as SYSTEM_DATA then the user can only change the EFF_STATUS and the DESCR, DESCRSHORT. Customers can add their own Actions.

SELECT A.ACTION , A.EFF_STATUS ,A.ACTION_DESCR ,A.ACTION_DESCRSHORT ,S.HR_STATUS ,S.EMPL_STATUS ,S.PEN_EMPL_STATUS ,S.HR_STATUS_VALID ,S.EMPL_STATUS_VALID ,S.PER_ORG_VALID ,S.SET_STATUS_FLG ,S.SET_HIRE_DT ,S.SET_LST_HIRE_DT ,S.SET_TERM_DT ,S.SET_ASGN_ST_DT ,S.SET_ASGN_LST_DT ,S.SET_ASGN_END_DT ,S.SET_LDW ,S.SET_EXP_END_DT ,S.SET_EXP_RTRN_DT ,S.MESSAGE_SET_NBR ,S.MESSAGE_NBR ,A.OBJECTOWNERID FROM PS_ACTION_TBL A , PS_ACTION_STAT_TBL S WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ACTION_TBL B WHERE A.ACTION = B.ACTION AND B.EFFDT <= %CurrentDateIn) AND A.ACTION = S.ACTION

  • Related Language Record: ACTIONVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: ACTION_TBL

    2 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    3 ACTION_DESCR Character(50) VARCHAR2(50) NOT NULL Action Description
    4 ACTION_DESCRSHORT Character(30) VARCHAR2(30) NOT NULL Short Description for an Action
    5 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
    A=Active
    I=Inactive
    6 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
    A=Active
    D=Deceased
    L=Leave of Absence
    P=Leave With Pay
    Q=Retired With Pay
    R=Retired
    S=Suspended
    T=Terminated
    U=Terminated With Pay
    V=Terminated Pension Pay Out
    W=Short Work Break
    X=Retired-Pension Administration
    7 PEN_EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Employee Status
    X=Retired - Pension Administrati
    8 HR_STATUS_VALID Character(1) VARCHAR2(1) NOT NULL Used to determine if a particular Action is valid in the JOB entry if the Previous HR Status (EFF_STATUS) is equal to this value.
    A=Active
    I=Inactive
    9 EMPL_STATUS_VALID Character(1) VARCHAR2(1) NOT NULL Used to determine if a particular Action is valid in the JOB entry if the Previous Pay Status (EMPL_STATUS) is equal to this value.
    0=S - Suspended
    1=W - Short Work Break
    2=P/L - Any Leave
    3=P/L - Disability Leave
    4=Act, Leave, Sus, Ret, SWB
    5=Act, Leave, Sus, Ret, SWB, TWP
    10 PER_ORG_VALID Character(1) VARCHAR2(1) NOT NULL Used to determine if a particular Action is valid in the JOB entry PER_ORG for the PER_ORG_ASGN row is this value.
    0=EMP, CWR or POI
    1=Employee Only
    2=Contingent Worker only
    3=Contingent Worker or POI
    4=Person of Interest Only
    5=Employee or Contingent Worker
    11 SET_STATUS_FLG Character(1) VARCHAR2(1) NOT NULL Action sets Status Fields

    Y/N Table Edit

    Default Value: N

    12 SET_HIRE_DT Character(1) VARCHAR2(1) NOT NULL Indicate whether the Action will set the PER_ORG_INST.HIRE_DT
    0=No Action
    2=JOB.EFFDT

    Default Value: 0

    13 SET_LST_HIRE_DT Character(1) VARCHAR2(1) NOT NULL Indicate whether the Action will set the PER_ORG_INST.LST_HIRE_DT
    0=No Action
    2=JOB.EFFDT

    Default Value: 0

    14 SET_TERM_DT Character(1) VARCHAR2(1) NOT NULL Indicate whether the Action will set the PER_ORG_INST_TERMINATON_DT
    0=No Action
    1=Clear
    3=JOB.EFFDT - 1

    Default Value: 0

    15 SET_ASGN_ST_DT Character(1) VARCHAR2(1) NOT NULL Indicate whether the Action will set the PER_ORG_INST_TERMINATON_DT
    0=No Action
    2=JOB.EFFDT

    Default Value: 0

    16 SET_ASGN_LST_DT Character(1) VARCHAR2(1) NOT NULL Indicate whether the Action will set the PER_ORG_ASGN.SET_LST_START_DT
    0=No Action
    2=JOB.EFFDT

    Default Value: 0

    17 SET_ASGN_END_DT Character(1) VARCHAR2(1) NOT NULL Indicate whether the Action will set the PER_ORG_ASGN.SET_ASGN_END_DT
    0=No Action
    1=Clear
    3=JOB.EFFDT -1

    Default Value: 0

    18 SET_LDW Character(1) VARCHAR2(1) NOT NULL Indicate whether the Action will set the JOB.LAST_DATE_WORKED
    0=No Action
    1=Clear
    3=JOB.EFFDT - 1

    Default Value: 0

    19 SET_EXP_END_DT Character(1) VARCHAR2(1) NOT NULL Indicate whether the Action will set the JOB_DATES.EXPECTED_END_DT
    0=No Action
    1=Clear
    20 SET_EXP_RTRN_DT Character(1) VARCHAR2(1) NOT NULL Indicate whether the Action will set the JOB_DATES.EXPECTED_RETURN_DT
    0=No Action
    1=Clear
    21 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    22 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    23 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier