HR_LBR_TIE_VW

(SQL View)
 Index Back

HR-Labor Tiebreaker View

This view is a prompt record used in Layoff/ Recall Roster Setup pages to access Tiebreaker Types attached to the selected Labor Agreement.

SELECT A.SETID , A.LABOR_AGREEMENT , A.TIEBREAKER_ID , B.DESCR FROM PS_HR_LBR_TIEBREAK A , PS_HR_TIEBREAK_TBL B WHERE A.TIEBREAKER_ID = B.TIEBREAKER_ID AND B.EFFDT = ( SELECT MAX (D.EFFDT) FROM PS_HR_TIEBREAK_TBL D WHERE D.TIEBREAKER_ID = B.TIEBREAKER_ID AND D.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX (C.EFFDT) FROM PS_HR_LBR_TIEBREAK C WHERE C.SETID = A.SETID AND C.LABOR_AGREEMENT = A.LABOR_AGREEMENT AND C.EFFDT <= %CurrentDateIn)

  • Related Language Record: HR_LBRTIEVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement
    3 TIEBREAKER_ID Character(11) VARCHAR2(11) NOT NULL Tie Breaker ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description