Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

DEPBEN


                              DEPBEN FILE

UPDATED BY

BS30.1    BS31.1    BS531     HR11.1    HR13.1    HR513
PA115     PA218

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DEP-COMPANY            Numeric 4                                 BS30.1
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

DEP-EMPLOYEE           Numeric 9                                 BS30.1
Element: Employee      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.

DEP-DEPENDENT          Numeric 4                                 BS30.1
Element: Dependent Number

DEP-PLAN-TYPE          Alpha 2                                   BS30.1
Element: Type

DEP-PLAN-CODE          Alpha 4                                   BS30.1
Element: Plan          Contains the user-defined code that
                       represents a benefit plan.

DEP-EMP-START          Numeric 8  (yyyymmdd)                     BS30.1
Element: Emp Start

DEP-START-DATE         Numeric 8  (yyyymmdd)                     BS30.1
Element: Start Date

DEP-STOP-DATE          Numeric 8  (yyyymmdd)                     BS30.1
Element: Stop Date

DEP-FC                 Alpha 1                                   BS30.1
Element: Fc

DEP-DATE-STAMP         Numeric 8  (yyyymmdd)
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

DEP-TIME-STAMP         Numeric 6  (hhmmss)
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

DEP-USER-ID            Alpha 10  (Lower Case)
Element: User          Contains the user ID of the person who
                       last changed this record.

DEP-CREATE-TRANS       Alpha 1                                   BS30.1
Element: Create Trans  Y = Yes
                       N = No

DEP-TRAN-REASON        Alpha 10                                  BS30.1
Element: Reason

DEP-MEMBER-ID          Numeric 1                                 BS30.1
Element: Member Id

                         DEPBEN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DEPSET1   COMPANY                                                BS30.1  BS31.1
          EMPLOYEE                                               BS531   HR11.1
          DEPENDENT                                              HR13.1  HR513
          PLAN-TYPE                                              PA115   PA218
          PLAN-CODE
          EMP-START
          START-DATE

DEPSET3   COMPANY                                                BS531
          EMPLOYEE
          PLAN-TYPE
          PLAN-CODE
          EMP-START
          DEPENDENT
          START-DATE

                         DEPBEN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bnben          BNBEN        Required

                            DEP-COMPANY        -> BNB-COMPANY
                            DEP-EMPLOYEE       -> BNB-EMPLOYEE
                            DEP-PLAN-TYPE      -> BNB-PLAN-TYPE
                            DEP-PLAN-CODE      -> BNB-PLAN-CODE
                            DEP-EMP-START      -> BNB-START-DATE

Company        PRSYSTEM     Required

                            DEP-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Dependent      EMDEPEND     Required

                            DEP-COMPANY        -> EMD-COMPANY
                            DEP-EMPLOYEE       -> EMD-EMPLOYEE
                            DEP-DEPENDENT      -> EMD-SEQ-NBR

Employee       EMPLOYEE     Required

                            DEP-COMPANY        -> EMP-COMPANY
                            DEP-EMPLOYEE       -> EMP-EMPLOYEE

Plan           PLAN         Required

                            DEP-COMPANY        -> PLN-COMPANY
                            DEP-PLAN-TYPE      -> PLN-PLAN-TYPE
                            DEP-PLAN-CODE      -> PLN-PLAN-CODE

Reason Code    PCODES       Required
                            When DEP-TRAN-REASON != Spaces

                            "BT"               -> PCO-TYPE
                            DEP-TRAN-REASON    -> PCO-CODE