GPFR_ABS_DEP_VW (SQL View)	Index Back
Absence Dependent Counter Counts of dependents and beneficiaries for absence

GPFR_ABS_DEP_VW

(SQL View)

Absence Dependent Counter

Counts of dependents and beneficiaries for absence

SELECT A.EMPLID , A.EFFDT , C.DEPENDENT_BENEF , C.BIRTHDATE , C.DT_OF_DEATH FROM PS_GPFR_NB_DEP_VW A , PS_DEP_BENEF_FRA B , PS_DEP_BEN C WHERE A.EMPLID = B.EMPLID AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_DEP_BENEF_FRA D WHERE B.EMPLID = D.EMPLID AND B.DEPENDENT_BENEF = D.DEPENDENT_BENEF AND D.EFFDT <= A.EFFDT) AND B.DEP_BEN_STS_10_FRA = 'Y' AND B.EMPLID = C.EMPLID AND B.DEPENDENT_BENEF = C.DEPENDENT_BENEF

# 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

5 DT_OF_DEATH Date(10) DATE Date of Death

#	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
5	DT_OF_DEATH	Date(10)	DATE	Date of Death