CWCONTRULE – No description in the Lawson data dictionary

System: CW (CW)
Prefix: CWC
Primary key: COMPANY, CONTRACT-GROUP, EFFECT-DATE
Fields: 28
Updated by: 2 programs
Referenced by: 169 programs

CWCONTRULE is a Lawson CW table (prefix CWC); no description in the lawson data dictionary. It is indexed by COMPANY, CONTRACT-GROUP, EFFECT-DATE (CWCSET1); alternate indexes: CWCSET2 and CWCSET3. It is related 1:1 to PRSYSTEM, PAYCLASS and PCODES and 1:M to PRPAYCODE. It is updated by PR20.1 and PR20.4 and referenced by BN150, BN305, EXI2.1, EXI4.1, HR00.1, HR01.1, HR04.2, HR04.3 and 161 more. The table has 28 fields, 3 indexes and 10 documented relations.

About CWCONTRULE

No description in the Lawson data dictionary.

Fields (28)

Column = COBOL field name without the CWC- 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
#`CWC-COMPANY` PK COMPANY	Numeric 4	—	—
#`CWC-EFFECT-DATE` PK EFFECT_DATE	Numeric 8 (yyyymmdd)	—	—
#`CWC-PAID-CODE` PAID_CODE	Alpha 10	—	—
#`CWC-UNPAID-CODE` UNPAID_CODE	Alpha 10	—	—
#`CWC-WEEKEND-CODE` WEEKEND_CODE	Alpha 10	—	—
#`CWC-CONTRACT-PAY` CONTRACT_PAY	Alpha 3	—	—
#`CWC-DOCKING-PAY` DOCKING_PAY	Alpha 3	—	—
#`CWC-PAY-CYCLE` PAY_CYCLE	Alpha 1 Occurs 9 Times ×9	—	—
#`CWC-ROUND-METH-UNT` ROUND_METH_UNT	Numeric 1	— `0` None `1` Normal `2` High `3` Low	—
#`CWC-ROUND-TO-UNIT` ROUND_TO_UNIT	Signed 18.6	—	—
#`CWC-ROUND-METH-DOL` ROUND_METH_DOL	Numeric 1	— `0` None `1` Normal `2` High `3` Low	—
#`CWC-ROUND-TO-DOL` ROUND_TO_DOL	Signed 18.6	—	—
#`CWC-TR-CREATION` TR_CREATION	Numeric 1	— `1` Paid by Pay Period `2` Earned + Reserve by Pay Period `3` Earned + Reserve by Wrk Period `4` Daily Earned + Res by Pay Per `5` Daily Earned + Daily Reserve	—
#`CWC-PAY-PER-CALC` PAY_PER_CALC	Numeric 1	— `1` Remain Wages/Remain Pay Period `2` Full Amount/Full Pay Periods	—
#`CWC-TOLERANCE-AMT` TOLERANCE_AMT	Signed 18.6	—	—
#`CWC-REGULAR` REGULAR	Alpha 4	—	—
#`CWC-RESERVE` RESERVE	Alpha 4	—	—
#`CWC-ADJUSTMENT` ADJUSTMENT	Alpha 4	—	—
#`CWC-PAYOUT` PAYOUT	Alpha 4	—	—
#`CWC-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	—
#`CWC-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	—
#`CWC-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	—
#`CWC-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	—
#`CWC-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	—
#`CWC-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	—
#`CWC-CONTRACT-GROUP` PK CONTRACT_GROUP	Alpha 15	—	—
#`CWC-RESV-FIRST-PAY` RESV_FIRST_PAY	Alpha 1	— `1` No `2` Yes	—
#`CWC-WEB-AVAILABLE` WEB_AVAILABLE	Alpha 1	— `1` No `2` Yes	—

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	Used in
`CWCSET1`	`COMPANY` `CONTRACT-GROUP` `EFFECT-DATE` ↓	Primary	BN150, BN305, HR00.1, HR01.1, HR04.2, HR04.3, HR04.7, HR04.8 +22 more (list truncated in source)
`CWCSET2`	`COMPANY` `CONTRACT-GROUP` `EFFECT-DATE`		—
`CWCSET3`	`COMPANY` `EFFECT-DATE` ↓ `CONTRACT-GROUP`		—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

One to one (6) — lookups and parents

Relation Table Rules Condition Field map

Company

PRSYSTEM

Required

`CWC-COMPANY`	→	`PRS-COMPANY (PRSSET1)`
`Spaces`	→	`PRS-PROCESS-LEVEL`

Contract Pay

PAYCLASS

Required

`CWC-COMPANY`	→	`PCL-COMPANY`
`CWC-CONTRACT-PAY`	→	`PCL-PAY-CLASS`

Docking Pay

PAYCLASS

Required

When (CWC-DOCKING-PAY != Spaces)

`CWC-COMPANY`	→	`PCL-COMPANY`
`CWC-DOCKING-PAY`	→	`PCL-PAY-CLASS`

Paid Day Code

PCODES

Required

`"DC"`	→	`PCO-TYPE`
`CWC-PAID-CODE`	→	`PCO-CODE`

Unpd Day Code

PCODES

Required

`"DC"`	→	`PCO-TYPE`
`CWC-UNPAID-CODE`	→	`PCO-CODE`

Wknd Day Code

PCODES

Required

`"DC"`	→	`PCO-TYPE`
`CWC-WEEKEND-CODE`	→	`PCO-CODE`

One to many (4) — child tables

Relation Table Rules Condition Field map

Adjustment

PRPAYCODE

`CWC-COMPANY`	→	`PCD-COMPANY`
`CWC-ADJUSTMENT`	→	`PCD-PAY-CODE`
—	→	`PCD-PROCESS-LEVEL`
—	→	`PCD-JOB-CODE`

Payout

PRPAYCODE

`CWC-COMPANY`	→	`PCD-COMPANY`
`CWC-PAYOUT`	→	`PCD-PAY-CODE`
—	→	`PCD-PROCESS-LEVEL`
—	→	`PCD-JOB-CODE`

Regular

PRPAYCODE

`CWC-COMPANY`	→	`PCD-COMPANY`
`CWC-REGULAR`	→	`PCD-PAY-CODE`
—	→	`PCD-PROCESS-LEVEL`
—	→	`PCD-JOB-CODE`

Reserve

PRPAYCODE

Valid When (CWC-RESERVE != Spaces)

`CWC-COMPANY`	→	`PCD-COMPANY`
`CWC-RESERVE`	→	`PCD-PAY-CODE`
—	→	`PCD-PROCESS-LEVEL`
—	→	`PCD-JOB-CODE`

Programs

Updated by (2)

PR20.1 Pay Class
PR20.4 Pay Code

Referenced by (169)

BN150 Life Insurance Reportable Income
BN305 Highly Compensated Employees
EXI2.1 Invoke for PRTRDPD
EXI4.1 Invoke for PRPRBPD
HR00.1 Company
HR01.1 Process Level
HR04.2 Human Resource Codes
HR04.3 Human Resource Codes
HR04.7 User Fields Value List
HR04.8 Human Resource Codes
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR28.1 Employee Ethnicity
HR511 Employee Conversion
HR80.1 Job Occupation Type
HR80.2 Union
HR80.3 Bargaining Unit
HR80.4 Badge Code
HR80.5 Mail Group
HR80.6 Hire Source
HR80.7 User Level
HR80.8 Relationship
HR80.9 Primary Care Physician
HR81.1 Education Degree
HR81.2 Education Subject
HR81.3 Education Institution
HR81.4 Competency
HR81.5 Competency and Certification Source
HR81.6 Certification
HR81.7 Company Property
HR81.8 Emergency Medical
HR81.9 Work Restriction
HR82.1 Working Condition
HR82.2 Work Requirement
HR82.3 Parking Lot
HR82.4 Relocation
HR82.5 Benefit
HR82.6 Qualification
HR82.7 Proficiency
HR82.8 User Field
HR82.9 Association
HR83.1 Review Type
HR83.2 Performance Rating
HR83.3 Applicant Rating
HR83.4 Interview Rating
HR83.5 Personnel Action Reason
HR83.6 Review Type
HR83.7 Benefit Reason Code
HR83.8 Requisition Status
HR83.9 Reason Code
HR84.1 Position Reason Code
HR84.2 Budget Reason Code
HR84.3 Requisition Cost
HR84.4 Supervisor User Field 1
HR84.5 Supervisor User Field 2
HR84.6 Supervisor User Field 3
HR84.7 Supervisor User Field 4
HR84.8 Supervisor User Field 5
HR84.9 Incident Status
HR85.1 Incident Outcome
HR85.2 Incident Category
HR85.3 Incident
HR85.4 Illness
HR85.5 Body Part
HR85.6 Incident Cost Category
HR85.7 Incident Cost Type
HR85.8 Accommodations
HR86.1 Incident Follow Up Category
HR86.2 Incident Follow Up Type
HR86.3 Incident Follow Up Outcome
HR86.4 Test Type
HR86.5 Test Correspondence
HR86.6 Test Source
HR86.7 Test User Field 2
HR86.8 Test User Field 3
HR86.9 Test Eligibility Override Reason
HR87.1 Test Reason
HR87.2 Test Notification Type
HR87.3 Test Refusal Reason
HR87.4 Incident Severity
HR87.5 Incident User 2
HR87.6 Incident User 3
HR87.7 Grievance and Disciplinary Action Category
HR87.8 Grievance and Disciplinary Action Status
HR87.9 Grievance and Disciplinary Action Outcome
HR88.1 Grievance and Disciplinary Action Step Category
HR88.2 Grievance and Disciplinary Action Step Type
HR88.3 Grievance and Disciplinary Action Step Outcome
HR88.4 Human Resource Codes - Disability
HR88.5 Human Resource Codes - Religion
HR88.6 Contract Type
HR88.7 Census Metropolitan Area
HR89.1 HR Codes - Work Eligibility Document Type
HR89.2 HR Codes - Work Eligibility Document Description
HR89.3 Human Resource Codes - Work Eligibility Status
HR89.4 Human Resource Codes - Travel Doc Application Status
HR89.5 Human Resource Codes - Travel Document
HR89.6 Human Resource Codes - Contact Number Type
HR89.7 HR Codes - Official Languages - Bilingual Region
HR89.8 Sharp Device
HR89.9 Brand of Device
HR91.7 Objective Status
HR92.1 Day Codes
HR92.2 Leave Status
HR92.3 Leave Reason
LP130 Absence Plan Payout
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
PR128 Offset Time Record Creation
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
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
PR30.2 Employee Automatic Time Record
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
PR512 Employee ACH Distribution Interface
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
ZH510 Update PCP from ZPENDPCP

CWCONTRULE – No description in the Lawson data dictionary

About CWCONTRULE

Fields (28) Copy as SQL

Indexes (3)

Relations

One to one (6) — lookups and parents

One to many (4) — child tables

Programs

Updated by (2)

Referenced by (169)

Fields (28)