Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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    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    HR170     HR213     HR30.1
HR511     HR650     HR70.1    HR90.1    PA18.1    PA311
PA502     PR13.1    PR13.5    PR13.6    PR13.8

UPDATED BY

HR13.1    HR513     HR701     PA218

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

EMD-COMPANY          Numeric 4                                   HR13.1  HR513
Company              Contains the number that represents an      PA218
                     established company and is entered on
                     all functions.

EMD-EMPLOYEE         Numeric 9                                   HR13.1  HR513
Employee             Contains the employee who has the           PA218
                     dependents.

EMD-SEQ-NBR          Numeric 4                                   HR13.1  HR513
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
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
Last Name            Contains the dependent's last name.         PA218

EMD-FIRST-NAME       Alpha 15  (Lower Case)                      HR13.1  HR513
First Name           Contains the dependent's first name.        PA218

EMD-MIDDLE-INIT      Alpha 1                                     HR13.1  HR513
Middle Initial       Contains the dependent's middle initial.    PA218

EMD-EMP-ADDRESS      Alpha 1                                     HR13.1  HR513
Employee 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
Address 1            Contains the first line of the              PA218
                     dependent's address.

EMD-ADDR2            Alpha 30  (Lower Case)                      HR13.1  HR513
Address 2            Contains the second line of the             PA218
                     dependent's address.

EMD-ADDR3            Alpha 30  (Lower Case)                      HR13.1  HR513
Address 3            This field contains the third line of       PA218
                     address information.

EMD-ADDR4            Alpha 30  (Lower Case)                      HR13.1  HR513
Address 4            This field contains the fourth line of      PA218
                     address information.

EMD-CITY             Alpha 18  (Lower Case)                      HR13.1  HR513
City                 Contains the city of the dependent's        PA218
                     address.

EMD-STATE            Alpha 2                                     HR13.1  HR513
State or Province    Contains the state of the dependent's       PA218
                     address.

EMD-ZIP              Alpha 10                                    HR13.1  HR513
Postal Code          Contains the postal code of the             PA218
                     dependent's address.

EMD-FICA-NBR         Alpha 15                                    HR13.1  HR513
Social Security      Contains the dependent's Social             PA218
Number               Security number.

EMD-HM-PHONE-CNTRY   Alpha 6                                     HR13.1  HR513
Hm Phone Cntry       Contains the country code of the            PA218
                     dependent's telephone number.

EMD-HM-PHONE-NBR     Alpha 15                                    HR13.1  HR513
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
Work Telephone       Contains 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
Birthdate            Contains the dependent's birthdate.         PA218

EMD-HL-COV-FLAG      Alpha 1                                     HR13.1  HR513
Health Coverage      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
Dental Coverage      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
Dependent Life       Indicates 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
Spouse or Dependent  Indicates if the dependent is a spouse      PA218
                     or a dependent.
                     S = Spouse
                     D = Dependent

EMD-SEX              Alpha 1                                     HR13.1  HR513
Gender               Indicates the employee's gender.            PA218
                     F = Female
                     M = Male

EMD-STUDENT          Alpha 1                                     HR13.1  HR513
Student              Indicates if the dependent is a student.    PA218
                     Y = Yes
                     N = No

EMD-DISABLED         Alpha 1                                     HR13.1  HR513
Disabled             Indicates if the dependent is disabled.     PA218
                     Y = Yes
                     N = No

EMD-SMOKER           Alpha 1                                     HR13.1  HR513
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
Adoption Date        Indicates date adoption is finalized.       PA218

EMD-PLACEMENT-DATE   Numeric 8  (yyyymmdd)                       HR13.1  HR513
Placement Date       Indicates date child is placed with         PA218
                     employee.

EMD-NAME-SUFFIX      Alpha 4  (Lower Case)                       HR13.1  HR513
Name Suffix          Contains the suffix of the dependent's      PA218
                     name.

EMD-LAST-NAME-PRE    Alpha 30  (Lower Case)                      HR13.1  HR513
Last Name Pre        Contains the prefix (title) of the          PA218
                     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     PA218
                     address.

EMD-CONSENT          Alpha 1                                     HR13.1  HR513
Consent              N = No                                      PA218
                     Y = Yes
                     " " = No

EMD-FULL-NAME        Derived
Full Name

EMD-SHORT-NAME       Derived
Short Name

EMD-LABEL-NAME-1     Derived
Label Name 1

EMD-ACTIVE-FLAG      Alpha 1                                     HR13.1  HR513
Status               The Active flag of the credit card          HR701   PA218
                     type.
                     A = Active
                     I = Inactive

EMD-DATE-STAMP       Numeric 8  (yyyymmdd)                       HR13.1  HR513
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
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
User ID Name         Contains the user ID of the person who      PA218
                     last changed this record.

                         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
                                                                 BN321   BN331
                                                                 BN45.1  BN48.1
                                                                 BN531   BN532
                                                                 BN65.1  BN70.1
                                                                 BN71.1  BN72.1
                                                                 BN85.1  BS13.1
                                                                 BS14.1  BS15.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