BNCHANGE

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 BN305 BN35.1 HAP3.1 HCRE.1 HEP4.1
HPOS.1 HPQC.1 HPRS.1 HR11.1 HR11.2 HR15.1
HR155 HR156 HR28.1 HR511 HR515 HR54.1
HR55.2 HRS1.1 HRSC.1 LT101 LT11.5 ZH156
ZH510 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 ZE521 ZE531 ZE540 PR110
PR113 PR12.6 PR120 PR13.1 PR13.5 PR13.6
PR13.8 PR13.9 PR30.2

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


BNCHANGE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNHSET1 COMPANY
EMPLOYEE
EFFECT-DATE
SEQ-NBR
...
BN100 BN305
BN35.1 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR28.1 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 LT101
LT11.5 ZH156
ZH510 LP100
LP101 PA02.1
PA100 PA102
BNHSET2 COMPANY
EMPLOYEE
EFFECT-DATE
CHANGE-TYPE
SEQ-NBR
Subset
WhereHOLD-FLAG !="Y"
BN100


BNCHANGE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

File created: Thu Jun 09 11:09:54 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.