|
|
BNFAMSTS 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.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BFS-COMPANY Numeric 4 BS03.2
Element: Company The company number represents an
established company and is entered on
all function codes.
BFS-PROCESS-LEVEL Alpha 5 BS03.2
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
BFS-FAMILY-STATUS Alpha 10 BS03.2
Element: Family Status 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
BFS-GROUP-NAME Alpha 10 BS03.2
Element: Group Name
BFS-PLAN-GROUP Alpha 20 BS03.2
Element: Plan Group
BFS-PLAN-TYPE Alpha 2 BS03.2
Element: Type 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
BFS-PLAN-CODE Alpha 4 BS03.2
Element: Plan Contains the user-defined code that
represents a benefit plan.
BFS-PROCESS-ORDER Numeric 2 BS02.1 BS03.2
Element: Process Order
BFS-INQUIRE-ONLY Alpha 1
Element: Inquire Only Y = Yes
N = No
BFS-ADD-ALLOWED Alpha 1 BS03.2
Element: Add Allowed Y = Yes
N = No
BFS-ADD-DATE Alpha 2 BS03.2
Element: Add Date 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
BFS-CHANGE-ALLOWED Alpha 1 BS03.2
Element: Change AllowedY = Yes
N = No
BFS-CHANGE-DATE Alpha 2 BS03.2
Element: Change Date 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
BFS-STOP-ALLOWED Alpha 1 BS03.2
Element: Stop Allowed Y = Yes
N = No
BFS-STOPPED-DATE Alpha 2 BS03.2
Element: Stopped Date 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
BFS-EOI-DAYS Numeric 3 BS03.2
Element: Eoi Days
BFS-EMPLOYEE-COST Alpha 1 BS03.2
Element: Employee Cost E = Employee Only
F = Flex Only
B = Employee And Flex Both
T = Total of Employee And Flex
BFS-COMPANY-COST Alpha 1 BS03.2
Element: Company Cost Y = Yes
N = No
BFS-DEP-BENEFITS Alpha 1 BS03.2
Element: Dep Benefits Y = Yes
N = No
BFS-BENEFICIARY Alpha 1
Element: Beneficiary Y = Yes
N = No
BFS-CO-PROVIDED Alpha 1
Element: Co Provided Y = Yes
N = No
BNFAMSTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BFSSET1 COMPANY BN100 BN101
PROCESS-LEVEL BN102 BN103
FAMILY-STATUS BN105 BN145
GROUP-NAME BN245 BN31.1
PLAN-GROUP BN31.2 BN32.1
PLAN-TYPE BN32.2 BN32.3
PLAN-CODE 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 BS10.1 BS12.1
PROCESS-LEVEL
FAMILY-STATUS
GROUP-NAME
PROCESS-ORDER
PLAN-TYPE
PLAN-CODE
BFSSET3 COMPANY BS03.2 BS13.1
PROCESS-LEVEL BS14.1 BS15.1
FAMILY-STATUS
GROUP-NAME
PLAN-TYPE
PLAN-CODE
BFSSET4 COMPANY BS02.1
PROCESS-LEVEL
PLAN-GROUP
FAMILY-STATUS
GROUP-NAME
PLAN-TYPE
PLAN-CODE
BFSSET5 COMPANY BN15.1
PLAN-TYPE
PLAN-CODE
PROCESS-LEVEL
FAMILY-STATUS
GROUP-NAME
PLAN-GROUP
BNFAMSTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
