Employee Dependent

Contains information regarding the dependents of employees.

REFERENCED BY

BN106	BN140	BN248	BN285	BN29.3	BN321
BN48.1	BN53.1	BN532	BN70.1	BN85.1	BN95.3
BN990	BS30.1	XB500	XB510	XB520	HR30.1
HR90.1	PA18.1

UPDATED BY

HR13.1	HR13.3	HR13.4	HR513	PA218	BN100
BN101	BN102	BN103	BN105	BN145	BN150
BN245	BN305	BN31.1	BN31.2	BN32.1	BN32.2
BN32.3	BN320	BN331	BN45.1	BN531	BN65.1
BN71.1	BN72.1	BN729	BN991	BS13.1	BS14.1
BS15.1	BS32.1	XB515	HEMD.1	HR11.1	HR11.2
HR170	HR213	HR511	HR70.1	PA02.1	PA100
PA102	PA115	PA13.1	PA13.2	PA311	PA502
PA513	PA52.1	PA52.3	PA52.4	PA52.5	PR110
PR113	PR120	PR13.1	PR13.5	PR13.6	PR13.8
PR13.9

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
EMD-COMPANY Element: Company	Numeric 4 Contains the number that represents an established company and is entered on all functions.	HR13.1 HR513 PA218
EMD-EMPLOYEE Element: Employee	Numeric 9 Contains the employee who has the dependents.	HR13.1 HR513 PA218
EMD-SEQ-NBR Element: Dependent	Numeric 4 Contains the dependent number. The dependent number is used as a key when accessing dependent data.	HR13.1 HR513 PA218
EMD-REL-CODE Element: Relation	Alpha 10 Contains the relationship code that explains the relationship between the employee and dependent.	HR13.1 HR513 PA218
EMD-LAST-NAME Element: Last Name	Alpha 30 (Lower Case) Contains the dependent's last name.	HR13.1 HR513 PA218 XB510
EMD-FIRST-NAME Element: First Name	Alpha 15 (Lower Case) Contains the dependent's first name.	HR13.1 HR513 PA218 XB510
EMD-MIDDLE-INIT Element: Middle Init	Alpha 1 Contains the dependent's middle initial.	HR13.1 HR513 PA218 XB510
EMD-EMP-ADDRESS Element: Emp Address	Alpha 1 Indicates 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 Element: Address 1	Alpha 30 (Lower Case) Contains the first line of the dependent's address.	HR13.1 HR513 PA218
EMD-ADDR2 Element: Address 2	Alpha 30 (Lower Case) Contains the second line of the dependent's address.	HR13.1 HR513 PA218
EMD-ADDR3 Element: Addr1	Alpha 30 (Lower Case) This field contains the first line of address information.	HR13.1 HR513 PA218
EMD-ADDR4 Element: Addr1	Alpha 30 (Lower Case) This field contains the first line of address information.	HR13.1 HR513 PA218
EMD-CITY Element: City	Alpha 18 (Lower Case) Contains the city of the dependent's address.	HR13.1 HR513 PA218
EMD-STATE Element: State	Alpha 2 Contains the state of the dependent's address.	HR13.1 HR513 PA218
EMD-ZIP Element: Zip	Alpha 10 Contains the postal code of the dependent's address.	HR13.1 HR513 PA218
EMD-FICA-NBR Element: Social Number	Alpha 20 Contains the dependent's Social Security number.	HR13.1 HR513 PA218
EMD-HM-PHONE-CNTRY Element: Hm Phone Cntry	Alpha 6 Contains the country code of the dependent's telephone number.	HR13.1 HR513 PA218
EMD-HM-PHONE-NBR Element: Hm Phone Nbr	Alpha 15 Contains the dependent's telephone number.	HR13.1 HR513 PA218
EMD-WK-PHONE-CNTRY Element: Wk Phone Cntry	Alpha 6 Contains the country code of the dependent's work telephone number.	HR13.1 HR513 PA218
EMD-WK-PHONE-NBR Element: Wk Phone Nbr	Alpha 15 Contains the dependent's work telephone number.	HR13.1 HR513 PA218
EMD-WK-PHONE-EXT Element: Wk Phone Ext	Alpha 5 Contains the extension of the dependent's work telephone number.	HR13.1 HR513 PA218
EMD-BIRTHDATE Element: Birthdate	Numeric 8 (yyyymmdd) Contains the dependent's birthdate.	HR13.1 HR513 PA218
EMD-HL-COV-FLAG Element: Hl Cov Flag	Alpha 1 Indicates 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 Element: Dn Cov Flag	Alpha 1 Indicates 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 Element: Dependent Life	Alpha 1 Indicates 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 Element: Dep Type	Alpha 1 Indicates if the dependent is a spouse or a dependent. S = Spouse D = Dependent P = Domestic Partner	HR13.1 HR513 PA218
EMD-SEX Element: Sex	Alpha 1 Indicates the employee's gender. F = Female M = Male	HR13.1 HR513 PA218
EMD-STUDENT Element: Student	Alpha 1 Indicates if the dependent is a student. Y = Yes N = No F = Fulltime P = Parttime	HR13.1 HR513 PA218
EMD-DISABLED Element: Disabled	Alpha 1 Indicates if the dependent is disabled. Y = Yes N = No	HR13.1 HR513 PA218
EMD-SMOKER Element: Smoker	Alpha 1 Indicates if the dependent is a smoker. Y = Yes N = No	HR13.1 HR513 PA218
EMD-PRIMARY-CARE Element: Primary Care	Alpha 10 Contains the dependent's primary care physician.	HR13.1 HR513 PA218
EMD-ADOPTION-DATE Element: Adoption Date	Numeric 8 (yyyymmdd) Indicates date adoption is finalized.	HR13.1 HR513 PA218
EMD-PLACEMENT-DATE Element: Placement Date	Numeric 8 (yyyymmdd) Indicates date child is placed with employee.	HR13.1 HR513 PA218
EMD-NAME-SUFFIX Element: Name Suffix	Alpha 4 (Lower Case) Contains the suffix of the dependent's name.	HR13.1 HR513 PA218
EMD-LAST-NAME-PRE Element: Last Name Pre	Alpha 30 (Lower Case) Contains the prefix (title) of the dependent's name.	HR13.1 HR513 PA218
EMD-FIRST-MI Element: First Mi	Derived
EMD-FIRST-MI-EXP Element: First Mi Exp	Derived
EMD-LAST-PRE Element: Last Pre	Derived
EMD-LAST-SUF Element: Last Suf	Derived
EMD-LAST-PRE-SUF Element: Last Pre Suf	Derived
EMD-LAST-NAME-EXP Element: Last Name Exp	Derived
EMD-LABEL-ADDR Element: Label Addr	Derived
EMD-CUR-AGE Element: Cur Age	Derived
EMD-COUNTRY-CODE Element: Country Code	Alpha 2 Contains the country of the dependent's address.	HR13.1 HR513 PA218
EMD-CONSENT Element: Consent	Alpha 1 N = No Y = Yes " " = No	HR13.1 HR513 PA218
EMD-FULL-NAME Element: Full Name	Derived
EMD-SHORT-NAME Element: Short Name	Derived
EMD-LABEL-NAME-1 Element: Label Name 1	Derived
EMD-ACTIVE-FLAG Element: Active Flag	Alpha 1 The Active flag of the credit card type. A = Active I = Inactive	HR13.1 HR513 PA218
EMD-DATE-STAMP Element: 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 Element: 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 Element: User	Alpha 10 (Lower Case)	HR13.1 HR513 PA218
EMD-DECEASED Element: Deceased	Alpha 1 Y = Yes N = No	HR13.1 HR513 PA218
EMD-DEATH-DATE Element: Date	Numeric 8 (yyyymmdd) This field displays the system date when this was created.	HR13.1 HR513 PA218
EMD-ESTAB-PATIENT Element: Estab Patient	Numeric 1 1 = No 2 = Yes 3 = Unknown	HR13.1 HR513 PA218
EMD-PRIOR-COV-MO Element: Prior Cov Mo	Numeric 2	HR13.1 HR513 PA218
EMD-MEDICARE-IND Element: 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 Element: Vs Cov Flag	Alpha 1 N = No Coverage Y = Coverage

EMDEPEND FILE INDEX

EMDEPEND FILE RELATIONS

ONE TO ONE RELATIONS

EMDEPEND FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.