Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms

                             BNGRPCHG FILE

                          Benefit Group Change

If a personnel action removes or adds an employee from or to an employee
group tied to benefits, the employee's benefits can change. This file contains
records for a group an employee was removed from or added to.

BN100 (Employee Change Benefit Update) uses this file to update employee
benefits. Records are deleted when BN100 is updated.

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

BNG-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

BNG-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

BNG-EFFECT-DATE      Numeric 8  (yyyymmdd)                       HR15.1  HR155
Effective Date       Contains the date the personnel action      HR511   HR515
                     that created this record took effect.       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

BNG-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

BNG-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

BNG-DATE-STAMP       Numeric 8  (yyyymmdd)                       HR15.1  HR155
Date Stamp           Contains the system date the change was     HR511   HR515
                     created.                                    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

BNG-HOLD-FLAG        Alpha 1                                     BN35.1  HR15.1
On Hold Flag         Enables a change record to be put on        HR155   HR511
                     hold. BN100 (Employee Change Benefit        HR515   HR54.1
                     Update) will not process records that       HR55.2  HR650
                     are on hold.                                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

BNG-ADD-DELETE       Alpha 1                                     HR15.1  HR155
Add Delete           Indicates if an employee was added to       HR511   HR515
                     or deleted from an employee group.          HR54.1  HR55.2
                     D = Delete                                  HR650   HRS1.1
                     A = Add                                     HRSC.1  PA113
                                                                 PA16.1  PA502
                                                                 PA513   PA54.1
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR22.1  TR500

BNG-GROUP-NAME       Alpha 10                                    HR15.1  HR155
Group Name           Contains the employee group the             HR511   HR515
                     employee was added to or removed from.      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

                         BNGRPCHG FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BNGSET1   COMPANY                                                BN100   BN35.1
          EMPLOYEE                                               HR15.1  HR155
          EFFECT-DATE                                            HR511   HR515
          SEQ-NBR                                                HR54.1  HR55.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

BNGSET2   COMPANY       Subset                                   BN100
          EMPLOYEE      Where HOLD-FLAG != "Y"
          EFFECT-DATE
          ADD-DELETE*
          SEQ-NBR

BNGSET4   COMPANY                                                BN100   HR15.1
          EMPLOYEE                                               HR155   HR511
          EFFECT-DATE                                            HR515   HR54.1
          ADD-DELETE                                             HR55.2  HR650
          GROUP-NAME                                             HRS1.1  HRSC.1
                                                                 PA113   PA16.1
                                                                 PA502   PA513
                                                                 PA54.1  TR22.1
                                                                 TR500   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

                         BNGRPCHG FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bncompany      BNCOMPANY    Required

                            BNG-COMPANY       -> BNC-COMPANY

Employee       EMPLOYEE     Required

                            BNG-COMPANY       -> EMP-COMPANY
                            BNG-EMPLOYEE      -> EMP-EMPLOYEE

Persacthst     PERSACTHST   Required

                            BNG-ACT-OBJ-ID    -> PAH-OBJ-ID

Prsystem       PRSYSTEM     Required

                            BNG-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

                         BNGRPCHG FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Benefit        BENEFIT

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

Empflexdol     EMPFLEXDOL

                            BNG-COMPANY       -> EFD-COMPANY
                            BNG-EMPLOYEE      -> EFD-EMPLOYEE
                                                 EFD-START-DATE