HR_LAY_SRCH_VW

(SQL View)
 Index Back

HR - Layoff Search Record.

Search Record for Layoff.

SELECT R.LBR_ROSTER_ID , RD.DESCR50 , R.LBR_ROST_STATUS_CD , RD.LBR_ROSTER_TYPE , RD.SETID , RD.LABOR_AGREEMENT FROM PS_HR_LBR_ROSTER R , PS_HR_LBR_ROSTDATA RD WHERE R.LBR_EVENT_TYPE = 'L' AND R.LBR_ROSTER_ID = RD.LBR_ROSTER_ID AND EFFDT = ( SELECT MAX(EFFDT) FROM PS_HR_LBR_ROSTDATA RD1 WHERE RD.LBR_ROSTER_ID = RD1.LBR_ROSTER_ID)

  • Related Language Record: HR_LAYSRCVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LBR_ROSTER_ID Character(11) VARCHAR2(11) NOT NULL Roster ID
    2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    3 LBR_ROST_STATUS_CD Character(3) VARCHAR2(3) NOT NULL Roster Status
    010=010 - Open
    020=020 - In Progress
    030=030 - Awaiting Approval
    040=040 - Approved
    050=050 - Not Approved
    060=060 - On Hold
    070=070 - Final
    090=090 - Cancelled
    100=100 - Closed
    4 LBR_ROSTER_TYPE Character(4) VARCHAR2(4) NOT NULL Roster Type
    PERM=Permanent
    RECL=Recall
    REIN=Reinstatement
    TEMP=Temporary

    Prompt Table: HR_LAY_TYP_VW

    5 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    6 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

    Prompt Table: HR_LABOR_AGRMNT