BNBEN

UPDATED BY
BN305 BS31.1 BS531 ZB10.3 ZS531 HR11.1
HR11.2 HR28.1 HR511 LT101 ZH510 PA02.1
PA100 PA102 PA115 PA13.1 PA13.2 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PR110
PR113 PR12.6 PR120 PR13.1 PR13.5 PR13.6
PR13.8 PR13.9 PR30.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BNB-COMPANY
Element: Company Hr
Numeric 4
BS31.1 ZS531
BNB-EMPLOYEE
Element: Employee
Numeric 9
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.
BS31.1
BNB-PLAN-TYPE
Element: Plan Type
Alpha 2
BS31.1
BNB-PLAN-CODE
Element: Plan Code
Alpha 4
Contains the user-defined code that represents a benefit plan.
BS31.1
BNB-START-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
BS31.1
BNB-FC
Element: Fc
Alpha 1
BS31.1
BNB-ENROLL-DATE
Element: Enroll Date
Numeric 8 (yyyymmdd)
BNB-COVER-OPT
Element: Cover Opt
Numeric 2
BS31.1
BNB-MULT-SALARY
Element: Mult Salary
Signed 6.3
BS31.1
BNB-COVER-AMT
Element: Cover Amt
Signed 11.2
BS31.1
BNB-PAY-RATE
Element: Pay Rate
Signed 13.4
BS31.1
BNB-PCT-AMT-FLAG
Element: Pct Amt Flag
Alpha 1
BS31.1
BNB-PRE-AFT-FLAG
Element: Pre Aft Flag
Alpha 1
BS31.1
BNB-SMOKER-FLAG
Element: Smoker Flag
Alpha 1
BS31.1
BNB-EMP-PRE-CONT
Element: Emp Pre Cont
Signed 11.2
BS31.1
BNB-EMP-AFT-CONT
Element: Emp Aft Cont
Signed 11.2
BS31.1
BNB-STOP-DATE
Element: Stop Date
Numeric 8 (yyyymmdd)
BS31.1
BNB-PEND-EVIDENCE
Element: Pend Evidence
Alpha 1
BNB-YTD-CONT
Element: Ytd Cont
Signed 13.2
BNB-RCD-TYPE
Element: Rcd Type
Numeric 2
BS31.1
BNB-PLAN-GROUP
Element: Plan Group
Alpha 20
BS31.1
BNB-COP-COV-DESC
Element: Cop Cov Desc
Alpha 15
BS31.1
BNB-DEP-COVER-AMT
Element: Dep Cover Amt
Signed 11.2
BS31.1
BNB-COV-PCT
Element: Cov Pct
Signed 5.2
BS31.1
BNB-FLEX-COST
Element: Flex Cost
Signed 9.2
BS31.1
BNB-EMP-COST
Element: Emp Cost
Signed 9.2
BS31.1
BNB-COMP-COST
Element: Comp Cost
Signed 9.2
BS31.1
BNB-UPDATE-DATE
Element: Update Date
Numeric 8 (yyyymmdd)
This field contains the date the record was updated.
BS31.1
BNB-ALPHADATA1
Element: Alphadata1
Alpha 1
BNB-NUMERIC1
Element: Numeric1
Signed 15.4
BNB-DATE1
Element: Date1
Numeric 8 (yyyymmdd)
BNB-PLAN-DESC
Element: Plan Desc
Alpha 30
BS31.1
BNB-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
BS31.1
BNB-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BS31.1
BNB-CREATION-DATE
Element: Creation Date
Numeric 8 (yyyymmdd)
This is the date that this line was added to the requisition.
BS31.1
BNB-UPD-DATE
Element: Upd Date
Numeric 8 (yyyymmdd)
BS31.1
BNB-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BS31.1
BNB-USER-ID
Element: User
Alpha 10 (Lower Case)
BS31.1
BNB-CREATE-TRANS
Element: Create Trans
Alpha 1

Y = Yes
N = No
BS31.1
BNB-TRAN-REASON
Element: Reason
Alpha 10
BS31.1
BNB-MEMBER-ID
Element: Member Id
Numeric 1
BS31.1
BNB-BN-TYPE
Element: Bn Type
Alpha 1
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
BS31.1
BNB-HOLD-FLAG
Element: Hold Flag
Alpha 1

N = No
Y = Yes


BNBEN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNBSET1 COMPANY
EMPLOYEE
PLAN-TYPE
PLAN-CODE
START-DATE
...
BN305 BS31.1
BS531 ZB10.3
ZS531 HR11.1
HR11.2 HR28.1
HR511 LT101
ZH510 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6


BNBEN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 11:09:52 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.