|
|
CONTRDETL FILE
Contribution Schedule Detail
The Contribution Schedule Detail file contains the contribution limits and
company match information.
This file is the detail file associated with the plan's Contribution Schedule
Header file.
REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN215
BN245 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3
BN531 BN65.1 BN71.1 BN72.1 BS13.1 BS14.1
BS15.1 BS32.1 HR55.1
UPDATED BY
BN00.1 BN15.1 BN18.1 BN18.2 BN18.3 BN18.4
BN18.5 BN18.6 BN18.7 BN19.3 BN19.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CND-COMPANY Numeric 4 BN15.1 BN19.3
Company Contains the company number. BN19.4
CND-PLAN-TYPE Alpha 2 BN15.1 BN19.3
Type Contains the benefit plan type. BN19.4
HL = Health
DN = Dental
DI = Disability
EL = Life
DL = Dependent Life
DC = Defined Contribution
DB = Defined Benefit
VA = Vacation
RS = Spending Account
SB = Savings Bond
SP = Stock Purchase
CND-PLAN-CODE Alpha 4 BN15.1 BN19.3
Plan Contains the code that represents a BN19.4
defined contribution plan.
CND-GROUP-NAME Alpha 10 BN15.1 BN19.3
Group Name Contains the employee group name. BN19.4
CND-START-DATE Numeric 8 (yyyymmdd) BN15.1 BN19.3
Start Date Contains the start date for this BN19.4
particular schedule of contributions.
CND-BEGIN-YEAR-PCT Numeric 3 BN15.1 BN19.3
Begin Year Pct If match limit schedules are used, this BN19.4
field contains the beginning years of
service for the detail record. If match
percent schedules are used, this field
contains the beginning percent for the
detail record.
CND-EMP-PRE-PCT Signed 5.2 BN15.1 BN19.3
Pre-Tax Contains the pre-tax contribution limit BN19.4
for all employees in the particular
range of years of service.
CND-EMP-POST-PCT Signed 5.2 BN15.1 BN19.3
After-Tax Contains the employee after-tax BN19.4
contribution limit for all employees in
the particular range of years of
service.
CND-EMP-TOT-PCT Signed 9.2 BN15.1 BN19.3
Emp Tot Pct Contains the total percent contribution BN19.4
for the detail record. Total pre-tax and
after tax contributions cannot exceed
this limit.
CND-MATCH-PCT Signed 5.2 BN15.1 BN19.3
Percent Contains the company match percent. BN19.4
The value of this field is used to
determine the EDM-NEXT-AMOUNT when the
system creates the company match
deduction in the Employee Deduction file
as the EDM-NEXT-AMOUNT.
CND-PCT-MATCHED Signed 5.2 BN15.1 BN19.3
Up To If match limit schedules are used, this BN19.4
field contains the percent to be
matched.
The value of this field is determines
EDM-PCT-AMOUNT is used when the system
creates the company matching deduction
in the Employee Deduction file.
CND-MAX-MATCH Signed 11.2 BN15.1 BN19.3
Maximum Amount Contains the maximum company matching BN19.4
contribution as a flat dollar amount.
This field is used to determine the
EDM-BALANCE-AMT when the system creates
the company matching deduction in the
Employee Deduction file.
If there is a maximum match amount, the
deduction is set up as a descending
deduction (EDM-BALANCE-TYPE = D).
CONTRDETL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CNDSET1 COMPANY BN00.1 BN100
PLAN-TYPE BN101 BN102
PLAN-CODE BN103 BN105
START-DATE BN15.1 BN18.1
GROUP-NAME BN18.2 BN18.3
BEGIN-YEAR-PCT BN18.4 BN18.5
BN18.6 BN18.7
BN19.3 BN19.4
BN215 BN245
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
...
CNDSET2 COMPANY BN100 BN101
PLAN-TYPE BN102 BN103
PLAN-CODE BN105 BN245
START-DATE BN31.1 BN31.2
GROUP-NAME BN32.1 BN32.2
BEGIN-YEAR-PCT* BN32.3 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1
CONTRDETL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
CND-COMPANY -> BNC-COMPANY
Company Name PRSYSTEM Required
CND-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Persgroup PERSGROUP Not Required
CND-COMPANY -> PRG-COMPANY
CND-GROUP-NAME -> PRG-GROUP-NAME
Plan PLAN Required
CND-COMPANY -> PLN-COMPANY
"DC" -> PLN-PLAN-TYPE
CND-PLAN-CODE -> PLN-PLAN-CODE
CONTRDETL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Premium PREMIUM
CND-COMPANY -> PRE-COMPANY
CND-PLAN-TYPE -> PRE-PLAN-TYPE
CND-PLAN-CODE -> PRE-PLAN-CODE
PRE-COVER-TYPE
PRE-START-DATE
PRE-GROUP-NAME
|