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

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

BNH-COMPANY            Numeric 4                                 HAP3.1  HEP4.1
Element: Company Hr    Contains the company number.              HPOS.1  HPQC.1
                                                                 HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR155   HR511
                                                                 HR515   HR54.1
                                                                 HR55.2  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

BNH-EMPLOYEE           Numeric 9                                 HAP3.1  HEP4.1
Element: Employee      Contains the employee number.             HPOS.1  HPQC.1
                                                                 HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR155   HR511
                                                                 HR515   HR54.1
                                                                 HR55.2  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

BNH-EFFECT-DATE        Numeric 8  (yyyymmdd)                     HAP3.1  HEP4.1
Element: Effective DateContains the personnel action effective   HPOS.1  HPQC.1
                       date.                                     HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR155   HR511
                                                                 HR515   HR54.1
                                                                 HR55.2  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

BNH-SEQ-NBR            Numeric 4                                 HAP3.1  HEP4.1
Element: Sequence NumbeContains an automatically assigned        HPOS.1  HPQC.1
                       sequence number.                          HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR155   HR511
                                                                 HR515   HR54.1
                                                                 HR55.2  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

BNH-ACT-OBJ-ID         Numeric 12                                HAP3.1  HEP4.1
Object                 Contains the Object Id of the personnel   HPOS.1  HPQC.1
Identification         action.                                   HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR155   HR511
                                                                 HR515   HR54.1
                                                                 HR55.2  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

BNH-DATE-STAMP         Numeric 8  (yyyymmdd)                     HAP3.1  HEP4.1
Element: Date Stamp    Contains the system date the change is    HPOS.1  HPQC.1
                       entered.                                  HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR155   HR511
                                                                 HR515   HR54.1
                                                                 HR55.2  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

BNH-HOLD-FLAG          Alpha 1                                   BN35.1  HAP3.1
Element: On Hold Flag  Enables a benefit change record to be     HEP4.1  HPOS.1
                       put on hold so BN100 (Employee Change     HPQC.1  HPRS.1
                       Benefit Update) will not process the      HR11.1  HR11.2
                       change.                                   HR15.1  HR155
                       Y = Yes                                   HR511   HR515
                       N = No                                    HR54.1  HR55.2
                                                                 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

BNH-CHANGE-TYPE        Alpha 1                                   HAP3.1  HEP4.1
Element: Change Type   Contains the type of change.              HPOS.1  HPQC.1
                       1 = Postal Code                           HPRS.1  HR11.1
                       2 = Salary                                HR11.2  HR15.1
                       3 = Pay Frequency                         HR155   HR511
                       4 = Birthdate                             HR515   HR54.1
                       5 = Service Date                          HR55.2  HRS1.1
                       6 = Smoker Flag Change                    HRSC.1  PA02.1
                       7 = New Hire                              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

BNH-OLD-VALUE          Alpha 20                                  HAP3.1  HEP4.1
Element: Old Value     Contains the old value.                   HPOS.1  HPQC.1
                                                                 HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR155   HR511
                                                                 HR515   HR54.1
                                                                 HR55.2  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

BNH-NEW-VALUE          Alpha 30                                  HAP3.1  HEP4.1
Field Value After      Contains the new value.                   HPOS.1  HPQC.1
Change                                                           HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR155   HR511
                                                                 HR515   HR54.1
                                                                 HR55.2  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

                         BNCHANGE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BNHSET1   COMPANY                                                BN100   BN35.1
          EMPLOYEE                                               HAP3.1  HEP4.1
          EFFECT-DATE                                            HPOS.1  HPQC.1
          SEQ-NBR                                                HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR155   HR511
                                                                 HR515   HR54.1
                                                                 HR55.2  HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA115
                                                                 PA13.1  PA13.2
                                                                 PA16.1  PA20.1
                                                                 PA21.1  PA22.1
                                                                 PA24.1  PA27.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