|
|
EMDEPEND FILE
Employee Dependent
Contains information regarding the dependents of employees.
REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN106
BN140 BN145 BN150 BN245 BN248 BN285
BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN320
BN321 BN331 BN45.1 BN48.1 BN53.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
HR170 HR213 HR30.1 HR511 HR70.1 HR90.1
PA02.1 PA100 PA102 PA18.1 PA311 PA502
PA52.1 PA52.3 PA52.4 PA52.5 PR110 PR113
PR120 PR13.1 PR13.5 PR13.6 PR13.8 PR252
PR299
UPDATED BY
HR13.1 HR513 PA218 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EMD-COMPANY Numeric 4 HR13.1 HR513
Element: Company Contains the number that represents an PA218
established company and is entered on
all functions.
EMD-EMPLOYEE Numeric 9 HR13.1 HR513
Element: Employee Contains the employee who has the PA218
dependents.
EMD-SEQ-NBR Numeric 4 HR13.1 HR513
Element: Dependent Contains the dependent number. The PA218
dependent number is used as a key when
accessing dependent data.
EMD-REL-CODE Alpha 10 HR13.1 HR513
Element: Relation Contains the relationship code that PA218
explains the relationship between the
employee and dependent.
EMD-LAST-NAME Alpha 30 (Lower Case) HR13.1 HR513
Element: Last Name Contains the dependent's last name. PA218
EMD-FIRST-NAME Alpha 15 (Lower Case) HR13.1 HR513
Element: First Name Contains the dependent's first name. PA218
EMD-MIDDLE-INIT Alpha 1 HR13.1 HR513
Element: Middle InitialContains the dependent's middle initial. PA218
EMD-EMP-ADDRESS Alpha 1 HR13.1 HR513
Element: Employee AddreIndicates if the system uses the PA218
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
Element: Address 1 Contains the first line of the PA218
dependent's address.
EMD-ADDR2 Alpha 30 (Lower Case) HR13.1 HR513
Element: Address 2 Contains the second line of the PA218
dependent's address.
EMD-ADDR3 Alpha 30 (Lower Case) HR13.1 HR513
Element: Address 1 This field contains the third line of PA218
address information.
EMD-ADDR4 Alpha 30 (Lower Case) HR13.1 HR513
Element: Address 1 This field contains the fourth line of PA218
address information.
EMD-CITY Alpha 18 (Lower Case) HR13.1 HR513
Element: City Contains the city of the dependent's PA218
address.
EMD-STATE Alpha 2 HR13.1 HR513
Element: State or ProviContains the state of the dependent's PA218
address.
EMD-ZIP Alpha 10 HR13.1 HR513
Element: Postal Code Contains the postal code of the PA218
dependent's address.
EMD-FICA-NBR Alpha 20 HR13.1 HR513
Element: Social Number Contains the dependent's Social PA218
Security number.
EMD-HM-PHONE-CNTRY Alpha 6 HR13.1 HR513
Element: Hm Phone CntryContains the country code of the PA218
dependent's telephone number.
EMD-HM-PHONE-NBR Alpha 15 HR13.1 HR513
Element: Hm Phone Nbr Contains the dependent's telephone PA218
number.
EMD-WK-PHONE-CNTRY Alpha 6 HR13.1 HR513
Work Telephone Contains the country code of the PA218
Country dependent's work telephone number.
EMD-WK-PHONE-NBR Alpha 15 HR13.1 HR513
Element: Work TelephoneContains the dependent's work telephone PA218
number.
EMD-WK-PHONE-EXT Alpha 5 HR13.1 HR513
Work Telephone Contains the extension of the PA218
Extension dependent's work telephone number.
EMD-BIRTHDATE Numeric 8 (yyyymmdd) HR13.1 HR513
Element: Birthdate Contains the dependent's birthdate. PA218
EMD-HL-COV-FLAG Alpha 1 HR13.1 HR513
Element: Health CoveragIndicates if this dependent is covered PA218
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
Element: Dental CoveragIndicates if the dependent is covered PA218
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
Element: Dependent LifeIndicates if the dependent is covered PA218
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
Element: Spouse or DepeIndicates if the dependent is a spouse PA218
or a dependent.
S = Spouse
D = Dependent
EMD-SEX Alpha 1 HR13.1 HR513
Element: Gender Indicates the employee's gender. PA218
F = Female
M = Male
EMD-STUDENT Alpha 1 HR13.1 HR513
Element: Student Indicates if the dependent is a student. PA218
Y = Yes
N = No
F = Fulltime
P = Parttime
EMD-DISABLED Alpha 1 HR13.1 HR513
Element: Disabled Indicates if the dependent is disabled. PA218
Y = Yes
N = No
EMD-SMOKER Alpha 1 HR13.1 HR513
Element: Smoker Indicates if the dependent is a smoker. PA218
Y = Yes
N = No
EMD-PRIMARY-CARE Alpha 10 HR13.1 HR513
Primary Care Contains the dependent's primary care PA218
Physician physician.
EMD-ADOPTION-DATE Numeric 8 (yyyymmdd) HR13.1 HR513
Element: Adoption Date Indicates date adoption is finalized. PA218
EMD-PLACEMENT-DATE Numeric 8 (yyyymmdd) HR13.1 HR513
Element: Placement DateIndicates date child is placed with PA218
employee.
EMD-NAME-SUFFIX Alpha 4 (Lower Case) HR13.1 HR513
Element: Name Suffix Contains the suffix of the dependent's PA218
name.
EMD-LAST-NAME-PRE Alpha 30 (Lower Case) HR13.1 HR513
Element: Last Name Pre Contains the prefix (title) of the PA218
dependent's name.
EMD-FIRST-MI Derived
Element: First Mi
EMD-FIRST-MI-EXP Derived
Element: First Mi Exp
EMD-LAST-PRE Derived
Element: Last Pre
EMD-LAST-SUF Derived
Element: Last Suf
EMD-LAST-PRE-SUF Derived
Element: Last Pre Suf
EMD-LAST-NAME-EXP Derived
Element: Last Name Exp
EMD-LABEL-ADDR Derived
Element: Label Address
EMD-CUR-AGE Derived
Element: Age
EMD-COUNTRY-CODE Alpha 2 HR13.1 HR513
Element: Country Code Contains the country of the dependent's PA218
address.
EMD-CONSENT Alpha 1 HR13.1 HR513
Element: Consent N = No PA218
Y = Yes
" " = No
EMD-FULL-NAME Derived
Element: Full Name
EMD-SHORT-NAME Derived
Element: Short Name
EMD-LABEL-NAME-1 Derived
Element: Label Name 1
EMD-ACTIVE-FLAG Alpha 1 HR13.1 HR513
Element: Status The Active flag of the credit card PA218
type.
A = Active
I = Inactive
EMD-DATE-STAMP Numeric 8 (yyyymmdd) HR13.1 HR513
Element: Date Stamp This field contains the server date PA218
(month, date, and year) of the last
change to this record.
EMD-TIME-STAMP Numeric 6 (hhmmss) HR13.1 HR513
Element: Time Stamp Contains the server time (hour, minute, PA218
and second) when the record was last
changed.
EMD-USER-ID Alpha 10 (Lower Case) HR13.1 HR513
Element: User Contains the user ID of the person who PA218
last changed this record.
EMD-DECEASED Alpha 1 HR13.1 HR513
Element: Deceased Y = Yes PA218
N = No
EMD-DEATH-DATE Numeric 8 (yyyymmdd) HR13.1 HR513
Element: Date PA218
EMD-ESTAB-PATIENT Numeric 1 HR13.1 HR513
Element: Estab Patient 1 = No PA218
2 = Yes
3 = Unknown
EMD-PRIOR-COV-MO Numeric 2 HR13.1 HR513
Element: Prior Cov Mo PA218
EMDEPEND FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EMDSET1 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
SEQ-NBR BN105 BN106
BN140 BN145
BN150 BN245
BN248 BN285
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN321 BN331
BN45.1 BN48.1
BN53.1 BN531
BN532 BN65.1
BN70.1 BN71.1
BN72.1 BN85.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
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
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
|
