CMCONTRULE – No description in the Lawson data dictionary

System
CW (CW)
Prefix
CRU
Primary key
COMPANY, CONTRACT-GROUP, EFFECT-DATE
Fields
33
Updated by
0 programs
Referenced by
0 programs

CMCONTRULE is a Lawson CW table (prefix CRU); no description in the lawson data dictionary. It is indexed by COMPANY, CONTRACT-GROUP, EFFECT-DATE (CRUSET1); alternate indexes: CRUSET2 and CRUSET3. It is related 1:1 to PRSYSTEM, PAYCLASS and PCODES and 1:M to PRPAYCODE. The table has 33 fields, 3 indexes and 10 documented relations.

About CMCONTRULE

No description in the Lawson data dictionary.

Fields (33)

Column = COBOL field name without the CRU- 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 / columnTypeDescription & valuesUpdated by
#CRU-COMPANY PK
COMPANY		Numeric 4——
#CRU-CONTRACT-GROUP PK
CONTRACT_GROUP		Alpha 15——
#CRU-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)——
#CRU-PAID-CODE
PAID_CODE		Alpha 10——
#CRU-UNPAID-CODE
UNPAID_CODE		Alpha 10——
#CRU-WEEKEND-CODE
WEEKEND_CODE		Alpha 10——
#CRU-CONTRACT-PAY
CONTRACT_PAY		Alpha 3——
#CRU-DOCKING-PAY
DOCKING_PAY		Alpha 3——
#CRU-BENEFIT-PAY
BENEFIT_PAY		Alpha 3——
#CRU-BENEFIT-SALARY
BENEFIT_SALARY		Alpha 1 Occurs 5 Times ×5——
#CRU-PAY-CYCLE
PAY_CYCLE		Alpha 1 Occurs 9 Times ×9——
#CRU-TR-CREATION
TR_CREATION		Numeric 1—
  • 1 Paid by Pay Cycle
  • 2 Paid by Work Period
  • 3 Earned + Res by Pay Cycle
  • 4 Earned Work Per + Res Pay Cyc
  • 5 Daily Earned + Res by Pay Cyc
—
#CRU-BEF-FIRST-CYC
BEF_FIRST_CYC		Numeric 1—
  • 1 No Reserve
  • 2 All in Reserve
—
#CRU-LATE-START-DT
LATE_START_DT		Numeric 1—
  • 1 Pay Actual
  • 2 Normal Payout
  • 3 All in Reserve
—
#CRU-REGULAR
REGULAR		Alpha 4——
#CRU-RESERVE
RESERVE		Alpha 4——
#CRU-RETRO-REG
RETRO_REG		Alpha 4——
#CRU-RETRO-RES
RETRO_RES		Alpha 4——
#CRU-ROUND-METH-UNT
ROUND_METH_UNT		Numeric 1—
  • 0 None
  • 1 Normal
  • 2 High
  • 3 Low
—
#CRU-ROUND-TO-UNIT
ROUND_TO_UNIT		Signed 18.6——
#CRU-ROUND-METH-DOL
ROUND_METH_DOL		Numeric 1—
  • 0 None
  • 1 Normal
  • 2 High
  • 3 Low
—
#CRU-ROUND-TO-DOL
ROUND_TO_DOL		Signed 18.6——
#CRU-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)——
#CRU-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)——
#CRU-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)——
#CRU-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)——
#CRU-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)——
#CRU-USER-ID
USER_ID		Alpha 10 (Lower Case)——
#CRU-LATE-STEP-DOWN
LATE_STEP_DOWN		Numeric 1—
  • 0 No
  • 1 Yes
—
#CRU-EQUALIZE-WAGE
EQUALIZE_WAGE		Numeric 1—
  • 0 No
  • 1 Yes; No Adjustment
  • 2 Yes; With Adjustment
—
#CRU-TRUNCATE-AMT
TRUNCATE_AMT		Numeric 1—
  • 0 No
  • 1 Yes
—
#CRU-TOLERANCE-AMT
TOLERANCE_AMT		Signed 18.6——
#CRU-WITHHOLD-RES
WITHHOLD_RES		Numeric 1—
  • 0 No
  • 1 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.

IndexKeysFlagsConditionUsed in
CRUSET1
  1. COMPANY
  2. CONTRACT-GROUP
  3. EFFECT-DATE ↓
PrimaryBN150, BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +22 more (list truncated in source)
CRUSET2
  1. COMPANY
  2. CONTRACT-GROUP
  3. EFFECT-DATE
—
CRUSET3
  1. COMPANY
  2. EFFECT-DATE ↓
  3. CONTRACT-GROUP
—

Relations

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

One to one (6) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
CRU-COMPANY→PRS-COMPANY (PRSSET1)
Spaces→PRS-PROCESS-LEVEL
Contract PayPAYCLASSRequired
CRU-COMPANY→PCL-COMPANY
CRU-CONTRACT-PAY→PCL-PAY-CLASS
Docking PayPAYCLASSRequiredWhen (CRU-DOCKING-PAY != Spaces)
CRU-COMPANY→PCL-COMPANY
CRU-DOCKING-PAY→PCL-PAY-CLASS
Paid Day CodePCODESRequired
"DC"→PCO-TYPE
CRU-PAID-CODE→PCO-CODE
Unpd Day CodePCODESRequired
"DC"→PCO-TYPE
CRU-UNPAID-CODE→PCO-CODE
Wknd Day CodePCODESRequired
"DC"→PCO-TYPE
CRU-WEEKEND-CODE→PCO-CODE

One to many (4) — child tables

RelationTableRulesConditionField map
RegularPRPAYCODERequired
CRU-COMPANY→PCD-COMPANY
CRU-REGULAR→PCD-PAY-CODE
—→PCD-PROCESS-LEVEL
—→PCD-JOB-CODE
ReservePRPAYCODERequiredWhen (CRU-RESERVE != Spaces)
CRU-COMPANY→PCD-COMPANY
CRU-RESERVE→PCD-PAY-CODE
—→PCD-PROCESS-LEVEL
—→PCD-JOB-CODE
Retro RegPRPAYCODERequiredWhen CRU-RETRO-REG != Spaces
CRU-COMPANY→PCD-COMPANY
CRU-RETRO-REG→PCD-PAY-CODE
—→PCD-PROCESS-LEVEL
—→PCD-JOB-CODE
Retro ResPRPAYCODERequiredWhen CRU-RETRO-RES != Spaces
CRU-COMPANY→PCD-COMPANY
CRU-RETRO-RES→PCD-PAY-CODE
—→PCD-PROCESS-LEVEL
—→PCD-JOB-CODE

Programs

No Lawson programs are documented as updating or referencing this table.