|
|
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 BN320 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 HR11.1 HR170
HR213 HR30.1 HR511 HR70.1 HR90.1 PA02.1
PA100 PA102 PA311 PA502 PA52.1 PA52.3
PA52.4 PA52.5 PR13.1
UPDATED BY
HR13.1 HR513 HR704 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EMD-COMPANY Numeric 4 HR13.1 HR513
Company Contains the number that represents an
established company and is entered on
all functions.
EMD-EMPLOYEE Numeric 9 HR13.1 HR513
Employee Contains the employee who has the
dependents.
EMD-SEQ-NBR Numeric 4 HR13.1 HR513
Dependent Contains the dependent number. The
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
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.
EMD-FIRST-NAME Alpha 15 (Lower Case) HR13.1 HR513
First Name Contains the dependent's first name.
EMD-MIDDLE-INIT Alpha 1 HR13.1 HR513
Middle Initial Contains the dependent's middle initial.
EMD-EMP-ADDRESS Alpha 1 HR13.1 HR513
Employee Address 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
EMD-ADDR1 Alpha 30 (Lower Case) HR13.1 HR513
Address 1 Contains the first line of the
dependent's address.
EMD-ADDR2 Alpha 30 (Lower Case) HR13.1 HR513
Address 2 Contains the second line of the
dependent's address.
EMD-ADDR3 Alpha 30 (Lower Case) HR13.1 HR513
Address 3 This field contains the third line of
address information.
EMD-ADDR4 Alpha 30 (Lower Case) HR13.1 HR513
Address 4 This field contains the fourth line of
address information.
EMD-CITY Alpha 18 (Lower Case) HR13.1 HR513
City Contains the city of the dependent's
address.
EMD-STATE Alpha 2 HR13.1 HR513
State or Province Contains the state of the dependent's
address.
EMD-ZIP Alpha 10 HR13.1 HR513
Postal Code Contains the postal code of the
dependent's address.
EMD-COUNTRY Alpha 30 (Lower Case)
Country Contains the country of the dependent's
address.
EMD-FICA-NBR Alpha 15 HR13.1 HR513
Social Security Contains the dependent's Social
Number Security number.
EMD-HM-PHONE-CNTRY Alpha 6 HR13.1 HR513
Hm Phone Cntry Contains the country code of the
dependent's telephone number.
EMD-HM-PHONE-NBR Alpha 15 HR13.1 HR513
Hm Phone Nbr Contains the dependent's telephone
number.
EMD-WK-PHONE-CNTRY Alpha 6 HR13.1 HR513
Work Telephone Contains the country code of the
Country dependent's work telephone number.
EMD-WK-PHONE-NBR Alpha 15 HR13.1 HR513
Work Telephone Contains the dependent's work telephone
number.
EMD-WK-PHONE-EXT Alpha 5 HR13.1 HR513
Work Telephone Contains the extension of the
Extension dependent's work telephone number.
EMD-BIRTHDATE Numeric 8 (yyyymmdd) HR13.1 HR513
Birthdate Contains the dependent's birthdate.
EMD-HL-COV-FLAG Alpha 1 HR13.1 HR513
Health Coverage 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
EMD-DN-COV-FLAG Alpha 1 HR13.1 HR513
Dental Coverage 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
EMD-DL-COV-FLAG Alpha 1 HR13.1 HR513
Dependent Life 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
EMD-DEP-TYPE Alpha 1 HR13.1 HR513
Spouse or Dependent Indicates if the dependent is a spouse
or a dependent.
S = Spouse
D = Dependent
EMD-SEX Alpha 1 HR13.1 HR513
Gender Indicates the employee's gender.
F = Female
M = Male
EMD-STUDENT Alpha 1 HR13.1 HR513
Student Indicates if the dependent is a student.
Y = Yes
N = No
EMD-DISABLED Alpha 1 HR13.1 HR513
Disabled Indicates if the dependent is disabled.
Y = Yes
N = No
EMD-SMOKER Alpha 1 HR13.1 HR513
Smoker Indicates if the dependent is a smoker.
Y = Yes
N = No
EMD-PRIMARY-CARE Alpha 10 HR13.1 HR513
Primary Care Contains the dependent's primary care
Physician physician.
EMD-ADOPTION-DATE Numeric 8 (yyyymmdd) HR13.1 HR513
Adoption Date Indicates date adoption is finalized.
EMD-PLACEMENT-DATE Numeric 8 (yyyymmdd) HR13.1 HR513
Placement Date Indicates date child is placed with
employee.
EMD-NAME-SUFFIX Alpha 4 (Lower Case)
Name Suffix Contains the suffix of the dependent's
name.
EMD-LAST-NAME-PRE Alpha 30 (Lower Case)
Last Name Pre Contains the prefix (title) of the
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 HR704
address.
EMD-CONSENT Alpha 1 HR13.1 HR513
Consent N = No
Y = Yes
" " = No
EMD-FULL-NAME Derived
Full Name
EMD-SHORT-NAME Derived
Short Name
EMD-LABEL-NAME-1 Derived
Label Name 1
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
BN320 BN321
BN331 BN45.1
BN48.1 BN531
BN532 BN65.1
BN70.1 BN71.1
BN72.1 BN85.1
BS13.1 BS14.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
|