Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             HRDEPBEN FILE

                           Dependent Benefits

Contains information regarding dependent's benefits.

REFERENCED BY

BN331     HR170     HR513     HR70.1    PA218     BN17.1
BN17.3    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
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
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
Dependent Number     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.2
                                                                 HR13.3  HR13.4

HDB-PLAN-TYPE        Alpha 2                                     BN100   BN101
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
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
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
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.2
                                                                 HR13.3  HR13.4

HDB-STOP-DATE        Numeric 8  (yyyymmdd)                       BN100   BN101
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.2
                                                                 HR13.3  HR13.4

HDB-CREATION-DATE    Numeric 8  (yyyymmdd)                       BN100   BN101
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.2
                                                                 HR13.3  HR13.4

HDB-UPD-DATE         Numeric 8  (yyyymmdd)                       BN100   BN101
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
User ID Name         Contains the user ID of the person who      BN102   BN103
                     last changed this record.                   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
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   BN531
          START-DATE                                             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   BN150
          PLAN-CODE                                              BN245   BN31.1
          EMP-START                                              BN31.2  BN32.1
          DEPENDENT                                              BN32.2  BN32.3
          START-DATE                                             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