CMASSIGN – No description in the Lawson data dictionary

System: CW (CW)
Prefix: CAS
Primary key: COMPANY, EMPLOYEE, CONTRACT-NBR, SEGMENT-NBR
Fields: 71
Updated by: 72 programs
Referenced by: 15 programs

CMASSIGN is a Lawson CW table (prefix CAS); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, CONTRACT-NBR, SEGMENT-NBR (CASSET1); alternate indexes: CASSET2, CASSET3, CASSET4, CASSET5, CASSET6 and CASSET7. It is related 1:1 to PRSYSTEM, CMCONTRACT, EMPLOYEE and PAEMPLOYEE. It is updated by BN150, BN305, EXI2.1, EXI4.1, HR11.1, HR11.2, HR11.4, HR28.1 and 64 more and referenced by HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR15.1, HR515 and 7 more. The table has 71 fields, 7 indexes and 4 documented relations.

About CMASSIGN

No description in the Lawson data dictionary.

Fields (71)

Column = COBOL field name without the CAS- 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
#`CAS-COMPANY` PK COMPANY	Numeric 4	—	—
#`CAS-EMPLOYEE` PK EMPLOYEE	Numeric 9	—	—
#`CAS-CONTRACT-NBR` PK CONTRACT_NBR	Numeric 6	—	—
#`CAS-SEGMENT-NBR` PK SEGMENT_NBR	Numeric 6	—	—
#`CAS-POS-LEVEL` SET2 SET3 SET4 SET5 POS_LEVEL	Numeric 2	—	—
#`CAS-REC-TYPE` SET2 SET3 SET5 REC_TYPE	Alpha 1	— `1` Base assignment `2` Supplemental assignment	—
#`CAS-STATUS` SET5 STATUS	Numeric 1	— `0` Open `3` Void `9` Closed	—
#`CAS-POSITION` SET6 SET7 POSITION	Alpha 12	—	—
#`CAS-START-DATE` SET2 SET3 SET4 SET5 SET6 SET7 START_DATE	Numeric 8 (yyyymmdd)	—	—
#`CAS-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	—	—
#`CAS-UNITS` UNITS	Signed 18.6	—	—
#`CAS-AMOUNT` AMOUNT	Signed 18.6	—	—
#`CAS-HOURLY-RATE` HOURLY_RATE	Signed 13.4	—	—
#`CAS-PAY-CYC-AMT` PAY_CYC_AMT	Signed 18.6	—	—
#`CAS-FULL-AMOUNT` FULL_AMOUNT	Signed 18.6	—	—
#`CAS-SALARY-CLASS` SALARY_CLASS	Alpha 1	— `H` Hourly `S` Salaried	—
#`CAS-CALC-TYPE` CALC_TYPE	Alpha 1	— `1` Annual Amount `2` Pay Cycle `3` Daily Rate	—
#`CAS-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 Academic Monthly `010` 10 Month Academic Monthly	—
#`CAS-PAY-CODE-REG` PAY_CODE_REG	Alpha 4	—	—
#`CAS-PAY-CODE-RES` PAY_CODE_RES	Alpha 4	—	—
#`CAS-BENEFIT-SAL` BENEFIT_SAL	Alpha 1 Occurs 5 Times ×5	—	—
#`CAS-CHECK-GRP` CHECK_GRP	Alpha 1	—	—
#`CAS-PROCESS-GRP` PROCESS_GRP	Alpha 1	—	—
#`CAS-PAY-CYCLE` PAY_CYCLE	Alpha 1 Occurs 9 Times ×9	—	—
#`CAS-ROLL-OVER` ROLL_OVER	Numeric 1	— `0` Yes `1` No	—
#`CAS-FTE` FTE	Signed 11.6	—	—
#`CAS-YTD-PAID-WAGES` YTD_PAID_WAGES	Signed 18.6	—	—
#`CAS-YTD-DOCKED-WGS` YTD_DOCKED_WGS	Signed 18.6	—	—
#`CAS-YTD-PAID-UNITS` YTD_PAID_UNITS	Signed 18.6	—	—
#`CAS-YTD-DOCKED-UTS` YTD_DOCKED_UTS	Signed 18.6	—	—
#`CAS-WAGE-BALANCE` WAGE_BALANCE	Signed 18.6	—	—
#`CAS-UNITS-BALANCE` UNITS_BALANCE	Signed 18.6	—	—
#`CAS-UNITS-WORKED` UNITS_WORKED	Signed 18.6	—	—
#`CAS-UNITS-REMAIN` UNITS_REMAIN	Signed 18.6	—	—
#`CAS-PAY-CYC-REG` PAY_CYC_REG	Signed 18.6	—	—
#`CAS-PAY-CYC-RES` PAY_CYC_RES	Signed 18.6	—	—
#`CAS-RESERVE-BAL` RESERVE_BAL	Signed 18.6	—	—
#`CAS-RESERVE-UNITS` RESERVE_UNITS	Signed 18.6	—	—
#`CAS-REMAIN-CYCLES` REMAIN_CYCLES	Numeric 3	—	—
#`CAS-NBR-PAY-CYCLES` NBR_PAY_CYCLES	Numeric 3	—	—
#`CAS-PAY-CHG-IND` PAY_CHG_IND	Numeric 1	—	—
#`CAS-PAY-CYC-OVR` PAY_CYC_OVR	Numeric 1	—	—
#`CAS-SEG-OVR-FLG` SEG_OVR_FLG	Numeric 1	—	—
#`CAS-START-DT-OVR` START_DT_OVR	Numeric 1	—	—
#`CAS-END-DT-OVR` END_DT_OVR	Numeric 1	—	—
#`CAS-CLOSE-DATE` CLOSE_DATE	Numeric 8 (yyyymmdd)	—	—
#`CAS-PROCESS-LEVEL` PROCESS_LEVEL	Alpha 5	—	—
#`CAS-DEPARTMENT` DEPARTMENT	Alpha 5	—	—
#`CAS-LAST-CYC-PROC` LAST_CYC_PROC	Numeric 8 (yyyymmdd)	—	—
#`CAS-RETRO-DATE` RETRO_DATE	Numeric 8 (yyyymmdd)	—	—
#`CAS-PAYOUT` PAYOUT	Numeric 1	— `0` No `1` Payout in Full `2` Payout Reserve only	—
#`CAS-LATE-START` LATE_START	Numeric 1	— `0` No `1` Yes	—
#`CAS-SCHEDULE` SCHEDULE	Alpha 9	—	—
#`CAS-PAY-GRADE` PAY_GRADE	Alpha 3	—	—
#`CAS-PAY-STEP` PAY_STEP	Numeric 2	—	—
#`CAS-PAY-TMP-REG` PAY_TMP_REG	Signed 18.6	—	—
#`CAS-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	—
#`CAS-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	—
#`CAS-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	—
#`CAS-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	—
#`CAS-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	—
#`CAS-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	—
#`CAS-PAY-TMP-CYC` PAY_TMP_CYC	Signed 18.6	—	—
#`CAS-PAY-RES-AMT` PAY_RES_AMT	Signed 18.6	—	—
#`CAS-ADJUST-PAY` ADJUST_PAY	Signed 18.6	—	—
#`CAS-ADJUST-DONE` ADJUST_DONE	Signed 18.6	—	—
#`CAS-WORK-CYCLES` WORK_CYCLES	Numeric 3	—	—
#`CAS-ANN-PAY-AMT` ANN_PAY_AMT	Signed 18.6	—	—
#`CAS-YTD-SUMR-DEFRL` YTD_SUMR_DEFRL	Signed 18.6	—	—
#`CAS-PRV-LAST-PROC` PRV_LAST_PROC	Numeric 8 (yyyymmdd)	—	—
#`CAS-YTD-UNTS-DEFRL` YTD_UNTS_DEFRL	Signed 18.6	—	—

Indexes (7)

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	Condition	Used in
`CASSET1`	`COMPANY` `EMPLOYEE` `CONTRACT-NBR` ↓ `SEGMENT-NBR` ↓	Primary		BN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source)
`CASSET2`	`COMPANY` `EMPLOYEE` `CONTRACT-NBR` `REC-TYPE` `POS-LEVEL` `START-DATE` `SEGMENT-NBR`			—
`CASSET3`	`COMPANY` `EMPLOYEE` `CONTRACT-NBR` `REC-TYPE` `POS-LEVEL` `START-DATE` ↓ `SEGMENT-NBR`			BN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source)
`CASSET4`	`COMPANY` `EMPLOYEE` `POS-LEVEL` `START-DATE` ↓ `CONTRACT-NBR` `SEGMENT-NBR`	Subset	Where ((STATUS = Zeroes) Or (STATUS = 9)) And (REC-TYPE = "1")	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
`CASSET5`	`COMPANY` `EMPLOYEE` `CONTRACT-NBR` `REC-TYPE` `STATUS` `POS-LEVEL` `START-DATE` `SEGMENT-NBR`	KeyChange		—
`CASSET6`	`COMPANY` `EMPLOYEE` `CONTRACT-NBR` `POSITION` `START-DATE` `SEGMENT-NBR`	Subset	Where (REC-TYPE = "2")	LT101, LT111, PA02.1, PA502
`CASSET7`	`COMPANY` `EMPLOYEE` `CONTRACT-NBR` `POSITION` `START-DATE` ↓ `SEGMENT-NBR`	Subset	Where (REC-TYPE = "2")	BN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source)

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

`CAS-COMPANY`	→	`PRS-COMPANY`
`Spaces`	→	`PRS-PROCESS-LEVEL`

Emp Contract

CMCONTRACT

Required

`CAS-COMPANY`	→	`CNR-COMPANY`
`CAS-EMPLOYEE`	→	`CNR-EMPLOYEE`
`CAS-CONTRACT-NBR`	→	`CNR-CONTRACT-NBR`

Employee

EMPLOYEE

Required

`CAS-COMPANY`	→	`EMP-COMPANY`
`CAS-EMPLOYEE`	→	`EMP-EMPLOYEE`

Paemployee

PAEMPLOYEE

Required

`CAS-COMPANY`	→	`PEM-COMPANY`
`CAS-EMPLOYEE`	→	`PEM-EMPLOYEE`

Programs

Updated by (72)

BN150 Life Insurance Reportable Income
BN305 Highly Compensated Employees
EXI2.1 Invoke for PRTRDPD
EXI4.1 Invoke for PRPRBPD
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR28.1 Employee Ethnicity
HR511 Employee Conversion
LP130 Absence Plan Payout
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
PR128 Offset Time Record Creation
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
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
PR29.1 Pension Payment Maintenance
PR30.2 Employee Automatic Time Record
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
PR512 Employee ACH Distribution Interface
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
ZH510 Update PCP from ZPENDPCP

Referenced by (15)

HAP3.1 Applicant Option 4 Selection Invoke
HCRE.1 Action Reason Code Selects
HEP4.1 Employee Option 4 Selection Invoke
HPOS.1 Position Selection Invoke
HPQC.1 Prqcentgrp Select Invoke
HPRS.1 Process Level Select Invoke
HR15.1 User Fields
HR515 User Field Conversion
HR54.1 Employee History Correction
HRS1.1 Select Control
HRSC.1 Select Control
LT11.5 HRM User Field Interface
LT13.5 HRM User Field Interface History
PA113 Retroactive History Update
PA54.1 Personnel Action History Correction

CMASSIGN – No description in the Lawson data dictionary

About CMASSIGN

Fields (71) Copy as SQL

Indexes (7)

Relations

One to one (4) — lookups and parents

Programs

Updated by (72)

Referenced by (15)

Fields (71)