View: Paper R1 Information

RotoID: CT0099
Table: CTR1PH
Protocol: Flat
DLL:CTR1PH

Keys: 1

Title Fields
Key Name PAYYEAR, EMPLOYEE

Fields: 64

Field Index Type Title Attributes Presentation
PAYYEAR 1 Integer Payment Year E A K R 
EMPLOYEE 2 String*12 Employee ID E A K R 
EMPLRACCNO 3 String*20 Employer Account Number E A 
EMPLRNAME 4 String*60 Employer Name E A 
EMPLRADDR1 5 String*60 Employer Address 1 E A 
EMPLRADDR2 6 String*60 Employer Address 2 E A 
EMPLRADDR3 7 String*60 Employer Address 3 E A 
EMPLRADDR4 8 String*60 Employer Address 4 E A 
EMPLRCITY 9 String*30 Employer City E A 
EMPLRSTATE 10 String*30 Employer Province E A 
EMPLRZIP 11 String*20 Employer Postal Code E A 
SSN 12 String*11 Employee SIN E A 
LASTNAME 13 String*20 Employee Last Name E A 
FIRSTNAME 14 String*15 Employee First Name E A 
MIDDLENAME 15 String*15 Employee Middle Name E A 
ADDRESS1 16 String*60 Employee Address 1 E A 
ADDRESS2 17 String*60 Employee Address 2 E A 
ADDRESS3 18 String*60 Employee Address 3 E A 
ADDRESS4 19 String*60 Employee Address 4 E A 
CITY 20 String*30 Employee City E A 
STATE 21 String*30 Employee Province E A 
ZIP 22 String*20 Employee Postal Code E A 
WAGESTIPS 23 BCD*10.3 Employee Income E A 
QPENSIONC 24 BCD*10.3 QPP Contributions E A 
UIPREMIUM 25 BCD*10.3 EI Premium E A 
RPENSIONC 26 BCD*10.3 Registered Pension Plan Deduction E A 
INCOMETAX 27 BCD*10.3 Income Tax Deducted E A 
UNIONDUES 28 BCD*10.3 Unions Dues Deduction E A 
QPPEARNING 29 BCD*10.3 QPP Pensionable Earnings E A 
HOUSINGBEN 30 BCD*10.3 Housing, Board, Lodging E A 
COAUTOBEN 31 BCD*10.3 Personal Use of Employer's Auto E A 
HEALTHBEN 32 BCD*10.3 Private Health Plan Benefit E A 
TRAVELBEN 33 BCD*10.3 Travel in Designated Areas E A 
OTHERBEN 34 BCD*10.3 Other Taxable Allowances/Benefits E A 
COMMISSION 35 BCD*10.3 Employment Commissions E A 
CHARITYDED 36 BCD*10.3 Charitable Contribution Deductions E A 
OTHEREARN 37 BCD*10.3 Other Taxable Income E A 
MULTEMPINS 38 BCD*10.3 Multi-Employer Insuance Plan Contrib. E A 
DEFEREARN 39 BCD*10.3 Deferred Earnings E A 
INDIANPAY 40 BCD*10.3 Indian Pay E A 
TIPS 41 BCD*10.3 Tips E A 
ALLOCTIPS 42 BCD*10.3 Allocated Tips E A 
RETIREMENT 43 BCD*10.3 Phased Retirement E A 
NOTES 53 String*250 Notes E A 
COUNTRY 54 String*30 Country E A 
ER1BOX 55 Integer O-Code Box E A 
EFILENO 56 String*9 eFile Number E A 
CPENSIONC 57 BCD*10.3 CPP Contributions E A 
BOXGBLANK 58 Boolean Box G is blank E A 
RL1NO 59 String*9 RL1 Slip Number E A 
PIPEARNING 60 BCD*10.3 Parental Insurance Earnings E A 
PIPPREMIUM 61 BCD*10.3 Parental Insurance Premium E A 
RECORDTYPE 62 Integer Record Type E A 
ORGEFILENO 63 String*9 Original EFile Number E A 
ADDBOX1 64 String*6 Additional Info Box 1 E A 
ADDAMT1 65 BCD*10.3 Additional Info Amount 1 E A 
ADDBOX2 66 String*6 Additional Info Box 2 E A 
ADDAMT2 67 BCD*10.3 Additional Info Amount 2 E A 
ADDBOX3 68 String*6 Additional Info Box 3 E A 
ADDAMT3 69 BCD*10.3 Additional Info Amount 3 E A 
ADDBOX4 70 String*6 Additional Info Box 4 E A 
ADDAMT4 71 BCD*10.3 Additional Info Amount 4 E A 
CPENSION2C 72 BCD*10.3 CPP2 Contributions E A 
QPENSION2C 73 BCD*10.3 QPP2 Contributions E A 

This page was generated on 2025-Sep-23

© 2025 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).