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.

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-CONSENT
CONSENT		Alpha 1" " = No
  • N No
  • Y Yes
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
EMDSET1COMPANY, EMPLOYEE, SEQ-NBRPrimaryBN100, BN101, BN102, BN103, BN105, BN106, BN140, BN145 +22 more (list truncated in source)

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredEMD-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
CountryINSTCTRYCDRequiredWhen (EMD-COUNTRY-CODE != Spaces)EMD-COUNTRY-CODE → INT-COUNTRY-CODE
EmployeeEMPLOYEERequiredEMD-COMPANY → EMP-COMPANY, EMD-EMPLOYEE → EMP-EMPLOYEE
Pa EmployeePAEMPLOYEERequiredEMD-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
BenefitsHRDEPBENEMD-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 CascadesEMD-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 CascadesEMD-COMPANY → HCN-COMPANY, "4" → HCN-REQ-TYPE, EMD-EMPLOYEE → HCN-ID-NBR, EMD-SEQ-NBR → HCN-DEPENDENT, → HCN-SEQ-NBR
CorrespondenceHRCORRESPEMD-COMPANY → HCP-COMPANY, "4" → HCP-REQ-TYPE, EMD-EMPLOYEE → HCP-ID-NBR, EMD-SEQ-NBR → HCP-DEPENDENT, → HCP-SEQ-NBR
HrhistoryHRHISTORYDelete CascadesEMD-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 CascadesEMD-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)