BNPLNENR

UPDATED BY
BN100 BN101 BN102 BN103 BN105 BN145
BN15.1 BN232 BN245 BN31.1 BN31.2 BN32.1
BN32.2 BN32.3 BN320 BN331 BN340 BN45.1
BN531 BN65.1 BN71.1 BN72.1 BS02.1 BS03.1
BS09.1 BS10.1 BS11.1 BS12.1 BS13.1 BS14.1
BS15.1 BS32.1 ZB01.1 ZB10.1 ZB10.2 ZB31.1
ZB31.2 ZB32.1 ZB32.2 ZB32.3 ZB599

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BPE-COMPANY
Element: Company Hr
Numeric 4
BS03.1
BPE-PLAN-TYPE
Element: Plan Type
Alpha 2

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
BS03.1
BPE-PLAN-CODE
Element: Plan Code
Alpha 4
Contains the user-defined code that represents a benefit plan.
BS03.1
BPE-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
BS03.1
BPE-GROUP-NAME
Element: Group Name
Alpha 10
BS03.1
BPE-PLAN-GROUP
Element: Plan Group
Alpha 20
BS03.1
BPE-PROCESS-ORDER
Element: Process Order
Numeric 2
BS02.1 BS03.1
BPE-ANNUAL-ENROLL
Element: Annual Enroll
Alpha 1

Y = Yes
N = No
BPE-LIFE-EVENT
Element: Life Event
Alpha 1

M = Marriage
D = Divorce
B = Birth
A = Adoption
BPE-INQUIRY
Element: Inquiry
Alpha 1

Y = Yes
N = No
BPE-CHANGE
Element: Change
Alpha 1

Y = Yes
N = No
BPE-HIRE
Element: Hire
Alpha 1

Y = Yes
N = No
BPE-EMPLOYEE-COST
Element: Employee Cost
Alpha 1

E = Employee Only
F = Flex Only
B = Both Employee and Flex
T = Total of Employee and Flex
BS03.1
BPE-COMPANY-COST
Element: Company Cost
Alpha 1

Y = Yes
N = No
BS03.1
BPE-DEP-BENEFITS
Element: Dep Benefits
Alpha 1

Y = Yes
N = No
BS03.1
BPE-BENEFICIARY
Element: Beneficiary
Alpha 1

Y = Yes
N = No
BPE-CO-PROVIDED
Element: Co Provided
Alpha 1

Y = Yes
N = No
BPE-DATE-1
Element: Date 1
Numeric 8 (yyyymmdd)
BPE-DATE-2
Element: Date 2
Numeric 8 (yyyymmdd)
BPE-MISC-1
Element: Misc 1
Alpha 10
BPE-MISC-2
Element: Misc 2
Alpha 10
BPE-CREATE-TRANS
Element: Create Trans
Alpha 1

Y = Yes
N = No
BS03.1
BPE-DEFAULT-REASON
Element: Reason
Alpha 10 Occurs 3 Times
BS03.1
BPE-REASON-1
Element: Reason 1
Derived


BNPLNENR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BPESET1 COMPANY
PROCESS-LEVEL
GROUP-NAME
PLAN-GROUP
PLAN-TYPE
PLAN-CODE
...
BN100 BN101
BN102 BN103
BN105 BN145
BN232 BN245
BN31.1 BN31.2
BN32.1 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
PROCESS-LEVEL
GROUP-NAME
PROCESS-ORDER
PLAN-TYPE
PLAN-CODE
BS10.1 BS12.1
BPESET3 COMPANY
PROCESS-LEVEL
GROUP-NAME
PLAN-TYPE
PLAN-CODE
BS03.1 BS13.1
BS14.1 BS15.1
BPESET4 COMPANY
PROCESS-LEVEL
PLAN-GROUP
GROUP-NAME
PLAN-TYPE
PLAN-CODE
BS02.1
BPESET5 COMPANY
PLAN-TYPE
PLAN-CODE
PROCESS-LEVEL
GROUP-NAME
PLAN-GROUP
BN15.1


BNPLNENR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
Reason Code PCODES Required
When BPE-REASON-1 !=Zeroes
"BT"->PCO-TYPE
BPE-DEFAULT-REASON->PCO-CODE


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

Home
Contact Us



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