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 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 PR13.9
HR170 HR70.1 HS11.1 HS11.2 PA215 PA311

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 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 PR13.9
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 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 PR13.9
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 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 PR13.9
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 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 PR13.9
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 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 PR13.9
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 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 PR13.9
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 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 PR13.9
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 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 PR13.9
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 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 PR13.9
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 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 PR13.9


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: Wed Jun 08 20:50:25 2016

Home
Contact Us



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