Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CONTRDETL


                             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
Element: Company       Contains the company number.              BN19.4

CND-PLAN-TYPE          Alpha 2                                   BN15.1  BN19.3
Element: 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
Element: Plan          Contains the code that represents a       BN19.4
                       defined contribution plan.

CND-GROUP-NAME         Alpha 10                                  BN15.1  BN19.3
Element: Group Name    Contains the employee group name.         BN19.4

CND-START-DATE         Numeric 8  (yyyymmdd)                     BN15.1  BN19.3
Element: Date          Contains the start date for this          BN19.4
                       particular schedule of contributions.

CND-BEGIN-YEAR-PCT     Numeric 3                                 BN15.1  BN19.3
Element: Begin Year PctIf 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
Element: 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
Element: 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
Element: 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                                BN100   BN101
Element: Percent       Contains the company match percent.       BN102   BN103
                                                                 BN105   BN15.1
                       The value of this field is used to        BN19.3  BN19.4
                       determine the EDM-NEXT-AMOUNT when the    BN245   BN31.1
                       system creates the company match          BN31.2  BN32.1
                       deduction in the Employee Deduction file  BN32.2  BN32.3
                       as the EDM-NEXT-AMOUNT.                   BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1

CND-PCT-MATCHED        Signed 5.2                                BN15.1  BN19.3
Element: 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
Element: Maximum AmountContains 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