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
HR54.1 HRS1.1 HRSC.1 PA54.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PMD-COMPANY Numeric 4 HR54.1 HRS1.1
Company Contains the company number which HRSC.1 PA54.1
represents an established company.
PMD-EMPLOYEE Numeric 9 HR54.1 HRS1.1
Employee Contains the employee's number. It is HRSC.1 PA54.1
use to correlate all information related
to the employee.
PMD-TYPE Alpha 2 HR54.1 HRS1.1
Type Indicates whether the condition is an HRSC.1 PA54.1
emergency medical or a work restriction.
EM = Emergency Medical
WR = Work Restriction
AC = Accomodation
PMD-CODE Alpha 10 HR54.1 HRS1.1
Code Contains the emergency medical HRSC.1 PA54.1
condition or work restriction.
PMD-BEG-DATE Numeric 8 (yyyymmdd)
Beginning Date Contains the beginning date of the
emergency medical condition or work
restriction period.
PMD-END-DATE Numeric 8 (yyyymmdd)
Ending Date Contains the ending date of the
emergency medical condition or work
restriction period.
PMD-SEQ-NBR Numeric 4
Sequence Number An automatically assigned sequence
number.
PAMEDICAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PMDSET1 COMPANY HR170 HR70.1
EMPLOYEE HS11.1
TYPE
CODE
SEQ-NBR
PMDSET2 COMPANY KeyChange PA215 PA311
EMPLOYEE
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
|
