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.

Field / column	Type	Description & values	Updated 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` CHECK_ID	Numeric 12	—	—
`CCE-PAY-START-DATE` PAY_START_DATE	Numeric 8 (yyyymmdd)	—	—
`CCE-PAY-END-DATE` 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` CHECK_NBR	Numeric 8	—	—
`CCE-CHECK-DATE` CHECK_DATE	Numeric 8 (yyyymmdd)	—	—

Indexes (5)

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

Index	Keys	Flags	Condition	Used in
`CCESET1`	`COMPANY`, `EMPLOYEE`, `CONTRACT-YEAR`, `POSITION`, `CONT-SEQ-NBR`, `TRANS-SEQ-NBR*`	Primary		BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source)
`CCESET2`	`COMPANY`, `EMPLOYEE`, `CONTRACT-YEAR`, `POSITION`, `PAY-END-DATE`, `CONT-SEQ-NBR`, `TRANS-SEQ-NBR`			—
`CCESET3`	`COMPANY`, `CONTRACT-YEAR`, `EMPLOYEE`, `POSITION`, `PAY-END-DATE`, `CONT-SEQ-NBR`, `TRANS-SEQ-NBR`	Subset	Where (CONT-SEQ-NBR != Zeroes)	—
`CCESET4`	`COMPANY`, `CONTRACT-YEAR`, `EMPLOYEE`, `CHECK-ID`, `POSITION`, `TRANS-SEQ-NBR`			—
`CCESET5`	`COMPANY`, `CONTRACT-YEAR`, `EMPLOYEE`, `CHECK-DATE*`, `CHECK-NBR`, `POSITION`, `TRANS-SEQ-NBR`			—

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Field map
Company	PRSYSTEM	Required	`CCE-COMPANY` → `PRS-COMPANY (PRSSET1)`, `Spaces` → `PRS-PROCESS-LEVEL`
Emp Contract	CWCONTRACT	Required	`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`
Employee	EMPLOYEE	Required	`CCE-COMPANY` → `EMP-COMPANY`, `CCE-EMPLOYEE` → `EMP-EMPLOYEE`
Paemployee	PAEMPLOYEE	Required	`CCE-COMPANY` → `PEM-COMPANY`, `CCE-EMPLOYEE` → `PEM-EMPLOYEE`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Assignment	CWASSIGN			`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 Record	PRTIME			`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.