PY_YE_AMEND_BN (SQL Table)	Index Back
T4, T4A Filer Amendment Table Filer amendment information for T4 and T4A electronic reporting.

PY_YE_AMEND_BN

(SQL Table)

T4, T4A Filer Amendment Table

Filer amendment information for T4 and T4A electronic reporting.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CANADA_BN Character(15) VARCHAR2(15) NOT NULL Payroll Account Number
Prompt Table: PY_CAN_BN_VW

2 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year

3 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
Default Value: T
Prompt Table: PY_FORM_ID_VW

4 YE_AMEND_NOTE Long Character CLOB Filer Amendment Note

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CANADA_BN	Character(15)	VARCHAR2(15) NOT NULL	Payroll Account Number Prompt Table: PY_CAN_BN_VW
2	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
3	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 Default Value: T Prompt Table: PY_FORM_ID_VW
4	YE_AMEND_NOTE	Long Character	CLOB	Filer Amendment Note