Lawson Insight Technical Documentation |
|
BNTRANS
BNTRANS FILE
REFERENCED BY
BN70.1
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
HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BNT-COMPANY Numeric 4 BN100 BN101
Element: Company Hr 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 Alpha 2 BN100 BN101
Element: Plan Type 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 Alpha 4 BN100 BN101
Element: Plan Code Contains the user-defined code that BN102 BN103
represents a benefit plan. 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 Numeric 9 BN100 BN101
Element: Employee Contains the employee number. Each BN102 BN103
person employed by the company is BN105 BN31.1
assigned a unique number. The system BN31.2 BN32.1
uses the employee number to correlate BN32.2 BN32.3
all of the information related to that BN53.1 BN531
person. BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
BNT-PARTICIPNT Numeric 9 BN100 BN101
Element: Participnt 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 Numeric 4 BN100 BN101
Element: Dependent 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 Numeric 8 (yyyymmdd) BN100 BN101
Element: Start Date 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 Numeric 4 BN100 BN101
Element: Seq Nbr An automatically assigned sequence BN102 BN103
number. 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 Numeric 8 (yyyymmdd) BN100 BN101
Element: Start Date 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 Numeric 1 BN100 BN101
Element: Event Code 1 = Termination of Employment BN102 BN103
2 = Reduction of Work Hours BN105 BN31.1
3 = Medicare BN31.2 BN32.1
4 = Death BN32.2 BN32.3
5 = Divorce BN531 BN532
6 = Separation BN71.1 BN72.1
7 = Ineligible Child BS32.1 HR13.1
8 = Bankruptcy or Retiree HR13.2 HR13.3
HR13.4 HR513
PA218
BNT-COVER-TYPE Alpha 1 BN100 BN101
Element: Cover Type E = Employee BN102 BN103
R = Retiree BN105 BN31.1
C = COBRA Participant 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 Numeric 1 BN100 BN101
Element: Status This field displays the status of the BN102 BN103
transaction. BN105 BN106
1 = Active BN31.1 BN31.2
2 = Transmitted BN32.1 BN32.2
3 = On Hold 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 Alpha 1 BN100 BN101
Element: Action A = Add BN102 BN103
C = Change BN105 BN106
D = Delete BN31.1 BN31.2
S = Stop 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 Alpha 10 BN100 BN101
Element: Reason 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 Numeric 1 BN100 BN101
Element: Member Id 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 Numeric 8 (yyyymmdd) BN100 BN101
Element: Effect Date 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 Numeric 8 (yyyymmdd) BN100 BN101
Element: Stop Date 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 Alpha 30 (Lower Case) BN100 BN101
Element: Hipaa File Nbr 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 Numeric 8 (yyyymmdd) BN100 BN101
Element: Date This field displays the system date BN102 BN103
when this was created. 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 Numeric 8 (yyyymmdd) BN100 BN101
Element: Date Stamp This field contains the server date BN102 BN103
(month, date, and year) of the last BN105 BN106
change to this record. 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 Numeric 6 (hhmmss) BN100 BN101
Element: Time Stamp Contains the server time (hour, minute, BN102 BN103
and second) when the record was last BN105 BN106
changed. 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 Alpha 10 (Lower Case) BN100 BN101
Element: User Id Contains the user ID of the person who BN102 BN103
last changed this record. 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 BN100 BN101
PLAN-TYPE BN102 BN103
PLAN-CODE BN105 BN106
EMPLOYEE BN31.1 BN31.2
PARTICIPNT BN32.1 BN32.2
DEPENDENT BN32.3 BN430
START-DATE BN53.1 BN531
TRAN-SEQ-NBR BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
BNTSET2 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
PARTICIPNT BN105 BN106
DEPENDENT BN31.1 BN31.2
PLAN-TYPE BN32.1 BN32.2
PLAN-CODE BN32.3 BN531
EFFECT-DATE BN532 BN70.1
TRAN-SEQ-NBR 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 RELATED
NAME 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
|