GPJP_IT_D_TX_VW (SQL View)	Index Back
Contains an EE's dependent tax This record should contain one record for each of an employee's dependents.

GPJP_IT_D_TX_VW

(SQL View)

Contains an EE's dependent tax

This record should contain one record for each of an employee's dependents.

SELECT A.EMPLID , A.DEPENDENT_BENEF , A.EFFDT , A.EMPL_RCD , A.GPJP_NO_RSDNT_RLTV FROM PS_GPJP_IT_DEP_TAX A WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_GPJP_IT_DEP_TAX A_ED WHERE A.EMPLID = A_ED.EMPLID AND A.DEPENDENT_BENEF = A_ED.DEPENDENT_BENEF AND A.EFFDT <= %CurrentDateIn)

Parent record: 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 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Prompt Table: %GP_EDIT_FLD1

5 GPJP_NO_RSDNT_RLTV Character(1) VARCHAR2(1) NOT NULL Non-Resident Relative indicator
Y/N Table Edit
Default Value: N

#	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	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: %GP_EDIT_FLD1
5	GPJP_NO_RSDNT_RLTV	Character(1)	VARCHAR2(1) NOT NULL	Non-Resident Relative indicator Y/N Table Edit Default Value: N