Cash/Deferred Account History

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.

REFERENCED BY

BN100	BN101	BN102	BN103	BN105	BN232
BN31.1	BN31.2	BN310	BN32.1	BN32.2	BN32.3
BN340	BN531	BS32.1	ZB10.1	ZB31.1	ZB31.2
ZB32.1	ZB32.2	ZB32.3	HR170	HR70.1	PR240
PR241	PR242	BN15.1

UPDATED BY

BN430

BN55.2

BN555

PR197

PR129

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
COD-COMPANY Element: Company Hr	Numeric 4 Contains the company number.	BN55.2 BN555 PR197
COD-EMPLOYEE Element: Employee	Numeric 9 Contains the employee number.	BN55.2 BN555 PR197
COD-PLAN-CODE Element: 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 Element: 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 Element: Amount Ytd	Signed 13.2 Occurs 6 Times 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 Element: 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 Element: Pre Tax Ytd	Derived
COD-AFTER-TAX-YTD Element: After Tax Ytd	Derived
COD-INTEREST-YTD Element: Interest Ytd	Derived
COD-COMP-CONT-YTD Element: Comp Cont Ytd	Derived
COD-FORF-ADD-YTD Element: Forf Add Ytd	Derived
COD-COMP-INT-YTD Element: Comp Int Ytd	Derived
COD-TOTAL-YTD Element: Total Ytd	Derived
COD-PLAN-TYPE Element: Plan Type	Alpha 2 Displays the type of plan. DB = Defined Benefit DC = Defined Contribution	BN55.2 BN555 PR197
COD-DATE-STAMP Element: 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 Element: 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 Element: User	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 Element: Process Lev Hr	Alpha 5	BN55.2 BN555 PR197
COD-BUS-NBR-GRP Element: Bus Nbr Grp	Alpha 4	BN55.2 BN555 PR197
COD-QC-ENT-NBR-GRP Element: Qc Ent Nbr Grp	Alpha 4	BN55.2 BN555 PR197
COD-CREATE-DATE Element: Date Stamp	Numeric 8 (yyyymmdd)	BN55.2 BN555
COD-CREATE-TIME Element: Time Stamp	Numeric 6 (hhmmss)	BN55.2 BN555
COD-CREATE-USER-ID Element: User Id	Alpha 10 (Lower Case)	BN55.2 BN555

CODA FILE INDEX

CODA FILE RELATIONS

ONE TO ONE RELATIONS

CODA FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.