PY_NRA_FORMS_VW (SQL View)	Index Back
Form 1042-S View Forms 1042-S View record

PY_NRA_FORMS_VW

(SQL View)

Form 1042-S View

Forms 1042-S View record

SELECT DISTINCT A.EMPLID ,A.PY_TAX_YEAR ,A.COMPANY ,A.TAXFORM_ID ,A.COMPANY ,( SELECT MAX(A2.YE_FORM_ISSUE_DT) FROM PS_PY_SS_NRA1_VW A2 WHERE A.EMPLID=A2.EMPLID AND A.PY_TAX_YEAR=A2.PY_TAX_YEAR AND A.COMPANY=A2.COMPANY AND A.TAXFORM_ID=A2.TAXFORM_ID) , ( SELECT COUNT(*) FROM PS_PY_SS_NRA1_VW A1 WHERE A1.EMPLID=A.EMPLID AND A.PY_TAX_YEAR=A1.PY_TAX_YEAR AND A.COMPANY=A1.COMPANY AND A.TAXFORM_ID=A1.TAXFORM_ID ) ,A.PY_AMEND_NO FROM PS_PY_SS_NRA1_VW A WHERE A.YE_FORM_VIEWING_DT<=%CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

4 TAXFORM_ID Character(1) VARCHAR2(1) NOT NULL Tax Form Identification
A=T4A Slip
B=Business Payrolls Survey - CAN
C=WCB Assessable Earnings
E=Record of Employment
F=940 - Annual Employer's FUTA
I=W-2VI
J=W-2cVI
M=W-2GU
N=W-2cGU
P=W-2PR
Q=W-2cPR
R=RL-1 Slip
S=W-2AS
T=T4 Slip
U=W-2cAS
V=RL-2 Slip
W=W-2
X=W-2c
Y=1099-R
Z=1042-S

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

6 YE_FORM_ISSUE_DT Date(10) DATE This field is used in Payroll for North America Self Service Year-End Forms. It stores the date when the forms were generated.

7 COUNT1 Number(12,0) DECIMAL(12) NOT NULL AUS WGEA counts

8 PY_AMEND_NO Number(2,0) SMALLINT NOT NULL 1042S Amendment Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	PY_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Represents the year for personal income tax purposes.
3	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
4	TAXFORM_ID	Character(1)	VARCHAR2(1) NOT NULL	Tax Form Identification A=T4A Slip B=Business Payrolls Survey - CAN C=WCB Assessable Earnings E=Record of Employment F=940 - Annual Employer's FUTA I=W-2VI J=W-2cVI M=W-2GU N=W-2cGU P=W-2PR Q=W-2cPR R=RL-1 Slip S=W-2AS T=T4 Slip U=W-2cAS V=RL-2 Slip W=W-2 X=W-2c Y=1099-R Z=1042-S
5	W2_REPORTING_CO	Character(3)	VARCHAR2(3) NOT NULL	W-2 Reporting Company
6	YE_FORM_ISSUE_DT	Date(10)	DATE	This field is used in Payroll for North America Self Service Year-End Forms. It stores the date when the forms were generated.
7	COUNT1	Number(12,0)	DECIMAL(12) NOT NULL	AUS WGEA counts
8	PY_AMEND_NO	Number(2,0)	SMALLINT NOT NULL	1042S Amendment Number