|
|
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 PR199
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COD-COMPANY Numeric 4 BN500 BN55.1
Company Contains the company number. PR199
COD-EMPLOYEE Numeric 9 BN500 BN55.1
Employee Contains the employee number. PR199
COD-PLAN-CODE Alpha 4 BN500 BN55.1
Plan This field is equal to the defined PR199
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 PR199
start date. The life-to-date plan year
has a value of zero.
COD-AMOUNT-YTD Signed 11.2 Occurs 6 Times BN500 BN55.1
Year To Date Amount These fields track the account PR199
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 PR199
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
CODA FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CODSET1 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
PLAN-CODE BN105 BN232
PLAN-YEAR BN31.1 BN31.2
BN310 BN32.1
BN32.2 BN32.3
BN340 BN430
BN500 BN531
BN55.1 BN55.2
BS32.1 HR170
HR70.1 PR199
CODSET2 COMPANY BN55.1 HR170
EMPLOYEE HR70.1
PLAN-CODE
PLAN-YEAR*
CODSET3 COMPANY KeyChange BN15.1
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
"DC" -> 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
|