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	BS10.1	BS12.1
BS13.1	BS14.1	BS15.1	BS32.1	ZB10.1	ZB31.1
ZB31.2	ZB32.1	ZB32.2	ZB32.3	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 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 BS10.1 BS12.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
CND-CREATE-DATE Element: Date Stamp	Numeric 8 (yyyymmdd)	BN15.1 BN19.3 BN19.4
CND-CREATE-TIME Element: Time Stamp	Numeric 6 (hhmmss)	BN15.1 BN19.3 BN19.4
CND-CREATE-USER-ID Element: User Id	Alpha 10 (Lower Case)	BN15.1 BN19.3 BN19.4
CND-DATE-STAMP Element: Date Stamp	Numeric 8 (yyyymmdd)	BN15.1 BN19.3 BN19.4
CND-TIME-STAMP Element: Time Stamp	Numeric 6 (hhmmss)	BN15.1 BN19.3 BN19.4
CND-USER-ID Element: User Id	Alpha 10 (Lower Case)	BN15.1 BN19.3 BN19.4

CONTRDETL FILE INDEX

CONTRDETL FILE RELATIONS

ONE TO ONE RELATIONS

CONTRDETL FILE RELATIONS

ONE TO MANY RELATIONS

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