Lawson Insight Technical Documentation |
|
HRDEPBEN
HRDEPBEN FILE
Dependent Benefits
Contains information regarding dependent's benefits.
REFERENCED BY
BN331 BN53.1 HR170 HR70.1 BN17.1 BN17.3
BN106 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.1 HR13.2
HR13.3 HR13.4 HR513 PA218 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HDB-COMPANY Numeric 4 BN100 BN101
Element: Company Hr 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 Numeric 9 BN100 BN101
Element: 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.1
HR13.2 HR13.3
HR13.4 HR513
PA218
HDB-DEPENDENT Numeric 4 BN100 BN101
Element: Dependent 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.1
HR13.2 HR13.3
HR13.4 HR513
PA218
HDB-PLAN-TYPE Alpha 2 BN100 BN101
Element: Plan 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.1
HR13.2 HR13.3
HR13.4 HR513
PA218
HDB-PLAN-CODE Alpha 4 BN100 BN101
Element: Plan Code 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.1
HR13.2 HR13.3
HR13.4 HR513
PA218
HDB-EMP-START Numeric 8 (yyyymmdd) BN100 BN101
Element: 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.1
HR13.2 HR13.3
HR13.4 HR513
PA218
HDB-START-DATE Numeric 8 (yyyymmdd) BN100 BN101
Element: 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.1
HR13.2 HR13.3
HR13.4 HR513
PA218
HDB-STOP-DATE Numeric 8 (yyyymmdd) BN100 BN101
Element: 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.1
HR13.2 HR13.3
HR13.4 HR513
PA218
HDB-CREATION-DATE Numeric 8 (yyyymmdd) BN100 BN101
Element: Creation Date This is the date that this line was BN102 BN103
added to the requisition. 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 Numeric 8 (yyyymmdd) BN100 BN101
Element: Upd Date 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 Alpha 10 (Lower Case) BN100 BN101
Element: User 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 Numeric 6 (hhmmss) BN100 BN101
Element: Time Stamp Contains the server time (hour, minute, BN102 BN103
and second) when the record was last BN105 BN31.1
changed. 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 Alpha 1
Element: Cover Type E = Employee
C = COBRA
R = Retiree
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 BN53.1
START-DATE BN531 BN532
BN71.1 BN72.1
BS32.1 HR11.1
HR13.1 HR13.2
HR13.3 HR13.4
HR170 HR513
HR70.1 PA115
PA218
HDBSET2 COMPANY BN17.1 BN17.3
PLAN-TYPE HR13.1 HR513
PLAN-CODE PA218
START-DATE
EMP-START
EMPLOYEE
DEPENDENT
HDBSET3 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
PLAN-TYPE BN105 BN106
PLAN-CODE BN150 BN245
EMP-START BN31.1 BN31.2
DEPENDENT BN32.1 BN32.2
START-DATE BN32.3 BN321
BN430 BN531
BN532 BN71.1
BN72.1 BS32.1
HR13.1 HR13.2
HR13.3 HR13.4
HR513 PA218
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.1
HR13.2 HR13.3
HR13.4 HR513
PA218
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
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
|