GPJP_YEA_DPSRCH (SQL View)	Index Back
Srch record used for YEA SS Search record used for YEA Self Service

GPJP_YEA_DPSRCH

(SQL View)

Srch record used for YEA SS

Search record used for YEA Self Service

SELECT A.EMPLID ,A.DEPENDENT_BENEF ,A.NAME ,A.RELATIONSHIP FROM PS_DEPENDENT_VW A , PS_GPJP_IT_DEP_TAX B WHERE A.EMPLID=B.EMPLID AND A.DEPENDENT_BENEF = B.DEPENDENT_BENEF AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_GPJP_IT_DEP_TAX C WHERE 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 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

4 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee

#	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
4	RELATIONSHIP	Character(2)	VARCHAR2(2) NOT NULL	Relationship to Employee