CW – Lawson tables and programs
CW in Lawson S3 v10 MSP6 has 12 tables, 0 online screens and 0 batch programs. The source library does not name this system; the folder code is used.
Tables (12)
| Table | Prefix | Description | Primary key | Fields |
|---|---|---|---|---|
| CMASSIGN | CAS | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, CONTRACT-NBR, SEGMENT-NBR | 71 |
| CMCHANGE | CHG | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, POS-LEVEL, EFFECT-DATE, CHANGE-TYPE, WORK-SCHED, CONTRACT-YEAR, CONTRACT-NBR | 27 |
| CMCONTRACT | CNR | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, CONTRACT-NBR | 54 |
| CMCONTRULE | CRU | No description in the Lawson data dictionary | COMPANY, CONTRACT-GROUP, EFFECT-DATE | 33 |
| CMEMPTRANS | CET | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, CONTRACT-NBR, TRANS-SEQ-NBR | 25 |
| CMPAYCYC | CYC | No description in the Lawson data dictionary | COMPANY, CONTRACT-YEAR, WORK-SCHED, PAY-START-DATE | 12 |
| CWASSIGN | CWA | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, CONTRACT-YEAR, POSITION, ASG-EFFECT-DTE, PCD-SEQ-NBR | 76 |
| CWCHANGE | CCH | Employee Contract Change Audit | COMPANY, EMPLOYEE, POSITION, WORK-SCHED, EFFECT-DATE, CHANGE-TYPE | 23 |
| CWCONTRACT | CCT | Contracts are used in K12 school districts to manage and track employee employment records and drive an employee's pay… | COMPANY, EMPLOYEE, CONTRACT-YEAR, POSITION, CONT-SEQ-NBR | 95 |
| CWCONTRULE | CWC | No description in the Lawson data dictionary | COMPANY, CONTRACT-GROUP, EFFECT-DATE | 28 |
| CWDISTRIB | CWD | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, CONTRACT-YEAR, POSITION, CONT-SEQ-NBR, PAY-CODE, GL-EFFECT-DATE, GL-SEQ-NBR | 23 |
| CWEMPTRANS | CCE | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, CONTRACT-YEAR, POSITION, CONT-SEQ-NBR, TRANS-SEQ-NBR | 23 |