Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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

BN100     BN35.1    HR15.1    HR155     HR511     HR515
HR54.1    HR55.2    HR650     HRS1.1    HRSC.1    PA113
PA16.1    PA502     PA513     PA54.1    TR22.1    TR500
PR13.1    PR13.5    PR13.6    PR13.8

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BNH-COMPANY          Numeric 4                                   HR15.1  HR155
Company              Contains the company number.                HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA113
                                                                 PA16.1  PA502
                                                                 PA513   PA54.1
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR22.1  TR500

BNH-EMPLOYEE         Numeric 9                                   HR15.1  HR155
Employee             Contains the employee number.               HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA113
                                                                 PA16.1  PA502
                                                                 PA513   PA54.1
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR22.1  TR500

BNH-EFFECT-DATE      Numeric 8  (yyyymmdd)                       HR15.1  HR155
Effective Date       Contains the personnel action effective     HR511   HR515
                     date.                                       HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA113
                                                                 PA16.1  PA502
                                                                 PA513   PA54.1
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR22.1  TR500

BNH-SEQ-NBR          Numeric 4                                   HR15.1  HR155
Sequence Number      Contains an automatically assigned          HR511   HR515
                     sequence number.                            HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA113
                                                                 PA16.1  PA502
                                                                 PA513   PA54.1
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR22.1  TR500

BNH-ACT-OBJ-ID       Numeric 12                                  HR15.1  HR155
Subsystem Activity   Contains the Object Id of the personnel     HR511   HR515
InterfaceID          action.                                     HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA113
                                                                 PA16.1  PA502
                                                                 PA513   PA54.1
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR22.1  TR500

BNH-DATE-STAMP       Numeric 8  (yyyymmdd)                       HR15.1  HR155
Date Stamp           Contains the system date the change is      HR511   HR515
                     entered.                                    HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA113
                                                                 PA16.1  PA502
                                                                 PA513   PA54.1
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR22.1  TR500

BNH-HOLD-FLAG        Alpha 1                                     BN35.1  HR15.1
On Hold Flag         Enables a benefit change record to be       HR155   HR511
                     put on hold so BN100 (Employee Change       HR515   HR54.1
                     Benefit Update) will not process the        HR55.2  HR650
                     change.                                     HRS1.1  HRSC.1
                     Y = Yes                                     PA113   PA16.1
                     N = No                                      PA502   PA513
                                                                 PA54.1  PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  TR22.1
                                                                 TR500

BNH-CHANGE-TYPE      Alpha 1                                     HR15.1  HR155
Change Type          Contains the type of change.                HR511   HR515
                     1 = Postal Code                             HR54.1  HR55.2
                     2 = Salary                                  HR650   HRS1.1
                     3 = Pay Frequency                           HRSC.1  PA113
                     4 = Birthdate                               PA16.1  PA502
                     5 = Service Date                            PA513   PA54.1
                     6 = Smoker Flag Change                      PR13.1  PR13.5
                     7 = New Hire                                PR13.6  PR13.8
                                                                 TR22.1  TR500

BNH-OLD-VALUE        Alpha 20                                    HR15.1  HR155
Old Value            Contains the old value.                     HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA113
                                                                 PA16.1  PA502
                                                                 PA513   PA54.1
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR22.1  TR500

BNH-NEW-VALUE        Alpha 30                                    HR15.1  HR155
Field Value After    Contains the new value.                     HR511   HR515
Change                                                           HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA113
                                                                 PA16.1  PA502
                                                                 PA513   PA54.1
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR22.1  TR500

                         BNCHANGE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BNHSET1   COMPANY                                                BN100   BN35.1
          EMPLOYEE                                               HR15.1  HR155
          EFFECT-DATE                                            HR511   HR515
          SEQ-NBR                                                HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA113
                                                                 PA16.1  PA502
                                                                 PA513   PA54.1
                                                                 TR22.1  TR500
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

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