Issue
How can I copy the Employee information from one company to another in Canadian Payroll?
Resolution
Copy the following files from the Project folder. If you are on MS SQL, you will need to DTS the files from the existing company database to the new company database.
CDN Payroll Employee Rate History (CPY10065)
CDN Payroll Employee Master (CPY10100)
CDN payroll Employee Direct Deposit File (CPY10102)
CDN Payroll Employee T4 File (CPY10103)
CDN Payroll Employee T4A File (CPY10104)
CDN Payroll Employee Tax Credits File (CPY10105)
CDN Payroll Employee WCB (CPY10106)
CDN Employee Master Misc. Edu. Notes (CPY10107)
CDN Employee Master Misc. Review Notes (CPY10108)
CDN Payroll Employee Banked Overtime (CPY10110)
CDN Payroll Employee Banked Leave (CPY10115)
CDN Payroll Employee Banked Stat (CPY101120)
CDN Payroll Employee Banked Sick (CPY10130)
CDN Payroll Employee Delayed Deductions (CPY10135)
CDN Payroll Employee Paycodes (CPY10140)
CDN Employee Distribution Master (CPY10150)
CDN Payroll Employee Paycode YTD (CPY10160)
CDB Payroll Employee R1 (CPY40105)
To copy the employee historical information, you willalso need to copy the following files:
CDN Payroll Employee Rate History LY (CPY50065)
CDN Payroll Employee Master LY (CPY50100)
CDN Employee Maser Miscellaneous LY (CPY50101)
CDN Payroll Employee Direct Deposit File LY (CPY50102)
CDN Payroll Employee T4 File LY (CPY50103)
CDN Payroll Employee T4a File LY (CPY50104)
CND Payroll Employee Tax Credits LY File (CPY50105)
CDN Payroll Employee WCB LY (CPY50106)
CDN Employee Master Misc. Edu Notes LY (CPY50107)
CDN Employee Master Misc Review Notes LY (CPY50108)
CDN Employee Banked Overtime LY (CPY50110)
CDN Payroll Employee Banked Overtime LY (CPY50110)
CDN Payroll Employee Banked Leave LY (CPY50115)
CDN Payroll Employee Banked Stat LY (CPY50120)
CDN Payroll Employee Banked Sick LY (CPY50130)
CDN Payroll Employee Delayed Deduction LY (CPY50135)
CDN Payroll Employee Paycodes LY (CPY50140)
CDN Employee Distribution Master LY (CPY50150)
CDN Payroll Employee Paycodes YTD LY (CPY50160)
CDN Payroll Employee R1 LY (CPY70105)
This article was TechKnowledge Document ID:29860
How can I copy the Employee information from one company to another in Canadian Payroll?
Resolution
Copy the following files from the Project folder. If you are on MS SQL, you will need to DTS the files from the existing company database to the new company database.
CDN Payroll Employee Rate History (CPY10065)
CDN Payroll Employee Master (CPY10100)
CDN payroll Employee Direct Deposit File (CPY10102)
CDN Payroll Employee T4 File (CPY10103)
CDN Payroll Employee T4A File (CPY10104)
CDN Payroll Employee Tax Credits File (CPY10105)
CDN Payroll Employee WCB (CPY10106)
CDN Employee Master Misc. Edu. Notes (CPY10107)
CDN Employee Master Misc. Review Notes (CPY10108)
CDN Payroll Employee Banked Overtime (CPY10110)
CDN Payroll Employee Banked Leave (CPY10115)
CDN Payroll Employee Banked Stat (CPY101120)
CDN Payroll Employee Banked Sick (CPY10130)
CDN Payroll Employee Delayed Deductions (CPY10135)
CDN Payroll Employee Paycodes (CPY10140)
CDN Employee Distribution Master (CPY10150)
CDN Payroll Employee Paycode YTD (CPY10160)
CDB Payroll Employee R1 (CPY40105)
To copy the employee historical information, you willalso need to copy the following files:
CDN Payroll Employee Rate History LY (CPY50065)
CDN Payroll Employee Master LY (CPY50100)
CDN Employee Maser Miscellaneous LY (CPY50101)
CDN Payroll Employee Direct Deposit File LY (CPY50102)
CDN Payroll Employee T4 File LY (CPY50103)
CDN Payroll Employee T4a File LY (CPY50104)
CND Payroll Employee Tax Credits LY File (CPY50105)
CDN Payroll Employee WCB LY (CPY50106)
CDN Employee Master Misc. Edu Notes LY (CPY50107)
CDN Employee Master Misc Review Notes LY (CPY50108)
CDN Employee Banked Overtime LY (CPY50110)
CDN Payroll Employee Banked Overtime LY (CPY50110)
CDN Payroll Employee Banked Leave LY (CPY50115)
CDN Payroll Employee Banked Stat LY (CPY50120)
CDN Payroll Employee Banked Sick LY (CPY50130)
CDN Payroll Employee Delayed Deduction LY (CPY50135)
CDN Payroll Employee Paycodes LY (CPY50140)
CDN Employee Distribution Master LY (CPY50150)
CDN Payroll Employee Paycodes YTD LY (CPY50160)
CDN Payroll Employee R1 LY (CPY70105)
This article was TechKnowledge Document ID:29860