HRDEPBEN FILE
Dependent Benefits
Contains information regarding dependent's benefits.
REFERENCED BY
BN331 HR170 HR513 HR70.1 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.3 HR13.4
HR13.5
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.3
HR13.4 HR13.5
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.3
HR13.4 HR13.5
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.3
HR13.4 HR13.5
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.3
HR13.4 HR13.5
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.3
HR13.4 HR13.5
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.3
HR13.4 HR13.5
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.3
HR13.4 HR13.5
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.3
HR13.4 HR13.5
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
HR13.1 HR13.3
HR13.4 HR13.5
HR170 HR513
HR70.1
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.3
HR13.4 HR13.5
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.3
HR13.4 HR13.5
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
|