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.