BNNEWHIRE FILE
REFERENCED BY
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 BS09.1 BS10.1 BS11.1
BS12.1 BS13.1 BS14.1 BS15.1 BS32.1 BN15.1
UPDATED BY
BS02.1 BS03.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BNN-COMPANY Numeric 4 BS03.3
Element: Company Hr
BNN-PROCESS-LEVEL Alpha 5 BS03.3
Element: Process Lev Hr
BNN-GROUP-NAME Alpha 10 BS03.3
Element: Group Name
BNN-PLAN-GROUP Alpha 20 BS03.3
Element: Plan Group
BNN-PLAN-TYPE Alpha 2 BS03.3
Element: Plan Type DB = Defined Benefit
DC = Defined Contribution
DI = Disability
DL = Dependent Life
DN = Dental
EL = Employee Life
HL = Health
RS = Spending Account
SB = Savings Bond
SP = Stock Purchase
VA = Vacation
BNN-PLAN-CODE Alpha 4 BS03.3
Element: Plan Code Contains the user-defined code that
represents a benefit plan.
BNN-PROCESS-ORDER Numeric 2 BS02.1 BS03.3
Element: Process Order
BNN-EMPLOYEE-COST Alpha 1 BS03.3
Element: Employee Cost E = Employee Only
F = Flex Only
B = Employee And Flex Both
T = Total of Employee And Flex
BNN-COMPANY-COST Alpha 1 BS03.3
Element: Company Cost Y = Yes
N = No
BNN-DEP-BENEFITS Alpha 1 BS03.3
Element: Dep Benefits Y = Yes
N = No
BNN-BENEFICIARY Alpha 1
Element: Beneficiary Y = Yes
N = No
BNN-CO-PROVIDED Alpha 1
Element: Co Provided Y = Yes
N = No
BNN-EOI-DAYS Numeric 3 BS03.3
Element: Eoi Days
BNN-CREATE-TRANS Alpha 1 BS03.3
Element: Create Trans Y = Yes
N = No
BNN-DEFAULT-REASON Alpha 10 Occurs 3 Times BS03.3
Element: Reason
BNN-REASON-1 Derived
Element: Reason 1
BNNEWHIRE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNNSET1 COMPANY BN100 BN101
PROCESS-LEVEL BN102 BN103
GROUP-NAME BN105 BN145
PLAN-GROUP BN232 BN245
PLAN-TYPE BN31.1 BN31.2
PLAN-CODE BN32.1 BN32.2
BN32.3 BN320
BN331 BN340
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS03.3
BS09.1 BS10.1
BS11.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
BNNSET2 COMPANY BS10.1 BS12.1
PROCESS-LEVEL
GROUP-NAME
PROCESS-ORDER
PLAN-TYPE
PLAN-CODE
BNNSET3 COMPANY BS03.3 BS13.1
PROCESS-LEVEL BS14.1 BS15.1
GROUP-NAME
PLAN-TYPE
PLAN-CODE
BNNSET4 COMPANY BS02.1
PROCESS-LEVEL
PLAN-GROUP
GROUP-NAME
PLAN-TYPE
PLAN-CODE
BNNSET5 COMPANY BN15.1
PLAN-TYPE
PLAN-CODE
PROCESS-LEVEL
GROUP-NAME
PLAN-GROUP
BNNEWHIRE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bnplngroup BNPLNGROUP Required
BNN-COMPANY -> BPG-COMPANY
BNN-PLAN-GROUP -> BPG-PLAN-GROUP
Group Name PERSGROUP Required
BNN-COMPANY -> PRG-COMPANY
BNN-GROUP-NAME -> PRG-GROUP-NAME
Plan PLAN Required
BNN-COMPANY -> PLN-COMPANY
BNN-PLAN-TYPE -> PLN-PLAN-TYPE
BNN-PLAN-CODE -> PLN-PLAN-CODE
Process Level PRSYSTEM Required
BNN-COMPANY -> PRS-COMPANY
BNN-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Prsystem PRSYSTEM Required
BNN-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Reason Code PCODES Required
When BNN-REASON-1 != Zeroes
"BT" -> PCO-TYPE
BNN-DEFAULT-REASON -> PCO-CODE
|