# Application: Canadian Payroll 5.5A

Views
Tables
Objects

## Views: 131

RotoID | Tables | Title | DLL | Compositions
--- | --- | --- | --- | ---
CP0001 |  | Payroll Activation | CPACTV |
CP0006 | CPCLAS | Class Codes | CPCLAS |
CP0007 | CPDTLM | Earnings/Deductions | CPDTLM | CP0015, CP0015, CP0015, CP0015, CP0015, CP0009, CP0123, CP0040
CP0008 | CPEMPD | Employee Earnings/Deductions | CPEMPD | CP0014, CP0125, CP0041
CP0009 | CPDIST | Distribution | CPDIST | CP0029, CP0007
CP0010 | CPEMPT | Employee Taxes | CPEMPT | CP0014, CP0062, CP0126
CP0012 | CPHSTH | Employee History Control | CPHSTH | CP0013
CP0013 | CPHSHO | Employee History Optional Field Values | CPHSHO | CP0012
CP0014 | CPEMPL | Employees | CPEMPL | CP0008, CP0010, CP0053, CP0201, CP0122
CP0015 | CPINCL | Include List | CPINCL | CP0007, CP0029
CP0016 |  | Canadian Payroll Integrity Checker | CPDCHK |
CP0017 | CPSTAT | Status | CPSTAT |
CP0018 |  | Delete Inactive Records | CPMAIN |
CP0019 | CPMCHD | Manual Cheque Header | CPMCHD | CP0020, CP0129
CP0020 | CPMCDT | Manual Cheque Detail | CPMCDT | CP0019, CP0130, CP0043
CP0021 | CPHHAU | History Audit Headers | CPHHAU | CP0024, CP0135
CP0022 | CPOTSC | Overtime Schedules | CPOTSC |
CP0023 | CPOPTS | Company Options | CPOPTS |
CP0024 | CPHDAU | History Audit Details | CPHDAU | CP0021, CP0136
CP0025 | CPSHFT | Shift Differential Schedule | CPSHFT | CP0038
CP0026 |  | Concurrency controller | CPCTRL |
CP0027 | CPWRKC | Work Classification Codes | CPWRKC |
CP0029 | CPTXMS | Company Payroll Taxes | CPTXMS | CP0015, CP0015, CP0015, CP0009, CP0124
CP0030 | CPEUIC | Employee EI History | CPEUIC |
CP0031 | CPTCHD | Timecard Header | CPTCHD | CP0032, CP0127
CP0032 | CPTCDT | Timecard Detail | CPTCDT | CP0031, CP0128, CP0042
CP0036 | CPWCCH | Workers Compensation Master | CPWCCH | CP0037
CP0037 | CPWCCD | Workers Compensation Codes | CPWCCD | CP0036
CP0038 | CPSHFD | Shift Differential Detail | CPSHFD | CP0025, CP0039
CP0039 | CPSHFB | Shift Differential Billing Detail | CPSHFB | CP0038
CP0040 | CPDTLB | Earnings Billing Detail | CPDTLB | CP0007
CP0041 | CPEMDB | Employee Billing Details | CPEMDB | CP0008
CP0042 | CPTCJB | Timecard Job Details | CPTCJB | CP0032, CP0141
CP0043 | CPMCJB | Manual Cheque Job Details | CPMCJB | CP0020, CP0142
CP0044 | CPUTJB | Employee Timecard Job Details | CPUTJB | CP0103, CP0143
CP0045 | CPESLH | Employee Selection Lists | CPESLH | CP0046
CP0046 | CPESLD | Employee Selection List Members | CPESLD | CP0045
CP0047 | CPYTDS | Employee YTD Summaries | CPYTDS |
CP0048 | CPCHKH | Cheque Header | CPCHKH | CP0049, CP0052, CP0202, CP0133, CP0134
CP0049 | CPCHKD | Cheque Details | CPCHKD | CP0048, CP0134, CP0056
CP0050 |  | Payroll Posting Superview | CPPOST |
CP0051 | CPGLBM | Globally Modify List | CPGLBM |
CP0052 | CPCHKC | Cheque Comment Detail | CPCHKC | CP0048
CP0053 | CPEMPC | Employee Notes | CPEMPC | CP0014
CP0056 | CPCHJB | Cheque Job Details | CPCHJB | CP0049, CP0144
CP0057 | CPGLREF | G/L Reference Integration | CPGLREF |
CP0058 |  | Globally Modify Process | CPGMET | CP0008, CP0041
CP0059 |  | G/L Acct Desc Report Extraction | CPGLDX |
CP0060 | CPGLDD | G/L Acct Desc Report List | CPGLDD |
CP0062 | CPEMTF | Employee Tax Fields | CPEMTF | CP0010
CP0064 | CPXCPT | Calc PR Exceptions | CPXCPT |
CP0065 |  | Process Manual Cheques | CPPMAN | CP0138
CP0077 | CPCHKS | Cheque History Summary | CPCHKS |
CP0078 |  | Print Cheques Control | CPPCKS |
CP0079 | CPPCKH | Print Cheques Header Extension | CPPCKH | CP0080
CP0080 | CPPCKD | Print Cheques Detail Extension | CPPCKD | CP0079
CP0081 |  | Earnings Hours Report | CPERHR |
CP0082 |  | Check Reconciliation | CPCREC |
CP0083 |  | Calculate Payroll | CPCALC | CP0137
CP0084 | CPCALE | E/D/T List | CPCALE |
CP0085 | CPCALT | Timecard List | CPCALT |
CP0086 | CPCALA | Cost Center Allocations | CPCALA |
CP0087 | CPCALO | Timecard Earnings List | CPCALO |
CP0088 | CPCHKR | Cheque Run Header | CPCHKR | CP0139
CP0089 | CPPCKF | Print Cheques Trans. | CPPCKF |
CP0093 | CPEHRP | Earnings Hourly Report | CPEHRP |
CP0094 |  | Payroll Register G/L Accounts | CPPREG |
CP0097 | PRRSTRT | Restart | PRRSTRT |
CP0099 | CPDTLX | Earnings/Deductions (virtual) | CPDTLX |
CP0100 | CPTXMC | Temporary Tax List | CPTXMC |
CP0101 |  | Empl Timecards Transfer Ctrl | CPUTTR |
CP0102 | CPUTCH | Employee Timecard Header | CPUTCH | CP0103, CP0131
CP0103 | CPUTCD | Employee Timecard Detail | CPUTCD | CP0102, CP0132, CP0044
CP0104 |  | Employee Activity | CPEMAC |
CP0105 |  | Find Duplicate SIN | CPESIN |
CP0106 | CPEDUP | Duplicate SIN | CPEDUP |
CP0107 |  | Create G/L Batch | CPGLTR |
CP0108 |  | Copy Timecard | CPTCCP |
CP0109 |  | Employee Sel Lists Superview | CPESLC | CP0045, CP0046
CP0110 | CPINCX | Include List (virtual) | CPINCX |
CP0111 |  | G/L Drill Down | CPDLDN |
CP0112 |  | Cheque Selection Superview | CPCHKX |
CP0113 | CPCHKL | Cheque Selection List | CPCHKL |
CP0115 | CPACCO | Accrual Carry-over Log File | CPACCO |
CP0120 | CPOFH | Optional Field Locations | CPOFH | CP0121
CP0121 | CPOFD | Optional Field Values | CPOFD | CP0120
CP0122 | CPEMPO | Employee Optional Field Values | CPEMPO | CP0014
CP0123 | CPDTLO | Earnings/Deductions Opt Fields | CPDTLO | CP0007
CP0124 | CPTXMO | Taxes Optional Field Values | CPTXMO | CP0029
CP0125 | CPEMDO | Empl Earn/Ded Optional Fields | CPEMDO | CP0008
CP0126 | CPEMTO | Empl Taxes Optional Fields | CPEMTO | CP0010
CP0127 | CPTCHO | Timecard Optional Field Values | CPTCHO | CP0031
CP0128 | CPTCDO | Timecard Details Optional Field Values | CPTCDO | CP0032
CP0129 | CPMCHO | Manual Cheque Optional Field Values | CPMCHO | CP0019
CP0130 | CPMCDO | MC Details Opt Field Values | CPMCDO | CP0020
CP0131 | CPUTHO | Empl Timecard Optional Fields | CPUTHO | CP0102
CP0132 | CPUTDO | Empl Timecard Details Opt Flds | CPUTDO | CP0103
CP0133 | CPCHHO | Cheque Header Optional Field Values | CPCHHO | CP0048
CP0134 | CPCHDO | Cheque Details Optional Fields | CPCHDO | CP0049
CP0135 | CPHHOA | History Audit Header Opt Fields | CPHHOA | CP0021
CP0136 | CPHDOA | History Audit Detail Opt Fields | CPHDOA | CP0024
CP0137 | CPCLCO | Calculate Payroll Optional Fields | CPCLCO | CP0083
CP0138 | CPPMCO | Process Manual Cheque Optional Fields | CPPMCO | CP0065
CP0139 | CPCHKO | Cheque Run Optional Field Values | CPCHKO | CP0088
CP0140 |  | PR Optional Field Callbacks | CPOFCMD |
CP0141 | CPTCJO | Timecard Jobs Optional Field Values | CPTCJO | CP0042
CP0142 | CPMCJO | Manual Cheque Jobs Opt Fields | CPMCJO | CP0043
CP0143 | CPUTJO | Employee TC Jobs Opt Field Values | CPUTJO | CP0044
CP0144 | CPCHJO | Cheque Jobs Optional Fields Values | CPCHJO | CP0056
CP0200 | CPCOBK | Company EFT Banks | CPCOBK |
CP0201 | CPEMBK | Employee EFT Banks | CPEMBK | CP0014
CP0202 | CPCHKE | Cheque EFT Details | CPCHKE | CP0048
CP0203 |  | EFT Run Superview | CPERUN |
CP0204 | CPEREG | EFT Run History Header | CPEREG | CP0205
CP0205 | CPETRN | EFT Run History Details | CPETRN | CP0204
CP0206 | CPEMULH | EFT Combine File Header | CPEMULH | CP0207
CP0207 | CPEMULD | EFT Combine File Detail | CPEMULD | CP0206
CP0208 | CPELST | EFT Combine File List | CPELST |
CP0209 | CPEMRGH | EFT Files Combine Setup Header | CPEMRGH | CP0210
CP0210 | CPEMRGD | EFT Files Combine Setup Detail | CPEMRGD | CP0209
CP0211 |  | EFT Combine Superview | CPECOMB | CP0208
CP0220 | CPAUDM | Delete Inactive Records Audit | CPAUDM | CP0221, CP0222
CP0221 | CPAUDMI | Delete Audit Inactive Details | CPAUDMI | CP0220
CP0222 | CPAUDMH | Delete Audit Transaction Details | CPAUDMH | CP0220
CP0223 | CPAUDE | Update Earn/Ded Audit | CPAUDE | CP0224
CP0224 | CPAUDED | Update Earn/Ded Audit Details | CPAUDED | CP0223
CP0225 | CPAUDT | Update Taxes Audit | CPAUDT | CP0226
CP0226 | CPAUDTD | Update Taxes Audit Details | CPAUDTD | CP0225
CP0227 | CPAUDA | Assign Earn/Ded Audit | CPAUDA | CP0228
CP0228 | CPAUDAD | Assign Earn/Ded Audit Details | CPAUDAD | CP0227, CP0229
CP0229 | CPAUDAB | Assign Earn/Ded Audit Billing | CPAUDAB | CP0228

## Tables: 97

Table | RotoID | Title
--- | --- | ---
CPACCO | CP0115 | Accrual Carry-over Log File
CPAUDA | CP0227 | Assign Earn/Ded Audit
CPAUDAB | CP0229 | Assign Earn/Ded Audit Billing
CPAUDAD | CP0228 | Assign Earn/Ded Audit Details
CPAUDE | CP0223 | Update Earn/Ded Audit
CPAUDED | CP0224 | Update Earn/Ded Audit Details
CPAUDM | CP0220 | Delete Inactive Records Audit
CPAUDMH | CP0222 | Delete Audit Transaction Details
CPAUDMI | CP0221 | Delete Audit Inactive Details
CPAUDT | CP0225 | Update Taxes Audit
CPAUDTD | CP0226 | Update Taxes Audit Details
CPCALA | CP0086 | Cost Center Allocations
CPCHDO | CP0134 | Cheque Details Optional Fields
CPCHHO | CP0133 | Cheque Header Optional Field Values
CPCHJB | CP0056 | Cheque Job Details
CPCHJO | CP0144 | Cheque Jobs Optional Fields Values
CPCHKC | CP0052 | Cheque Comment Detail
CPCHKD | CP0049 | Cheque Details
CPCHKE | CP0202 | Cheque EFT Details
CPCHKH | CP0048 | Cheque Header
CPCHKL | CP0113 | Cheque Selection List
CPCHKO | CP0139 | Cheque Run Optional Field Values
CPCHKR | CP0088 | Cheque Run Header
CPCHKS | CP0077 | Cheque History Summary
CPCLAS | CP0006 | Class Codes
CPCLCO | CP0137 | Calculate Payroll Optional Fields
CPCOBK | CP0200 | Company EFT Banks
CPDIST | CP0009 | Distribution
CPDTLB | CP0040 | Earnings Billing Detail
CPDTLM | CP0007 | Earnings/Deductions
CPDTLO | CP0123 | Earnings/Deductions Opt Fields
CPEDUP | CP0106 | Duplicate SIN
CPEHRP | CP0093 | Earnings Hourly Report
CPELST | CP0208 | EFT Combine File List
CPEMBK | CP0201 | Employee EFT Banks
CPEMDB | CP0041 | Employee Billing Details
CPEMDO | CP0125 | Empl Earn/Ded Optional Fields
CPEMPC | CP0053 | Employee Notes
CPEMPD | CP0008 | Employee Earnings/Deductions
CPEMPL | CP0014 | Employees
CPEMPO | CP0122 | Employee Optional Field Values
CPEMPT | CP0010 | Employee Taxes
CPEMRGD | CP0210 | EFT Files Combine Setup Detail
CPEMRGH | CP0209 | EFT Files Combine Setup Header
CPEMTF | CP0062 | Employee Tax Fields
CPEMTO | CP0126 | Empl Taxes Optional Fields
CPEMULD | CP0207 | EFT Combine File Detail
CPEMULH | CP0206 | EFT Combine File Header
CPEREG | CP0204 | EFT Run History Header
CPESLD | CP0046 | Employee Selection List Members
CPESLH | CP0045 | Employee Selection Lists
CPETRN | CP0205 | EFT Run History Details
CPEUIC | CP0030 | Employee EI History
CPGLBM | CP0051 | Globally Modify List
CPGLDD | CP0060 | G/L Acct Desc Report List
CPGLREF | CP0057 | G/L Reference Integration
CPHDAU | CP0024 | History Audit Details
CPHDOA | CP0136 | History Audit Detail Opt Fields
CPHHAU | CP0021 | History Audit Headers
CPHHOA | CP0135 | History Audit Header Opt Fields
CPINCL | CP0015 | Include List
CPMCDO | CP0130 | MC Details Opt Field Values
CPMCDT | CP0020 | Manual Cheque Detail
CPMCHD | CP0019 | Manual Cheque Header
CPMCHO | CP0129 | Manual Cheque Optional Field Values
CPMCJB | CP0043 | Manual Cheque Job Details
CPMCJO | CP0142 | Manual Cheque Jobs Opt Fields
CPOFD | CP0121 | Optional Field Values
CPOFH | CP0120 | Optional Field Locations
CPOPTS | CP0023 | Company Options
CPOTSC | CP0022 | Overtime Schedules
CPPCKD | CP0080 | Print Cheques Detail Extension
CPPCKH | CP0079 | Print Cheques Header Extension
CPPMCO | CP0138 | Process Manual Cheque Optional Fields
CPSHFB | CP0039 | Shift Differential Billing Detail
CPSHFD | CP0038 | Shift Differential Detail
CPSHFT | CP0025 | Shift Differential Schedule
CPSTAT | CP0017 | Status
CPTCDO | CP0128 | Timecard Details Optional Field Values
CPTCDT | CP0032 | Timecard Detail
CPTCHD | CP0031 | Timecard Header
CPTCHO | CP0127 | Timecard Optional Field Values
CPTCJB | CP0042 | Timecard Job Details
CPTCJO | CP0141 | Timecard Jobs Optional Field Values
CPTXMO | CP0124 | Taxes Optional Field Values
CPTXMS | CP0029 | Company Payroll Taxes
CPUTCD | CP0103 | Employee Timecard Detail
CPUTCH | CP0102 | Employee Timecard Header
CPUTDO | CP0132 | Empl Timecard Details Opt Flds
CPUTHO | CP0131 | Empl Timecard Optional Fields
CPUTJB | CP0044 | Employee Timecard Job Details
CPUTJO | CP0143 | Employee TC Jobs Opt Field Values
CPWCCD | CP0037 | Workers Compensation Codes
CPWCCH | CP0036 | Workers Compensation Master
CPWRKC | CP0027 | Work Classification Codes
CPXCPT | CP0064 | Calc PR Exceptions
CPYTDS | CP0047 | Employee YTD Summaries

## Objects: 38

Object | Protocol | Views
--- | --- | ---
CPCALCULAT | ORDERED | CP0083, CP0137
CPCHECKS | ORD5 | CP0048, CP0049, CP0052, CP0202, CP0133, CP0134
CPCLASSIDS | SET | CP0006
CPCONTROL | SUPER | CP0026
CPCPYTCARD | SUPER | CP0108
CPDCHK | FLAT | CP0016
CPDELINREC | FLAT | CP0018
CPDISTCODE | SET | CP0009
CPEARNDED | ORD4 | CP0007, CP0009, CP0015, CP0123, CP0040
CPEFTCOBK | SET | CP0200
CPEFTMERGE | ORDERED | CP0211, CP0208
CPEFTMERGESTP | ORDERED | CP0209, CP0210
CPEFTTRANS | ORDERED | CP0204, CP0205
CPEMASTER | ORD9 | CP0014, CP0008, CP0010, CP0053, CP0201, CP0062, CP0122, CP0125, CP0126, CP0041
CPERNGHRS | SUPER | CP0081
CPESELECT | ORDERED | CP0045, CP0046
CPEUIHST | SET | CP0030
CPGENEFT | SUPER | CP0203
CPGMET | SUPER | CP0058
CPINCLIST | SET | CP0015
CPMANCHK | ORD5 | CP0019, CP0020, CP0129, CP0130, CP0043, CP0142
CPMANCKDTL | ORD3 | CP0020, CP0130, CP0043, CP0142
CPOPTFLDS | ORDERED | CP0120, CP0121
CPOPTIONS | FLAT | CP0023
CPOTSCHED | FLAT | CP0022
CPPRCHECKS | SUPER | CP0078
CPPRMANCHK | ORDERED | CP0065, CP0138
CPREGISTER | SUPER | CP0094
CPSHFTSCH | ORD2 | CP0025, CP0038, CP0039
CPTAXFLD | FLAT | CP0062
CPTAXMASTR | ORD3 | CP0029, CP0009, CP0015, CP0124
CPTIMECARD | ORD5 | CP0031, CP0032, CP0127, CP0128, CP0042, CP0141
CPTMCRDDTL | ORD3 | CP0032, CP0128, CP0042, CP0141
CPUTCARD | ORD5 | CP0102, CP0103, CP0131, CP0132, CP0044, CP0143
CPUTCTRF | SUPER | CP0101
CPWORKCODE | FLAT | CP0027
CPWORKCOMP | ORDERED | CP0036, CP0037
CPYTDSUM | FLAT | CP0047

This page was generated on 2008-May-02

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.