|
eForms Standard & Enterprise Only
Cell A1 (import from Excel) or the first data element (import from CSV) must contain "T4E"
Heading
|
Description
|
Type, Size
|
Comments & Examples
|
LASTNAME
|
Employee last name
|
Text, 30
|
Required
|
FIRSTNAME
|
Employee first name
|
Text, 30
|
|
INITIAL
|
Employee initial
|
Text, 1
|
|
ADDRESS1
|
Address line 1
|
Text, 50
|
|
ADDRESS2
|
Address line 2
|
Text, 50
|
|
CITY
|
City
|
Text, 28
|
|
PROV
|
Province code
|
Text, 2
|
|
POSTAL
|
Postal code (including space)
|
Text, 10
|
|
COUNTRY
|
Country code
|
Text, 3
|
|
YEAR
|
Year
|
Numeric, 4
|
2024
|
SLIPSTATUS
|
Status of slip
|
Text, 1
|
O - Original,
A - Amended
C - Cancelled
|
SIN
|
Social insurance number (12)
|
Numeric, 9
|
|
RECIPIENTNO
|
Recipient’s number
|
Text, 20
|
|
REPAYMENTRATE
|
T4E repayment rate; percentage (7)
|
Numeric, 3
|
|
TOTALBENEFITS
|
Total benefits paid (14)
|
Currency
|
|
REGULAROTHERBENEFITS
|
Regular benefits paid included in Box 14 (15)
|
Currency
|
|
EMPLOYMENTSUPPORT
|
Employment benefits and support measures included in Box 14 (17)
|
Currency
|
|
TAXABLETUITION
|
Taxable tuition assistance (20)
|
Currency
|
|
NONTAXABLETUITION
|
Non-taxable tuition assistance (21)
|
Currency
|
|
INCOMETAX
|
T4E income tax deducted (22)
|
Currency
|
|
QUEBECINCOMETAX
|
T4E Québec income tax deducted (23)
|
Currency
|
|
OTHERCODE1
|
Other information Box 1
|
Numeric, 2
|
|
OTHERAMT1
|
Other information Amount 1
|
Currency
|
|
OTHERCODE2
|
Other information Box 2
|
Numeric, 2
|
|
OTHERAMT2
|
Other information Amount 2
|
Currency
|
|
OTHERCODE3
|
Other information Box 3
|
Numeric, 2
|
|
OTHERAMT3
|
Other information Amount 3
|
Currency
|
|
OTHERCODE4
|
Other information Box 4
|
Numeric, 2
|
|
OTHERAMT4
|
Other information Amount 4
|
Currency
|
|
OTHERCODE5
|
Other information Box 5
|
Numeric, 2
|
|
OTHERAMT5
|
Other information Amount 5
|
Currency
|
|
OTHERCODE6
|
Other information Box 6
|
Numeric, 2
|
|
OTHERAMT6
|
Other information Amount 6
|
Currency
|
|
TEXTATTOP
|
Optional text to print at top of slip
|
Text, 15
|
|
EMAILADDRESS
|
Recipient email address
|
Text, 255
|
eForms Enterprise only
One email address, or two separated by a semi-colon
|
OKTOEMAILSLIP
|
Permission granted to email slip
|
Yes/No
|
eForms Enterprise only
|
COMPANY.NAME1
|
Company associated with slip
|
Text, 35
|
eForms Enterprise only
|
COMPANY.COMPANYTAG
|
Tag associated with company name
|
Text, 10
|
eForms Enterprise only
|
SLIPTAG
|
Subset tag
|
Text, 10
|
eForms Enterprise only
|
CUSTOMFIELD
|
GUID or other unique identifier
|
Text, 50
|
eForms Enterprise only
|
CUSTOMPASSWORD
|
Password for recipient PDF slip
|
Text, 20
|
eForms Enterprise only
|
|