Lawson Insight Technical Documentation

                             PAMEDICAL FILE

                     Emp Medical and Work Desc Code

The Emp Medical and Work Desc Code file contains emergency medical conditions
and/or work restrictions for employees. The information is organized by
beginning and ending dates.

REFERENCED BY

HR170     HR70.1    HS11.1    PA215     PA311

UPDATED BY

HR54.1    HRS1.1    HRSC.1    PA100     PA102     PA15.1
PA15.2    PA52.1    PA52.3    PA52.4    PA52.5    PA54.1
PRSC.1    HR11.1    PA115

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PMD-COMPANY          Numeric 4                                   HR54.1  HRS1.1
Company              Contains the company number which           HRSC.1  PA100
                     represents an established company.          PA102   PA15.1
                                                                 PA15.2  PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PRSC.1

PMD-EMPLOYEE         Numeric 9                                   HR54.1  HRS1.1
Employee             Contains the employee's number. It is       HRSC.1  PA100
                     use to correlate all information related    PA102   PA15.1
                     to the employee.                            PA15.2  PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PRSC.1

PMD-TYPE             Alpha 2                                     HR54.1  HRS1.1
Type                 Indicates whether the condition is an       HRSC.1  PA100
                     emergency medical or a work restriction.    PA102   PA15.1
                     EM = Emergency Medical                      PA15.2  PA52.1
                     WR = Work Restriction                       PA52.3  PA52.4
                     AC = Accomodation                           PA52.5  PA54.1
                                                                 PRSC.1

PMD-CODE             Alpha 10                                    HR54.1  HRS1.1
Code                 Contains the emergency medical              HRSC.1  PA100
                     condition or work restriction.              PA102   PA15.1
                                                                 PA15.2  PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PRSC.1

PMD-BEG-DATE         Numeric 8  (yyyymmdd)                       PA15.1  PA15.2
Beginning Date       Contains the beginning date of the
                     emergency medical condition or work
                     restriction period.

PMD-END-DATE         Numeric 8  (yyyymmdd)                       PA15.1  PA15.2
Ending Date          Contains the ending date of the
                     emergency medical condition or work
                     restriction period.

PMD-SEQ-NBR          Numeric 4                                   PA15.1  PA15.2
Sequence Number      An automatically assigned sequence
                     number.

                         PAMEDICAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PMDSET1   COMPANY                                                HR11.1  HR170
          EMPLOYEE                                               HR70.1  HS11.1
          TYPE                                                   PA115   PA15.1
          CODE                                                   PA15.2
          SEQ-NBR

PMDSET2   COMPANY       KeyChange                                PA15.1  PA15.2
          EMPLOYEE                                               PA215   PA311
          TYPE
          CODE
          BEG-DATE*
          SEQ-NBR

                         PAMEDICAL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PMD-COMPANY     -> PRS-COMPANY
                            Spaces          -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            PMD-COMPANY     -> EMP-COMPANY
                            PMD-EMPLOYEE    -> EMP-EMPLOYEE

Hr Code        PCODES       Required

                            PMD-TYPE        -> PCO-TYPE
                            PMD-CODE        -> PCO-CODE

Pa Employee    PAEMPLOYEE   Required

                            PMD-COMPANY     -> PEM-COMPANY
                            PMD-EMPLOYEE    -> PEM-EMPLOYEE