Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EMDEPEND


                             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