HRDEPBEN – Dependent Benefits

System: Human Resources (HR)
Prefix: HDB
Primary key: COMPANY, EMPLOYEE, DEPENDENT, PLAN-TYPE, PLAN-CODE, EMP-START, START-DATE
Fields: 16
Updated by: 30 programs
Referenced by: 15 programs

HRDEPBEN is the Dependent Benefits table in Lawson Human Resources (prefix HDB). It is indexed by COMPANY, EMPLOYEE, DEPENDENT, PLAN-TYPE, PLAN-CODE, EMP-START, START-DATE (HDBSET1); alternate indexes: HDBSET2, HDBSET3 and HDBSET4. It is related 1:1 to BENEFIT, PRSYSTEM, EMDEPEND, EMPLOYEE, PAEMPLOYEE and PLAN. It is updated by BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 and 22 more and referenced by BN106, BN150, BN17.1, BN17.3, BN245, BN321, BN331, BN53.1 and 7 more. The table has 16 fields, 4 indexes and 6 documented relations.

About HRDEPBEN

Contains information regarding dependent's benefits.

Fields (16)

Column = COBOL field name without the HDB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`HDB-COMPANY` PK COMPANY	Numeric 4	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +19 more
`HDB-EMPLOYEE` PK EMPLOYEE	Numeric 9	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.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +19 more
`HDB-DEPENDENT` PK DEPENDENT	Numeric 4	Contains the dependent's number. When you define a dependent, you assign a number to the dependent that is unique by employee.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +19 more
`HDB-PLAN-TYPE` PK PLAN_TYPE	Alpha 2	Contains the benefit type. `HL` Health `DN` Dental `DL` Dependent Life `EL` Employee Life	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +19 more
`HDB-PLAN-CODE` PK PLAN_CODE	Alpha 4	Contains the benefit's plan code.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +19 more
`HDB-EMP-START` PK EMP_START	Numeric 8 (yyyymmdd)	Contains the start date of the employee's benefit.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +19 more
`HDB-START-DATE` PK START_DATE	Numeric 8 (yyyymmdd)	Contains the start date of the dependent's coverage.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +19 more
`HDB-STOP-DATE` STOP_DATE	Numeric 8 (yyyymmdd)	Contains the stop date of the dependent's coverage.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +20 more
`HDB-CREATION-DATE` CREATION_DATE	Numeric 8 (yyyymmdd)	This is the date that this line was added to the requisition.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +19 more
`HDB-UPD-DATE` UPD_DATE	Numeric 8 (yyyymmdd)	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +19 more
`HDB-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +19 more
`HDB-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +19 more
`HDB-COVER-TYPE` COVER_TYPE	Alpha 1	— `E` Employee `C` COBRA `R` Retiree	—
`HDB-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +19 more
`HDB-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +19 more
`HDB-PARTICIPNT` PARTICIPNT	Numeric 9	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +19 more

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`HDBSET1`	`COMPANY`, `EMPLOYEE`, `DEPENDENT`, `PLAN-TYPE`, `PLAN-CODE`, `EMP-START`, `START-DATE`	Primary	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +22 more (list truncated in source)
`HDBSET2`	`COMPANY`, `PLAN-TYPE`, `PLAN-CODE`, `START-DATE`, `EMP-START`, `EMPLOYEE`, `DEPENDENT`		BN17.1, BN17.3, HR13.1, HR513, PA218, ZP567
`HDBSET3`	`COMPANY`, `EMPLOYEE`, `PLAN-TYPE`, `PLAN-CODE`, `EMP-START`, `DEPENDENT`, `START-DATE`		BN100, BN101, BN102, BN103, BN105, BN106, BN150, BN245 +22 more (list truncated in source)
`HDBSET4`	`COMPANY`, `EMPLOYEE`, `DEPENDENT`, `PLAN-TYPE`, `PLAN-CODE`, `EMP-START`, `START-DATE*`		BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +22 more

Relations

One to one (6) — lookups and parents

Relation	Table	Rules	Field map
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`

Programs

Updated by (30)

BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN105 Plan Update
BN31.1 Speed Benefit Entry
BN31.2 Employee Benefit Entry
BN32.1 Employee Benefit Changes
BN32.2 Employee Benefit Detail Changes
BN32.3 Benefit Add
BN430 Benefit Purge
BN531 Batch Benefit Enrollment
BN532 Batch Dependent Benefit Enrollment
BN71.1 COBRA Benefit Entry
BN72.1 Retiree Benefit Entry
BS32.1 Web Enrollment Stop Benefits Update
HR11.1 Employee
HR13.1 Dependent
HR13.2 Dependent Benefits
HR13.3 Dependent Benefits
HR13.4 Dependent Benefits
HR513 Dependent Conversion
PA115 Employee Purge
PA218 Travel Listing
ZB10.1 Coverage Options Calculator
ZB31.1 Speed Benefit Entry
ZB31.2 Employee Benefit Entry
ZB32.1 Employee Benefit Changes
ZB32.2 Employee Benefit Detail Changes
ZB32.3 Benefit Add

Referenced by (15)

BN106 Benefit Transaction Export
BN150 Life Insurance Reportable Income
BN17.1 Coverage Options by Plan
BN17.3 Coverage Amounts
BN245 Benefit Election Form
BN321 Dependent Benefit Listing
BN331 HIPAA Certification Report
BN53.1 Benefit Transactions
BS10.1 Web Enrollment Current Benefit Inquiry
HR170 Human Resource Writer Report Request
HR70.1 Human Resource Writer Inquiry
ZH230 PPH Big Bad Edit
ZP560 PPH Medical-Dental Interfaces
ZP562 Sharp Medical Export Interface
ZP567 Vision Enrollment