HRDEPBEN

Dependent Benefits

Contains information regarding dependent's benefits.
UPDATED BY
BN100 BN101 BN102 BN103 BN105 BN106
BN150 BN17.1 BN17.3 BN245 BN31.1 BN31.2
BN32.1 BN32.2 BN32.3 BN321 BN331 BN430
BN53.1 BN531 BN532 BN71.1 BN72.1 BS10.1
BS32.1 ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2
ZB32.3 HR11.1 HR13.1 HR13.2 HR13.3 HR13.4
HR170 HR513 HR70.1 ZH230 PA115 PA218
ZP560 ZP562 ZP567

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HDB-COMPANY
Element: Company Hr		Numeric 4
BN100 BN101
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 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
HDB-EMPLOYEE
Element: 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
BN32.2 BN32.3
BN531 BN532
BN71.1 BN72.1
BS32.1 HR13.1
HR13.2 HR13.3
HR13.4 HR513
PA218 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
HDB-DEPENDENT
Element: 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
BN32.2 BN32.3
BN531 BN532
BN71.1 BN72.1
BS32.1 HR13.1
HR13.2 HR13.3
HR13.4 HR513
PA218 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
HDB-PLAN-TYPE
Element: 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
BN32.2 BN32.3
BN531 BN532
BN71.1 BN72.1
BS32.1 HR13.1
HR13.2 HR13.3
HR13.4 HR513
PA218 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
HDB-PLAN-CODE
Element: Plan Code		Alpha 4
Contains the benefit's plan code.
BN100 BN101
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 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
HDB-EMP-START
Element: 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
BN32.2 BN32.3
BN531 BN532
BN71.1 BN72.1
BS32.1 HR13.1
HR13.2 HR13.3
HR13.4 HR513
PA218 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
HDB-START-DATE
Element: 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
BN32.2 BN32.3
BN531 BN532
BN71.1 BN72.1
BS32.1 HR13.1
HR13.2 HR13.3
HR13.4 HR513
PA218 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
HDB-STOP-DATE
Element: 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
BN32.2 BN32.3
BN531 BN532
BN71.1 BN72.1
BS32.1 HR13.1
HR13.2 HR13.3
HR13.4 HR513
PA218 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3 ZP567
HDB-CREATION-DATE
Element: 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
BN32.2 BN32.3
BN531 BN532
BN71.1 BN72.1
BS32.1 HR13.1
HR13.2 HR13.3
HR13.4 HR513
PA218 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
HDB-UPD-DATE
Element: Upd Date		Numeric 8 (yyyymmdd)
BN100 BN101
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 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
HDB-USER-ID
Element: User		Alpha 10 (Lower Case)
BN100 BN101
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 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
HDB-TIME-STAMP
Element: 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
BN32.2 BN32.3
BN531 BN532
BN71.1 BN72.1
BS32.1 HR13.1
HR13.2 HR13.3
HR13.4 HR513
PA218 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3
HDB-COVER-TYPE
Element: Cover Type		Alpha 1

E = Employee
C = COBRA
R = Retiree


HRDEPBEN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HDBSET1 COMPANY
EMPLOYEE
DEPENDENT
PLAN-TYPE
PLAN-CODE
EMP-START
START-DATE
...
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN331 BN53.1
BN531 BN532
BN71.1 BN72.1
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3 HR11.1
HR13.1 HR13.2
HR13.3 HR13.4
HR170 HR513
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
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN321
BN430 BN531
BN532 BN71.1
BN72.1 BS10.1
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3 HR13.1
HR13.2 HR13.3
HDBSET4 COMPANY
EMPLOYEE
DEPENDENT
PLAN-TYPE
PLAN-CODE
EMP-START
START-DATE*
BN100 BN101
BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BN532
BN71.1 BN72.1
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3 HR13.1
HR13.2 HR13.3
HR13.4 HR513
ZH230 PA218
ZP560 ZP562


HRDEPBEN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 11:14:52 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.