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
|