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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated 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 9Contains 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 4Contains 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 2Contains 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 4Contains 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HDBSET1
  1. COMPANY
  2. EMPLOYEE
  3. DEPENDENT
  4. PLAN-TYPE
  5. PLAN-CODE
  6. EMP-START
  7. START-DATE
PrimaryBN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +22 more (list truncated in source)
HDBSET2
  1. COMPANY
  2. PLAN-TYPE
  3. PLAN-CODE
  4. START-DATE
  5. EMP-START
  6. EMPLOYEE
  7. DEPENDENT
BN17.1, BN17.3, HR13.1, HR513, PA218, ZP567
HDBSET3
  1. COMPANY
  2. EMPLOYEE
  3. PLAN-TYPE
  4. PLAN-CODE
  5. EMP-START
  6. DEPENDENT
  7. START-DATE
BN100, BN101, BN102, BN103, BN105, BN106, BN150, BN245 +22 more (list truncated in source)
HDBSET4
  1. COMPANY
  2. EMPLOYEE
  3. DEPENDENT
  4. PLAN-TYPE
  5. PLAN-CODE
  6. EMP-START
  7. START-DATE ↓
BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +22 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
BENEFITPRSYSTEMEMDEPENDEMPLOYEEPAEMPLOYEEPLANHRDEPBEN

One to one (6) — lookups and parents

RelationTableRulesConditionField map
BenefitBENEFITRequired
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
CompanyPRSYSTEMRequired
HDB-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
DependentEMDEPENDRequired
HDB-COMPANY→EMD-COMPANY
HDB-EMPLOYEE→EMD-EMPLOYEE
HDB-DEPENDENT→EMD-SEQ-NBR
EmployeeEMPLOYEERequired
HDB-COMPANY→EMP-COMPANY
HDB-EMPLOYEE→EMP-EMPLOYEE
PaemployeePAEMPLOYEERequired
HDB-COMPANY→PEM-COMPANY
HDB-EMPLOYEE→PEM-EMPLOYEE
PlanPLANRequired
HDB-COMPANY→PLN-COMPANY
HDB-PLAN-TYPE→PLN-PLAN-TYPE
HDB-PLAN-CODE→PLN-PLAN-CODE

Programs

Updated by (30)

Referenced by (15)