EMDEPEND FILE
Employee Dependent
Contains information regarding the dependents of employees.
REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN140
BN145 BN150 BN245 BN248 BN285 BN31.1
BN31.2 BN32.1 BN32.2 BN32.3 BN321 BN331
BN45.1 BN48.1 BN531 BN532 BN65.1 BN70.1
BN71.1 BN72.1 BN85.1 BS13.1 BS14.1 BS15.1
BS30.1 BS32.1 HEMD.1 HR170 HR213 HR30.1
HR511 HR650 HR70.1 HR90.1 PA18.1 PA311
PA502 PR13.1 PR13.5 PR13.6 PR13.8
UPDATED BY
HR13.1 HR513 HR701 PA218
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EMD-COMPANY Numeric 4 HR13.1 HR513
Company Contains the number that represents an PA218
established company and is entered on
all functions.
EMD-EMPLOYEE Numeric 9 HR13.1 HR513
Employee Contains the employee who has the PA218
dependents.
EMD-SEQ-NBR Numeric 4 HR13.1 HR513
Dependent Contains the dependent number. The PA218
dependent number is used as a key when
accessing dependent data.
EMD-REL-CODE Alpha 10 HR13.1 HR513
Relation Contains the relationship code that PA218
explains the relationship between the
employee and dependent.
EMD-LAST-NAME Alpha 30 (Lower Case) HR13.1 HR513
Last Name Contains the dependent's last name. PA218
EMD-FIRST-NAME Alpha 15 (Lower Case) HR13.1 HR513
First Name Contains the dependent's first name. PA218
EMD-MIDDLE-INIT Alpha 1 HR13.1 HR513
Middle Initial Contains the dependent's middle initial. PA218
EMD-EMP-ADDRESS Alpha 1 HR13.1 HR513
Employee Address Indicates if the system uses the PA218
employee's home or supplemental address
for the dependent, or neither.
H = Home Address
S = Supplemental Address
N = No
EMD-ADDR1 Alpha 30 (Lower Case) HR13.1 HR513
Address 1 Contains the first line of the PA218
dependent's address.
EMD-ADDR2 Alpha 30 (Lower Case) HR13.1 HR513
Address 2 Contains the second line of the PA218
dependent's address.
EMD-ADDR3 Alpha 30 (Lower Case) HR13.1 HR513
Address 3 This field contains the third line of PA218
address information.
EMD-ADDR4 Alpha 30 (Lower Case) HR13.1 HR513
Address 4 This field contains the fourth line of PA218
address information.
EMD-CITY Alpha 18 (Lower Case) HR13.1 HR513
City Contains the city of the dependent's PA218
address.
EMD-STATE Alpha 2 HR13.1 HR513
State or Province Contains the state of the dependent's PA218
address.
EMD-ZIP Alpha 10 HR13.1 HR513
Postal Code Contains the postal code of the PA218
dependent's address.
EMD-FICA-NBR Alpha 15 HR13.1 HR513
Social Security Contains the dependent's Social PA218
Number Security number.
EMD-HM-PHONE-CNTRY Alpha 6 HR13.1 HR513
Hm Phone Cntry Contains the country code of the PA218
dependent's telephone number.
EMD-HM-PHONE-NBR Alpha 15 HR13.1 HR513
Hm Phone Nbr Contains the dependent's telephone PA218
number.
EMD-WK-PHONE-CNTRY Alpha 6 HR13.1 HR513
Work Telephone Contains the country code of the PA218
Country dependent's work telephone number.
EMD-WK-PHONE-NBR Alpha 15 HR13.1 HR513
Work Telephone Contains the dependent's work telephone PA218
number.
EMD-WK-PHONE-EXT Alpha 5 HR13.1 HR513
Work Telephone Contains the extension of the PA218
Extension dependent's work telephone number.
EMD-BIRTHDATE Numeric 8 (yyyymmdd) HR13.1 HR513
Birthdate Contains the dependent's birthdate. PA218
EMD-HL-COV-FLAG Alpha 1 HR13.1 HR513
Health Coverage Indicates if this dependent is covered PA218
by the employee's health insurance plan.
The Lawson Benefits system uses this
field.
N = No Coverage
Y = Coverage
EMD-DN-COV-FLAG Alpha 1 HR13.1 HR513
Dental Coverage Indicates if the dependent is covered PA218
by the employee's dental insurance plan.
The Lawson Benefits system uses this
field.
N = No Coverage
Y = Coverage
EMD-DL-COV-FLAG Alpha 1 HR13.1 HR513
Dependent Life Indicates if the dependent is covered PA218
by the employee's dependent life
insurance plan. The Lawson Benefits
system uses this field.
N = No Coverage
Y = Coverage
EMD-DEP-TYPE Alpha 1 HR13.1 HR513
Spouse or Dependent Indicates if the dependent is a spouse PA218
or a dependent.
S = Spouse
D = Dependent
EMD-SEX Alpha 1 HR13.1 HR513
Gender Indicates the employee's gender. PA218
F = Female
M = Male
EMD-STUDENT Alpha 1 HR13.1 HR513
Student Indicates if the dependent is a student. PA218
Y = Yes
N = No
EMD-DISABLED Alpha 1 HR13.1 HR513
Disabled Indicates if the dependent is disabled. PA218
Y = Yes
N = No
EMD-SMOKER Alpha 1 HR13.1 HR513
Smoker Indicates if the dependent is a smoker. PA218
Y = Yes
N = No
EMD-PRIMARY-CARE Alpha 10 HR13.1 HR513
Primary Care Contains the dependent's primary care PA218
Physician physician.
EMD-ADOPTION-DATE Numeric 8 (yyyymmdd) HR13.1 HR513
Adoption Date Indicates date adoption is finalized. PA218
EMD-PLACEMENT-DATE Numeric 8 (yyyymmdd) HR13.1 HR513
Placement Date Indicates date child is placed with PA218
employee.
EMD-NAME-SUFFIX Alpha 4 (Lower Case) HR13.1 HR513
Name Suffix Contains the suffix of the dependent's PA218
name.
EMD-LAST-NAME-PRE Alpha 30 (Lower Case) HR13.1 HR513
Last Name Pre Contains the prefix (title) of the PA218
dependent's name.
EMD-FIRST-MI Derived
First Mi
EMD-FIRST-MI-EXP Derived
First Mi Exp
EMD-LAST-PRE Derived
Last Pre
EMD-LAST-SUF Derived
Last Suf
EMD-LAST-PRE-SUF Derived
Last Pre Suf
EMD-LAST-NAME-EXP Derived
Last Name Exp
EMD-LABEL-ADDR Derived
Label Address
EMD-CUR-AGE Derived
Age
EMD-COUNTRY-CODE Alpha 2 HR13.1 HR513
Country Code Contains the country of the dependent's PA218
address.
EMD-CONSENT Alpha 1 HR13.1 HR513
Consent N = No PA218
Y = Yes
" " = No
EMD-FULL-NAME Derived
Full Name
EMD-SHORT-NAME Derived
Short Name
EMD-LABEL-NAME-1 Derived
Label Name 1
EMD-ACTIVE-FLAG Alpha 1 HR13.1 HR513
Status The Active flag of the credit card HR701 PA218
type.
A = Active
I = Inactive
EMD-DATE-STAMP Numeric 8 (yyyymmdd) HR13.1 HR513
Date Stamp This field contains the server date PA218
(month, date, and year) of the last
change to this record.
EMD-TIME-STAMP Numeric 6 (hhmmss) HR13.1 HR513
Time Stamp Contains the server time (hour, minute, PA218
and second) when the record was last
changed.
EMD-USER-ID Alpha 10 (Lower Case) HR13.1 HR513
User ID Name Contains the user ID of the person who PA218
last changed this record.
EMDEPEND FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EMDSET1 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
SEQ-NBR BN105 BN140
BN145 BN150
BN245 BN248
BN285 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN321 BN331
BN45.1 BN48.1
BN531 BN532
BN65.1 BN70.1
BN71.1 BN72.1
BN85.1 BS13.1
BS14.1 BS15.1
...
EMDEPEND FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
EMD-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Country INSTCTRYCD Required
When (EMD-COUNTRY-CODE != Spaces )
EMD-COUNTRY-CODE -> INT-COUNTRY-CODE
Employee EMPLOYEE Required
EMD-COMPANY -> EMP-COMPANY
EMD-EMPLOYEE -> EMP-EMPLOYEE
Pa Employee PAEMPLOYEE Required
EMD-COMPANY -> PEM-COMPANY
EMD-EMPLOYEE -> PEM-EMPLOYEE
Primary Care PCODES Required
When EMD-PRIMARY-CARE != Spaces
"PC" -> PCO-TYPE
EMD-PRIMARY-CARE -> PCO-CODE
Rel Code PCODES Required
"DP" -> PCO-TYPE
EMD-REL-CODE -> PCO-CODE
EMDEPEND FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Benefits HRDEPBEN
EMD-COMPANY -> HDB-COMPANY
EMD-EMPLOYEE -> HDB-EMPLOYEE
EMD-SEQ-NBR -> HDB-DEPENDENT
HDB-PLAN-TYPE
HDB-PLAN-CODE
HDB-EMP-START
HDB-START-DATE
Comments PACOMMENTS Delete Cascades
EMD-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"DP" -> PAC-CMT-TYPE
EMD-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
EMD-SEQ-NBR -> PAC-LN-NBR
PAC-SEQ-NBR
Correspondence HRCORRESP
EMD-COMPANY -> HCP-COMPANY
"4" -> HCP-REQ-TYPE
EMD-EMPLOYEE -> HCP-ID-NBR
EMD-SEQ-NBR -> HCP-DEPENDENT
HCP-SEQ-NBR
Name Suffix HRCTRYCODE
Valid When EMD-NAME-SUFFIX != Spaces
"SU" -> CTC-TYPE
EMD-NAME-SUFFIX -> CTC-HRCTRY-CODE
CTC-COUNTRY-CODE
|
