HR_RCLESTVW_LNG

(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.LANGUAGE_CD , A.DESCR FROM PS_HR_LBR_EEST_LNG A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_HR_LBR_EEST_LNG B WHERE B.LBR_EMP_ROST_STAT = A.LBR_EMP_ROST_STAT AND B.EFFDT <=%CurrentDateIn)

  • Related Language Record for HR_RCL_EESTY_VW HR_RCL_EEST_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description