 |
Lawson Insight Technical Documentation |
|
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
|