Lawson Insight Technical Documentation |
|
BNGRPCHG
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
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
BNG-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
BNG-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
BNG-EFFECT-DATE Numeric 8 (yyyymmdd) BN305 HAP3.1
Element: Effect Date Contains the date the personnel action HEP4.1 HPOS.1
that created this record took effect. 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
BNG-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
BNG-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
BNG-DATE-STAMP Numeric 8 (yyyymmdd) BN305 HAP3.1
Element: Date Stamp Contains the system date the change was HEP4.1 HPOS.1
created. 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
BNG-HOLD-FLAG Alpha 1 BN305 BN35.1
Element: Hold Flag Enables a change record to be put on HAP3.1 HEP4.1
hold. BN100 (Employee Change Benefit HPOS.1 HPQC.1
Update) will not process records that HPRS.1 HR11.1
are on hold. 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
BNG-ADD-DELETE Alpha 1 BN305 HAP3.1
Element: Add Delete Indicates if an employee was added to HEP4.1 HPOS.1
or deleted from an employee group. HPQC.1 HPRS.1
D = Delete HR11.1 HR11.2
A = Add 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
BNG-GROUP-NAME Alpha 10 BN305 HAP3.1
Element: Group Name Contains the employee group the HEP4.1 HPOS.1
employee was added to or removed from. 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
BNGRPCHG FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNGSET1 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.1
HR55.2 HRS1.1
HRSC.1 LP100
LP101 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA16.1 PA20.1
...
BNGSET2 COMPANY Subset BN100
EMPLOYEE Where HOLD-FLAG != "Y"
EFFECT-DATE
ADD-DELETE*
SEQ-NBR
BNGSET4 COMPANY BN100 BN305
EMPLOYEE HAP3.1 HEP4.1
EFFECT-DATE HPOS.1 HPQC.1
ADD-DELETE HPRS.1 HR11.1
GROUP-NAME 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
...
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
|