|
|
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
BN305 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 PA13.1 PA13.2
PA18.1 PA311 PA502 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PR110 PR113 PR120 PR13.1
PR13.5 PR13.6 PR13.8
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 Init Contains the dependent's middle initial. PA218
EMD-EMP-ADDRESS Alpha 1 HR13.1 HR513
Element: Emp Address Indicates 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: Addr1 This field contains the first line of PA218
address information.
EMD-ADDR4 Alpha 30 (Lower Case) HR13.1 HR513
Element: Addr1 This field contains the first 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 Contains the state of the dependent's PA218
address.
EMD-ZIP Alpha 10 HR13.1 HR513
Element: Zip 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
Element: Wk Phone CntryContains the country code of the PA218
dependent's work telephone number.
EMD-WK-PHONE-NBR Alpha 15 HR13.1 HR513
Element: Wk Phone Nbr Contains the dependent's work telephone PA218
number.
EMD-WK-PHONE-EXT Alpha 5 HR13.1 HR513
Element: Wk Phone Ext Contains the extension of the PA218
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: Hl Cov Flag Indicates 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: Dn Cov Flag Indicates 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: Dep Type Indicates if the dependent is a spouse PA218
or a dependent.
S = Spouse
D = Dependent
EMD-SEX Alpha 1 HR13.1 HR513
Element: Sex 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
Element: Primary Care Contains the dependent's primary care PA218
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 Addr
EMD-CUR-AGE Derived
Element: Cur 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: Active Flag 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 PA218
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 This field displays the system date PA218
when this was created.
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
EMD-MEDICARE-IND Alpha 1 HR13.1 HR513
Element: Medicare Ind A = Medicare Part A PA218
B = Medicare Part B
C = Medicare Part A and B
D = Medicare Unknown
E = No Medicare
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
BN305 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
...
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
|
