CMCONTRACT – No description in the Lawson data dictionary
- System
- CW (CW)
- Prefix
CNR- Primary key
COMPANY,EMPLOYEE,CONTRACT-NBR- Fields
- 54
- Updated by
- 32 programs
- Referenced by
- 55 programs
CMCONTRACT is a Lawson CW table (prefix CNR); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, CONTRACT-NBR (CNRSET1); alternate indexes: CNRSET2 and CNRSET3. It is related 1:1 to PRSYSTEM, PCODES, EMPLOYEE, PAEMPLOYEE and HRWRKSCHD and 1:M to CMASSIGN and CMCONTRULE. It is updated by BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 and 24 more and referenced by BN150, EXI2.1, EXI4.1, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1 and 47 more. The table has 54 fields, 3 indexes and 8 documented relations.
About CMCONTRACT
No description in the Lawson data dictionary.
Fields (54)
Column = COBOL field name without the CNR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#CNR-COMPANY PKCOMPANY | Numeric 4 | — | — |
#CNR-EMPLOYEE PKEMPLOYEE | Numeric 9 | — | — |
#CNR-CONTRACT-NBR PKCONTRACT_NBR | Numeric 6 | — | — |
#CNR-WORK-SCHED SET3WORK_SCHED | Alpha 10 | — | — |
#CNR-CONTRACT-YEAR SET2 SET3CONTRACT_YEAR | Numeric 4 | — | — |
#CNR-CONTRACT-GROUPCONTRACT_GROUP | Alpha 15 | — | — |
#CNR-START-DATESTART_DATE | Numeric 8 (yyyymmdd) | — | — |
#CNR-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | — | — |
#CNR-START-DT-OVRSTART_DT_OVR | Numeric 1 | —
| — |
#CNR-END-DT-OVREND_DT_OVR | Numeric 1 | —
| — |
#CNR-STATUSSTATUS | Numeric 1 | —
| — |
#CNR-CLOSE-DATECLOSE_DATE | Numeric 8 (yyyymmdd) | — | — |
#CNR-PAYOUTPAYOUT | Numeric 1 | —
| — |
#CNR-NBR-PAY-CYCLESNBR_PAY_CYCLES | Numeric 3 | — | — |
#CNR-PAY-CYC-OVRPAY_CYC_OVR | Numeric 1 | — | — |
#CNR-FULL-AMTFULL_AMT | Signed 18.6 | — | — |
#CNR-FULL-UNITSFULL_UNITS | Signed 18.6 | — | — |
#CNR-EST-CNR-AMTEST_CNR_AMT | Signed 18.6 | — | — |
#CNR-BENEFIT-SALBENEFIT_SAL | Alpha 1 Occurs 5 Times ×5 | — | — |
#CNR-RIGHTRIGHT | Alpha 10 | — | — |
#CNR-CHECK-GRPCHECK_GRP | Alpha 1 | — | — |
#CNR-PROCESS-GRPPROCESS_GRP | Alpha 1 | — | — |
#CNR-TAX-FREQ-OVERTAX_FREQ_OVER | Numeric 3 | —
| — |
#CNR-PAY-CYCLEPAY_CYCLE | Alpha 1 Occurs 9 Times ×9 | — | — |
#CNR-YTD-PAID-WAGESYTD_PAID_WAGES | Signed 18.6 | — | — |
#CNR-YTD-PAID-UNITSYTD_PAID_UNITS | Signed 18.6 | — | — |
#CNR-YTD-DOCKED-WGSYTD_DOCKED_WGS | Signed 18.6 | — | — |
#CNR-YTD-DOCKED-UTSYTD_DOCKED_UTS | Signed 18.6 | — | — |
#CNR-WAGE-BALANCEWAGE_BALANCE | Signed 18.6 | — | — |
#CNR-UNITS-BALANCEUNITS_BALANCE | Signed 18.6 | — | — |
#CNR-RESERVE-BALRESERVE_BAL | Signed 18.6 | — | — |
#CNR-RESERVE-UNITSRESERVE_UNITS | Signed 18.6 | — | — |
#CNR-UNITS-WORKEDUNITS_WORKED | Signed 18.6 | — | — |
#CNR-UNITS-REMAINUNITS_REMAIN | Signed 18.6 | — | — |
#CNR-EP-RESV-PAYOUTEP_RESV_PAYOUT | Numeric 1 | —
| — |
#CNR-EP-CHECK-GRPEP_CHECK_GRP | Alpha 1 | — | — |
#CNR-EP-PROCESS-GRPEP_PROCESS_GRP | Alpha 1 | — | — |
#CNR-UNIT-TYPEUNIT_TYPE | Numeric 1 | —
| — |
#CNR-BEN-ELIG-FLAGBEN_ELIG_FLAG | Numeric 1 | — | — |
#CNR-CES-STATUSCES_STATUS | Numeric 1 | —
| — |
#CNR-CREATE-DATECREATE_DATE | Numeric 8 (yyyymmdd) | — | — |
#CNR-CREATE-TIMECREATE_TIME | Numeric 6 (hhmmss) | — | — |
#CNR-CREATE-USER-IDCREATE_USER_ID | Alpha 10 (Lower Case) | — | — |
#CNR-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | — | — |
#CNR-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | — | — |
#CNR-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | — |
#CNR-LATE-STEP-DOWNLATE_STEP_DOWN | Numeric 1 | —
| — |
#CNR-EQUALIZE-WAGEEQUALIZE_WAGE | Numeric 1 | —
| — |
#CNR-TRUNCATE-AMTTRUNCATE_AMT | Numeric 1 | —
| — |
#CNR-TOLERANCE-AMTTOLERANCE_AMT | Signed 18.6 | — | — |
#CNR-WITHHOLD-RESWITHHOLD_RES | Numeric 1 | —
| — |
#CNR-YTD-SUMR-DEFRLYTD_SUMR_DEFRL | Signed 18.6 | — | — |
#CNR-HRH-OBJ-IDHRH_OBJ_ID | Numeric 12 | — | — |
#CNR-YTD-UNTS-DEFRLYTD_UNTS_DEFRL | Signed 18.6 | — | — |
Indexes (3)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
CNRSET1 |
| Primary | BN150, BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1 +22 more (list truncated in source) | |
CNRSET2 |
| — | ||
CNRSET3 |
| — |
Relations
One to one (6) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Company | PRSYSTEM | Required |
| |||||||||||||
| Contract Group | PCODES | Required | When (CNR-CONTRACT-GROUP != Spaces) |
| ||||||||||||
| Contract Right | PCODES | Required | When (CNR-RIGHT != Spaces) |
| ||||||||||||
| Employee | EMPLOYEE | Required |
| |||||||||||||
| Paemployee | PAEMPLOYEE | Required |
| |||||||||||||
| Work Schedule | HRWRKSCHD | Required |
|
One to many (2) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Assignments | CMASSIGN | Delete Cascades |
| |||||||||||||
| Contract Rule | CMCONTRULE |
|
Programs
Updated by (32)
- BN305 Highly Compensated Employees
- HR11.1 Employee
- HR11.2 Compensation Analysis
- HR11.4 Employee Assignment Inquiry
- HR28.1 Employee Ethnicity
- HR511 Employee Conversion
- LT101 HRM Receiver Update
- LT111 HRM Receiver Update
- PA02.1 Position
- PA100 Action Update
- PA102 Position Update
- PA115 Employee Purge
- PA13.1 Multiple Positions and Jobs
- PA13.2 Multiple Position and Job History
- PA502 Position Conversion
- PA513 Position and Job Conversion
- PA52.1 Individual Action
- PA52.3 Mass Action
- PA52.4 Hire an Applicant
- PA52.5 Position and Job Action
- PR110 Step And Grade Audit
- PR113 United States Tax Deduction Update
- PR12.6 Employee Automatic Deposit
- PR120 Mass Pay Update
- PR13.1 Employee United States Taxes
- PR13.5 Employee Canada Taxes
- PR13.6 Employee Canada Taxes
- PR13.8 U.S. Tax Deduction Errors
- PR13.9 Employee Additional Tax Details
- PR30.2 Employee Automatic Time Record
- PR512 Employee ACH Distribution Interface
- ZH510 Update PCP from ZPENDPCP
Referenced by (55)
- BN150 Life Insurance Reportable Income
- EXI2.1 Invoke for PRTRDPD
- EXI4.1 Invoke for PRPRBPD
- HAP3.1 Applicant Option 4 Selection Invoke
- HCRE.1 Action Reason Code Selects
- HEP4.1 Employee Option 4 Selection Invoke
- HPOS.1 Position Selection Invoke
- HPQC.1 Prqcentgrp Select Invoke
- HPRS.1 Process Level Select Invoke
- HR15.1 User Fields
- HR515 User Field Conversion
- HR54.1 Employee History Correction
- HRS1.1 Select Control
- HRSC.1 Select Control
- LP130 Absence Plan Payout
- LT11.5 HRM User Field Interface
- LT13.5 HRM User Field Interface History
- PA113 Retroactive History Update
- PA54.1 Personnel Action History Correction
- PR128 Offset Time Record Creation
- PR131 Retroactive Pay Calculation
- PR132 FLSA Overtime Calculation
- PR134 Automatic Time Records
- PR135 Time Record Edit
- PR136 Missing Time Records
- PR137 Batch Time Record Update
- PR189 Gross Up Calculation
- PR29.1 Pension Payment Maintenance
- PR32.1 Employee Daily Time Entry
- PR32.2 Employee Daily Time Entry
- PR33.1 Speed Entry Setup
- PR33.2 Speed Entry by Number
- PR33.3 Speed Entry by Name
- PR35.1 Time Entry
- PR35.2 Detail Time Entry
- PR35.3 Speed Time Entry
- PR35.4 Step and Grade, Grade Range Time Entry
- PR35.5 Attendance Time Entry
- PR35.6 Activity Time Entry
- PR35.8 Position Time Entry
- PR35.9 Reason Code Time Entry
- PR36.1 Time Record Entry
- PR36.4 Manual Time Record Maintenance
- PR37.1 Batch Time Control
- PR45.1 Error Processing
- PR521 Nonstandard Pay and Work Period CSV Load
- PR529 Pension Payroll Conversion
- PR530 Time Record Interface CSV
- PR560 Payroll History Load CSV
- PR582 Mass Adjustment Load
- PR80.1 Manual Check
- PR80.4 Manual Payment
- PR82.1 Adjustment
- TA147 Canada Vacation Audit
- UK102 Bonus Pay Update