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