TA147 – Canada Vacation Audit
- System
- Event Management (TA)
- Type
- Batch program
- Updates
- 41 tables
- References
- 84 tables
TA147 (Canada Vacation Audit) is a Lawson Event Management batch program. It updates ACCOMMIT, ACCOMMITX, ADDRDATA, C6EMDDMSTR, C6EMPADDRT, CKPOINT, CMASSIGN, CMPAYCYC and 33 more and references ACACCTCAT, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, ATTENDCODE, C6EMPADDRT and 76 more.
About TA147
Run Canadian Vacation Audit (TA147) to - view vacationable dollars and vacation pay, - view the percentage of wages paid as vacation pay, and - compare the percentage to either the government standards percentage or a percentage you enter. You can print the following reports: - Shortfalls Only - prints a report of the time accrual dollars paid to the employee are less than the percentage calculation entered on the TA147 parameters. - All Differences - prints a report of all differences, whether positive or negative. - All Employee's in Plan - prints a report of all employees, even if there are no differences between the parameters entered and theamounts paid. **Processing Effect The time records are created using the pay code from Canadian Vacation Hours Schedule (TA40.2) or Canadian Vacation Date Schedule (TA40.3). NOTE No matter what Report Option is selected, time records are created only for shortfalls.
Updated files (41)
| Table | Description | System |
|---|---|---|
| ACCOMMIT | Activity Commitments | AC |
| ACCOMMITX | Activity Commitments Detail | AC |
| ADDRDATA | Address Code | IF |
| C6EMDDMSTR | No description in the Lawson data dictionary | C6 |
| C6EMPADDRT | No description in the Lawson data dictionary | C6 |
| CKPOINT | No description in the Lawson data dictionary | — |
| CMASSIGN | No description in the Lawson data dictionary | CW |
| CMPAYCYC | No description in the Lawson data dictionary | CW |
| CWASSIGN | No description in the Lawson data dictionary | CW |
| EMDEDMASTR | Employee Deduction | PR |
| EMPLOYEE | Employee | HR |
| FBDETAIL | Budget Detail | GL |
| FBFUNDAMT | Budget Fund Balance | GL |
| FBTRANS | Budget Transactions | GL |
| FBYETR | No description in the Lawson data dictionary | GL |
| GLCOMMIT | GL Commitments | GL |
| GLCOMMITX | GL commitment Detail | GL |
| GLHISCOMBL | No description in the Lawson data dictionary | GL |
| GLHISCOMX | No description in the Lawson data dictionary | GL |
| HRHISTORY | HR History | HR |
| LPPENDREQ | No description in the Lawson data dictionary | LP |
| PAEMPPOS | Employee Multiple Pos, Jobs | HR |
| PAYDEDUCTN | Employee Payment Deductions | PR |
| PRBATCH | Payroll Time Record Batch Head | PR |
| PRMONITOR | No description in the Lawson data dictionary | PR |
| PRPAYCODE | Pay Code | PR |
| PRRATEHIST | Employee Rate History | HR |
| PRREGPARM | No description in the Lawson data dictionary | PR |
| PRSHIFTHDR | Contains the shift table code definitions. | PR |
| PRSYSTEM | HR Company and Process Levels | HR |
| PRTAXLOC | No description in the Lawson data dictionary | PR |
| PRTIME | Employee Pay/Hours History | PR |
| SUBCKPOINT | Subledger Check Point | IF |
| TAEEMASTER | Employee Absence Plan | LP |
| TAEMPSERV | Employee LP Service Record | LP |
| TAENROLL | No description in the Lawson data dictionary | LP |
| TAPAYROLL | Absence Plan Payroll Rule | LP |
| TASTRUCTUR | Absence Plan Structure | LP |
| TIMERECORD | Employee Time Records | PR |
| TIPPAY | Employee Tip Pay | PR |
| TRSGBLCK | This file contains segment block data for employee time records. | PR |
Referenced files (84)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ATTENDCODE | Attendance Code | TM |
| C6EMPADDRT | No description in the Lawson data dictionary | C6 |
| C6PRDDEF | No description in the Lawson data dictionary | C6 |
| C6PRDDTL | No description in the Lawson data dictionary | C6 |
| CMASSIGN | No description in the Lawson data dictionary | CW |
| CMCONTRACT | No description in the Lawson data dictionary | CW |
| CMCONTRULE | No description in the Lawson data dictionary | CW |
| CMPAYCYC | No description in the Lawson data dictionary | CW |
| CWASSIGN | No description in the Lawson data dictionary | CW |
| CWCONTRACT | Contracts are used in K12 school districts to manage and track employee employment records and drive an employee's pay… | CW |
| CWCONTRULE | No description in the Lawson data dictionary | CW |
| DEDCODE | Deduction | PR |
| DEPTCODE | Department | HR |
| DEPTSEGBLK | Department Segment Block | HR |
| EMDISTMAST | Emp Acct Distribution Override | PR |
| EMSTATUS | Employee/Applicant Status | HR |
| EMTAMASTR | Employee Time Accrual Master | TA |
| EMTATRANS | Emp Time Accrual Transactions | TA |
| FBFUNDDTL | Budget Fund Detail | GL |
| GLADDRESS | General Ledger Company Address | IF |
| GLCHART | General Ledger Chart | IF |
| GLCODES | General Ledger Codes | IF |
| GLINTCO | General Ledger Intercompany | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| HRHISTORY | HR History | HR |
| HRSECLEV | Employee Security Level | HR |
| INSTCTRYCD | Intrastat Country Codes | TX |
| JOBCODE | Job Code Parameters | HR |
| LPLINK | LP Link Plan Table | LP |
| ONETMDED | Payroll One-time Deduction | PR |
| PADICT | HR Systems Data Dictionary | HR |
| PAEMPLOYEE | Employee Personnel Information | HR |
| PAEMPPOS | Employee Multiple Pos, Jobs | HR |
| PAPOSITION | Positions | PA |
| PAPOSRULE | Position Rules | PA |
| PASCRTY | Data Item Attribute Parameters | HR |
| PAYDEDUCTN | Employee Payment Deductions | PR |
| PAYMASTR | Employee Payment Master | PR |
| PAYSUMGRP | Pay Summary Groups | PR |
| PCODES | Human Resource Code | HR |
| PCODESDTL | Contains contact information detail (address and phone number) for specific types of PCODES. | HR |
| PERSACTION | Personnel Action | PA |
| PERSGROUP | Employee Group Header | HR |
| PGEMPLOYEE | Employee Group Employees | HR |
| PLAN | PL Group Detail | BN |
| PLANMASTER | Time Accrual Plan | TA |
| PRBUSGRP | No description in the Lawson data dictionary | PR |
| PRCHECK | Employee Payment | PR |
| PREMDEDHST | Employee Deduction History | PR |
| PROVERTIME | Overtime Pay Plan | PR |
| PRPAYCODE | Pay Code | PR |
| PRPENPAY | No description in the Lawson data dictionary | PR |
| PRPROCGRP | Payroll Process Group | HR |
| PRPROVINCE | This file contains province codes and descriptions. | PR |
| PRQCENTGRP | No description in the Lawson data dictionary | PR |
| PRRATEHIST | Employee Rate History | HR |
| PRRATES | Alternate Pay Rates | PR |
| PRSAGDTL | Step & Grade Schedule Detail | HR |
| PRSAGHEAD | Step & Grade Schedule Header | HR |
| PRSHIFTHDR | Contains the shift table code definitions. | PR |
| PRSHIFTTBL | This detail file contains shift differential rates by shift code and can be assigned by job code, grade range schedule… | PR |
| PRSTATE | States | PR |
| PRTAXAUTH | Tax Authority | PR |
| PRTAXLEVY | Payroll Tax Levy | PR |
| PRTIME | Employee Pay/Hours History | PR |
| PSGRELATE | Pay Class/Pay Sum Grp Relation | HR |
| SYSTEMCODE | System Code | IF |
| TAEEMASTER | Employee Absence Plan | LP |
| TAENROLL | No description in the Lawson data dictionary | LP |
| TAPAYROLL | Absence Plan Payroll Rule | LP |
| TAPLAN | Absence Plan | LP |
| TAREASCODE | Absence Plan Reason Code | LP |
| TASERVCODE | Absence Plan Service Code | LP |
| TASERVICE | Service Class & Code Relations | LP |
| TASTRUCTUR | Absence Plan Structure | LP |
| TAXGROUP | Payroll Tax Reporting Group | PR |
| WCCLASSOVR | No description in the Lawson data dictionary | PR |
Program calls
Invoked programs (17)
ACAC, ACTA, API4, HRHI, HRLO, HRST, IFAC, IFCU, IFLU, IFOB, IFRS, IFSG, IFUP, PREN, SLSE, SLSS, SLSU