PY_SS_1099R_VW (SQL View)	Index Back
1099-R Forms for SS This view will select year-end forms from guide table that meet the settings in 1099-R Form Options page.

PY_SS_1099R_VW

(SQL View)

1099-R Forms for SS

This view will select year-end forms from guide table that meet the settings in 1099-R Form Options page.

SELECT DISTINCT D.OPRID ,A.EMPLID ,A.PY_TAX_YEAR ,A.W2_REPORTING_CO FROM PS_PY_SS_1099_GDE A , PS_PY_YEO_CO_1099R B , PSOPRDEFN D WHERE A.YE_FORM_VIEWING_DT <= %CurrentDateIn AND A.W2_REPORTING_CO = B.W2_REPORTING_CO AND A.PY_TAX_YEAR = B.PY_TAX_YEAR AND A.TAXFORM_ID IN ('Y') AND A.PY_W2_FINAL_PRINT = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 EMPLID_PAYEE_RET Character(11) VARCHAR2(11) NOT NULL Retiree Payee

3 PY_TAX_YEAR Number(4,0) SMALLINT NOT NULL Represents the year for personal income tax purposes.

4 W2_REPORTING_CO Character(3) VARCHAR2(3) NOT NULL W-2 Reporting Company

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	EMPLID_PAYEE_RET	Character(11)	VARCHAR2(11) NOT NULL	Retiree Payee
3	PY_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Represents the year for personal income tax purposes.
4	W2_REPORTING_CO	Character(3)	VARCHAR2(3) NOT NULL	W-2 Reporting Company