GPUS_YE_EE1_VW

(SQL View)
 Index Back

Year End Employee Data View

Year End Employee Data View

SELECT A.EMPLID ,A.GPUS_CAL_YEAR ,A.GPUS_TAXFORM_ID ,A.GPUS_YE_RPT_CO ,C.GPUS_TAX_EIN ,A.GPUS_SEQ_NBR ,B.GPUS_TAXFORM_BOX ,B.STATE ,SUM(B.GPUS_YE_AMOUNT) FROM PS_GPUS_YE_EE5_VW A ,PS_GPUS_YE_AMOUNTS B ,PS_GPUS_YE_CO_EIN C WHERE A.EMPLID = B.EMPLID AND A.GPUS_CAL_YEAR = B.GPUS_CAL_YEAR AND A.GPUS_TAXFORM_ID = B.GPUS_TAXFORM_ID AND A.GPUS_SEQ_NBR = B.GPUS_SEQ_NBR AND A.GPUS_YE_RPT_CO = C.GPUS_YE_RPT_CO AND C.GPUS_TAX_EIN = B.GPUS_TAX_EIN AND (C.EFFDT <= %DateIn(%NumToChar(A.GPUS_CAL_YEAR) %Concat '-12-31') AND C.EFFDT >= %DateIn(%NumToChar(A.GPUS_CAL_YEAR) %Concat '-01-01')) GROUP BY A.EMPLID , A.GPUS_CAL_YEAR ,C.GPUS_TAX_EIN ,A.GPUS_TAXFORM_ID ,A.GPUS_YE_RPT_CO ,A.GPUS_SEQ_NBR ,B.GPUS_TAXFORM_BOX ,B.STATE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: GP_PERS_SRCH

2 GPUS_CAL_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
3 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
4 GPUS_YE_RPT_CO Character(3) VARCHAR2(3) NOT NULL Year-End Reporting Company

Prompt Table: GPUS_RPT_CO_VW

5 GPUS_TAX_EIN Character(9) VARCHAR2(9) NOT NULL Federal Employer Identification Number
6 GPUS_SEQ_NBR Number(3,0) SMALLINT NOT NULL Sequesnce Number
7 GPUS_TAXFORM_BOX Character(4) VARCHAR2(4) NOT NULL Tax Form Box
8 STATE Character(6) VARCHAR2(6) NOT NULL State
9 GPUS_YE_AMOUNT Signed Number(12,2) DECIMAL(10,2) NOT NULL Amount