Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            FLEXDOLLAR FILE

                              Flex Dollars

The Flex Dollars file contains the parameters used to calculate flex dollars
for employees.

BN08.1 (Flex Dollars) is the primary program that updates this file.

REFERENCED BY

BN02.1    BN02.3    BN02.2    BN02.4    BN02.5    BN06.1
BN100     BN101     BN102     BN103     BN104     BN105
BN145     BN206     BN232     BN238     BN245     BN246
BN258     BN259     BN31.1    BN31.2    BN32.1    BN32.2
BN32.3    BN325     BN331     BN45.1    BN531     BN65.1
BN71.1    BN72.1    BS09.1    BS10.1    BS11.1    BS12.1
BS13.1    BS14.1    BS15.1    BS32.1    HR55.1    BN138

UPDATED BY

BN00.1    BN08.1    BN90.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

FLD-COMPANY          Numeric 4                                   BN08.1
Company              Contains the company number.

FLD-FLEX-PLAN        Alpha 4                                     BN08.1
Flex Plan            Contains the flex plan name.

FLD-START-DATE       Numeric 8  (yyyymmdd)                       BN08.1
Start Date           Contains the flex dollar start date.
                     The month and date corresponds to the
                     month and date on the flex plan.

FLD-GROUP-NAME       Alpha 10                                    BN08.1
Group Name           Contains the employee group used to
                     define flex dollars.

FLD-STOP-DATE        Numeric 8  (yyyymmdd)                       BN08.1
Stop Date            Contains the flex dollar's stop date.
                     This is calculated as 12 months from the
                     start date.

FLD-CMP-BASE-AMT     Signed 11.2                                 BN08.1
Company Paid Base    Contains the base amount of dollars the
Flex Amount          company gives each employee.

FLD-CMP-BASE-PCT     Signed 5.2                                  BN08.1
Company Paid         Contains the percent of an employee's
Percent Salary       salary used to determine how many flex
                     dollars the employee receives.

FLD-ADD-TO-GRS-PCT   Signed 5.2                                  BN08.1
Add To Grs Pct       Contains the percent of unspent flex
                     dollars which employees can add to
                     taxable wages.

FLD-MIN-TOT-CREDTS   Signed 11.2                                 BN08.1
Min Tot Credts       Contains the minimum number of credits
                     an employee receives.

FLD-MAX-TOT-CREDTS   Signed 11.2                                 BN08.1
Max Tot Credts       Contains the maximum number of credits
                     an employee receives.

FLD-EMP-BASE-AMT     Signed 11.2                                 BN08.1
Employee Flex        Contains the amount of an employee's
Dollar Base Amt      salary which can be spent on a pre-tax
                     basis to purchase benefits.

FLD-EMP-BASE-PCT     Signed 5.2                                  BN08.1
Employee Flex        Contains the percent of an employee's
Dollar Base Pct      salary which can be spent on a pre-tax
                     basis to purchase benefits.

FLD-SALARY-TYPE      Alpha 2                                     BN08.1
Salary Type          Defines the salary that is used to
                     calculate the flex dollars.
                     EM = HR11 Salary
                     B1 = Benefit Salary 1
                     B2 = Benefit Salary 2
                     B3 = Benefit Salary 3
                     B4 = Benefit Salary 4
                     B5 = Benefit Salary 5
                     E1 = HR11 and Ben Sal 1
                     E2 = HR11 and Ben Sal 2
                     E3 = HR11 and Ben Sal 3
                     E4 = HR11 and Ben Sal 4
                     E5 = HR11 and Ben Sal 5
                     X = Custom Calculation

FLD-SALARY-DATE      Numeric 4  (mmdd)                           BN08.1
Salary Date          If flex dollars are based on the
                     employee's salary, and the salary is
                     determined on a specific month and day,
                     this field contains the date the salary
                     is determined.

FLD-SAL-FIRST-MO     Alpha 1                                     BN08.1
Sal First Mo         If flex dollars are based on salary,
                     this field determines the salary
                     calculation date.
                     C = Current
                     M = First of Month
                     A = As of Date

FLD-SAL-ROUND-METH   Alpha 1                                     BN08.1
Sal Round Meth       If flex dollars are based on salary,
                     this field defines how the salary amount
                     should be rounded.
                     H = High
                     L = Low
                     R = Normal
                     N = No Rounding

FLD-SAL-BEF-AFT      Alpha 1                                     BN08.1
Sal Bef Aft          If flex dollars are based on the
                     salary, this field defines when the
                     salary should be rounded. It does not
                     affect the calculation.
                     B = Before
                     A = After

FLD-SAL-ROUND-TO     Signed 9.4                                  BN08.1
Sal Round To         If the salary amount is rounded, this
                     defines to what place the amount is
                     rounded.

FLD-MIN-SALARY       Signed 11.2                                 BN08.1
Minimum Salary       Contains the minimum salary for
                     calculating flex dollars.

                     If an employee's salary is less than
                     this amount, the system uses this amount
                     to calculate flex dollars for the
                     employee.

FLD-MAX-SALARY       Signed 11.2                                 BN08.1
Maximum Salary       Contains the maximum salary that can be
                     used in the flex dollar calculation.

                     If the employee's salary is greater
                     than this amount, the system uses this
                     amount to calculate flex dollars for the
                     employee.

FLD-AGE-DATE         Numeric 4  (mmdd)                           BN08.1
Age Date             If flex dollars are based on a specific
                     age, this field contains the date on
                     which the age is calculated.

FLD-AGE-FIRST-MO     Alpha 1                                     BN08.1
Age First Mo         If the flex dollars are calculated for
                     specific ages, this field determines the
                     age calculation date.
                     C = Current
                     M = First of Month
                     A = As of Date

FLD-AGE-RATE-TBL     Alpha 4                                     BN08.1
Age Rate Tbl         If flex dollars are calculated for
                     specific ages, this is the table used to
                     define flex dollars ages.

FLD-AGE-CREDIT       Signed 11.2                                 BN08.1
Credits Per          Contains the age flex credits.

FLD-AGE-ROUND-METH   Alpha 1                                     BN08.1
Age Round Meth       If flex dollars are based on age, this
                     field defines how the age credits should
                     be  rounded.
                     H = High
                     L = Low
                     R = Normal
                     N = No Rounding

FLD-AGE-BEF-AFT      Alpha 1                                     BN08.1
Age Bef Aft          If flex dollars are based on age, this
                     field determines when rounding is
                     performed. It has no affect on
                     calculations.
                     B = Before
                     A = After

FLD-AGE-ROUND-TO     Signed 9.4                                  BN08.1
Age Round To         If flex credits are rounded, this field
                     defines to what place the amount is
                     rounded.

FLD-AGE-MIN-CREDTS   Signed 11.2                                 BN08.1
Age Min Credts       Contains the minimum number of credits
                     for an age.

FLD-AGE-MAX-CREDTS   Signed 11.2                                 BN08.1
Age Max Credts       Contains the maximum number of credits
                     for an age.

FLD-FROM-DATE        Alpha 2                                     BN08.1
From Date            Contains the code that defines the date
                     from which service credits are
                     calculated.
                     HI = Hire Date
                     AJ = Adjusted Hire Date
                     AN = Anniversary Date
                     SN = Seniority Date
                     B1 = Benefit Date 1
                     B2 = Benefit Date 2
                     B3 = Benefit Date 3
                     B4 = Benefit Date 4
                     B5 = Benefit Date 5
                     X = Custom Calculation

FLD-SERV-DATE        Numeric 4  (mmdd)                           BN08.1
Serv Date            If flex dollars are based on service,
                     and service is determined on a certain
                     month and day, this field contains the
                     day to be used.

FLD-SERV-FIRST-MO    Alpha 1                                     BN08.1
Serv First Mo        If the flex dollars include service
                     credits, this field contains the service
                     calculation month and days.
                     C = Current
                     M = First of Month
                     A = As of Date

FLD-SERV-RATE-TBL    Alpha 4                                     BN08.1
Serv Rate Tbl        If flex dollars are calculated based on
                     years of service, this is the rate table
                     used to define the service credits.

FLD-SERV-CREDIT      Signed 11.2                                 BN08.1
Credits Per          Contains the service flex credits.

FLD-SERV-RND-METH    Alpha 1                                     BN08.1
Serv Rnd Meth        If flex dollars are based on service,
                     this field defines how the service
                     credits should be rounded.
                     H = High
                     L = Low
                     R = Normal
                     N = No Rounding

FLD-SERV-BEF-AFT     Alpha 1                                     BN08.1
Serv Bef Aft         If service credits are rounded, this
                     field defines the place to which the
                     amount is rounded.
                     B = Before
                     A = After

FLD-SERV-ROUND-TO    Signed 9.4                                  BN08.1
Serv Round To        If the service credits are rounded,
                     this defines to what place the amount is
                      rounded.

FLD-SERV-MIN-CREDT   Signed 11.2                                 BN08.1
Serv Min Credt       Contains the minimum number of credits
                     for a service.

FLD-SERV-MAX-CREDT   Signed 11.2                                 BN08.1
Serv Max Credt       Contains the maximum number of credits
                     for a service.

FLD-DEP-FIRST-MO     Alpha 1                                     BN08.1
Dep First Mo         If flex dollars include dependent
                     credits, this field contains the date
                     used to determine the number of
                     dependents from the HR History file.
                     A = As of Date
                     C = Current
                     M = First of Month

FLD-DEP-RATE-TBL     Alpha 4                                     BN08.1
Dep Rate Tbl         If flex dollars are based on the number
                     of dependents, this field contains the
                     rate table used to define the number of
                     dependent credits.

FLD-DEP-DATE         Numeric 4  (mmdd)                           BN08.1
Dep Date             If flex dollars are based on the number
                     of dependents, this contains the month
                     and year used to determine the number of
                     dependents from the HR History file.

FLD-LIFE-FIRST-MO    Alpha 1                                     BN08.1
Life First Mo        If flex dollars are based on the number
                     of lifestyle credits, this field
                     contains the date used to define the
                     number of lifestyle credits from the HR
                     History file.
                     A = As of Date
                     C = Current
                     M = First of Month

FLD-LIFE-RATE-TBL    Alpha 4                                     BN08.1
Life Rate Tbl        If flex dollars are based on the number
                     of lifestyle credits, this field
                     contains the rate table used to define
                     the number of lifestyle credits.

FLD-LIFE-DATE        Numeric 4  (mmdd)                           BN08.1
Life Date            If flex dollars are based on the number
                     of lifestyle credits, this field
                     contains the month and year used to
                     determine the number of lifestyle
                     credits from the HR History file.

FLD-LAST-CMT-SEQ     Numeric 4                                   BN90.1
Last Comment         Contains the sequence number of the
Sequence Number      last comment.

FLD-SALARY-YEAR      Numeric 4                                   BN08.1
Salary Year          If flex dollars are based on salary
                     year, and an "as of" date is used, this
                     field contains the year.

FLD-AGE-YEAR         Numeric 4                                   BN08.1
Age Year             If flex dollars are based on age and an
                     "as of" date is used, this field
                     contains the year.

FLD-SERV-YEAR        Numeric 4                                   BN08.1
Serv Year            If flex credits are based on a service
                     and an "as of" date is used, this field
                     contains the year.

FLD-DEP-YEAR         Numeric 4                                   BN08.1
Dep Year             If flex dollars are based on dependents
                     and an "as of" date is used, this field
                     contains the year.

FLD-LIFE-YEAR        Numeric 4                                   BN08.1
Life Year            If flex dollars are based on lifestyle
                     credits and an "as of" date is used,
                     this field contains the year.

                         FLEXDOLLAR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FLDSET1   COMPANY                                                BN00.1  BN02.1
          FLEX-PLAN                                              BN02.3  BN06.1
          START-DATE                                             BN08.1  BN100
          GROUP-NAME                                             BN101   BN102
                                                                 BN103   BN104
                                                                 BN105   BN145
                                                                 BN206   BN232
                                                                 BN238   BN245
                                                                 BN246   BN258
                                                                 BN259   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN325   BN331
                                                                 BN45.1  BN531
                                                                 BN65.1  BN71.1
                                                                 ...

FLDSET3   COMPANY                                                BN100   BN101
          FLEX-PLAN                                              BN102   BN103
          START-DATE*                                            BN105   BN138
          GROUP-NAME                                             BN145   BN245
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN331
                                                                 BN45.1  BN531
                                                                 BN65.1  BN71.1
                                                                 BN72.1  BS09.1
                                                                 BS10.1  BS11.1
                                                                 BS12.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1

FLDSET4   COMPANY       KeyChange, Subset                        BN02.1  BN02.2
          FLEX-PLAN     Where (AGE-RATE-TBL  != Spaces )         BN02.3  BN02.4
          START-DATE    Or    (SERV-RATE-TBL != Spaces )         BN02.5
          GROUP-NAME    Or    (DEP-RATE-TBL  != Spaces )
                        Or    (LIFE-RATE-TBL != Spaces )

                         FLEXDOLLAR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Age Rate Tbl   RATETBLHDR   Required

                            FLD-COMPANY          -> RTH-COMPANY
                            FLD-AGE-RATE-TBL     -> RTH-TABLE-CODE
                            FLD-START-DATE       -> RTH-START-DATE

Company        BNCOMPANY    Required

                            FLD-COMPANY          -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            FLD-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Dep Rate Tbl   RATETBLHDR   Required

                            FLD-COMPANY          -> RTH-COMPANY
                            FLD-DEP-RATE-TBL     -> RTH-TABLE-CODE
                            FLD-START-DATE       -> RTH-START-DATE

Flexible Plan  FLEXPLAN     Required

                            FLD-COMPANY          -> FLP-COMPANY
                            FLD-FLEX-PLAN        -> FLP-FLEX-PLAN

Life Rate Tbl  RATETBLHDR   Required

                            FLD-COMPANY          -> RTH-COMPANY
                            FLD-LIFE-RATE-TBL    -> RTH-TABLE-CODE
                            FLD-START-DATE       -> RTH-START-DATE

Persgroup      PERSGROUP    Required

                            FLD-COMPANY          -> PRG-COMPANY
                            FLD-GROUP-NAME       -> PRG-GROUP-NAME

Serv Rate Tbl  RATETBLHDR   Required

                            FLD-COMPANY          -> RTH-COMPANY
                            FLD-SERV-RATE-TBL    -> RTH-TABLE-CODE
                            FLD-START-DATE       -> RTH-START-DATE

                         FLEXDOLLAR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Emp Flex Dol   EMPFLEXDOL   Delete Restricted

                            FLD-COMPANY          -> EFD-COMPANY
                            FLD-START-DATE       -> EFD-START-DATE
                                                    EFD-EMPLOYEE