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.2
HR13.3 HR13.4 BN430 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BNT-COMPANY Numeric 4 BN100 BN101
Element: Company Hr Identifies the AP company if the BN102 BN103
resource type = V. Identifies the HR BN105 BN31.1
company if the resource type = E. It is BN31.2 BN32.1
blank for type A, P or Q resources. BN32.2 BN32.3
BN53.1 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.2 HR13.3
HR13.4
BNT-PLAN-TYPE Alpha 2 BN100 BN101
Element: 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.2 HR13.3
HR13.4
BNT-PLAN-CODE Alpha 4 BN100 BN101
Element: Plan 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.2 HR13.3
HR13.4
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.2 HR13.3
HR13.4
BNT-PARTICIPNT Numeric 9 BN100 BN101
Element: Participant Number BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN53.1 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.2 HR13.3
HR13.4
BNT-DEPENDENT Numeric 4 BN100 BN101
Element: Dependent Number BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN53.1 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.2 HR13.3
HR13.4
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.2 HR13.3
HR13.4
BNT-TRAN-SEQ-NBR Numeric 4 BN100 BN101
Element: Sequence Number BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN53.1 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.2 HR13.3
HR13.4
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.2
HR13.3 HR13.4
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.2
8 = Bankruptcy or Retiree HR13.3 HR13.4
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.2 HR13.3
HR13.4
BNT-TRAN-STATUS Numeric 1 BN100 BN101
Element: Status 1 = Active BN102 BN103
2 = Transmitted BN105 BN106
3 = On Hold BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN53.1
BN531 BN532
BN71.1 BN72.1
BS32.1 HR13.2
HR13.3 HR13.4
BNT-TRAN-ACTION Alpha 1 BN100 BN101
Element: Action A = Add BN102 BN103
C = Change BN105 BN31.1
D = Delete BN31.2 BN32.1
S = Stop BN32.2 BN32.3
BN53.1 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.2 HR13.3
HR13.4
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.2 HR13.3
HR13.4
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.2 HR13.3
HR13.4
BNT-EFFECT-DATE Numeric 8 (yyyymmdd) BN100 BN101
Element: Effective 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.2 HR13.3
HR13.4
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.2 HR13.3
HR13.4
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.2 HR13.3
HR13.4
BNT-FILE-DATE Numeric 8 (yyyymmdd) BN100 BN101
Element: Date BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BN532
BN71.1 BN72.1
BS32.1 HR13.2
HR13.3 HR13.4
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.2 HR13.3
HR13.4
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.2 HR13.3
HR13.4
BNT-USER-ID Alpha 10 (Lower Case) BN100 BN101
Element: User ID Name 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.2 HR13.3
HR13.4
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.2 HR13.3
HR13.4
BNTSET2 COMPANY BN70.1 HR11.1
EMPLOYEE HR13.1 PA115
PARTICIPNT
DEPENDENT
PLAN-TYPE
PLAN-CODE
EFFECT-DATE
TRAN-SEQ-NBR
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
|