CODA FILE
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 HR170 HR70.1 BN15.1
UPDATED BY
BN430 BN500 BN55.1 BN555 PR197 PR702
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COD-COMPANY Numeric 4 BN500 BN55.1
Company Contains the company number. BN555 PR197
COD-EMPLOYEE Numeric 9 BN500 BN55.1
Employee Contains the employee number. BN555 PR197
COD-PLAN-CODE Alpha 4 BN500 BN55.1
Plan This field is equal to the defined BN555 PR197
contribution plan code from the BENEFIT
file (BEN-PLAN-CODE).
COD-PLAN-YEAR Numeric 4 BN500 BN55.1
Plan Year The plan year is based on the plan BN555 PR197
start date. The life-to-date plan year
has a value of zero.
COD-AMOUNT-YTD Signed 13.2 Occurs 6 Times BN500 BN55.1
Year To Date Amount These fields track the account BN555 PR197
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
COD-LAST-UPD-DATE Numeric 8 (yyyymmdd) BN500 BN55.1
Last Update Date This field is only tracked on the BN555 PR197
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).
COD-PRE-TAX-YTD Derived
Pre Tax Ytd
COD-AFTER-TAX-YTD Derived
After Tax Ytd
COD-INTEREST-YTD Derived
Interest Ytd
COD-COMP-CONT-YTD Derived
Comp Cont Ytd
COD-FORF-ADD-YTD Derived
Forf Add Ytd
COD-COMP-INT-YTD Derived
Comp Int Ytd
COD-TOTAL-YTD Derived
Total Ytd
COD-PLAN-TYPE Alpha 2 BN55.1 BN555
Type Contains the type of plan. PR197 PR702
DB = Defined Benefit
DC = Defined Contribution
COD-DATE-STAMP Numeric 8 (yyyymmdd) BN55.1 BN555
Date Stamp 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.
COD-TIME-STAMP Numeric 6 (hhmmss) BN55.1 BN555
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
This is not updated by PR199.
COD-USER-ID Alpha 10 (Lower Case) BN55.1 BN555
User ID Name Contains the user ID of the person who
last changed this record.
This will not be updated by PR199.
CODA FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CODSET1 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
PLAN-TYPE BN105 BN232
PLAN-CODE BN31.1 BN31.2
PLAN-YEAR BN310 BN32.1
BN32.2 BN32.3
BN340 BN430
BN500 BN531
BN55.1 BN55.2
BN555 BS32.1
HR170 HR70.1
PR197 PR702
CODSET2 COMPANY BN55.1 HR170
EMPLOYEE HR70.1
PLAN-TYPE
PLAN-CODE
PLAN-YEAR*
CODSET3 COMPANY KeyChange BN15.1
PLAN-TYPE
PLAN-CODE
PLAN-YEAR
EMPLOYEE
CODA FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
COD-COMPANY -> BNC-COMPANY
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
CODA FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|
