CWASSIGN – No description in the Lawson data dictionary

System: CW (CW)
Prefix: CWA
Primary key: COMPANY, EMPLOYEE, CONTRACT-YEAR, POSITION, ASG-EFFECT-DTE, PCD-SEQ-NBR
Fields: 76
Updated by: 41 programs
Referenced by: 32 programs

CWASSIGN is a Lawson CW table (prefix CWA); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, CONTRACT-YEAR, POSITION, ASG-EFFECT-DTE, PCD-SEQ-NBR (CWASET1); alternate indexes: CWASET2 and CWASET3. It is related 1:1 to PRSYSTEM, EMPLOYEE, PAEMPLOYEE and HRWRKSCHD and 1:M to CWCONTRACT, PAEMPPOS, CWEMPTRANS, PRPAYCODE and PAPOSITION. It is updated by BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 and 33 more and referenced by BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 and 24 more. The table has 76 fields, 3 indexes and 9 documented relations.

About CWASSIGN

No description in the Lawson data dictionary.

Fields (76)

Column = COBOL field name without the CWA- 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 / column	Type	Description & values	Updated by
#`CWA-COMPANY` PK COMPANY	Numeric 4	—	—
#`CWA-EMPLOYEE` PK EMPLOYEE	Numeric 9	—	—
#`CWA-CONTRACT-YEAR` PK CONTRACT_YEAR	Numeric 4	—	—
#`CWA-ASG-PAY-CODE` ASG_PAY_CODE	Alpha 4	—	—
#`CWA-ASG-EFFECT-DTE` PK ASG_EFFECT_DTE	Numeric 8 (yyyymmdd)	—	—
#`CWA-ASG-END-DATE` ASG_END_DATE	Numeric 8 (yyyymmdd)	—	—
#`CWA-PRORATED-AMT` PRORATED_AMT	Signed 18.6	—	—
#`CWA-PRORATED-UNITS` PRORATED_UNITS	Signed 18.6	—	—
#`CWA-PCD-SEQ-NBR` PK PCD_SEQ_NBR	Numeric 8	—	—
#`CWA-ASG-CALC-TYPE` ASG_CALC_TYPE	Numeric 1	— `1` Annual Amount `2` Pay Period `3` Percent of Current Earnings `4` Daily Rate `5` Hourly	—
#`CWA-AMT-PCT` AMT_PCT	Signed 18.6	—	—
#`CWA-POSITION` PK POSITION	Alpha 12	—	—
#`CWA-CHECK-GRP` CHECK_GRP	Alpha 1	—	—
#`CWA-PROCESS-GRP` PROCESS_GRP	Alpha 1	—	—
#`CWA-PAY-CYCLE` PAY_CYCLE	Alpha 1 Occurs 9 Times ×9	X	—
#`CWA-TAX-FREQ-OVER` TAX_FREQ_OVER	Numeric 3	— `001` Weekly `002` Biweekly `003` Semi-monthly `004` Monthly `005` Daily `006` Quarterly `007` Semi-annually `008` Annually `009` 9 Month Accademic Monthly `010` 10 Month Academic Monthly	—
#`CWA-ROLL-OVER-FLAG` ROLL_OVER_FLAG	Numeric 1	— `1` No `2` Yes	—
#`CWA-DATE-OVER-FLG` DATE_OVER_FLG	Numeric 1	— `1` No `2` Yes	—
#`CWA-PAY-PER-AMT` PAY_PER_AMT	Signed 18.6	—	—
#`CWA-YTD-PAID-WAGES` YTD_PAID_WAGES	Signed 18.6	—	—
#`CWA-PAID-WAGE-BAL` PAID_WAGE_BAL	Signed 18.6	—	—
#`CWA-USER-ALPHA-1` USER_ALPHA_1	Alpha 20 (Lower Case)	—	—
#`CWA-USER-ALPHA-2` USER_ALPHA_2	Alpha 20 (Lower Case)	—	—
#`CWA-USER-ALPHA-3` USER_ALPHA_3	Alpha 20 (Lower Case)	—	—
#`CWA-USER-ALPHA-4` USER_ALPHA_4	Alpha 20 (Lower Case)	—	—
#`CWA-USER-ALPHA-5` USER_ALPHA_5	Alpha 20 (Lower Case)	—	—
#`CWA-USER-ALPHA-6` USER_ALPHA_6	Alpha 20 (Lower Case)	—	—
#`CWA-USER-ALPHA-7` USER_ALPHA_7	Alpha 20 (Lower Case)	—	—
#`CWA-USER-ALPHA-8` USER_ALPHA_8	Alpha 20 (Lower Case)	—	—
#`CWA-USER-ALPHA-9` USER_ALPHA_9	Alpha 20 (Lower Case)	—	—
#`CWA-USER-ALPHA-10` USER_ALPHA_10	Alpha 20 (Lower Case)	—	—
#`CWA-USER-ALPHA-11` USER_ALPHA_11	Alpha 20 (Lower Case)	—	—
#`CWA-USER-ALPHA-12` USER_ALPHA_12	Alpha 20 (Lower Case)	—	—
#`CWA-USER-NUM-1` USER_NUM_1	Signed 18.6	—	—
#`CWA-USER-NUM-2` USER_NUM_2	Signed 18.6	—	—
#`CWA-USER-NUM-3` USER_NUM_3	Signed 18.6	—	—
#`CWA-USER-NUM-4` USER_NUM_4	Signed 18.6	—	—
#`CWA-USER-NUM-5` USER_NUM_5	Signed 18.6	—	—
#`CWA-USER-NUM-6` USER_NUM_6	Signed 18.6	—	—
#`CWA-USER-NUM-7` USER_NUM_7	Signed 18.6	—	—
#`CWA-USER-NUM-8` USER_NUM_8	Signed 18.6	—	—
#`CWA-USER-NUM-9` USER_NUM_9	Signed 18.6	—	—
#`CWA-USER-NUM-10` USER_NUM_10	Signed 18.6	—	—
#`CWA-USER-NUM-11` USER_NUM_11	Signed 18.6	—	—
#`CWA-USER-NUM-12` USER_NUM_12	Signed 18.6	—	—
#`CWA-USER-DATE-1` USER_DATE_1	Numeric 8 (yyyymmdd)	—	—
#`CWA-USER-DATE-2` USER_DATE_2	Numeric 8 (yyyymmdd)	—	—
#`CWA-USER-DATE-3` USER_DATE_3	Numeric 8 (yyyymmdd)	—	—
#`CWA-USER-DATE-4` USER_DATE_4	Numeric 8 (yyyymmdd)	—	—
#`CWA-USER-DATE-5` USER_DATE_5	Numeric 8 (yyyymmdd)	—	—
#`CWA-USER-DATE-6` USER_DATE_6	Numeric 8 (yyyymmdd)	—	—
#`CWA-USER-DATE-7` USER_DATE_7	Numeric 8 (yyyymmdd)	—	—
#`CWA-USER-DATE-8` USER_DATE_8	Numeric 8 (yyyymmdd)	—	—
#`CWA-USER-DATE-9` USER_DATE_9	Numeric 8 (yyyymmdd)	—	—
#`CWA-USER-DATE-10` USER_DATE_10	Numeric 8 (yyyymmdd)	—	—
#`CWA-USER-DATE-11` USER_DATE_11	Numeric 8 (yyyymmdd)	—	—
#`CWA-USER-DATE-12` USER_DATE_12	Numeric 8 (yyyymmdd)	—	—
#`CWA-CLOSE-DATE` CLOSE_DATE	Numeric 8 (yyyymmdd)	—	—
#`CWA-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	—
#`CWA-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	—
#`CWA-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	—
#`CWA-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	—
#`CWA-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	—
#`CWA-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	—
#`CWA-FULL-AMT` FULL_AMT	Signed 18.6	—	—
#`CWA-FULL-UNITS` FULL_UNITS	Signed 18.6	—	—
#`CWA-PAY-CYCLES` PAY_CYCLES	Numeric 3	—	—
#`CWA-BEN-ELIG-FLAG` BEN_ELIG_FLAG	Numeric 1	— `1` No `2` Yes	—
#`CWA-PAY-CHG-IND` PAY_CHG_IND	Numeric 1	— `1` No `2` Yes	—
#`CWA-WORK-SCHED` WORK_SCHED	Alpha 10	—	—
#`CWA-STOP-DT-OVR` STOP_DT_OVR	Numeric 1	— `1` No `2` Yes	—
#`CWA-PAY-CYC-OVR` PAY_CYC_OVR	Numeric 1	— `1` No `2` Yes	—
#`CWA-PAYOUT` PAYOUT	Numeric 1	— `0` No `1` Yes	—
#`CWA-FTE` FTE	Signed 11.6	—	—
#`CWA-HOURS` HOURS	Signed 7.2	—	—
#`CWA-YTD-HOURS` YTD_HOURS	Signed 18.6	—	—

Indexes (3)

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.

Index	Keys	Flags	Used in
`CWASET1`	`COMPANY` `EMPLOYEE` `CONTRACT-YEAR` ↓ `POSITION` `ASG-EFFECT-DTE` ↓ `PCD-SEQ-NBR`	Primary	BN150, BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +22 more (list truncated in source)
`CWASET2`	`COMPANY` `EMPLOYEE` `CONTRACT-YEAR` `POSITION` `ASG-EFFECT-DTE` `PCD-SEQ-NBR`		—
`CWASET3`	`COMPANY` `CONTRACT-YEAR` ↓ `EMPLOYEE` `POSITION` `ASG-EFFECT-DTE` ↓ `PCD-SEQ-NBR`		—

Relations

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

One to one (4) — lookups and parents

Relation Table Rules Condition Field map

Company

PRSYSTEM

Required

`CWA-COMPANY`	→	`PRS-COMPANY (PRSSET1)`
`Spaces`	→	`PRS-PROCESS-LEVEL`

Employee

EMPLOYEE

Required

`CWA-COMPANY`	→	`EMP-COMPANY`
`CWA-EMPLOYEE`	→	`EMP-EMPLOYEE`

Paemployee

PAEMPLOYEE

Required

`CWA-COMPANY`	→	`PEM-COMPANY`
`CWA-EMPLOYEE`	→	`PEM-EMPLOYEE`

Work Schedule

HRWRKSCHD

Required

`CWA-COMPANY`	→	`WSC-COMPANY`
`CWA-WORK-SCHED`	→	`WSC-WORK-SCHED`
`CWA-CONTRACT-YEAR`	→	`WSC-CONTRACT-YEAR`
`Zeroes`	→	`WSC-EFFECT-DATE`

One to many (5) — child tables

Relation Table Rules Condition Field map

Emp Contract

CWCONTRACT

`CWA-COMPANY`	→	`CCT-COMPANY`
`CWA-EMPLOYEE`	→	`CCT-EMPLOYEE`
`CWA-CONTRACT-YEAR`	→	`CCT-CONTRACT-YEAR`
`CWA-POSITION`	→	`CCT-POSITION`
—	→	`CCT-CONT-SEQ-NBR`

Emp Position

PAEMPPOS

`CWA-COMPANY`	→	`PEP-COMPANY`
`CWA-EMPLOYEE`	→	`PEP-EMPLOYEE`
`CWA-POSITION`	→	`PEP-POSITION`
`CWA-ASG-EFFECT-DTE`	→	`PEP-EFFECT-DATE`
—	→	`PEP-POS-LEVEL`

Emp Trans

CWEMPTRANS

Delete Cascades

`CWA-COMPANY`	→	`CCE-COMPANY`
`CWA-EMPLOYEE`	→	`CCE-EMPLOYEE`
`CWA-CONTRACT-YEAR`	→	`CCE-CONTRACT-YEAR`
`CWA-POSITION`	→	`CCE-POSITION`
—	→	`CCE-CONT-SEQ-NBR`
—	→	`CCE-TRANS-SEQ-NBR`

Pay Code

PRPAYCODE

`CWA-COMPANY`	→	`PCD-COMPANY`
`CWA-ASG-PAY-CODE`	→	`PCD-PAY-CODE`
—	→	`PCD-PROCESS-LEVEL`
—	→	`PCD-JOB-CODE`

Position

PAPOSITION

`CWA-COMPANY`	→	`POS-COMPANY`
`CWA-POSITION`	→	`POS-POSITION`
—	→	`POS-EFFECT-DATE`

Programs

Updated by (41)

BN150 Life Insurance Reportable Income
EXI2.1 Invoke for PRTRDPD
EXI4.1 Invoke for PRPRBPD
LP130 Absence Plan Payout
PR128 Offset Time Record Creation
PR131 Retroactive Pay Calculation
PR132 FLSA Overtime Calculation
PR134 Automatic Time Records
PR135 Time Record Edit
PR136 Missing Time Records
PR137 Batch Time Record Update
PR189 Gross Up Calculation
PR20.4 Pay Code
PR29.1 Pension Payment Maintenance
PR32.1 Employee Daily Time Entry
PR32.2 Employee Daily Time Entry
PR33.1 Speed Entry Setup
PR33.2 Speed Entry by Number
PR33.3 Speed Entry by Name
PR35.1 Time Entry
PR35.2 Detail Time Entry
PR35.3 Speed Time Entry
PR35.4 Step and Grade, Grade Range Time Entry
PR35.5 Attendance Time Entry
PR35.6 Activity Time Entry
PR35.8 Position Time Entry
PR35.9 Reason Code Time Entry
PR36.1 Time Record Entry
PR36.4 Manual Time Record Maintenance
PR37.1 Batch Time Control
PR45.1 Error Processing
PR521 Nonstandard Pay and Work Period CSV Load
PR529 Pension Payroll Conversion
PR530 Time Record Interface CSV
PR560 Payroll History Load CSV
PR582 Mass Adjustment Load
PR80.1 Manual Check
PR80.4 Manual Payment
PR82.1 Adjustment
TA147 Canada Vacation Audit
UK102 Bonus Pay Update

Referenced by (32)

BN305 Highly Compensated Employees
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR28.1 Employee Ethnicity
HR511 Employee Conversion
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR13.1 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR30.2 Employee Automatic Time Record
PR512 Employee ACH Distribution Interface
ZH510 Update PCP from ZPENDPCP

CWASSIGN – No description in the Lawson data dictionary

About CWASSIGN

Fields (76) Copy as SQL

Indexes (3)

Relations

One to one (4) — lookups and parents

One to many (5) — child tables

Programs

Updated by (41)

Referenced by (32)

Fields (76)