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.

REFERENCED BY
HR170 HR70.1 HS11.1 HS11.2 PA215 PA311


UPDATED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR11.1 HR11.2 HR11.4 HR28.1 HR511
HR54.1 HRS1.1 HRSC.1 LT101 LT111 ZH510
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 PR512

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 HR11.4
HR28.1 HR511
HR54.1 HRS1.1
HRSC.1 LT101
LT111 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
PR512 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 HR11.4
HR28.1 HR511
HR54.1 HRS1.1
HRSC.1 LT101
LT111 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
PR512 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 HR11.4
HR28.1 HR511
HR54.1 HRS1.1
HRSC.1 LT101
LT111 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
PR512 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 HR11.4
HR28.1 HR511
HR54.1 HRS1.1
HRSC.1 LT101
LT111 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
PR512 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 HR11.4
HR28.1 HR511
HR54.1 HRS1.1
HRSC.1 LT101
LT111 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
PR512 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 HR11.4
HR28.1 HR511
HR54.1 HRS1.1
HRSC.1 LT101
LT111 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
PR512 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 HR11.4
HR28.1 HR511
HR54.1 HRS1.1
HRSC.1 LT101
LT111 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
PR512 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 HR11.4
HR28.1 HR511
HR54.1 HRS1.1
HRSC.1 LT101
LT111 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
PR512 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 HR11.4
HR28.1 HR511
HR54.1 HRS1.1
HRSC.1 LT101
LT111 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
PR512 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 HR11.4
HR28.1 HR511
HR54.1 HRS1.1
HRSC.1 LT101
LT111 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
PR512 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 02:25:01 2016

Home
Contact Us



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