|
|
BNBEN FILE
REFERENCED BY
HR511 HR650 PA02.1 PA100 PA102 PA502
PA52.1 PA52.3 PA52.4 PA52.5 PR110 PR113
PR120 PR13.1 PR13.5 PR13.6 PR13.8
UPDATED BY
BS31.1 BS531 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BNB-COMPANY Numeric 4 BS31.1
Element: Company The company number represents an
established company and is entered on
all function codes.
BNB-EMPLOYEE Numeric 9 BS31.1
Element: Employee Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
BNB-PLAN-TYPE Alpha 2 BS31.1
Element: Type
BNB-PLAN-CODE Alpha 4 BS31.1
Element: Plan Contains the user-defined code that
represents a benefit plan.
BNB-START-DATE Numeric 8 (yyyymmdd) BS31.1
Element: Date
BNB-FC Alpha 1 BS31.1
Element: Fc
BNB-ENROLL-DATE Numeric 8 (yyyymmdd)
Element: Enroll Date
BNB-COVER-OPT Numeric 2 BS31.1
Element: Cover Opt
BNB-MULT-SALARY Signed 5.3 BS31.1
Element: Multiple of Salary
BNB-COVER-AMT Signed 11.2 BS31.1
Element: Flat Amount
BNB-PAY-RATE Signed 13.4 BS31.1
Element: Rate of Pay
BNB-PCT-AMT-FLAG Alpha 1 BS31.1
Percent or Amount
Indicator
BNB-PRE-AFT-FLAG Alpha 1 BS31.1
Element: Pre Aft Flag
BNB-SMOKER-FLAG Alpha 1 BS31.1
Element: Smoker Flag
BNB-EMP-PRE-CONT Signed 7.2 BS31.1
Employee Pre Tax
Contribution
BNB-EMP-AFT-CONT Signed 7.2 BS31.1
Employee After Tax
Contrib
BNB-STOP-DATE Numeric 8 (yyyymmdd) BS31.1
Element: Date
BNB-PEND-EVIDENCE Alpha 1
Element: Pend Evidence
BNB-YTD-CONT Signed 13.2
Element: Ytd Cont
BNB-RCD-TYPE Numeric 2 BS31.1
Element: Rcd Type
BNB-PLAN-GROUP Alpha 20 BS31.1
Element: Plan Group
BNB-COP-COV-DESC Alpha 15 BS31.1
Element: Cop Cov Desc
BNB-DEP-COVER-AMT Signed 11.2 BS31.1
Element: Dep Cover Amt
BNB-COV-PCT Signed 5.2 BS31.1
Element: Cov Pct
BNB-FLEX-COST Signed 9.2 BS31.1
Element: Flex Cost
BNB-EMP-COST Signed 9.2 BS31.1
Element: Emp Cost
BNB-COMP-COST Signed 9.2 BS31.1
Element: Comp Cost
BNB-UPDATE-DATE Numeric 8 (yyyymmdd) BS31.1
Element: Date
BNB-ALPHADATA1 Alpha 1
Element: Alphadata1
BNB-NUMERIC1 Signed 15.4
Element: Numeric1
BNB-DATE1 Numeric 8 (yyyymmdd)
Element: Date1
BNB-PLAN-DESC Alpha 30 BS31.1
Element: Plan Description
BNB-CURRENCY-CODE Alpha 5 BS31.1
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
BNB-CURR-ND Numeric 1 BS31.1
Account Currency
Code
BNB-CREATION-DATE Numeric 8 (yyyymmdd) BS31.1
Element: Date
BNB-UPD-DATE Numeric 8 (yyyymmdd) BS31.1
Element: Upd Date
BNB-TIME-STAMP Numeric 6 (hhmmss) BS31.1
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
BNB-USER-ID Alpha 10 (Lower Case) BS31.1
Element: User
BNBEN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNBSET1 COMPANY BS31.1 BS531
EMPLOYEE HR11.1 HR11.2
PLAN-TYPE HR511 HR650
PLAN-CODE PA02.1 PA100
START-DATE PA102 PA115
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
BNBSET2 COMPANY
PLAN-TYPE
PLAN-CODE
EMPLOYEE
START-DATE*
BNBSET3 COMPANY
PLAN-TYPE
PLAN-CODE
EMPLOYEE
START-DATE
BNBSET4 COMPANY
PLAN-TYPE
PLAN-CODE
START-DATE
EMPLOYEE
BNBEN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
BNB-COMPANY -> BNC-COMPANY (BNCSET1)
Currency CUCODES Required
BNB-CURRENCY-CODE -> CUC-CURRENCY-CODE
Employee EMPLOYEE Required
BNB-COMPANY -> EMP-COMPANY
BNB-EMPLOYEE -> EMP-EMPLOYEE
Plan PLAN Required
BNB-COMPANY -> PLN-COMPANY
BNB-PLAN-TYPE -> PLN-PLAN-TYPE
BNB-PLAN-CODE -> PLN-PLAN-CODE
BNBEN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Depben DEPBEN Delete Restricted
BNB-COMPANY -> DEP-COMPANY
BNB-EMPLOYEE -> DEP-EMPLOYEE
BNB-PLAN-TYPE -> DEP-PLAN-TYPE
BNB-PLAN-CODE -> DEP-PLAN-CODE
BNB-START-DATE -> DEP-EMP-START
DEP-DEPENDENT
DEP-START-DATE
|
