Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNGRPCHG


                             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    HGLM.1    HPOS.1    HPQC.1    HPRS.1
HR11.1    HR11.2    HR15.1    HR155     HR511     HR515
HR54.1    HR55.2    HR650     HRS1.1    HRSC.1    PA02.1
PA100     PA102     PA113     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    PRSC.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BNG-COMPANY            Numeric 4                                 HGLM.1  HPOS.1
Element: Company       Contains the company number.              HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   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
                                                                 PRSC.1  TR21.1
                                                                 TR22.1  TR26.1
                                                                 TR500

BNG-EMPLOYEE           Numeric 9                                 HGLM.1  HPOS.1
Element: Employee      Contains the employee number.             HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   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
                                                                 PRSC.1  TR21.1
                                                                 TR22.1  TR26.1
                                                                 TR500

BNG-EFFECT-DATE        Numeric 8  (yyyymmdd)                     HGLM.1  HPOS.1
Element: Date          Contains the date the personnel action    HPQC.1  HPRS.1
                       that created this record took effect.     HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   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
                                                                 PRSC.1  TR21.1
                                                                 TR22.1  TR26.1
                                                                 TR500

BNG-SEQ-NBR            Numeric 4                                 HGLM.1  HPOS.1
Element: Sequence NumbeContains an automatically assigned        HPQC.1  HPRS.1
                       sequence number.                          HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   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
                                                                 PRSC.1  TR21.1
                                                                 TR22.1  TR26.1
                                                                 TR500

BNG-ACT-OBJ-ID         Numeric 12                                HGLM.1  HPOS.1
Object                 Contains the Object Id of the personnel   HPQC.1  HPRS.1
Identification         action.                                   HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   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
                                                                 PRSC.1  TR21.1
                                                                 TR22.1  TR26.1
                                                                 TR500

BNG-DATE-STAMP         Numeric 8  (yyyymmdd)                     HGLM.1  HPOS.1
Element: Date Stamp    Contains the system date the change was   HPQC.1  HPRS.1
                       created.                                  HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   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
                                                                 PRSC.1  TR21.1
                                                                 TR22.1  TR26.1
                                                                 TR500

BNG-HOLD-FLAG          Alpha 1                                   BN35.1  HGLM.1
Element: On Hold Flag  Enables a change record to be put on      HPOS.1  HPQC.1
                       hold. BN100 (Employee Change Benefit      HPRS.1  HR11.1
                       Update) will not process records that     HR11.2  HR15.1
                       are on hold.                              HR155   HR511
                       Y = Yes                                   HR515   HR54.1
                       N = No                                    HR55.2  HR650
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 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  PRSC.1
                                                                 TR21.1  TR22.1
                                                                 TR26.1  TR500

BNG-ADD-DELETE         Alpha 1                                   HGLM.1  HPOS.1
Element: Add Delete    Indicates if an employee was added to     HPQC.1  HPRS.1
                       or deleted from an employee group.        HR11.1  HR11.2
                       D = Delete                                HR15.1  HR155
                       A = Add                                   HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   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
                                                                 PRSC.1  TR21.1
                                                                 TR22.1  TR26.1
                                                                 TR500

BNG-GROUP-NAME         Alpha 10                                  HGLM.1  HPOS.1
Element: Group Name    Contains the employee group the           HPQC.1  HPRS.1
                       employee was added to or removed from.    HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   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
                                                                 PRSC.1  TR21.1
                                                                 TR22.1  TR26.1
                                                                 TR500

                         BNGRPCHG FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BNGSET1   COMPANY                                                BN100   BN35.1
          EMPLOYEE                                               HGLM.1  HPOS.1
          EFFECT-DATE                                            HPQC.1  HPRS.1
          SEQ-NBR                                                HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.1
                                                                 HR55.2  HR650
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   PA13.1
                                                                 PA13.2  PA16.1
                                                                 PA20.1  PA21.1
                                                                 PA22.1  PA24.1
                                                                 ...

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

BNGSET4   COMPANY                                                BN100   HGLM.1
          EMPLOYEE                                               HPOS.1  HPQC.1
          EFFECT-DATE                                            HPRS.1  HR11.1
          ADD-DELETE                                             HR11.2  HR15.1
          GROUP-NAME                                             HR155   HR511
                                                                 HR515   HR54.1
                                                                 HR55.2  HR650
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA13.1  PA13.2
                                                                 PA16.1  PA20.1
                                                                 PA21.1  PA22.1
                                                                 PA24.1  PA27.1
                                                                 PA34.1  PA35.1
                                                                 ...

                         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