Lawson Insight Technical Documentation |
|
HRDEPBEN
HRDEPBEN FILE
Dependent Benefits
Contains information regarding dependent's benefits.
REFERENCED BY
BN331 BN53.1 HR170 HR513 HR70.1 PA218
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.2 HR13.3
HR13.4 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HDB-COMPANY Numeric 4 BN100 BN101
Element: Company Hr Identifies the AP company if the BN102 BN103
resource type = V. Identifies the HR BN105 BN31.1
company if the resource type = E. It is BN31.2 BN32.1
blank for type A, P or Q resources. BN32.2 BN32.3
BN531 BN532
BN71.1 BN72.1
BS32.1 HR13.2
HR13.3 HR13.4
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.2
HR13.3 HR13.4
HDB-DEPENDENT Numeric 4 BN100 BN101
Element: Dependent NumbContains 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.2
HR13.3 HR13.4
HDB-PLAN-TYPE Alpha 2 BN100 BN101
Element: 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.2
HR13.3 HR13.4
HDB-PLAN-CODE Alpha 4 BN100 BN101
Element: 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.2
HR13.3 HR13.4
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.2
HR13.3 HR13.4
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.2
HR13.3 HR13.4
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.2
HR13.3 HR13.4
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.2
HR13.3 HR13.4
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.2
HR13.3 HR13.4
HDB-USER-ID Alpha 10 (Lower Case) BN100 BN101
Element: User Contains the user ID of the person who BN102 BN103
last changed this record. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BN532
BN71.1 BN72.1
BS32.1 HR13.2
HR13.3 HR13.4
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.2
HR13.3 HR13.4
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
PLAN-CODE
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.2 HR13.3
HR13.4
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.2
HR13.3 HR13.4
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
|