BNGRPCHG

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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BNG-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 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LT101 LT11.5
LT111 LT13.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
BNG-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 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LT101 LT11.5
LT111 LT13.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
BNG-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
Contains the date the personnel action that created this record took effect.
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LT101 LT11.5
LT111 LT13.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
BNG-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 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LT101 LT11.5
LT111 LT13.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
BNG-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 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LT101 LT11.5
LT111 LT13.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
BNG-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
Contains the system date the change was created.
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LT101 LT11.5
LT111 LT13.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
BNG-HOLD-FLAG
Element: Hold Flag
Alpha 1
Enables a change record to be put on hold. BN100 (Employee Change Benefit Update) will not process records that are on hold.
Y = Yes
N = No
...
BN305 BN35.1
HAP3.1 HCRE.1
HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR11.4 HR15.1
HR155 HR156
HR28.1 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 LP100
LP101 LT101
LT11.5 LT111
LT13.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
BNG-ADD-DELETE
Element: Add Delete
Alpha 1
Indicates if an employee was added to or deleted from an employee group.
D = Delete
A = Add
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LT101 LT11.5
LT111 LT13.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
BNG-GROUP-NAME
Element: Group Name
Alpha 10
Contains the employee group the employee was added to or removed from.
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LT101 LT11.5
LT111 LT13.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
BNG-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LT101 LT11.5
LT111 LT13.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
BNG-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LT101 LT11.5
LT111 LT13.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
BNG-CREATE-USER-ID
Element: User Id
Alpha 10 (Lower Case)
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LT101 LT11.5
LT111 LT13.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
BNG-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LT101 LT11.5
LT111 LT13.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
BNG-USER-ID
Element: User Id
Alpha 10 (Lower Case)
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LT101 LT11.5
LT111 LT13.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


BNGRPCHG FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNGSET1 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 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.1
HR55.2 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 ZH156
ZH510 LP100
BNGSET2 COMPANY
EMPLOYEE
EFFECT-DATE
ADD-DELETE*
SEQ-NBR
Subset
WhereHOLD-FLAG !="Y"
BN100
BNGSET4 COMPANY
EMPLOYEE
EFFECT-DATE
ADD-DELETE
GROUP-NAME
...
BN100 BN305
HAP3.1 HCRE.1
HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR11.4 HR15.1
HR155 HR156
HR28.1 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 ZH156
ZH510 LP100
LP101 PA02.1


BNGRPCHG FILE RELATIONS


ONE TO ONE RELATIONS

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


File created: Thu Jun 09 02:10:00 2016

Home
Contact Us



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