W3EBENR_DEP_VW0

(SQL View)
Index Back

Dummy Dep/Ben view

This Dummy view is used as the Main Record for the Dependent/Benefici

SELECT EMPLID , DEPENDENT_BENEF FROM PS_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