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.

Field / columnTypeDescription & valuesUpdated by
CNR-COMPANY PK
COMPANY		Numeric 4——
CNR-EMPLOYEE PK
EMPLOYEE		Numeric 9——
CNR-CONTRACT-NBR PK
CONTRACT_NBR		Numeric 6——
CNR-WORK-SCHED
WORK_SCHED		Alpha 10——
CNR-CONTRACT-YEAR
CONTRACT_YEAR		Numeric 4——
CNR-CONTRACT-GROUP
CONTRACT_GROUP		Alpha 15——
CNR-START-DATE
START_DATE		Numeric 8 (yyyymmdd)——
CNR-END-DATE
END_DATE		Numeric 8 (yyyymmdd)——
CNR-START-DT-OVR
START_DT_OVR		Numeric 1—
  • 0 No
  • 1 Yes
—
CNR-END-DT-OVR
END_DT_OVR		Numeric 1—
  • 0 No
  • 1 Yes
—
CNR-STATUS
STATUS		Numeric 1—
  • 0 Open
  • 3 Void
  • 9 Closed
—
CNR-CLOSE-DATE
CLOSE_DATE		Numeric 8 (yyyymmdd)——
CNR-PAYOUT
PAYOUT		Numeric 1—
  • 0 No
  • 1 Payout in Full
  • 2 Payout Reserve only
  • 3 Payout Summer Deferral
—
CNR-NBR-PAY-CYCLES
NBR_PAY_CYCLES		Numeric 3——
CNR-PAY-CYC-OVR
PAY_CYC_OVR		Numeric 1——
CNR-FULL-AMT
FULL_AMT		Signed 18.6——
CNR-FULL-UNITS
FULL_UNITS		Signed 18.6——
CNR-EST-CNR-AMT
EST_CNR_AMT		Signed 18.6——
CNR-BENEFIT-SAL
BENEFIT_SAL		Alpha 1 Occurs 5 Times ×5——
CNR-RIGHT
RIGHT		Alpha 10——
CNR-CHECK-GRP
CHECK_GRP		Alpha 1——
CNR-PROCESS-GRP
PROCESS_GRP		Alpha 1——
CNR-TAX-FREQ-OVER
TAX_FREQ_OVER		Numeric 3—
  • 001 Weekly
  • 002 Biweekly
  • 003 Semi-Monthly
  • 004 Monthly
  • 005 Daily
  • 006 Quarterly
  • 007 Semi-Annual
  • 008 Annual
  • 009 9 Month Academic Monthly
  • 010 10 Month Academic Monthly
—
CNR-PAY-CYCLE
PAY_CYCLE		Alpha 1 Occurs 9 Times ×9——
CNR-YTD-PAID-WAGES
YTD_PAID_WAGES		Signed 18.6——
CNR-YTD-PAID-UNITS
YTD_PAID_UNITS		Signed 18.6——
CNR-YTD-DOCKED-WGS
YTD_DOCKED_WGS		Signed 18.6——
CNR-YTD-DOCKED-UTS
YTD_DOCKED_UTS		Signed 18.6——
CNR-WAGE-BALANCE
WAGE_BALANCE		Signed 18.6——
CNR-UNITS-BALANCE
UNITS_BALANCE		Signed 18.6——
CNR-RESERVE-BAL
RESERVE_BAL		Signed 18.6——
CNR-RESERVE-UNITS
RESERVE_UNITS		Signed 18.6——
CNR-UNITS-WORKED
UNITS_WORKED		Signed 18.6——
CNR-UNITS-REMAIN
UNITS_REMAIN		Signed 18.6——
CNR-EP-RESV-PAYOUT
EP_RESV_PAYOUT		Numeric 1—
  • 0 No
  • 1 Lump Sum
  • 2 By Pay Cycle
—
CNR-EP-CHECK-GRP
EP_CHECK_GRP		Alpha 1——
CNR-EP-PROCESS-GRP
EP_PROCESS_GRP		Alpha 1——
CNR-UNIT-TYPE
UNIT_TYPE		Numeric 1—
  • 1 Hours
  • 2 Days
  • 3 Zero Annual Units
—
CNR-BEN-ELIG-FLAG
BEN_ELIG_FLAG		Numeric 1——
CNR-CES-STATUS
CES_STATUS		Numeric 1—
  • 0 Open
  • 9 Closed
—
CNR-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)——
CNR-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)——
CNR-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)——
CNR-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)——
CNR-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)——
CNR-USER-ID
USER_ID		Alpha 10 (Lower Case)——
CNR-LATE-STEP-DOWN
LATE_STEP_DOWN		Numeric 1—
  • 0 No
  • 1 Yes
—
CNR-EQUALIZE-WAGE
EQUALIZE_WAGE		Numeric 1—
  • 0 No
  • 1 Yes; No Adjustment
  • 2 Yes; With Adjustment
—
CNR-TRUNCATE-AMT
TRUNCATE_AMT		Numeric 1—
  • 0 No
  • 1 Yes
—
CNR-TOLERANCE-AMT
TOLERANCE_AMT		Signed 18.6——
CNR-WITHHOLD-RES
WITHHOLD_RES		Numeric 1—
  • 0 No
  • 1 Yes
—
CNR-YTD-SUMR-DEFRL
YTD_SUMR_DEFRL		Signed 18.6——
CNR-HRH-OBJ-ID
HRH_OBJ_ID		Numeric 12——
CNR-YTD-UNTS-DEFRL
YTD_UNTS_DEFRL		Signed 18.6——

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CNRSET1COMPANY, EMPLOYEE, CONTRACT-NBR*PrimaryBN150, BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1 +22 more (list truncated in source)
CNRSET2COMPANY, CONTRACT-YEAR*, EMPLOYEE, CONTRACT-NBR*—
CNRSET3COMPANY, CONTRACT-YEAR, WORK-SCHED, EMPLOYEE, CONTRACT-NBR—

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredCNR-COMPANY → PRS-COMPANY (PRSSET1), Spaces → PRS-PROCESS-LEVEL
Contract GroupPCODESRequiredWhen (CNR-CONTRACT-GROUP != Spaces)"CG" → PCO-TYPE, CNR-CONTRACT-GROUP → PCO-CODE
Contract RightPCODESRequiredWhen (CNR-RIGHT != Spaces)"RR" → PCO-TYPE, CNR-RIGHT → PCO-CODE
EmployeeEMPLOYEERequiredCNR-COMPANY → EMP-COMPANY, CNR-EMPLOYEE → EMP-EMPLOYEE
PaemployeePAEMPLOYEERequiredCNR-COMPANY → PEM-COMPANY, CNR-EMPLOYEE → PEM-EMPLOYEE
Work ScheduleHRWRKSCHDRequiredCNR-COMPANY → WSC-COMPANY, CNR-WORK-SCHED → WSC-WORK-SCHED, CNR-CONTRACT-YEAR → WSC-CONTRACT-YEAR, Zeroes → WSC-EFFECT-DATE

One to many (2) — child tables

RelationTableRulesConditionField map
AssignmentsCMASSIGNDelete CascadesCNR-COMPANY → CAS-COMPANY, CNR-EMPLOYEE → CAS-EMPLOYEE, CNR-CONTRACT-NBR → CAS-CONTRACT-NBR, → CAS-SEGMENT-NBR
Contract RuleCMCONTRULECNR-COMPANY → CRU-COMPANY, CNR-CONTRACT-GROUP → CRU-CONTRACT-GROUP, → CRU-EFFECT-DATE

Programs

Updated by (32)

Referenced by (55)