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.