BNFAMSTS

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.2
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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BFS-COMPANY
Element: Company Hr
Numeric 4
BS03.2
BFS-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
BS03.2
BFS-FAMILY-STATUS
Element: Family Status
Alpha 10

ADOPTION = Adoption
BIRTH = Birth
DEATH = Death
DIVORCE = Divorce
LEGAL SEP = Legal Separation
LOA = Leave of Absence
MARRIAGE = Marriage
MOVE = Address Change
RETIREMENT = Retirement
SPS CHANGE = Spouse Coverage Change\
STUDENT = Student
BS03.2
BFS-GROUP-NAME
Element: Group Name
Alpha 10
BS03.2
BFS-PLAN-GROUP
Element: Plan Group
Alpha 20
BS03.2
BFS-PLAN-TYPE
Element: Plan Type
Alpha 2

HL = Health
DN = Dental
DI = Disability
EL = Employee Life
DL = Dependent Life
DC = Defined Contribution
DB = Defined Benefit
VA = Vacation
RS = Spending Account
SB = Savings Bond
SP = Stock Purchase
BS03.2
BFS-PLAN-CODE
Element: Plan Code
Alpha 4
Contains the user-defined code that represents a benefit plan.
BS03.2
BFS-PROCESS-ORDER
Element: Process Order
Numeric 2
BS02.1 BS03.2
BFS-INQUIRE-ONLY
Element: Inquire Only
Alpha 1

Y = Yes
N = No
BFS-ADD-ALLOWED
Element: Add Allowed
Alpha 1

Y = Yes
N = No
BS03.2
BFS-ADD-DATE
Element: Add Date
Alpha 2

FS = Family Status Change Date
CM = First of Current Month
NM = First of Next Month
CP = First of Current Pay Period
NP = First of Next Pay Period
CW = First of Current Work Period
NW = First of Next Work Period
BS03.2
BFS-CHANGE-ALLOWED
Element: Change Allowed
Alpha 1

Y = Yes
N = No
BS03.2
BFS-CHANGE-DATE
Element: Change Date
Alpha 2

FS = Family Status Change Date
CM = First of Current Month
NM = First of Next Month
CP = First of Current Work Period
NP = First of Next Pay Period
CW = First of Current Work Period
NW = First of Next Work Period
BS03.2
BFS-STOP-ALLOWED
Element: Stop Allowed
Alpha 1

Y = Yes
N = No
BS03.2
BFS-STOPPED-DATE
Element: Stopped Date
Alpha 2

FS = Family Status Change Date
CM = First of Current Month
NM = First of Next Month
CP = First of Current Pay Period
NP = First of Next Pay Period
CW = First of Current Work Period
NW = First of Next Work Period
BS03.2
BFS-EOI-DAYS
Element: Eoi Days
Numeric 3
BS03.2
BFS-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.2
BFS-COMPANY-COST
Element: Company Cost
Alpha 1

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

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

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

Y = Yes
N = No
BFS-CREATE-TRANS
Element: Create Trans
Alpha 1

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


BNFAMSTS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BFSSET1 COMPANY
PROCESS-LEVEL
FAMILY-STATUS
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.2
BS09.1 BS10.1
BS11.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
BFSSET2 COMPANY
PROCESS-LEVEL
FAMILY-STATUS
GROUP-NAME
PROCESS-ORDER
PLAN-TYPE
PLAN-CODE
BS10.1 BS12.1
BFSSET3 COMPANY
PROCESS-LEVEL
FAMILY-STATUS
GROUP-NAME
PLAN-TYPE
PLAN-CODE
BS03.2 BS13.1
BS14.1 BS15.1
BFSSET4 COMPANY
PROCESS-LEVEL
PLAN-GROUP
FAMILY-STATUS
GROUP-NAME
PLAN-TYPE
PLAN-CODE
BS02.1
BFSSET5 COMPANY
PLAN-TYPE
PLAN-CODE
PROCESS-LEVEL
FAMILY-STATUS
GROUP-NAME
PLAN-GROUP
BN15.1


BNFAMSTS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Bnplngroup BNPLNGROUP Required
BFS-COMPANY->BPG-COMPANY
BFS-PLAN-GROUP->BPG-PLAN-GROUP
Employee Group PERSGROUP Required
BFS-COMPANY->PRG-COMPANY
BFS-GROUP-NAME->PRG-GROUP-NAME
Plan PLAN Required
BFS-COMPANY->PLN-COMPANY
BFS-PLAN-TYPE->PLN-PLAN-TYPE
BFS-PLAN-CODE->PLN-PLAN-CODE
Process Level PRSYSTEM Required
BFS-COMPANY->PRS-COMPANY
BFS-PROCESS-LEVEL->PRS-PROCESS-LEVEL
Prsystem PRSYSTEM Required
BFS-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Reason Code PCODES Required
When BFS-REASON-1 !=Zeroes
"BT"->PCO-TYPE
BFS-DEFAULT-REASON->PCO-CODE


File created: Thu Jun 09 11:09:58 2016

Home
Contact Us



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