DEP_PAR_VW_UK

(SQL View)
 Index Back

UK Par Lve Dependents view

This view is used in UK Parental Leave. It brings back Dependents for whom the Eligible for Parental Leave checkbox has been selected.

SELECT EMPLID , DEPENDENT_BENEF , NAME FROM PS_DEPENDENT_VW WHERE DEP_ELIGIBLE_UK = 'Y'

  • Parent record: DEPENDENT_BENEF

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
    01=default
    3 NAME Character(50) VARCHAR2(50) NOT NULL Name