Lawson Insight Technical Documentation |
|
BNPLNENR
BNPLNENR FILE
REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN145
BN245 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3
BN320 BN331 BN340 BN45.1 BN531 BN65.1
BN71.1 BN72.1 BS09.1 BS10.1 BS11.1 BS12.1
BS13.1 BS14.1 BS15.1 BS32.1 BN15.1
UPDATED BY
BS02.1 BS03.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BPE-COMPANY Numeric 4 BS03.1
Element: Company The company number represents an
established company and is entered on
all function codes.
BPE-PLAN-TYPE Alpha 2 BS03.1
Element: Type DB = Defined Benefit
DC = Defined Contribution
DI = Disability
DL = Dependent Life
EL = Employee Life
HL = Health
RS = Spending Account
SB = Savings Bond
SP = Stock Purchase
VA = Vacation
BPE-PLAN-CODE Alpha 4 BS03.1
Element: Plan Contains the user-defined code that
represents a benefit plan.
BPE-PROCESS-LEVEL Alpha 5 BS03.1
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
BPE-GROUP-NAME Alpha 10 BS03.1
Element: Group Name
BPE-PLAN-GROUP Alpha 20 BS03.1
Element: Plan Group
BPE-PROCESS-ORDER Numeric 2 BS02.1 BS03.1
Element: Process Order
BPE-ANNUAL-ENROLL Alpha 1
Element: Annual Enroll Y = Yes
N = No
BPE-LIFE-EVENT Alpha 1
Element: Life Event M = Marriage
D = Divorce
B = Birth
A = Adoption
BPE-INQUIRY Alpha 1
Element: Inquiry Y = Yes
N = No
BPE-CHANGE Alpha 1
Element: Change Y = Yes
N = No
BPE-HIRE Alpha 1
Element: Hire Y = Yes
N = No
BPE-EMPLOYEE-COST Alpha 1 BS03.1
Element: Employee Cost E = Employee Only
F = Flex Only
B = Both Employee and Flex
T = Total of Employee and Flex
BPE-COMPANY-COST Alpha 1 BS03.1
Element: Company Cost Y = Yes
N = No
BPE-DEP-BENEFITS Alpha 1 BS03.1
Element: Dep Benefits Y = Yes
N = No
BPE-BENEFICIARY Alpha 1
Element: Beneficiary Y = Yes
N = No
BPE-CO-PROVIDED Alpha 1
Element: Co Provided Y = Yes
N = No
BPE-DATE-1 Numeric 8 (yyyymmdd)
Element: Date 1
BPE-DATE-2 Numeric 8 (yyyymmdd)
Element: Date 2
BPE-MISC-1 Alpha 10
Element: Misc 1
BPE-MISC-2 Alpha 10
Element: Misc 2
BNPLNENR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BPESET1 COMPANY BN100 BN101
PROCESS-LEVEL BN102 BN103
GROUP-NAME BN105 BN145
PLAN-GROUP BN245 BN31.1
PLAN-TYPE BN31.2 BN32.1
PLAN-CODE BN32.2 BN32.3
BN320 BN331
BN340 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS03.1 BS09.1
BS10.1 BS11.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1
BPESET2 COMPANY BS10.1 BS12.1
PROCESS-LEVEL
GROUP-NAME
PROCESS-ORDER
PLAN-TYPE
PLAN-CODE
BPESET3 COMPANY BS03.1 BS13.1
PROCESS-LEVEL BS14.1 BS15.1
GROUP-NAME
PLAN-TYPE
PLAN-CODE
BPESET4 COMPANY BS02.1
PROCESS-LEVEL
PLAN-GROUP
GROUP-NAME
PLAN-TYPE
PLAN-CODE
BPESET5 COMPANY BN15.1
PLAN-TYPE
PLAN-CODE
PROCESS-LEVEL
GROUP-NAME
PLAN-GROUP
BNPLNENR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bncompany BNCOMPANY Required
BPE-COMPANY -> BNC-COMPANY
Employee Group PERSGROUP Required
BPE-COMPANY -> PRG-COMPANY
BPE-GROUP-NAME -> PRG-GROUP-NAME
Plan PLAN Required
BPE-COMPANY -> PLN-COMPANY
BPE-PLAN-TYPE -> PLN-PLAN-TYPE
BPE-PLAN-CODE -> PLN-PLAN-CODE
Plan Group BNPLNGROUP Required
BPE-COMPANY -> BPG-COMPANY
BPE-PLAN-GROUP -> BPG-PLAN-GROUP
Prsystem PRSYSTEM Required
BPE-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
|