CWEMPTRANS – No description in the Lawson data dictionary

System
CW (CW)
Prefix
CCE
Primary key
COMPANY, EMPLOYEE, CONTRACT-YEAR, POSITION, CONT-SEQ-NBR, TRANS-SEQ-NBR
Fields
23
Updated by
0 programs
Referenced by
0 programs

CWEMPTRANS is a Lawson CW table (prefix CCE); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, CONTRACT-YEAR, POSITION, CONT-SEQ-NBR, TRANS-SEQ-NBR (CCESET1); alternate indexes: CCESET2, CCESET3, CCESET4 and CCESET5. It is related 1:1 to PRSYSTEM, CWCONTRACT, EMPLOYEE and PAEMPLOYEE and 1:M to CWASSIGN and PRTIME. The table has 23 fields, 5 indexes and 6 documented relations.

About CWEMPTRANS

No description in the Lawson data dictionary.

Fields (23)

Column = COBOL field name without the CCE- 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
#CCE-COMPANY PK
COMPANY		Numeric 4——
#CCE-EMPLOYEE PK
EMPLOYEE		Numeric 9——
#CCE-CONTRACT-YEAR PK
CONTRACT_YEAR		Numeric 4——
#CCE-POSITION PK
POSITION		Alpha 12——
#CCE-CONT-SEQ-NBR PK
CONT_SEQ_NBR		Numeric 12——
#CCE-TRANS-SEQ-NBR PK
TRANS_SEQ_NBR		Numeric 12——
#CCE-CHECK-ID SET4
CHECK_ID		Numeric 12——
#CCE-PAY-START-DATE
PAY_START_DATE		Numeric 8 (yyyymmdd)——
#CCE-PAY-END-DATE SET2 SET3
PAY_END_DATE		Numeric 8 (yyyymmdd)——
#CCE-PCD-SEQ-NBR
PCD_SEQ_NBR		Numeric 8——
#CCE-EARNED-WAGES
EARNED_WAGES		Signed 18.6——
#CCE-EARNED-UNITS
EARNED_UNITS		Signed 18.6——
#CCE-DOCKED-WAGES
DOCKED_WAGES		Signed 18.6——
#CCE-DOCKED-UNITS
DOCKED_UNITS		Signed 18.6——
#CCE-PAID-WAGES
PAID_WAGES		Signed 18.6——
#CCE-PAID-UNITS
PAID_UNITS		Signed 18.6——
#CCE-RESERVE-WAGES
RESERVE_WAGES		Signed 18.6——
#CCE-RESERVE-UNITS
RESERVE_UNITS		Signed 18.6——
#CCE-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)——
#CCE-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)——
#CCE-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)——
#CCE-CHECK-NBR SET5
CHECK_NBR		Numeric 8——
#CCE-CHECK-DATE SET5
CHECK_DATE		Numeric 8 (yyyymmdd)——

Indexes (5)

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
CCESET1
  1. COMPANY
  2. EMPLOYEE
  3. CONTRACT-YEAR ↓
  4. POSITION
  5. CONT-SEQ-NBR ↓
  6. TRANS-SEQ-NBR ↓
PrimaryBN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source)
CCESET2
  1. COMPANY
  2. EMPLOYEE
  3. CONTRACT-YEAR
  4. POSITION
  5. PAY-END-DATE
  6. CONT-SEQ-NBR
  7. TRANS-SEQ-NBR
—
CCESET3
  1. COMPANY
  2. CONTRACT-YEAR ↓
  3. EMPLOYEE
  4. POSITION
  5. PAY-END-DATE ↓
  6. CONT-SEQ-NBR ↓
  7. TRANS-SEQ-NBR ↓
SubsetWhere (CONT-SEQ-NBR != Zeroes)—
CCESET4
  1. COMPANY
  2. CONTRACT-YEAR
  3. EMPLOYEE
  4. CHECK-ID
  5. POSITION
  6. TRANS-SEQ-NBR
—
CCESET5
  1. COMPANY
  2. CONTRACT-YEAR
  3. EMPLOYEE
  4. CHECK-DATE ↓
  5. CHECK-NBR
  6. POSITION
  7. TRANS-SEQ-NBR
—

Relations

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

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
CCE-COMPANY→PRS-COMPANY (PRSSET1)
Spaces→PRS-PROCESS-LEVEL
Emp ContractCWCONTRACTRequired
CCE-COMPANY→CCT-COMPANY
CCE-EMPLOYEE→CCT-EMPLOYEE
CCE-CONTRACT-YEAR→CCT-CONTRACT-YEAR
CCE-POSITION→CCT-POSITION
CCE-CONT-SEQ-NBR→CCT-CONT-SEQ-NBR
EmployeeEMPLOYEERequired
CCE-COMPANY→EMP-COMPANY
CCE-EMPLOYEE→EMP-EMPLOYEE
PaemployeePAEMPLOYEERequired
CCE-COMPANY→PEM-COMPANY
CCE-EMPLOYEE→PEM-EMPLOYEE

One to many (2) — child tables

RelationTableRulesConditionField map
AssignmentCWASSIGN
CCE-COMPANY→CWA-COMPANY
CCE-CONTRACT-YEAR→CWA-CONTRACT-YEAR
CCE-EMPLOYEE→CWA-EMPLOYEE
CCE-POSITION→CWA-POSITION
—→CWA-ASG-EFFECT-DTE
—→CWA-PCD-SEQ-NBR
Time RecordPRTIME
CCE-COMPANY→PRT-COMPANY
CCE-EMPLOYEE→PRT-EMPLOYEE
CCE-PAY-END-DATE→PRT-PER-END-DATE
CCE-CHECK-ID→PRT-CHECK-ID
—→PRT-TIME-SEQ

Programs

No Lawson programs are documented as updating or referencing this table.