PAMEDICAL

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.
UPDATED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR11.1 HR11.2 HR170 HR28.1 HR511
HR54.1 HR70.1 HRS1.1 HRSC.1 LT101 ZH510
HS11.1 HS11.2 PA02.1 PA100 PA102 PA115
PA13.1 PA13.2 PA15.1 PA15.2 PA215 PA311
PA502 PA513 PA52.1 PA52.3 PA52.4 PA52.5
PA54.1 PR110 PR113 PR12.6 PR120 PR13.1
PR13.5 PR13.6 PR13.8 PR13.9 PR30.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PMD-COMPANY
Element: Company Hr
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
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PMD-EMPLOYEE
Element: 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
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PMD-TYPE
Element: 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
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PMD-CODE
Element: 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
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PMD-BEG-DATE
Element: 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
Element: 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
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
PA15.1 PA15.2
PMD-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PMD-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PMD-CREATE-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PMD-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PMD-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PMD-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510


PAMEDICAL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PMDSET1 COMPANY
EMPLOYEE
TYPE
CODE
SEQ-NBR
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


PAMEDICAL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:22:16 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.