EMDEPEND – Employee Dependent

System
Human Resources (HR)
Prefix
EMD
Primary key
COMPANY, EMPLOYEE, SEQ-NBR
Fields
62
Updated by
5 programs
Referenced by
188 programs

EMDEPEND is the Employee Dependent table in Lawson Human Resources (prefix EMD). It is indexed by COMPANY, EMPLOYEE, SEQ-NBR (EMDSET1). It is related 1:1 to PRSYSTEM, INSTCTRYCD, EMPLOYEE, PAEMPLOYEE and PCODES and 1:M to HRDEPBEN, PACOMMENTS, HRCONTNBR, HRCORRESP, HRHISTORY, HRCTRYCODE and EMPVISA. It is updated by HR11.1, HR13.1, HR513, PA115 and PA218 and referenced by BN100, BN101, BN102, BN103, BN105, BN106, BN140, BN145 and 180 more. The table has 62 fields, 1 index and 13 documented relations.

About EMDEPEND

Contains information regarding the dependents of employees.

Fields (62)

Column = COBOL field name without the EMD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#EMD-COMPANY PK
COMPANY		Numeric 4Contains the number that represents an established company and is entered on all functions.HR13.1, HR513, PA218
#EMD-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee who has the dependents.HR13.1, HR513, PA218
#EMD-SEQ-NBR PK
SEQ_NBR		Numeric 4Contains the dependent number. The dependent number is used as a key when accessing dependent data.HR13.1, HR513, PA218
#EMD-REL-CODE
REL_CODE		Alpha 10Contains the relationship code that explains the relationship between the employee and dependent.HR13.1, HR513, PA218
#EMD-LAST-NAME
LAST_NAME		Alpha 30 (Lower Case)Contains the dependent's last name.HR13.1, HR513, PA218
#EMD-FIRST-NAME
FIRST_NAME		Alpha 15 (Lower Case)Contains the dependent's first name.HR13.1, HR513, PA218
#EMD-MIDDLE-INIT
MIDDLE_INIT		Alpha 1Contains the dependent's middle initial.HR13.1, HR513, PA218
#EMD-EMP-ADDRESS
EMP_ADDRESS		Alpha 1Indicates if the system uses the employee's home or supplemental address for the dependent, or neither.
  • H Home Address
  • S Supplemental Address
  • N No
HR13.1, HR513, PA218
#EMD-ADDR1
ADDR1		Alpha 30 (Lower Case)Contains the first line of the dependent's address.HR13.1, HR513, PA218
#EMD-ADDR2
ADDR2		Alpha 30 (Lower Case)Contains the second line of the dependent's address.HR13.1, HR513, PA218
#EMD-ADDR3
ADDR3		Alpha 30 (Lower Case)This field contains the first line of address information.HR13.1, HR513, PA218
#EMD-ADDR4
ADDR4		Alpha 30 (Lower Case)This field contains the first line of address information.HR13.1, HR513, PA218
#EMD-CITY
CITY		Alpha 58 (Lower Case)Contains the city of the dependent's address.HR13.1, HR513, PA218
#EMD-STATE
STATE		Alpha 2Contains the state of the dependent's address.HR13.1, HR513, PA218
#EMD-ZIP
ZIP		Alpha 10Contains the postal code of the dependent's address.HR13.1, HR513, PA218
#EMD-FICA-NBR
FICA_NBR		Alpha 20Contains the dependent's Social Security number.HR13.1, HR513, PA218
#EMD-HM-PHONE-CNTRY
HM_PHONE_CNTRY		Alpha 6Displays the country code of the dependent's telephone number.HR13.1, HR513, PA218
#EMD-HM-PHONE-NBR
HM_PHONE_NBR		Alpha 15Contains the dependent's telephone number.HR13.1, HR513, PA218
#EMD-WK-PHONE-CNTRY
WK_PHONE_CNTRY		Alpha 6Displays the country code of the dependent's work telephone number.HR13.1, HR513, PA218
#EMD-WK-PHONE-NBR
WK_PHONE_NBR		Alpha 15Contains the dependent's work telephone number.HR13.1, HR513, PA218
#EMD-WK-PHONE-EXT
WK_PHONE_EXT		Alpha 5Contains the extension of the dependent's work telephone number.HR13.1, HR513, PA218
#EMD-BIRTHDATE
BIRTHDATE		Numeric 8 (yyyymmdd)Contains the dependent's birthdate.HR13.1, HR513, PA218
#EMD-HL-COV-FLAG
HL_COV_FLAG		Alpha 1Indicates if this dependent is covered by the employee's health insurance plan. The Lawson Benefits system uses this field.
  • N No Coverage
  • Y Coverage
HR13.1, HR513, PA218
#EMD-DN-COV-FLAG
DN_COV_FLAG		Alpha 1Indicates if the dependent is covered by the employee's dental insurance plan. The Lawson Benefits system uses this field.
  • N No Coverage
  • Y Coverage
HR13.1, HR513, PA218
#EMD-DL-COV-FLAG
DL_COV_FLAG		Alpha 1Indicates if the dependent is covered by the employee's dependent life insurance plan. The Lawson Benefits system uses this field.
  • N No Coverage
  • Y Coverage
HR13.1, HR513, PA218
#EMD-DEP-TYPE
DEP_TYPE		Alpha 1Select whether the dependent is a spouse or a dependent.
  • S Spouse
  • D Dependent
  • P Domestic Partner
HR13.1, HR513, PA218
#EMD-SEX
SEX		Alpha 1Indicates the employee's gender.
  • F Female
  • M Male
HR13.1, HR513, PA218
#EMD-STUDENT
STUDENT		Alpha 1Select if the dependent is a student.
  • Y Yes
  • N No
  • F Fulltime
  • P Parttime
  • H Hostelite
HR13.1, HR513, PA218
#EMD-DISABLED
DISABLED		Alpha 1Select whether the dependent is disabled.
  • Y Yes
  • N No
HR13.1, HR513, PA218
#EMD-SMOKER
SMOKER		Alpha 1Indicates if the dependent is a smoker.
  • Y Yes
  • N No
HR13.1, HR513, PA218
#EMD-PRIMARY-CARE
PRIMARY_CARE		Alpha 10Contains the dependent's primary care physician.HR13.1, HR513, PA218
#EMD-ADOPTION-DATE
ADOPTION_DATE		Numeric 8 (yyyymmdd)Indicates date adoption is finalized.HR13.1, HR513, PA218
#EMD-PLACEMENT-DATE
PLACEMENT_DATE		Numeric 8 (yyyymmdd)Indicates date child is placed with employee.HR13.1, HR513, PA218
#EMD-NAME-SUFFIX
NAME_SUFFIX		Alpha 4 (Lower Case)Displays the suffix of the dependent's name.HR13.1, HR513, PA218
#EMD-LAST-NAME-PRE
LAST_NAME_PRE		Alpha 30 (Lower Case)Displays the prefix (title) of the dependent's name.HR13.1, HR513, PA218
#EMD-FIRST-MI
FIRST_MI		Derived——
#EMD-FIRST-MI-EXP
FIRST_MI_EXP		Derived——
#EMD-LAST-PRE
LAST_PRE		Derived——
#EMD-LAST-SUF
LAST_SUF		Derived——
#EMD-LAST-PRE-SUF
LAST_PRE_SUF		Derived——
#EMD-LAST-NAME-EXP
LAST_NAME_EXP		Derived——
#EMD-CUR-AGE
CUR_AGE		Derived——
#EMD-COUNTRY-CODE
COUNTRY_CODE		Alpha 2Displays the country of the dependent's address.HR13.1, HR513, PA218
#EMD-FULL-NAME
FULL_NAME		Derived——
#EMD-SHORT-NAME
SHORT_NAME		Derived——
#EMD-LABEL-NAME-1
LABEL_NAME_1		Derived——
#EMD-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1The Active flag of the credit card type.
  • A Active
  • I Inactive
HR13.1, HR513, PA218
#EMD-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.HR13.1, HR513, PA218
#EMD-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.HR13.1, HR513, PA218
#EMD-USER-ID
USER_ID		Alpha 10 (Lower Case)—HR13.1, HR513, PA218
#EMD-DECEASED
DECEASED		Alpha 1—
  • Y Yes
  • N No
HR13.1, HR513, PA218
#EMD-DEATH-DATE
DEATH_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.HR13.1, HR513, PA218
#EMD-ESTAB-PATIENT
ESTAB_PATIENT		Numeric 1—
  • 1 No
  • 2 Yes
  • 3 Unknown
HR13.1, HR513, PA218
#EMD-PRIOR-COV-MO
PRIOR_COV_MO		Numeric 2—HR13.1, HR513, PA218
#EMD-MEDICARE-IND
MEDICARE_IND		Alpha 1—
  • A Medicare Part A
  • B Medicare Part B
  • C Medicare Part A and B
  • D Medicare Unknown
  • E No Medicare
HR13.1, HR513, PA218
#EMD-VS-COV-FLAG
VS_COV_FLAG		Alpha 1—
  • N No Coverage
  • Y Coverage
—
#EMD-STUDENT-VERIFY
STUDENT_VERIFY		Numeric 8 (yyyymmdd)—HR13.1, HR513, PA218
#EMD-EMAIL-PERSONAL
EMAIL_PERSONAL		Alpha 60 (Lower Case)—HR13.1, HR513, PA218
#EMD-HICN
HICN		Alpha 11—HR13.1, HR513, PA218
#EMD-DEP-OF
DEP_OF		Numeric 4——
#EMD-DISABILITY-SEV
DISABILITY_SEV		Alpha 1—
  • 0 0 to < 40%
  • 1 40% to < 80%
  • 2 80% + Above
HR13.1, HR513, PA218

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
EMDSET1
  1. COMPANY
  2. EMPLOYEE
  3. SEQ-NBR
PrimaryBN100, BN101, BN102, BN103, BN105, BN106, BN140, BN145 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMINSTCTRYCDEMPLOYEEPAEMPLOYEEPCODESHRDEPBENPACOMMENTSHRCONTNBRHRCORRESPHRHISTORYHRCTRYCODEEMPVISAEMDEPEND

One to one (6) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
EMD-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CountryINSTCTRYCDRequiredWhen (EMD-COUNTRY-CODE != Spaces)
EMD-COUNTRY-CODE→INT-COUNTRY-CODE
EmployeeEMPLOYEERequired
EMD-COMPANY→EMP-COMPANY
EMD-EMPLOYEE→EMP-EMPLOYEE
Pa EmployeePAEMPLOYEERequired
EMD-COMPANY→PEM-COMPANY
EMD-EMPLOYEE→PEM-EMPLOYEE
Primary CarePCODESRequiredWhen EMD-PRIMARY-CARE != Spaces
"PC"→PCO-TYPE
EMD-PRIMARY-CARE→PCO-CODE
Rel CodePCODESRequired
"DP"→PCO-TYPE
EMD-REL-CODE→PCO-CODE

One to many (7) — child tables

RelationTableRulesConditionField map
BenefitsHRDEPBEN
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
CommentsPACOMMENTSDelete 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
—→PAC-DATE
Contact NbrHRCONTNBRDelete Cascades
EMD-COMPANY→HCN-COMPANY
"4"→HCN-REQ-TYPE
EMD-EMPLOYEE→HCN-ID-NBR
EMD-SEQ-NBR→HCN-DEPENDENT
—→HCN-SEQ-NBR
CorrespondenceHRCORRESP
EMD-COMPANY→HCP-COMPANY
"4"→HCP-REQ-TYPE
EMD-EMPLOYEE→HCP-ID-NBR
EMD-SEQ-NBR→HCP-DEPENDENT
—→HCP-SEQ-NBR
HrhistoryHRHISTORYDelete Cascades
EMD-COMPANY→HRH-COMPANY
EMD-EMPLOYEE→HRH-EMPLOYEE
EMD-SEQ-NBR→HRH-OBJ-ID
—→HRH-FLD-NBR
—→HRH-POS-LEVEL
—→HRH-BEG-DATE
—→HRH-SEQ-NBR
Name SuffixHRCTRYCODEValid When EMD-NAME-SUFFIX != Spaces
"SU"→CTC-TYPE
EMD-NAME-SUFFIX→CTC-HRCTRY-CODE
—→CTC-COUNTRY-CODE
Travel InfoEMPVISADelete Cascades
EMD-COMPANY→EMV-COMPANY
EMD-EMPLOYEE→EMV-EMPLOYEE
EMD-SEQ-NBR→EMV-DEPENDENT
—→EMV-VISA-CNTRY-CD
—→EMV-BEGIN-DATE
—→EMV-SEQ-NBR

Programs

Updated by (5)

Referenced by (188)