Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAMEDICAL


                             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

HAP3.1    HEP4.1    HPOS.1    HPQC.1    HPRS.1    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                                 HAP3.1  HEP4.1
Element: Company Hr    Contains the company number which         HPOS.1  HPQC.1
                       represents an established company.        HPRS.1  HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA100   PA102
                                                                 PA15.1  PA15.2
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PRSC.1

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

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

PMD-CODE               Alpha 10                                  HAP3.1  HEP4.1
Element: Code          Contains the emergency medical            HPOS.1  HPQC.1
                       condition or work restriction.            HPRS.1  HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA100   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
Element: Beginning DateContains the beginning date of the
                       emergency medical condition or work
                       restriction period.

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

PMD-SEQ-NBR            Numeric 4                                 PA15.1  PA15.2
Element: Sequence NumbeAn 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