BNNEWHIRE

REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN145
BN232 BN245 BN260 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
ZB01.1 ZB10.1 ZB10.2 ZB31.1 ZB31.2 ZB32.1
ZB32.2 ZB32.3 BN15.1


UPDATED BY
BS02.1 BS03.3

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BNN-COMPANY
Element: Company Hr		Numeric 4
BS03.3
BNN-PROCESS-LEVEL
Element: Process Lev Hr		Alpha 5
BS03.3
BNN-GROUP-NAME
Element: Group Name		Alpha 10
BS03.3
BNN-PLAN-GROUP
Element: Plan Group		Alpha 20
BS03.3
BNN-PLAN-TYPE
Element: Plan Type		Alpha 2

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
BS03.3
BNN-PLAN-CODE
Element: Plan Code		Alpha 4
Contains the user-defined code that represents a benefit plan.
BS03.3
BNN-PROCESS-ORDER
Element: Process Order		Numeric 2
BS02.1 BS03.3
BNN-EMPLOYEE-COST
Element: Employee Cost		Alpha 1

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

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

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

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

Y = Yes
N = No
BNN-EOI-DAYS
Element: Eoi Days		Numeric 3
BS03.3
BNN-CREATE-TRANS
Element: Create Trans		Alpha 1

Y = Yes
N = No
BS03.3
BNN-DEFAULT-REASON
Element: Reason		Alpha 10 Occurs 3 Times
BS03.3
BNN-REASON-1
Element: Reason 1		Derived
BNN-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
BS03.3
BNN-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
BS03.3
BNN-CREATE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
BS03.3
BNN-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
BS02.1 BS03.3
BNN-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
BS02.1 BS03.3
BNN-USER-ID
Element: User Id		Alpha 10 (Lower Case)
BS02.1 BS03.3
BNN-EFFECTIVE-CODE
Element: Type		Alpha 2
Coded value to represent the effective date of changes.
CD = Current Date
ED = Eligibility Date
BS03.3


BNNEWHIRE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNNSET1 COMPANY
PROCESS-LEVEL
GROUP-NAME
PLAN-GROUP
PLAN-TYPE
PLAN-CODE
...
BN100 BN101
BN102 BN103
BN105 BN145
BN232 BN245
BN260 BN31.1
BN31.2 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
BNNSET2 COMPANY
PROCESS-LEVEL
GROUP-NAME
PROCESS-ORDER
PLAN-TYPE
PLAN-CODE
BS10.1 BS12.1
BNNSET3 COMPANY
PROCESS-LEVEL
GROUP-NAME
PLAN-TYPE
PLAN-CODE
BS03.3 BS13.1
BS14.1 BS15.1
BNNSET4 COMPANY
PROCESS-LEVEL
PLAN-GROUP
GROUP-NAME
PLAN-TYPE
PLAN-CODE
BS02.1
BNNSET5 COMPANY
PLAN-TYPE
PLAN-CODE
PROCESS-LEVEL
GROUP-NAME
PLAN-GROUP
BN15.1


BNNEWHIRE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 02:10:01 2016

Home
Contact Us



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