Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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