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    HR700     HRS1.1    HRSC.1    PA100     PA102
PA115     PA15.1    PA15.2    PA52.1    PA52.3    PA52.4
PA52.5    PA54.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

PMD-CODE             Alpha 10                                    HR54.1  HR700
Code                 Contains the emergency medical              HRS1.1  HRSC.1
                     condition or work restriction.              PA100   PA102
                                                                 PA15.1  PA15.2
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.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                                                HR170   HR70.1
          EMPLOYEE                                               HS11.1  PA115
          TYPE                                                   PA15.1  PA15.2
          CODE
          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