Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNCHANGE


                             BNCHANGE FILE

                            Benefit Changes

The Benefit Changes file contains changes made to employee records that could
affect  benefits. This file is updated by personnel actions.

UPDATED BY

BN305     BN35.1    HAP3.1    HEP4.1    HPOS.1    HPQC.1
HPRS.1    HR11.1    HR11.2    HR15.1    HR155     HR511
HR515     HR54.1    HR55.2    HRS1.1    HRSC.1    LP100
LP101     PA02.1    PA100     PA102     PA113     PA115
PA13.1    PA13.2    PA16.1    PA20.1    PA21.1    PA22.1
PA24.1    PA27.1    PA34.1    PA35.1    PA36.1    PA38.1
PA502     PA513     PA52.1    PA52.3    PA52.4    PA52.5
PA520     PA54.1    TR21.1    TR22.1    TR26.1    TR500
PR110     PR113     PR120     PR13.1    PR13.5    PR13.6
PR13.8    BN100

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BNH-COMPANY            Numeric 4                                 BN305   HAP3.1
Element: Company Hr    Contains the company number.              HEP4.1  HPOS.1
                                                                 HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HRS1.1  HRSC.1
                                                                 LP100   LP101
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   PA13.1
                                                                 PA13.2  PA16.1
                                                                 PA20.1  PA21.1
                                                                 PA22.1  PA24.1
                                                                 PA27.1  PA34.1
                                                                 PA35.1  PA36.1
                                                                 PA38.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA520
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR21.1  TR22.1
                                                                 TR26.1  TR500

BNH-EMPLOYEE           Numeric 9                                 BN305   HAP3.1
Element: Employee      Contains the employee number.             HEP4.1  HPOS.1
                                                                 HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HRS1.1  HRSC.1
                                                                 LP100   LP101
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   PA13.1
                                                                 PA13.2  PA16.1
                                                                 PA20.1  PA21.1
                                                                 PA22.1  PA24.1
                                                                 PA27.1  PA34.1
                                                                 PA35.1  PA36.1
                                                                 PA38.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA520
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR21.1  TR22.1
                                                                 TR26.1  TR500

BNH-EFFECT-DATE        Numeric 8  (yyyymmdd)                     BN305   HAP3.1
Element: Effect Date   Contains the personnel action effective   HEP4.1  HPOS.1
                       date.                                     HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HRS1.1  HRSC.1
                                                                 LP100   LP101
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   PA13.1
                                                                 PA13.2  PA16.1
                                                                 PA20.1  PA21.1
                                                                 PA22.1  PA24.1
                                                                 PA27.1  PA34.1
                                                                 PA35.1  PA36.1
                                                                 PA38.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA520
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR21.1  TR22.1
                                                                 TR26.1  TR500

BNH-SEQ-NBR            Numeric 4                                 BN305   HAP3.1
Element: Seq Nbr       Contains an automatically assigned        HEP4.1  HPOS.1
                       sequence number.                          HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HRS1.1  HRSC.1
                                                                 LP100   LP101
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   PA13.1
                                                                 PA13.2  PA16.1
                                                                 PA20.1  PA21.1
                                                                 PA22.1  PA24.1
                                                                 PA27.1  PA34.1
                                                                 PA35.1  PA36.1
                                                                 PA38.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA520
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR21.1  TR22.1
                                                                 TR26.1  TR500

BNH-ACT-OBJ-ID         Numeric 12                                BN305   HAP3.1
Element: Obj Id        Contains the Object Id of the personnel   HEP4.1  HPOS.1
                       action.                                   HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HRS1.1  HRSC.1
                                                                 LP100   LP101
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   PA13.1
                                                                 PA13.2  PA16.1
                                                                 PA20.1  PA21.1
                                                                 PA22.1  PA24.1
                                                                 PA27.1  PA34.1
                                                                 PA35.1  PA36.1
                                                                 PA38.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA520
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR21.1  TR22.1
                                                                 TR26.1  TR500

BNH-DATE-STAMP         Numeric 8  (yyyymmdd)                     BN305   HAP3.1
Element: Date Stamp    Contains the system date the change is    HEP4.1  HPOS.1
                       entered.                                  HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HRS1.1  HRSC.1
                                                                 LP100   LP101
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   PA13.1
                                                                 PA13.2  PA16.1
                                                                 PA20.1  PA21.1
                                                                 PA22.1  PA24.1
                                                                 PA27.1  PA34.1
                                                                 PA35.1  PA36.1
                                                                 PA38.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA520
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR21.1  TR22.1
                                                                 TR26.1  TR500

BNH-HOLD-FLAG          Alpha 1                                   BN305   BN35.1
Element: Hold Flag     Enables a benefit change record to be     HAP3.1  HEP4.1
                       put on hold so BN100 (Employee Change     HPOS.1  HPQC.1
                       Benefit Update) will not process the      HPRS.1  HR11.1
                       change.                                   HR11.2  HR15.1
                       Y = Yes                                   HR155   HR511
                       N = No                                    HR515   HR54.1
                                                                 HR55.2  HRS1.1
                                                                 HRSC.1  LP100
                                                                 LP101   PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA115
                                                                 PA13.1  PA13.2
                                                                 PA16.1  PA20.1
                                                                 PA21.1  PA22.1
                                                                 PA24.1  PA27.1
                                                                 PA34.1  PA35.1
                                                                 PA36.1  PA38.1
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA520   PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  TR21.1
                                                                 TR22.1  TR26.1
                                                                 TR500

BNH-CHANGE-TYPE        Alpha 1                                   BN305   HAP3.1
Element: Change Type   Contains the type of change.              HEP4.1  HPOS.1
                       1 = Postal Code                           HPQC.1  HPRS.1
                       2 = Salary                                HR11.1  HR11.2
                       3 = Pay Frequency                         HR15.1  HR155
                       4 = Birthdate                             HR511   HR515
                       5 = Service Date                          HR54.1  HR55.2
                       6 = Smoker Flag Change                    HRS1.1  HRSC.1
                       7 = New Hire                              LP100   LP101
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   PA13.1
                                                                 PA13.2  PA16.1
                                                                 PA20.1  PA21.1
                                                                 PA22.1  PA24.1
                                                                 PA27.1  PA34.1
                                                                 PA35.1  PA36.1
                                                                 PA38.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA520
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR21.1  TR22.1
                                                                 TR26.1  TR500

BNH-OLD-VALUE          Alpha 20                                  BN305   HAP3.1
Element: Old Value     Contains the old value.                   HEP4.1  HPOS.1
                                                                 HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HRS1.1  HRSC.1
                                                                 LP100   LP101
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   PA13.1
                                                                 PA13.2  PA16.1
                                                                 PA20.1  PA21.1
                                                                 PA22.1  PA24.1
                                                                 PA27.1  PA34.1
                                                                 PA35.1  PA36.1
                                                                 PA38.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA520
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR21.1  TR22.1
                                                                 TR26.1  TR500

BNH-NEW-VALUE          Alpha 30                                  BN305   HAP3.1
Element: New Value     Contains the new value.                   HEP4.1  HPOS.1
                                                                 HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HRS1.1  HRSC.1
                                                                 LP100   LP101
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   PA13.1
                                                                 PA13.2  PA16.1
                                                                 PA20.1  PA21.1
                                                                 PA22.1  PA24.1
                                                                 PA27.1  PA34.1
                                                                 PA35.1  PA36.1
                                                                 PA38.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA520
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR21.1  TR22.1
                                                                 TR26.1  TR500

                         BNCHANGE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BNHSET1   COMPANY                                                BN100   BN305
          EMPLOYEE                                               BN35.1  HAP3.1
          EFFECT-DATE                                            HEP4.1  HPOS.1
          SEQ-NBR                                                HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HRS1.1  HRSC.1
                                                                 LP100   LP101
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   PA13.1
                                                                 PA13.2  PA16.1
                                                                 PA20.1  PA21.1
                                                                 ...

BNHSET2   COMPANY       Subset                                   BN100
          EMPLOYEE      Where HOLD-FLAG != "Y"
          EFFECT-DATE
          CHANGE-TYPE
          SEQ-NBR

                         BNCHANGE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bncompany      BNCOMPANY    Required

                            BNH-COMPANY       -> BNC-COMPANY

Employee       EMPLOYEE     Required

                            BNH-COMPANY       -> EMP-COMPANY
                            BNH-EMPLOYEE      -> EMP-EMPLOYEE

Persacthst     PERSACTHST   Required

                            BNH-ACT-OBJ-ID    -> PAH-OBJ-ID

Prsystem       PRSYSTEM     Required

                            BNH-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

                         BNCHANGE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Benefit        BENEFIT

                            BNH-COMPANY       -> BEN-COMPANY
                            BNH-EMPLOYEE      -> BEN-EMPLOYEE
                                                 BEN-PLAN-TYPE
                                                 BEN-PLAN-CODE
                                                 BEN-START-DATE

Empflexdol     EMPFLEXDOL

                            BNH-COMPANY       -> EFD-COMPANY
                            BNH-EMPLOYEE      -> EFD-EMPLOYEE
                                                 EFD-START-DATE