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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 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
CYCSET1
  1. COMPANY
  2. CONTRACT-YEAR
  3. WORK-SCHED
  4. PAY-START-DATE
PrimaryBN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source)
CYCSET2
  1. COMPANY
  2. CONTRACT-YEAR ↓
  3. WORK-SCHED
  4. PAY-START-DATE ↓
—

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
CYC-COMPANY→PRS-COMPANY (PRSSET1)
Spaces→PRS-PROCESS-LEVEL

One to many (2) — child tables

RelationTableRulesConditionField map
CmcontruleCMCONTRULE
CYC-COMPANY→CRU-COMPANY
Spaces→CRU-CONTRACT-GROUP
—→CRU-EFFECT-DATE
HrwrkschdHRWRKSCHD
CYC-COMPANY→WSC-COMPANY
CYC-WORK-SCHED→WSC-WORK-SCHED
CYC-CONTRACT-YEAR→WSC-CONTRACT-YEAR
—→WSC-EFFECT-DATE

Programs

Updated by (40)