BNBEN FILE
REFERENCED BY
HR511 HR650 PA502 PR13.1 PR13.5 PR13.6
PR13.8
UPDATED BY
BS31.1 BS531
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BNB-COMPANY Numeric 4 BS31.1
Company The company number represents an
established company and is entered on
all function codes.
BNB-EMPLOYEE Numeric 9 BS31.1
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
Type
BNB-PLAN-CODE Alpha 4 BS31.1
Plan Contains the user-defined code that
represents a benefit plan.
BNB-START-DATE Numeric 8 (yyyymmdd) BS31.1
Start Date
BNB-FC Alpha 1 BS31.1
Fc
BNB-ENROLL-DATE Numeric 8 (yyyymmdd)
Enroll Date
BNB-COVER-OPT Numeric 2 BS31.1
Cover Opt
BNB-MULT-SALARY Signed 5.3 BS31.1
Multiple of Salary
BNB-COVER-AMT Signed 11.2 BS31.1
Flat Amount
BNB-PAY-RATE Signed 13.4 BS31.1
Rate of Pay
BNB-PCT-AMT-FLAG Alpha 1 BS31.1
Percent or Amount
Indicator
BNB-PRE-AFT-FLAG Alpha 1 BS31.1
Pre Aft Flag
BNB-SMOKER-FLAG Alpha 1 BS31.1
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
Stop Date
BNB-PEND-EVIDENCE Alpha 1
Pend Evidence
BNB-YTD-CONT Signed 13.2
Ytd Cont
BNB-RCD-TYPE Numeric 2 BS31.1
Rcd Type
BNB-PLAN-GROUP Alpha 20 BS31.1
Plan Group
BNB-COP-COV-DESC Alpha 15 BS31.1
Cop Cov Desc
BNB-DEP-COVER-AMT Signed 11.2 BS31.1
Dep Cover Amt
BNB-COV-PCT Signed 5.2 BS31.1
Cov Pct
BNB-FLEX-COST Signed 9.2 BS31.1
Flex Cost
BNB-EMP-COST Signed 9.2 BS31.1
Emp Cost
BNB-COMP-COST Signed 9.2 BS31.1
Comp Cost
BNB-UPDATE-DATE Numeric 8 (yyyymmdd) BS31.1
Update Date This field contains the date the record
was updated.
BNB-ALPHADATA1 Alpha 1
Alphadata1
BNB-NUMERIC1 Signed 15.4
Numeric1
BNB-DATE1 Numeric 8 (yyyymmdd)
Date1
BNB-PLAN-DESC Alpha 30 BS31.1
Plan Description
BNB-CURRENCY-CODE Alpha 5 BS31.1
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
BNB-CURR-ND Numeric 1 BS31.1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
BNB-CREATION-DATE Numeric 8 (yyyymmdd) BS31.1
Creation Date This is the date that this line was
added to the requisition.
BNB-UPD-DATE Numeric 8 (yyyymmdd) BS31.1
Upd Date
BNB-TIME-STAMP Numeric 6 (hhmmss) BS31.1
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
User ID Name Contains the user ID of the person who
last changed this record.
BNBEN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNBSET1 COMPANY BS31.1 BS531
EMPLOYEE HR511 HR650
PLAN-TYPE PA502 PR13.1
PLAN-CODE PR13.5 PR13.6
START-DATE 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
|
