PY_NY_TXGRCM_VW (SQL View)	Index Back
Taxable Gross Comp ID State VW Taxable Gross Comp ID State View

PY_NY_TXGRCM_VW

(SQL View)

Taxable Gross Comp ID State VW

Taxable Gross Comp ID State View

SELECT A.STATE ,A.TAX_GRS_TYPE ,A.TAX_GRS_COMPNT FROM PS_TAXGR_CMPNT_TBL A WHERE A.TAX_GRS_EFFECT ='S' AND A.TAX_GRS_TYPE='W' AND A.LOCALITY=' ' AND A.STATE='NY' AND A.EFFDT=( SELECT MAX (C.EFFDT) FROM PS_TAXGR_CMPNT_TBL C WHERE C.STATE=A.STATE AND C.LOCALITY=A.LOCALITY AND C.EFFDT=A.EFFDT AND C.TAX_GRS_TYPE=A.TAX_GRS_TYPE AND C.TAX_GRS_COMPNT=A.TAX_GRS_COMPNT AND C.PLAN_TYPE=A.PLAN_TYPE AND C.DEDCD=A.DEDCD)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STATE Character(6) VARCHAR2(6) NOT NULL State

2 TAX_GRS_TYPE Character(1) VARCHAR2(1) NOT NULL Taxable Gross
D=Disability
U=Unemployment
W=Withholding

3 TAX_GRS_COMPNT Character(5) VARCHAR2(5) NOT NULL Taxable gross component ID.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
2	TAX_GRS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Taxable Gross D=Disability U=Unemployment W=Withholding
3	TAX_GRS_COMPNT	Character(5)	VARCHAR2(5) NOT NULL	Taxable gross component ID.