PAMEDICAL – Emp Medical and Work Desc Code

System: Personnel (PA)
Prefix: PMD
Primary key: COMPANY, EMPLOYEE, TYPE, CODE, SEQ-NBR
Fields: 13
Updated by: 44 programs
Referenced by: 6 programs

PAMEDICAL is the Emp Medical and Work Desc Code table in Lawson Personnel (prefix PMD). It is indexed by COMPANY, EMPLOYEE, TYPE, CODE, SEQ-NBR (PMDSET1); alternate indexes: PMDSET2. It is related 1:1 to PRSYSTEM, EMPLOYEE, PCODES and PAEMPLOYEE. It is updated by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 and 36 more and referenced by HR170, HR70.1, HS11.1, HS11.2, PA215 and PA311. The table has 13 fields, 2 indexes and 4 documented relations.

About PAMEDICAL

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.

Fields (13)

Column = COBOL field name without the PMD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`PMD-COMPANY` PK COMPANY	Numeric 4	Contains the company number which represents an established company.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +36 more
`PMD-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee's number. It is use to correlate all information related to the employee.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +36 more
`PMD-TYPE` PK TYPE	Alpha 2	Indicates whether the condition is an emergency medical or a work restriction. `EM` Emergency Medical `WR` Work Restriction `AC` Accomodation	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +36 more
`PMD-CODE` PK CODE	Alpha 10	Contains the emergency medical condition or work restriction.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +36 more
`PMD-BEG-DATE` BEG_DATE	Numeric 8 (yyyymmdd)	Contains the beginning date of the emergency medical condition or work restriction period.	PA15.1, PA15.2
`PMD-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	Contains the ending date of the emergency medical condition or work restriction period.	PA15.1, PA15.2
`PMD-SEQ-NBR` PK SEQ_NBR	Numeric 4	An automatically assigned sequence number.	PA15.1, PA15.2
`PMD-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +36 more
`PMD-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +36 more
`PMD-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +36 more
`PMD-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +36 more
`PMD-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +36 more
`PMD-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +36 more

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PMDSET1`	`COMPANY`, `EMPLOYEE`, `TYPE`, `CODE`, `SEQ-NBR`	Primary		HR11.1, HR170, HR70.1, HS11.1, HS11.2, PA115, PA15.1, PA15.2
`PMDSET2`	`COMPANY`, `EMPLOYEE`, `TYPE`, `CODE`, `BEG-DATE*`, `SEQ-NBR`	KeyChange		PA15.1, PA15.2, PA215, PA311

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Field map
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`

Programs

Updated by (44)

BN305 Highly Compensated Employees
HAP3.1 Applicant Option 4 Selection Invoke
HCRE.1 Action Reason Code Selects
HEP4.1 Employee Option 4 Selection Invoke
HPOS.1 Position Selection Invoke
HPQC.1 Prqcentgrp Select Invoke
HPRS.1 Process Level Select Invoke
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR28.1 Employee Ethnicity
HR511 Employee Conversion
HR54.1 Employee History Correction
HRS1.1 Select Control
HRSC.1 Select Control
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA15.1 Medical
PA15.2 Work Restriction and Accommodation
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PA54.1 Personnel Action History Correction
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR13.1 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR30.2 Employee Automatic Time Record
PR512 Employee ACH Distribution Interface
ZH510 Update PCP from ZPENDPCP

Referenced by (6)

HR170 Human Resource Writer Report Request
HR70.1 Human Resource Writer Inquiry
HS11.1 Web Competency Profile
HS11.2 Web Competency Profile
PA215 Medical Listing
PA311 Employee Profile