Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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