CAN_AMEND_T4A_D

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
4	SEQUENCE_NUMBER	Number(2,0)	SMALLINT NOT NULL	Sequence Number
5	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
6	WAGE_LOSS_PLAN	Character(3)	VARCHAR2(3) NOT NULL	Wage Loss Replacement Plan
7	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province
8	CAN_YE_SLIP_SEQ	Number(2,0)	SMALLINT NOT NULL	This is the Canadian year-end slip sequence number. For T4 and T4A, they have a slip sequence number of 0 (default value). As for RL-1 and RL-2, if a box amount exceeds maximum box amount allowed by MRQ, additional slip will have incremental slip number.
9	BOX	Character(4)	VARCHAR2(4) NOT NULL	Box Prompt Table: %RECNAME_EDIT2
10	CAN_YE_BOX_TEXT	Character(11)	VARCHAR2(11) NOT NULL	Canadian YE Slip Box Text
11	PRV_AMOUNT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Previous Amount
12	CORRECTED_AMOUNT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Corrected Amount