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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PMD-COMPANY PK
COMPANY		Numeric 4Contains 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 9Contains 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 2Indicates 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 10Contains 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 SET2
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 4An 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PMDSET1
  1. COMPANY
  2. EMPLOYEE
  3. TYPE
  4. CODE
  5. SEQ-NBR
PrimaryHR11.1, HR170, HR70.1, HS11.1, HS11.2, PA115, PA15.1, PA15.2
PMDSET2
  1. COMPANY
  2. EMPLOYEE
  3. TYPE
  4. CODE
  5. BEG-DATE ↓
  6. SEQ-NBR
KeyChangePA15.1, PA15.2, PA215, PA311

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMEMPLOYEEPCODESPAEMPLOYEEPAMEDICAL

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PMD-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
PMD-COMPANY→EMP-COMPANY
PMD-EMPLOYEE→EMP-EMPLOYEE
Hr CodePCODESRequired
PMD-TYPE→PCO-TYPE
PMD-CODE→PCO-CODE
Pa EmployeePAEMPLOYEERequired
PMD-COMPANY→PEM-COMPANY
PMD-EMPLOYEE→PEM-EMPLOYEE

Programs

Updated by (44)

Referenced by (6)