|
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 PR240
PR241 PR242 BN15.1
UPDATED BY
BN430 BN55.1 BN555 PR197 PR702
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COD-COMPANY Numeric 4 BN55.1 BN555
Element: Company Hr Contains the company number. PR197
COD-EMPLOYEE Numeric 9 BN55.1 BN555
Element: Employee Contains the employee number. PR197
COD-PLAN-CODE Alpha 4 BN55.1 BN555
Element: Plan This field is equal to the defined PR197
contribution plan code from the BENEFIT
file (BEN-PLAN-CODE).
COD-PLAN-YEAR Numeric 4 BN55.1 BN555
Element: Plan Year The plan year is based on the plan PR197
start date. The life-to-date plan year
has a value of zero.
COD-AMOUNT-YTD Signed 13.2 Occurs 6 Times BN55.1 BN555
Element: Year To Date AThese fields track the account 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) BN55.1 BN555
Element: Last Update DaThis field is only tracked on the 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
Element: Pre Tax Ytd
COD-AFTER-TAX-YTD Derived
Element: After Tax Ytd
COD-INTEREST-YTD Derived
Element: Interest Ytd
COD-COMP-CONT-YTD Derived
Element: Comp Cont Ytd
COD-FORF-ADD-YTD Derived
Element: Forf Add Ytd
COD-COMP-INT-YTD Derived
Element: Comp Int Ytd
COD-TOTAL-YTD Derived
Element: Total Ytd
COD-PLAN-TYPE Alpha 2 BN55.1 BN555
Element: Type Contains the type of plan. PR197 PR702
DB = Defined Benefit
DC = Defined Contribution
COD-DATE-STAMP Numeric 8 (yyyymmdd) BN55.1 BN555
Element: 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
Element: 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
Element: User Contains the user ID of the person who
last changed this record.
This will not be updated by PR199.
COD-PROCESS-LEVEL Alpha 5 PR197
Element: Process Lev HrThis field contains the process level,
which is the reporting hierarchy below
company.
COD-BUS-NBR-GRP Alpha 4 PR197
Element: Bus Nbr Grp
COD-QC-ENT-NBR-GRP Alpha 4 PR197
Element: Qc Ent Nbr Grp
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
PROCESS-LEVEL BN32.2 BN32.3
BUS-NBR-GRP BN340 BN430
QC-ENT-NBR-GRP BN531 BN55.1
BN55.2 BN555
BS32.1 HR170
HR70.1 PR197
PR240 PR241
PR242 PR702
CODSET2 COMPANY BN55.1 HR170
EMPLOYEE HR70.1
PLAN-TYPE
PLAN-CODE
PLAN-YEAR*
PROCESS-LEVEL
BUS-NBR-GRP
QC-ENT-NBR-GRP
CODSET3 COMPANY KeyChange BN15.1
PLAN-TYPE
PLAN-CODE
PLAN-YEAR
EMPLOYEE
PROCESS-LEVEL
BUS-NBR-GRP
QC-ENT-NBR-GRP
CODSET4 COMPANY
PLAN-YEAR
BUS-NBR-GRP
PROCESS-LEVEL
EMPLOYEE
PLAN-TYPE
PLAN-CODE
QC-ENT-NBR-GRP
CODSET5 COMPANY Subset
PLAN-YEAR Where QC-ENT-NBR-GRP != Spaces
QC-ENT-NBR-GRP
PROCESS-LEVEL
EMPLOYEE
PLAN-TYPE
PLAN-CODE
BUS-NBR-GRP
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 RELATED
NAME 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 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
|