GPFR_CHILD_VW (SQL View)	Index Back
Children birthdates View that retrievies children birthdates. The children are identified by the Status9 flag present in French group into Dependents/Beneficiaries page.

GPFR_CHILD_VW

(SQL View)

Children birthdates

View that retrievies children birthdates. The children are identified by the Status9 flag present in French group into Dependents/Beneficiaries page.

SELECT A.EMPLID , B.EFFDT , A.DEPENDENT_BENEF , A.BIRTHDATE FROM PS_DEPENDENT_BENEF A , PS_DEP_BENEF_FRA B WHERE A.EMPLID = B.EMPLID AND A.DEPENDENT_BENEF = B.DEPENDENT_BENEF AND B.DEP_BEN_STS_9_FRA = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default

4 BIRTHDATE Date(10) DATE Date of Birth

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
4	BIRTHDATE	Date(10)	DATE	Date of Birth