CODA

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
PR129


UPDATED BY
BN430 BN55.2 BN55.1 BN555 PR197 PR702
BN100 BN101 BN102 BN103 BN105 BN232
BN31.1 BN31.2 BN310 BN32.1 BN32.2 BN32.3
BN340 BN531 BS32.1 HR170 HR70.1 PR240
PR241 PR242 PR243 PR244 PR245 PR249
BN15.1

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 PR702
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


CODA FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CODSET1 COMPANY
EMPLOYEE
PLAN-TYPE
PLAN-CODE
PLAN-YEAR
PROCESS-LEVEL
BUS-NBR-GRP
QC-ENT-NBR-GRP
...
BN100 BN101
BN102 BN103
BN105 BN232
BN31.1 BN31.2
BN310 BN32.1
BN32.2 BN32.3
BN340 BN430
BN531 BN55.1
BN55.2 BN555
BS32.1 HR170
HR70.1 PR129
PR197 PR240
PR241 PR242
PR243 PR244
PR245 PR249
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 PR240
PR241 PR242
PR243 PR244
PR245 PR249
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
WhereQC-ENT-NBR-GRP !=Spaces
CODSET6 COMPANY
PLAN-YEAR
PROCESS-LEVEL
BUS-NBR-GRP
QC-ENT-NBR-GRP
EMPLOYEE
PLAN-TYPE
PLAN-CODE


CODA FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


CODA FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Wed Jun 08 20:48:07 2016

Home
Contact Us



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