GPUS_YE_EE2_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 ,A.GPUS_TAX_EIN ,A.GPUS_SEQ_NBR ,B.GPUS_TAX_EIN FROM PS_GPUS_YE_EE5_VW A ,PS_GPUS_YE_DAT 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 B.GPUS_TAX_EIN = C.GPUS_TAX_EIN AND (C.EFFDT <= %DateIn(%NumToChar(B.GPUS_CAL_YEAR) %Concat '-12-31') AND C.EFFDT >= %DateIn(%NumToChar(B.GPUS_CAL_YEAR) %Concat '-01-01'))

# 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_OTHER_EIN Character(9) VARCHAR2(9) NOT NULL Other Federal Employer Identification Number (if the company filed statements under another FEIN earlier)

Prompt Table: GPUS_DEF_EIN_VW