HR_LAY_EEST_VW

(SQL View)
 Index Back

HR - Employee Status Codes.

This new setup table defines a set of Employee status codes for Layoff/ Recall process and also allows the user to create their own user defined Employee Status codes.

SELECT A.LBR_EMP_ROST_STAT , A.DESCR , A.LBR_PRCS_STAT_FLG , A.LBR_COMP_STAT_FLG FROM PS_HR_LBR_EEST_TBL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_HR_LBR_EEST_TBL B WHERE B.LBR_EMP_ROST_STAT = A.LBR_EMP_ROST_STAT AND B.EFFDT <=%CurrentDateIn AND A.LBR_EVENT_TYPE = 'L' AND A.EFF_STATUS = 'A' AND A.LBR_COMP_STAT_FLG <> 'Y' )

  • Related Language Record: HR_LAYESTVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LBR_EMP_ROST_STAT Character(11) VARCHAR2(11) NOT NULL Employee Roster Status
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 LBR_PRCS_STAT_FLG Character(1) VARCHAR2(1) NOT NULL Process Status?
    4 LBR_COMP_STAT_FLG Character(1) VARCHAR2(1) NOT NULL Status Complete?