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     HR70.1    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.1    HR13.2
HR13.3    HR13.4    HR513     PA218     HR11.1    PA115


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HDB-COMPANY            Numeric 4                                 BN100   BN101
Element: Company Hr                                              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

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.1
                                                                 HR13.2  HR13.3
                                                                 HR13.4  HR513
                                                                 PA218

HDB-DEPENDENT          Numeric 4                                 BN100   BN101
Element: Dependent     Contains 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.1
                                                                 HR13.2  HR13.3
                                                                 HR13.4  HR513
                                                                 PA218

HDB-PLAN-TYPE          Alpha 2                                   BN100   BN101
Element: Plan 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.1
                                                                 HR13.2  HR13.3
                                                                 HR13.4  HR513
                                                                 PA218

HDB-PLAN-CODE          Alpha 4                                   BN100   BN101
Element: Plan Code     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.1
                                                                 HR13.2  HR13.3
                                                                 HR13.4  HR513
                                                                 PA218

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.1
                                                                 HR13.2  HR13.3
                                                                 HR13.4  HR513
                                                                 PA218

HDB-START-DATE         Numeric 8  (yyyymmdd)                     BN100   BN101
Element: Start 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.1
                                                                 HR13.2  HR13.3
                                                                 HR13.4  HR513
                                                                 PA218

HDB-STOP-DATE          Numeric 8  (yyyymmdd)                     BN100   BN101
Element: Stop 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.1
                                                                 HR13.2  HR13.3
                                                                 HR13.4  HR513
                                                                 PA218

HDB-CREATION-DATE      Numeric 8  (yyyymmdd)                     BN100   BN101
Element: Creation Date This is the date that this line was       BN102   BN103
                       added to the requisition.                 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

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.1
                                                                 HR13.2  HR13.3
                                                                 HR13.4  HR513
                                                                 PA218

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.1
                                                                 HR13.2  HR13.3
                                                                 HR13.4  HR513
                                                                 PA218

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.1
                                                                 HR13.2  HR13.3
                                                                 HR13.4  HR513
                                                                 PA218

HDB-COVER-TYPE         Alpha 1
Element: Cover Type    E = Employee
                       C = COBRA
                       R = Retiree

                         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                                              HR13.1  HR513
          PLAN-CODE                                              PA218
          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.1  HR13.2
                                                                 HR13.3  HR13.4
                                                                 HR513   PA218

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.1
                                                                 HR13.2  HR13.3
                                                                 HR13.4  HR513
                                                                 PA218

                         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

Paemployee     PAEMPLOYEE   Required

                            HDB-COMPANY      -> PEM-COMPANY
                            HDB-EMPLOYEE     -> PEM-EMPLOYEE

Plan           PLAN         Required

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