CMPAYCYC – No description in the Lawson data dictionary

System
CW (CW)
Prefix
CYC
Primary key
COMPANY, CONTRACT-YEAR, WORK-SCHED, PAY-START-DATE
Fields
12
Updated by
40 programs
Referenced by
0 programs

CMPAYCYC is a Lawson CW table (prefix CYC); no description in the lawson data dictionary. It is indexed by COMPANY, CONTRACT-YEAR, WORK-SCHED, PAY-START-DATE (CYCSET1); alternate indexes: CYCSET2. It is related 1:1 to PRSYSTEM and 1:M to CMCONTRULE and HRWRKSCHD. It is updated by BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 and 32 more. The table has 12 fields, 2 indexes and 3 documented relations.

About CMPAYCYC

No description in the Lawson data dictionary.

Fields (12)

Column = COBOL field name without the CYC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CYC-COMPANY PK
COMPANY		Numeric 4——
CYC-CONTRACT-YEAR PK
CONTRACT_YEAR		Numeric 4——
CYC-WORK-SCHED PK
WORK_SCHED		Alpha 10——
CYC-PAY-START-DATE PK
PAY_START_DATE		Numeric 8 (yyyymmdd)——
CYC-PAY-END-DATE
PAY_END_DATE		Numeric 8 (yyyymmdd)——
CYC-PAY-CYCLES
PAY_CYCLES		Numeric 3——
CYC-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)——
CYC-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)——
CYC-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)——
CYC-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)——
CYC-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)——
CYC-USER-ID
USER_ID		Alpha 10 (Lower Case)——

Indexes (2)

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

IndexKeysFlagsConditionUsed in
CYCSET1COMPANY, CONTRACT-YEAR, WORK-SCHED, PAY-START-DATEPrimaryBN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source)
CYCSET2COMPANY, CONTRACT-YEAR*, WORK-SCHED, PAY-START-DATE*—

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredCYC-COMPANY → PRS-COMPANY (PRSSET1), Spaces → PRS-PROCESS-LEVEL

One to many (2) — child tables

RelationTableRulesConditionField map
CmcontruleCMCONTRULECYC-COMPANY → CRU-COMPANY, Spaces → CRU-CONTRACT-GROUP, → CRU-EFFECT-DATE
HrwrkschdHRWRKSCHDCYC-COMPANY → WSC-COMPANY, CYC-WORK-SCHED → WSC-WORK-SCHED, CYC-CONTRACT-YEAR → WSC-CONTRACT-YEAR, → WSC-EFFECT-DATE

Programs

Updated by (40)