EMDEPEND

Employee Dependent

Contains information regarding the dependents of employees.

REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN106
BN140 BN145 BN150 BN245 BN248 BN285
BN305 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3
BN320 BN321 BN331 BN45.1 BN48.1 BN53.1
BN531 BN532 BN65.1 BN66.1 BN70.1 BN71.1
BN72.1 BN85.1 BS10.1 BS12.1 BS13.1 BS14.1
BS15.1 BS30.1 BS32.1 ZB10.1 ZB31.1 ZB31.2
ZB32.1 ZB32.2 ZB32.3 HEMD.1 HR04.2 HR04.3
HR04.7 HR04.8 HR170 HR213 HR28.1 HR30.1
HR511 HR70.1 HR80.1 HR80.2 HR80.3 HR80.4
HR80.5 HR80.6 HR80.7 HR80.8 HR80.9 HR81.1
HR81.2 HR81.3 HR81.4 HR81.5 HR81.6 HR81.7
HR81.8 HR81.9 HR82.1 HR82.2 HR82.3 HR82.4
HR82.5 HR82.6 HR82.7 HR82.8 HR82.9 HR83.1
HR83.2 HR83.3 HR83.4 HR83.5 HR83.6 HR83.7
HR83.8 HR83.9 HR84.1 HR84.2 HR84.3 HR84.4
HR84.5 HR84.6 HR84.7 HR84.8 HR84.9 HR85.1
HR85.2 HR85.3 HR85.4 HR85.5 HR85.6 HR85.7
HR85.8 HR86.1 HR86.2 HR86.3 HR86.4 HR86.5
HR86.6 HR86.7 HR86.8 HR86.9 HR87.1 HR87.2
HR87.3 HR87.4 HR87.5 HR87.6 HR87.7 HR87.8
HR87.9 HR88.1 HR88.2 HR88.3 HR88.4 HR88.5
HR88.6 HR88.7 HR89.1 HR89.2 HR89.3 HR89.4
HR89.5 HR89.6 HR89.7 HR89.8 HR89.9 HR90.1
HR91.7 HR92.1 HR92.2 HR92.3 LT101 LT111
ZH12.1 ZH12.2 ZH230 ZH510 PA02.1 PA100
PA102 PA13.1 PA13.2 PA18.1 PA311 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PR110
PR113 PR12.6 PR120 PR13.1 PR13.5 PR13.6
PR13.8 PR13.9 PR140 PR189 PR195 PR30.2
PR512 PR80.1 PR80.4 PR89.1 PRAT.1 ZP560
ZP562 ZP567


UPDATED BY
HR13.1 HR513 PA218 HR11.1 PA115

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
EMD-FIRST-NAME
Element: First Name		Alpha 15 (Lower Case)
Contains the dependent's first name.
HR13.1 HR513
PA218
EMD-MIDDLE-INIT
Element: Middle Init		Alpha 1
Contains the dependent's middle initial.
HR13.1 HR513
PA218
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: Hr City		Alpha 58 (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
Displays 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
Displays 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
Select whether 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
Select if the dependent is a student.
Y = Yes
N = No
F = Fulltime
P = Parttime
H = Hostelite
HR13.1 HR513
PA218
EMD-DISABLED
Element: Disabled		Alpha 1
Select whether 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)
Displays the suffix of the dependent's name.
HR13.1 HR513
PA218
EMD-LAST-NAME-PRE
Element: Last Name Pre		Alpha 30 (Lower Case)
Displays 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-CUR-AGE
Element: Cur Age		Derived
EMD-COUNTRY-CODE
Element: Country Code		Alpha 2
Displays 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
EMD-STUDENT-VERIFY
Element: Update Date		Numeric 8 (yyyymmdd)
HR13.1 HR513
PA218
EMD-EMAIL-PERSONAL
Element: Email Address		Alpha 60 (Lower Case)
HR13.1 HR513
PA218
EMD-HICN
Element: Hl Claim Nbr		Alpha 11
HR13.1 HR513
PA218
EMD-DEP-OF
Element: Seq Nbr		Numeric 4
EMD-DISABILITY-SEV
Element: Disability Sev		Alpha 1

0 = 0 to < 40%
1 = 40% to < 80%
2 = 80% + Above
HR13.1 HR513
PA218


EMDEPEND FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EMDSET1 COMPANY
EMPLOYEE
SEQ-NBR
...
BN100 BN101
BN102 BN103
BN105 BN106
BN140 BN145
BN150 BN245
BN248 BN285
BN305 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN321
BN331 BN45.1
BN48.1 BN53.1
BN531 BN532
BN65.1 BN66.1
BN70.1 BN71.1


EMDEPEND FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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
  PAC-DATE
Contact Nbr HRCONTNBR Delete Cascades
EMD-COMPANY->HCN-COMPANY
"4"->HCN-REQ-TYPE
EMD-EMPLOYEE->HCN-ID-NBR
EMD-SEQ-NBR->HCN-DEPENDENT
  HCN-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
Hrhistory HRHISTORY Delete 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 Suffix HRCTRYCODE
Valid When EMD-NAME-SUFFIX !=Spaces
"SU"->CTC-TYPE
EMD-NAME-SUFFIX->CTC-HRCTRY-CODE
  CTC-COUNTRY-CODE
Travel Info EMPVISA Delete Cascades
EMD-COMPANY->EMV-COMPANY
EMD-EMPLOYEE->EMV-EMPLOYEE
EMD-SEQ-NBR->EMV-DEPENDENT
  EMV-VISA-CNTRY-CD
  EMV-BEGIN-DATE
  EMV-SEQ-NBR

File created: Thu Jun 09 02:15:56 2016

Home
Contact Us



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