GPAR_DEP_GAN_VW (SQL View)	Index Back
Dependent Income Tax Dependent Income Tax

GPAR_DEP_GAN_VW

(SQL View)

Dependent Income Tax

SELECT DISTINCT A.EMPLID , A.EFFDT , A.DEPENDENT_BENEF , A.INC_TAX_DEPEN_ARG , A.INC_TAX_BGNDT_ARG , A.INC_TAX_ENDDT_ARG , A.TAX_DEPEND_DED_ARG , C.DISABLED FROM PS_DEP_BENEF_ARG A ,PS_DEP_BEN_EFF C WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_DEP_BENEF_ARG B WHERE B.EMPLID = A.EMPLID AND B.DEPENDENT_BENEF = A.DEPENDENT_BENEF) AND A.EMPLID=C.EMPLID AND C.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_DEP_BEN_EFF B WHERE B.EMPLID = A.EMPLID AND B.DEPENDENT_BENEF = A.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 NOT NULL Effective Date
Default Value: %date

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

4 INC_TAX_DEPEN_ARG Character(1) VARCHAR2(1) NOT NULL Eligible for Income Tax
C=Child
O=Other Dependents
S=Spouse/Domestic Partner Adult

5 INC_TAX_BGNDT_ARG Date(10) DATE Income Tax Begin Date

6 INC_TAX_ENDDT_ARG Date(10) DATE Income Tax End Date

7 TAX_DEPEND_DED_ARG Character(3) VARCHAR2(3) NOT NULL Tax Dependent Deduction
050=50%
100=100%

8 DISABLED Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a dependent is a disabled.

#	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 NOT NULL	Effective Date Default Value: %date
3	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
4	INC_TAX_DEPEN_ARG	Character(1)	VARCHAR2(1) NOT NULL	Eligible for Income Tax C=Child O=Other Dependents S=Spouse/Domestic Partner Adult
5	INC_TAX_BGNDT_ARG	Date(10)	DATE	Income Tax Begin Date
6	INC_TAX_ENDDT_ARG	Date(10)	DATE	Income Tax End Date
7	TAX_DEPEND_DED_ARG	Character(3)	VARCHAR2(3) NOT NULL	Tax Dependent Deduction 050=50% 100=100%
8	DISABLED	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a dependent is a disabled.