|
|
BNBEN FILE
REFERENCED BY
HR511 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 Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
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: Start 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 6.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 11.2 BS31.1
Employee Pre Tax
Contribution
BNB-EMP-AFT-CONT Signed 11.2 BS31.1
Employee After Tax
Contrib
BNB-STOP-DATE Numeric 8 (yyyymmdd) BS31.1
Element: Stop 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: Update Date This field contains the date the record
was updated.
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 Represents the number of decimals
Code defined for the currency of the object.
BNB-CREATION-DATE Numeric 8 (yyyymmdd) BS31.1
Element: Creation Date This is the date that this line was
added to the requisition.
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 Contains the user ID of the person who
last changed this record.
BNB-CREATE-TRANS Alpha 1 BS31.1
Element: Create Trans Y = Yes
N = No
BNB-TRAN-REASON Alpha 10 BS31.1
Element: Reason
BNB-MEMBER-ID Numeric 1 BS31.1
Element: Member Id
BNBEN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNBSET1 COMPANY BS31.1 BS531
EMPLOYEE HR11.1 HR11.2
PLAN-TYPE HR511 PA02.1
PLAN-CODE PA100 PA102
START-DATE PA115 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
BNBEN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
BNB-COMPANY -> BNC-COMPANY
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
Reason Code PCODES Required
When BNB-TRAN-REASON != Spaces
"BT" -> PCO-TYPE
BNB-TRAN-REASON -> PCO-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
|
