BNTRANS

UPDATED BY
BN100 BN101 BN102 BN103 BN105 BN106
BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN430
BN53.1 BN531 BN532 BN70.1 BN71.1 BN72.1
BS32.1 ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2
ZB32.3 HR11.1 HR13.1 HR13.2 HR13.3 HR13.4
HR513 PA115 PA218

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BNT-COMPANY
Element: Company Hr
Numeric 4
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN53.1 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BNT-PLAN-TYPE
Element: Plan Type
Alpha 2
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN53.1 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BNT-PLAN-CODE
Element: Plan Code
Alpha 4
Contains the user-defined code that represents a benefit plan.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN53.1 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BNT-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.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN53.1 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BNT-PARTICIPNT
Element: Participnt
Numeric 9
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN53.1 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BNT-DEPENDENT
Element: Dependent
Numeric 4
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN53.1 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BNT-START-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN53.1 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BNT-TRAN-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN53.1 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BNT-EMP-START
Element: Start Date
Numeric 8 (yyyymmdd)
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BN532
BN71.1 BN72.1
BS32.1 HR13.1
HR13.2 HR13.3
HR13.4 HR513
PA218 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
BNT-EVENT-CODE
Element: Event Code
Numeric 1

1 = Termination of Employment
2 = Reduction of Work Hours
3 = Medicare
4 = Death
5 = Divorce
6 = Separation
7 = Ineligible Child
8 = Bankruptcy or Retiree
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BN532
BN71.1 BN72.1
BS32.1 HR13.1
HR13.2 HR13.3
HR13.4 HR513
PA218 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
BNT-COVER-TYPE
Element: Cover Type
Alpha 1

E = Employee
R = Retiree
C = COBRA Participant
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN53.1 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BNT-TRAN-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction.
1 = Active
2 = Transmitted
3 = On Hold
BN100 BN101
BN102 BN103
BN105 BN106
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN53.1
BN531 BN532
BN71.1 BN72.1
BS32.1 HR13.1
HR13.2 HR13.3
HR13.4 HR513
PA218 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
BNT-TRAN-ACTION
Element: Action
Alpha 1

A = Add
C = Change
D = Delete
S = Stop
BN100 BN101
BN102 BN103
BN105 BN106
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN53.1
BN531 BN532
BN71.1 BN72.1
BS32.1 HR13.1
HR13.2 HR13.3
HR13.4 HR513
PA218 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
BNT-TRAN-REASON
Element: Reason
Alpha 10
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN53.1 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BNT-MEMBER-ID
Element: Member Id
Numeric 1
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN53.1 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BNT-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN53.1 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BNT-STOP-DATE
Element: Stop Date
Numeric 8 (yyyymmdd)
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN53.1 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BNT-HIPAA-FILE-NBR
Element: Hipaa File Nbr
Alpha 30 (Lower Case)
BN100 BN101
BN102 BN103
BN105 BN106
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BNT-FILE-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BN532
BN71.1 BN72.1
BS32.1 HR13.1
HR13.2 HR13.3
HR13.4 HR513
PA218 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
BNT-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
BN100 BN101
BN102 BN103
BN105 BN106
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BNT-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN100 BN101
BN102 BN103
BN105 BN106
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
BNT-USER-ID
Element: User Id
Alpha 10 (Lower Case)
Contains the user ID of the person who last changed this record.
BN100 BN101
BN102 BN103
BN105 BN106
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3


BNTRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNTSET1 COMPANY
PLAN-TYPE
PLAN-CODE
EMPLOYEE
PARTICIPNT
DEPENDENT
START-DATE
TRAN-SEQ-NBR
BN100 BN101
BN102 BN103
BN105 BN106
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN430
BN53.1 BN531
BN532 BN71.1
BN72.1 BS32.1
ZB10.1 ZB31.1
ZB31.2 ZB32.1
ZB32.2 ZB32.3
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
BNTSET2 COMPANY
EMPLOYEE
PARTICIPNT
DEPENDENT
PLAN-TYPE
PLAN-CODE
EFFECT-DATE
TRAN-SEQ-NBR
...
BN100 BN101
BN102 BN103
BN105 BN106
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BN532 BN70.1
BN71.1 BN72.1
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3 HR11.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA115


BNTRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
BNT-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Dependent EMDEPEND Required
When BNT-DEPENDENT !=Zeroes
BNT-COMPANY->EMD-COMPANY
BNT-EMPLOYEE->EMD-EMPLOYEE
BNT-DEPENDENT->EMD-SEQ-NBR
Employee EMPLOYEE Required
When BNT-EMPLOYEE !=Zeroes
BNT-COMPANY->EMP-COMPANY
BNT-EMPLOYEE->EMP-EMPLOYEE
Participant PARTICIPNT Required
When BNT-PARTICIPNT !=Zeroes
BNT-COMPANY->PAR-COMPANY
BNT-PARTICIPNT->PAR-PARTICIPNT
Plan PLAN Required
BNT-COMPANY->PLN-COMPANY
BNT-PLAN-TYPE->PLN-PLAN-TYPE
BNT-PLAN-CODE->PLN-PLAN-CODE
Reason Code PCODES Required
"BT"->PCO-TYPE
BNT-TRAN-REASON->PCO-CODE


File created: Thu Jun 09 11:10:01 2016

Home
Contact Us



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