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.

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

IndexKeysFlagsConditionUsed in
CWCSET1COMPANY, CONTRACT-GROUP, EFFECT-DATE*PrimaryBN150, BN305, HR00.1, HR01.1, HR04.2, HR04.3, HR04.7, HR04.8 +22 more (list truncated in source)
CWCSET2COMPANY, CONTRACT-GROUP, EFFECT-DATE—
CWCSET3COMPANY, EFFECT-DATE*, CONTRACT-GROUP—

Relations

One to one (6) — lookups and parents

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

One to many (4) — child tables

RelationTableRulesConditionField map
AdjustmentPRPAYCODECWC-COMPANY → PCD-COMPANY, CWC-ADJUSTMENT → PCD-PAY-CODE, → PCD-PROCESS-LEVEL, → PCD-JOB-CODE
PayoutPRPAYCODECWC-COMPANY → PCD-COMPANY, CWC-PAYOUT → PCD-PAY-CODE, → PCD-PROCESS-LEVEL, → PCD-JOB-CODE
RegularPRPAYCODECWC-COMPANY → PCD-COMPANY, CWC-REGULAR → PCD-PAY-CODE, → PCD-PROCESS-LEVEL, → PCD-JOB-CODE
ReservePRPAYCODEValid When (CWC-RESERVE != Spaces)CWC-COMPANY → PCD-COMPANY, CWC-RESERVE → PCD-PAY-CODE, → PCD-PROCESS-LEVEL, → PCD-JOB-CODE

Programs

Updated by (2)

Referenced by (169)