GPUS_YE_TXBX_VW

(SQL View)
 Index Back

Tax Box View

Tax Box View for the Year End Reports

SELECT A.GPUS_TAXFORM_ID , A.GPUS_TAXFORM_BOX , A.DESCR FROM PS_GPUS_YE_TXBOX A WHERE A.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_GPUS_YE_TXBOX E , PS_GPUS_YE_EE0_VW B WHERE A.GPUS_TAXFORM_ID = E.GPUS_TAXFORM_ID AND A.GPUS_TAXFORM_BOX = E.GPUS_TAXFORM_BOX AND (E.EFFDT <= %DateIn(%NumToChar(B.GPUS_CAL_YEAR) %Concat '-12-31')))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPUS_TAXFORM_ID Character(3) VARCHAR2(3) NOT NULL Tax Form ID
10=W-2
110=W-2c
120=W-2cAS
130=W-2cGU
140=W-2cPR
150=W-2cVI
20=W-2AS
30=W-2GU
40=W-2PR
50=W-2VI
2 GPUS_TAXFORM_BOX Character(4) VARCHAR2(4) NOT NULL Tax Form Box
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description