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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CRUSET1COMPANY, CONTRACT-GROUP, EFFECT-DATE*PrimaryBN150, BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +22 more (list truncated in source)
CRUSET2COMPANY, CONTRACT-GROUP, EFFECT-DATE—
CRUSET3COMPANY, EFFECT-DATE*, CONTRACT-GROUP—

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredCRU-COMPANY → PRS-COMPANY (PRSSET1), Spaces → PRS-PROCESS-LEVEL
Contract PayPAYCLASSRequiredCRU-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
RegularPRPAYCODERequiredCRU-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 != SpacesCRU-COMPANY → PCD-COMPANY, CRU-RETRO-REG → PCD-PAY-CODE, → PCD-PROCESS-LEVEL, → PCD-JOB-CODE
Retro ResPRPAYCODERequiredWhen CRU-RETRO-RES != SpacesCRU-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.