GPJP_DEP_BEN_VW (SQL View)	Index Back
Dependant Tax View (Lvl-1) Dependant Tax View for Page GPJP_IT_DEP_TAX level-1.

GPJP_DEP_BEN_VW

(SQL View)

Dependant Tax View (Lvl-1)

Dependant Tax View for Page GPJP_IT_DEP_TAX level-1.

SELECT EMPLID , DEPENDENT_BENEF , NAME , RELATIONSHIP , SEX , BIRTHDATE , DT_OF_DEATH FROM PS_DEPENDENT_VW

# 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

5 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec

6 BIRTHDATE Date(10) DATE Date of Birth

7 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	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
5	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
6	BIRTHDATE	Date(10)	DATE	Date of Birth
7	DT_OF_DEATH	Date(10)	DATE	Date of Death