BNTRANS

UPDATED BY
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 BN430
BN70.1 HR11.1 PA115

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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


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
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 HR11.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA115
PA218


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: Wed Jun 08 20:48:07 2016

Home
Contact Us



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