|
|
BNBEN FILE
REFERENCED BY
BN305 HR511 PA02.1 PA100 PA102 PA13.1
PA13.2 PA502 PA513 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
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: Plan Type
BNB-PLAN-CODE Alpha 4 BS31.1
Element: Plan Code 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: Mult Salary
BNB-COVER-AMT Signed 11.2 BS31.1
Element: Cover Amt
BNB-PAY-RATE Signed 13.4 BS31.1
Element: Pay Rate
BNB-PCT-AMT-FLAG Alpha 1 BS31.1
Element: Pct Amt Flag
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
Element: Emp Pre Cont
BNB-EMP-AFT-CONT Signed 11.2 BS31.1
Element: Emp Aft Cont
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 Desc
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
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
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
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
BNB-BN-TYPE Alpha 1 BS31.1
Element: Bn Type Load pending employee actions by
specific Benefit Types of 1) New Hire,
2) Open Enrollment, 3) Life Event.
1 = Annual
2 = Life Event
3 = New Hire
BNBEN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNBSET1 COMPANY BN305 BS31.1
EMPLOYEE BS531 HR11.1
PLAN-TYPE HR11.2 HR511
PLAN-CODE PA02.1 PA100
START-DATE PA102 PA115
PA13.1 PA13.2
PA502 PA513
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
|
