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
|