Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HRDEPBEN


                             HRDEPBEN FILE

                           Dependent Benefits

Contains information regarding dependent's benefits.

REFERENCED BY

BN331     BN53.1    HR170     HR513     HR70.1    PA218
BN17.1    BN17.3    BN106     BN150     BN245     BN321

UPDATED BY

BN100     BN101     BN102     BN103     BN105     BN31.1
BN31.2    BN32.1    BN32.2    BN32.3    BN430     BN531
BN532     BN71.1    BN72.1    BS32.1    HR13.2    HR13.3
HR13.4    HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HDB-COMPANY            Numeric 4                                 BN100   BN101
Element: Company       The company number represents an          BN102   BN103
                       established company and is entered on     BN105   BN31.1
                       all function codes.                       BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN531   BN532
                                                                 BN71.1  BN72.1
                                                                 BS32.1  HR13.2
                                                                 HR13.3  HR13.4

HDB-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    BN531   BN532
                       person.                                   BN71.1  BN72.1
                                                                 BS32.1  HR13.2
                                                                 HR13.3  HR13.4

HDB-DEPENDENT          Numeric 4                                 BN100   BN101
Element: Dependent NumbContains the dependent's number. When     BN102   BN103
                       you define a dependent, you assign a      BN105   BN31.1
                       number to the dependent that is unique    BN31.2  BN32.1
                       by employee.                              BN32.2  BN32.3
                                                                 BN531   BN532
                                                                 BN71.1  BN72.1
                                                                 BS32.1  HR13.2
                                                                 HR13.3  HR13.4

HDB-PLAN-TYPE          Alpha 2                                   BN100   BN101
Element: Type          Contains the benefit type.                BN102   BN103
                       HL = Health                               BN105   BN31.1
                       DN = Dental                               BN31.2  BN32.1
                       DL = Dependent Life                       BN32.2  BN32.3
                       EL = Employee Life                        BN531   BN532
                                                                 BN71.1  BN72.1
                                                                 BS32.1  HR13.2
                                                                 HR13.3  HR13.4

HDB-PLAN-CODE          Alpha 4                                   BN100   BN101
Element: Plan          Contains the benefit's plan code.         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

HDB-EMP-START          Numeric 8  (yyyymmdd)                     BN100   BN101
Element: Emp Start     Contains the start date of the            BN102   BN103
                       employee's benefit.                       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

HDB-START-DATE         Numeric 8  (yyyymmdd)                     BN100   BN101
Element: Date          Contains the start date of the            BN102   BN103
                       dependent's coverage.                     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

HDB-STOP-DATE          Numeric 8  (yyyymmdd)                     BN100   BN101
Element: Date          Contains the stop date of the             BN102   BN103
                       dependent's coverage.                     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

HDB-CREATION-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

HDB-UPD-DATE           Numeric 8  (yyyymmdd)                     BN100   BN101
Element: Upd 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

HDB-USER-ID            Alpha 10  (Lower Case)                    BN100   BN101
Element: User                                                    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

HDB-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   BN31.1
                       changed.                                  BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN531   BN532
                                                                 BN71.1  BN72.1
                                                                 BS32.1  HR13.2
                                                                 HR13.3  HR13.4

                         HRDEPBEN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HDBSET1   COMPANY                                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          DEPENDENT                                              BN105   BN31.1
          PLAN-TYPE                                              BN31.2  BN32.1
          PLAN-CODE                                              BN32.2  BN32.3
          EMP-START                                              BN331   BN53.1
          START-DATE                                             BN531   BN532
                                                                 BN71.1  BN72.1
                                                                 BS32.1  HR11.1
                                                                 HR13.1  HR13.2
                                                                 HR13.3  HR13.4
                                                                 HR170   HR513
                                                                 HR70.1  PA115
                                                                 PA218

HDBSET2   COMPANY                                                BN17.1  BN17.3
          PLAN-TYPE
          PLAN-CODE
          START-DATE
          EMP-START
          EMPLOYEE
          DEPENDENT

HDBSET3   COMPANY                                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          PLAN-TYPE                                              BN105   BN106
          PLAN-CODE                                              BN150   BN245
          EMP-START                                              BN31.1  BN31.2
          DEPENDENT                                              BN32.1  BN32.2
          START-DATE                                             BN32.3  BN321
                                                                 BN430   BN531
                                                                 BN532   BN71.1
                                                                 BN72.1  BS32.1
                                                                 HR13.2  HR13.3
                                                                 HR13.4

HDBSET4   COMPANY                                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          DEPENDENT                                              BN105   BN31.1
          PLAN-TYPE                                              BN31.2  BN32.1
          PLAN-CODE                                              BN32.2  BN32.3
          EMP-START                                              BN531   BN532
          START-DATE*                                            BN71.1  BN72.1
                                                                 BS32.1  HR13.2
                                                                 HR13.3  HR13.4

                         HRDEPBEN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Benefit        BENEFIT      Required

                            HDB-COMPANY      -> BEN-COMPANY
                            HDB-PLAN-TYPE    -> BEN-PLAN-TYPE
                            HDB-EMPLOYEE     -> BEN-EMPLOYEE
                            HDB-EMP-START    -> BEN-START-DATE
                            HDB-PLAN-CODE    -> BEN-PLAN-CODE

Company        PRSYSTEM     Required

                            HDB-COMPANY      -> PRS-COMPANY
                            Spaces           -> PRS-PROCESS-LEVEL

Dependent      EMDEPEND     Required

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

Employee       EMPLOYEE     Required

                            HDB-COMPANY      -> EMP-COMPANY
                            HDB-EMPLOYEE     -> EMP-EMPLOYEE

Plan           PLAN         Required

                            HDB-COMPANY      -> PLN-COMPANY
                            HDB-PLAN-TYPE    -> PLN-PLAN-TYPE
                            HDB-PLAN-CODE    -> PLN-PLAN-CODE