Event Management – Lawson TA tables and programs
Event Management (TA) in Lawson S3 v10 MSP6 has 11 tables, 21 online screens and 28 batch programs.
Tables (11)
| Table | Prefix | Description | Primary key | Fields |
|---|
| ACCRSCHED | ACS | Activity Accrual Schedule | COMPANY, PLAN-NAME, THRU-CYCLE | 6 |
| ACTRLIMIT | ATL | Accrual Transaction Limit | COMPANY, PLAN-NAME, LIMIT-TYPE, THRU-LIM-CYC | 5 |
| EMTAMASTR | ETM | Employee Time Accrual Master | COMPANY, EMPLOYEE, PLAN-NAME | 38 |
| EMTATRANS | ETT | Emp Time Accrual Transactions | COMPANY, EMPLOYEE, PLAN-NAME, DATE, SEQ-NBR | 13 |
| EMTATRNSUM | EMT | Emp TA Transaction Summary | COMPANY, EMPLOYEE, PLAN-NAME, YEAR | 19 |
| PLANCLASS | PLC | Plan Class | COMPANY, PLAN-CLASS | 5 |
| PLANMASTER | PLM | Time Accrual Plan | COMPANY, PLAN-NAME | 54 |
| TAFORMULA | TAF | Time Accrual Formula | COMPANY, CALC-NAME | 87 |
| ZACCRSCHED | ZCS | No description in the Lawson data dictionary | COMPANY, PLAN-NAME, THRU-CYCLE | 6 |
| ZACTRLIMIT | ZTL | No description in the Lawson data dictionary | COMPANY, PLAN-NAME, LIMIT-TYPE, THRU-LIM-CYC | 5 |
| ZMAXHRS | JHT | No description in the Lawson data dictionary | COMPANY, CALC-NAME, FRMLA-TYPE | 6 |
Online screens (21)
| Screen | Description | Updates | References |
|---|
| TA05.1 | Plan Class | 1 | 2 |
| TA20.1 | Plan | 3 | 8 |
| TA20.2 | Accrual Schedule | 2 | 3 |
| TA20.3 | Accrual Limit | 2 | 1 |
| TA20.4 | Transfer Schedule | 1 | 2 |
| TA20.5 | Eligibility Limit | 2 | 1 |
| TA30.1 | Accrual Amount Formula | 1 | 3 |
| TA30.2 | Accrual Ratio Formula | 1 | 3 |
| TA40.1 | Canada Vacation Plan Master | 3 | 6 |
| TA40.2 | Canada Vacation Hours Schedule | 1 | 5 |
| TA40.3 | Canada Vacation Date Schedule | 1 | 5 |
| TA42.1 | Canada Vacation Adjustments | 3 | 3 |
| TA50.1 | Canada Employee Vacation Plan | 2 | 6 |
| TA60.1 | Employee Plan Inquiry | 2 | 8 |
| TA65.1 | Plan Balance Inquiry | 0 | 5 |
| TA65.2 | Yearly Activity Inquiry | 0 | 6 |
| TA65.3 | Employee Transaction Inquiry | 0 | 6 |
| TA70.1 | Plan Adjustments | 3 | 4 |
| TA70.2 | Employee Plan Adjustments | 3 | 3 |
| TA80.1 | Plan Transfer | 3 | 5 |
| TA81.1 | Canada Vacation Plan Transfer | 3 | 5 |
Batch programs (28)
| Program | Description | Updates | References |
|---|
| TA125 | This program has been retired. | 1 | 0 |
| TA145 | This program has been retired. | 1 | 0 |
| TA146 | This program has been retired. | 1 | 0 |
| TA147 | Canada Vacation Audit | 41 | 84 |
| TA148 | Canada Vacation Rollover | 4 | 10 |
| TA170 | This program has been retired. | 1 | 0 |
| TA175 | Time Accrual Report | 1 | 10 |
| TA180 | This program has been retired. | 1 | 0 |
| TA181 | This program has been retired. | 1 | 0 |
| TA195 | This program has been retired. | 1 | 0 |
| TA196 | This program has been retired. | 1 | 0 |
| TA198 | This program has been retired. | 1 | 0 |
| TA199 | This program has been retired. | 1 | 0 |
| TA205 | Plan Class Listing | 1 | 2 |
| TA220 | Plan Listing | 1 | 7 |
| TA230 | Formula Listing | 1 | 3 |
| TA241 | Canada Vacation Transaction Report | 1 | 6 |
| TA242 | Canada Vacation Employee Plan, Balance Listing | 1 | 5 |
| TA260 | Employee Plan Listing | 1 | 8 |
| TA265 | History Usage Report | 1 | 8 |
| TA270 | Open Manual Transactions | 1 | 5 |
| TA290 | Transaction History Report | 1 | 8 |
| TA300 | Time Accrual Purge | 2 | 2 |
| TA310 | Employee Plan Purge | 4 | 3 |
| TA340 | Canada Vacation History Purge | 2 | 2 |
| TA341 | Canada Vacation Employee Plan Purge | 4 | 4 |
| TA542 | Canada Vacation Balance Load | 3 | 4 |
| TA570 | CSV Load Balances | 3 | 4 |
Other tables used by Event Management programs (109)
ACACCTCAT, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, ACCOMMIT, ACCOMMITX, ADDRDATA, ATTENDCODE, C6EMDDMSTR, C6EMPADDRT, C6PRDDEF, C6PRDDTL, CAVACMSTR, CMASSIGN, CMCONTRACT, CMCONTRULE, CMPAYCYC, CWASSIGN, CWCONTRACT, CWCONTRULE, DEDCODE, DEPTCODE, DEPTSEGBLK, EMDEDMASTR, EMDISTMAST, EMPLOYEE, EMSTATUS, FBDETAIL, FBFUNDAMT, FBFUNDDTL, FBTRANS, FBYETR, GLADDRESS, GLCHART, GLCODES, GLCOMMIT, GLCOMMITX, GLHISCOMBL, GLHISCOMX, GLINTCO, GLNAMES, GLSYSTEM, HRHISTORY, HRSECLEV, INSTCTRYCD, JOBCODE, LPLINK, LPPENDREQ, ONETMDED, PADICT, PAEMPLOYEE, PAEMPPOS, PAPOSITION, PAPOSRULE, PASCRTY, PAYCLASS, PAYDEDUCTN, PAYMASTR, PAYSUMGRP, PCODES, PCODESDTL, PERSACTION, PERSGROUP, PGEMPLOYEE, PLAN, PRBATCH, PRBUSGRP, PRCHECK, PREMDEDHST, PRHOURS, PRMONITOR, PROVERTIME, PRPAYCODE, PRPENPAY, PRPROCGRP, PRPROVINCE, PRQCENTGRP, PRRATEHIST, PRRATES, PRREGPARM, PRSAGDTL, PRSAGHEAD, PRSHIFTHDR, PRSHIFTTBL, PRSTATE, PRSYSTEM, PRTAXAUTH, PRTAXLEVY, PRTAXLOC, PRTIME, PSGRELATE, SUBCKPOINT, SYSTEMCODE, TAEEMASTER, TAEMPSERV, TAENROLL, TAPAYROLL, TAPLAN, TAREASCODE, TASERVCODE, TASERVICE, TASTRUCTUR, TAXGROUP, TIMERECORD, TIPPAY, TRSGBLCK, WCCLASSOVR
