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
BN305 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 LP100
LP101 PA02.1 PA100 PA102 PA113 PA115
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 BN100
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BNH-COMPANY Numeric 4 BN305 HAP3.1
Element: Company Hr Contains the company number. 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
LP100 LP101
PA02.1 PA100
PA102 PA113
PA115 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
TR21.1 TR22.1
TR26.1 TR500
BNH-EMPLOYEE Numeric 9 BN305 HAP3.1
Element: Employee Contains the employee number. 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
LP100 LP101
PA02.1 PA100
PA102 PA113
PA115 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
TR21.1 TR22.1
TR26.1 TR500
BNH-EFFECT-DATE Numeric 8 (yyyymmdd) BN305 HAP3.1
Element: Effect Date Contains the personnel action effective HEP4.1 HPOS.1
date. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA113
PA115 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
TR21.1 TR22.1
TR26.1 TR500
BNH-SEQ-NBR Numeric 4 BN305 HAP3.1
Element: Seq Nbr Contains an automatically assigned HEP4.1 HPOS.1
sequence number. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA113
PA115 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
TR21.1 TR22.1
TR26.1 TR500
BNH-ACT-OBJ-ID Numeric 12 BN305 HAP3.1
Element: Obj Id Contains the Object Id of the personnel HEP4.1 HPOS.1
action. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA113
PA115 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
TR21.1 TR22.1
TR26.1 TR500
BNH-DATE-STAMP Numeric 8 (yyyymmdd) BN305 HAP3.1
Element: Date Stamp Contains the system date the change is HEP4.1 HPOS.1
entered. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA113
PA115 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
TR21.1 TR22.1
TR26.1 TR500
BNH-HOLD-FLAG Alpha 1 BN305 BN35.1
Element: Hold Flag Enables a benefit change record to be HAP3.1 HEP4.1
put on hold so BN100 (Employee Change HPOS.1 HPQC.1
Benefit Update) will not process the HPRS.1 HR11.1
change. HR11.2 HR15.1
Y = Yes HR155 HR511
N = No HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 LP100
LP101 PA02.1
PA100 PA102
PA113 PA115
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 TR21.1
TR22.1 TR26.1
TR500
BNH-CHANGE-TYPE Alpha 1 BN305 HAP3.1
Element: Change Type Contains the type of change. HEP4.1 HPOS.1
1 = Postal Code HPQC.1 HPRS.1
2 = Salary HR11.1 HR11.2
3 = Pay Frequency HR15.1 HR155
4 = Birthdate HR511 HR515
5 = Service Date HR54.1 HR55.2
6 = Smoker Flag Change HRS1.1 HRSC.1
7 = New Hire LP100 LP101
PA02.1 PA100
PA102 PA113
PA115 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
TR21.1 TR22.1
TR26.1 TR500
BNH-OLD-VALUE Alpha 20 BN305 HAP3.1
Element: Old Value Contains the old value. 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
LP100 LP101
PA02.1 PA100
PA102 PA113
PA115 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
TR21.1 TR22.1
TR26.1 TR500
BNH-NEW-VALUE Alpha 30 BN305 HAP3.1
Element: New Value Contains the new value. 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
LP100 LP101
PA02.1 PA100
PA102 PA113
PA115 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
TR21.1 TR22.1
TR26.1 TR500
BNCHANGE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNHSET1 COMPANY BN100 BN305
EMPLOYEE BN35.1 HAP3.1
EFFECT-DATE HEP4.1 HPOS.1
SEQ-NBR HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA16.1
PA20.1 PA21.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
|