HR_LAY_TEMP_VW

(SQL View)
Index Back

HR - Layoff Prompt Record.

Prompt Record for Layoff to be used in Recall/Reinstatement Roster.

SELECT A.LBR_ROSTER_ID , B.EFFDT , B.DESCR50 , B.LBR_ROSTER_TYPE , B.SETID , B.LABOR_AGREEMENT FROM PS_HR_LBR_ROSTER A , PS_HR_LBR_ROSTDATA B WHERE A.LBR_EVENT_TYPE = 'L' AND A.LBR_ROST_STATUS_CD <> '010' AND B.LBR_ROSTER_TYPE = 'TEMP' AND B.LBR_ROSTER_ID = A.LBR_ROSTER_ID AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_HR_LBR_ROSTDATA C WHERE C.LBR_ROSTER_ID = B.LBR_ROSTER_ID)

  • Related Language Record: HR_LAY_GTVW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LBR_ROSTER_ID Character(11) VARCHAR2(11) NOT NULL Roster ID
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    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
    6 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

    Prompt Table: EMPL_CTG_L1_VW