HRDEPBEN

Dependent Benefits

Contains information regarding dependent's benefits.
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.1 HR13.2
HR13.3 HR13.4 HR513 PA218 BN331 BN53.1
XB510 HR11.1 HR170 HR70.1 PA115 BN17.1
BN17.3 BN29.2 BN29.3 BN106 BN150 BN245
BN321 BN95.3 BN990 BN991 BS10.1 XB500
XB520

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
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
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
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
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
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
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
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
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
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
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
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
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 XB510
HR11.1 HR13.1
HR13.2 HR13.3
HR13.4 HR170
HR513 HR70.1
PA115 PA218
HDBSET2 COMPANY
PLAN-TYPE
PLAN-CODE
START-DATE
EMP-START
EMPLOYEE
DEPENDENT
BN17.1 BN17.3
BN29.2 HR13.1
HR513 PA218
HDBSET3 COMPANY
EMPLOYEE
PLAN-TYPE
PLAN-CODE
EMP-START
DEPENDENT
START-DATE
...
BN100 BN101
BN102 BN103
BN105 BN106
BN150 BN245
BN29.3 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN321 BN430
BN531 BN532
BN71.1 BN72.1
BN95.3 BN990
BN991 BS10.1
BS32.1 XB500
XB510 XB520
HR13.1 HR13.2
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 HR13.1
HR13.2 HR13.3
HR13.4 HR513
PA218


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: Wed Jun 08 20:49:07 2016

Home
Contact Us



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