BNGRPCHG FILE
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
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
BNG-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
BNG-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
BNG-EFFECT-DATE Numeric 8 (yyyymmdd) HR15.1 HR155
Effective Date Contains the date the personnel action HR511 HR515
that created this record took effect. 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
BNG-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
BNG-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
BNG-DATE-STAMP Numeric 8 (yyyymmdd) HR15.1 HR155
Date Stamp Contains the system date the change was HR511 HR515
created. 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
BNG-HOLD-FLAG Alpha 1 BN35.1 HR15.1
On Hold Flag Enables a change record to be put on HR155 HR511
hold. BN100 (Employee Change Benefit HR515 HR54.1
Update) will not process records that HR55.2 HR650
are on hold. 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
BNG-ADD-DELETE Alpha 1 HR15.1 HR155
Add Delete Indicates if an employee was added to HR511 HR515
or deleted from an employee group. HR54.1 HR55.2
D = Delete HR650 HRS1.1
A = Add HRSC.1 PA113
PA16.1 PA502
PA513 PA54.1
PR13.1 PR13.5
PR13.6 PR13.8
TR22.1 TR500
BNG-GROUP-NAME Alpha 10 HR15.1 HR155
Group Name Contains the employee group the HR511 HR515
employee was added to or removed from. 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
BNGRPCHG FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNGSET1 COMPANY BN100 BN35.1
EMPLOYEE HR15.1 HR155
EFFECT-DATE HR511 HR515
SEQ-NBR HR54.1 HR55.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
BNGSET2 COMPANY Subset BN100
EMPLOYEE Where HOLD-FLAG != "Y"
EFFECT-DATE
ADD-DELETE*
SEQ-NBR
BNGSET4 COMPANY BN100 HR15.1
EMPLOYEE HR155 HR511
EFFECT-DATE HR515 HR54.1
ADD-DELETE HR55.2 HR650
GROUP-NAME HRS1.1 HRSC.1
PA113 PA16.1
PA502 PA513
PA54.1 TR22.1
TR500 PR13.1
PR13.5 PR13.6
PR13.8
BNGRPCHG FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|