CONTRDETL

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.
UPDATED BY
BN00.1 BN100 BN101 BN102 BN103 BN105
BN15.1 BN18.1 BN18.2 BN18.3 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
BS32.1 ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2
ZB32.3 HR55.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CND-COMPANY
Element: Company Hr		Numeric 4
Contains the company number.
BN15.1 BN19.3
BN19.4
CND-PLAN-TYPE
Element: Plan Type		Alpha 2
Contains the benefit plan type.
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
BN15.1 BN19.3
BN19.4
CND-PLAN-CODE
Element: Plan Code		Alpha 4
Contains the code that represents a defined contribution plan.
BN15.1 BN19.3
BN19.4
CND-GROUP-NAME
Element: Group Name		Alpha 10
Contains the employee group name.
BN15.1 BN19.3
BN19.4
CND-START-DATE
Element: Start Date		Numeric 8 (yyyymmdd)
Contains the start date for this particular schedule of contributions.
BN15.1 BN19.3
BN19.4
CND-BEGIN-YEAR-PCT
Element: Begin Year Pct		Numeric 3
If match limit schedules are used, this 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.
BN15.1 BN19.3
BN19.4
CND-EMP-PRE-PCT
Element: Pre-Tax		Signed 5.2
Contains the pre-tax contribution limit for all employees in the particular range of years of service.
BN15.1 BN19.3
BN19.4
CND-EMP-POST-PCT
Element: After-Tax		Signed 5.2
Contains the employee after-tax contribution limit for all employees in the particular range of years of service.
BN15.1 BN19.3
BN19.4
CND-EMP-TOT-PCT
Element: Emp Tot Pct		Signed 9.2
Contains the total percent contribution for the detail record. Total pre-tax and after tax contributions cannot exceed this limit.
BN15.1 BN19.3
BN19.4
CND-MATCH-PCT
Element: Percent		Signed 5.2
Contains the company match percent. 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.
BN100 BN101
BN102 BN103
BN105 BN15.1
BN19.3 BN19.4
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
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
CND-PCT-MATCHED
Element: Up To		Signed 5.2
If match limit schedules are used, this 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.
BN15.1 BN19.3
BN19.4
CND-MAX-MATCH
Element: Maximum Amount		Signed 11.2
Contains the maximum company matching 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).
BN15.1 BN19.3
BN19.4


CONTRDETL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CNDSET1 COMPANY
PLAN-TYPE
PLAN-CODE
START-DATE
GROUP-NAME
BEGIN-YEAR-PCT
...
BN00.1 BN100
BN101 BN102
BN103 BN105
BN15.1 BN18.1
BN18.2 BN18.3
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
PLAN-TYPE
PLAN-CODE
START-DATE
GROUP-NAME
BEGIN-YEAR-PCT*
BN100 BN101
BN102 BN103
BN105 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 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3


CONTRDETL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

File created: Thu Jun 09 11:10:03 2016

Home
Contact Us



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