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    HS11.2    PA215     PA311


UPDATED BY

BN305     HAP3.1    HEP4.1    HPOS.1    HPQC.1    HPRS.1
HR11.1    HR11.2    HR511     HR54.1    HRS1.1    HRSC.1
PA02.1    PA100     PA102     PA115     PA13.1    PA13.2
PA15.1    PA15.2    PA502     PA513     PA52.1    PA52.3
PA52.4    PA52.5    PA54.1    PR110     PR113     PR120
PR13.1    PR13.5    PR13.6    PR13.8

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PMD-COMPANY            Numeric 4                                 BN305   HAP3.1
Element: Company Hr    Contains the company number which         HEP4.1  HPOS.1
                       represents an established company.        HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR511   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA15.1  PA15.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PMD-EMPLOYEE           Numeric 9                                 BN305   HAP3.1
Element: Employee      Contains the employee's number. It is     HEP4.1  HPOS.1
                       use to correlate all information related  HPQC.1  HPRS.1
                       to the employee.                          HR11.1  HR11.2
                                                                 HR511   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA15.1  PA15.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PMD-TYPE               Alpha 2                                   BN305   HAP3.1
Element: Type          Indicates whether the condition is an     HEP4.1  HPOS.1
                       emergency medical or a work restriction.  HPQC.1  HPRS.1
                       EM = Emergency Medical                    HR11.1  HR11.2
                       WR = Work Restriction                     HR511   HR54.1
                       AC = Accomodation                         HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA15.1  PA15.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PMD-CODE               Alpha 10                                  BN305   HAP3.1
Element: Code          Contains the emergency medical            HEP4.1  HPOS.1
                       condition or work restriction.            HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR511   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA15.1  PA15.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

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

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

PMD-SEQ-NBR            Numeric 4                                 PA15.1  PA15.2
Element: Seq Nbr       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                                                   HS11.2  PA115
          CODE                                                   PA15.1  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