CODA – Cash/Deferred Account History

System: Benefits (BN)
Prefix: COD
Primary key: COMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE, PLAN-YEAR, PROCESS-LEVEL, BUS-NBR-GRP, QC-ENT-NBR-GRP
Fields: 23
Updated by: 5 programs
Referenced by: 27 programs

CODA is the Cash/Deferred Account History table in Lawson Benefits (prefix COD). It is indexed by COMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE, PLAN-YEAR, PROCESS-LEVEL, BUS-NBR-GRP, QC-ENT-NBR-GRP (CODSET1); alternate indexes: CODSET2, CODSET3, CODSET4, CODSET5 and CODSET6. It is related 1:1 to BNCOMPANY, PRSYSTEM, EMPLOYEE, PAEMPLOYEE, PLAN, PRBUSGRP and PRQCENTGRP and 1:M to BENEFIT. It is updated by BN430, BN55.2, BN555, PR129 and PR197 and referenced by BN100, BN101, BN102, BN103, BN105, BN15.1, BN232, BN31.1 and 19 more. The table has 23 fields, 6 indexes and 9 documented relations.

About CODA

The Cash/Deferred Account History file contains CODA (Cash Or Deferred Arrangement) account balances by plan per year for each employee in a defined contribution plan. You can load account balances into this file by using BN55.1 (CODA Account Balance). You can also use BN55.1 to update this file for future additions, investment interests, and company contribution amounts. Once an employee is a participant in a defined contribution plan, PR199 (Payroll Close) updates the pre-tax and after-tax contribution fields. This file also contains a system-created life to date records for each of an employee's defined contribution benefits. The life to date record has a plan year equal to zero and is the total of all year to date records on file.

Fields (23)

Column = COBOL field name without the COD- 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
#`COD-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	BN55.2, BN555, PR197
#`COD-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number.	BN55.2, BN555, PR197
#`COD-PLAN-CODE` PK PLAN_CODE	Alpha 4	This field is equal to the defined contribution plan code from the BENEFIT file (BEN-PLAN-CODE).	BN55.2, BN555, PR197
#`COD-PLAN-YEAR` PK PLAN_YEAR	Numeric 4	The plan year is based on the plan start date. The life-to-date plan year has a value of zero.	BN55.2, BN555, PR197
#`COD-AMOUNT-YTD` AMOUNT_YTD	Signed 13.2 Occurs 6 Times ×6	These fields track the account balances. They represent year-to-date balances on plan year records and life-to-date balances on plan year "zero" records. There are six occurrences that represent the following account balances: `1` Employee pre-tax contributions `2` Employee after-tax contributions `3` Investment Interest `4` Company Contribution `5` Forfeiture Additions `6` Investment Interest	BN55.2, BN555, PR197
#`COD-LAST-UPD-DATE` LAST_UPD_DATE	Numeric 8 (yyyymmdd)	This field is only tracked on the life-to-date record and represents the last date that the total fields were updated by a payroll cycle in PR199 (Payroll Close) or manually on BN55 (CODA Account Balance).	PR197
#`COD-PRE-TAX-YTD` PRE_TAX_YTD	Derived	—	—
#`COD-AFTER-TAX-YTD` AFTER_TAX_YTD	Derived	—	—
#`COD-INTEREST-YTD` INTEREST_YTD	Derived	—	—
#`COD-COMP-CONT-YTD` COMP_CONT_YTD	Derived	—	—
#`COD-FORF-ADD-YTD` FORF_ADD_YTD	Derived	—	—
#`COD-COMP-INT-YTD` COMP_INT_YTD	Derived	—	—
#`COD-TOTAL-YTD` TOTAL_YTD	Derived	—	—
#`COD-PLAN-TYPE` PK PLAN_TYPE	Alpha 2	Displays the type of plan. `DB` Defined Benefit `DC` Defined Contribution	BN55.2, BN555, PR197
#`COD-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record. This field is not updated by PR199. Used to determine source of change if CODA doesn't reconcile to payroll.	BN55.2, BN555
#`COD-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed. This is not updated by PR199.	BN55.2, BN555
#`COD-USER-ID` USER_ID	Alpha 10 (Lower Case)	Contains the user ID of the person who last changed this record. This will not be updated by PR199.	BN55.2, BN555
#`COD-PROCESS-LEVEL` PK PROCESS_LEVEL	Alpha 5	—	BN55.2, BN555, PR197
#`COD-BUS-NBR-GRP` PK BUS_NBR_GRP	Alpha 4	—	BN55.2, BN555, PR197
#`COD-QC-ENT-NBR-GRP` PK QC_ENT_NBR_GRP	Alpha 4	—	BN55.2, BN555, PR197
#`COD-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	BN55.2, BN555
#`COD-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BN55.2, BN555
#`COD-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BN55.2, BN555

Indexes (6)

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
`CODSET1`	`COMPANY` `EMPLOYEE` `PLAN-TYPE` `PLAN-CODE` `PLAN-YEAR` `PROCESS-LEVEL` `BUS-NBR-GRP` `QC-ENT-NBR-GRP`	Primary		BN100, BN101, BN102, BN103, BN105, BN232, BN31.1, BN31.2 +22 more (list truncated in source)
`CODSET2`	`COMPANY` `EMPLOYEE` `PLAN-TYPE` `PLAN-CODE` `PLAN-YEAR` ↓ `PROCESS-LEVEL` `BUS-NBR-GRP` `QC-ENT-NBR-GRP`			BN55.1, BN55.2, HR170, HR70.1
`CODSET3`	`COMPANY` `PLAN-TYPE` `PLAN-CODE` `PLAN-YEAR` `EMPLOYEE` `PROCESS-LEVEL` `BUS-NBR-GRP` `QC-ENT-NBR-GRP`	KeyChange		BN15.1
`CODSET4`	`COMPANY` `PLAN-YEAR` `BUS-NBR-GRP` `PROCESS-LEVEL` `EMPLOYEE` `PLAN-TYPE` `PLAN-CODE` `QC-ENT-NBR-GRP`			—
`CODSET5`	`COMPANY` `PLAN-YEAR` `QC-ENT-NBR-GRP` `PROCESS-LEVEL` `EMPLOYEE` `PLAN-TYPE` `PLAN-CODE` `BUS-NBR-GRP`	Subset	Where QC-ENT-NBR-GRP != Spaces	—
`CODSET6`	`COMPANY` `PLAN-YEAR` `PROCESS-LEVEL` `BUS-NBR-GRP` `QC-ENT-NBR-GRP` `EMPLOYEE` `PLAN-TYPE` `PLAN-CODE`			—

Relations

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

One to one (8) — lookups and parents

Relation Table Rules Condition Field map

Company

BNCOMPANY

Required

COD-COMPANY → BNC-COMPANY (BNCSET1)

Company Name

PRSYSTEM

Required

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

Employee

EMPLOYEE

Required

`COD-COMPANY`	→	`EMP-COMPANY`
`COD-EMPLOYEE`	→	`EMP-EMPLOYEE`

Pa Employee

PAEMPLOYEE

Required

`COD-COMPANY`	→	`PEM-COMPANY`
`COD-EMPLOYEE`	→	`PEM-EMPLOYEE`

Plan

PLAN

Required

`COD-COMPANY`	→	`PLN-COMPANY`
`COD-PLAN-TYPE`	→	`PLN-PLAN-TYPE`
`COD-PLAN-CODE`	→	`PLN-PLAN-CODE`

Prbusgrp

PRBUSGRP

Required

`COD-COMPANY`	→	`PBG-COMPANY`
`COD-PROCESS-LEVEL`	→	`PBG-PROCESS-LEVEL`
`COD-BUS-NBR-GRP`	→	`PBG-BUS-NBR-GRP`

Process Level

PRSYSTEM

Required

`COD-COMPANY`	→	`PRS-COMPANY`
`COD-PROCESS-LEVEL`	→	`PRS-PROCESS-LEVEL`

Prqcentgrp

PRQCENTGRP

Required

`COD-COMPANY`	→	`PQC-COMPANY`
`COD-PROCESS-LEVEL`	→	`PQC-PROCESS-LEVEL`
`COD-QC-ENT-NBR-GRP`	→	`PQC-QC-ENT-NBR-GRP`

One to many (1) — child tables

Relation Table Rules Condition Field map

Benefit

BENEFIT

Delete Restricted

`COD-COMPANY`	→	`BEN-COMPANY`
`COD-EMPLOYEE`	→	`BEN-EMPLOYEE`
`"DC"`	→	`BEN-PLAN-TYPE`
`COD-PLAN-CODE`	→	`BEN-PLAN-CODE`
—	→	`BEN-START-DATE`

Programs

Updated by (5)

BN430 Benefit Purge
BN55.2 Vested Amounts
BN555 Defined Benefit or Defined Contribution Balance Conv
PR129 Roth Plan Start Dates
PR197 Payroll Close

Referenced by (27)

BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN105 Plan Update
BN15.1 Benefit Plan
BN232 Benefits Statement
BN31.1 Speed Benefit Entry
BN31.2 Employee Benefit Entry
BN310 Top Heavy Report
BN32.1 Employee Benefit Changes
BN32.2 Employee Benefit Detail Changes
BN32.3 Benefit Add
BN340 ADP and ACP Tests
BN531 Batch Benefit Enrollment
BS32.1 Web Enrollment Stop Benefits Update
HR170 Human Resource Writer Report Request
HR70.1 Human Resource Writer Inquiry
PR240 T4-T4A Slips
PR241 T4-T4A XML
PR242 T4-T4A Reports
ZB10.1 Coverage Options Calculator
ZB31.1 Speed Benefit Entry
ZB31.2 Employee Benefit Entry
ZB32.1 Employee Benefit Changes
ZB32.2 Employee Benefit Detail Changes
ZB32.3 Benefit Add

CODA – Cash/Deferred Account History

About CODA

Fields (23) Copy as SQL

Indexes (6)

Relations

One to one (8) — lookups and parents

One to many (1) — child tables

Programs

Updated by (5)

Referenced by (27)

Fields (23)