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    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
 |