Lawson Insight Technical Documentation |
|
PAMEDICAL
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 PA215 PA311
UPDATED BY
HGLM.1 HPOS.1 HPQC.1 HPRS.1 HR54.1 HRS1.1
HRSC.1 PA100 PA102 PA15.1 PA15.2 PA52.1
PA52.3 PA52.4 PA52.5 PA54.1 PRSC.1 HR11.1
PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PMD-COMPANY Numeric 4 HGLM.1 HPOS.1
Element: Company Contains the company number which HPQC.1 HPRS.1
represents an established company. HR54.1 HRS1.1
HRSC.1 PA100
PA102 PA15.1
PA15.2 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PRSC.1
PMD-EMPLOYEE Numeric 9 HGLM.1 HPOS.1
Element: Employee Contains the employee's number. It is HPQC.1 HPRS.1
use to correlate all information related HR54.1 HRS1.1
to the employee. HRSC.1 PA100
PA102 PA15.1
PA15.2 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PRSC.1
PMD-TYPE Alpha 2 HGLM.1 HPOS.1
Element: Type Indicates whether the condition is an HPQC.1 HPRS.1
emergency medical or a work restriction. HR54.1 HRS1.1
EM = Emergency Medical HRSC.1 PA100
WR = Work Restriction PA102 PA15.1
AC = Accomodation PA15.2 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PRSC.1
PMD-CODE Alpha 10 HGLM.1 HPOS.1
Element: Code Contains the emergency medical HPQC.1 HPRS.1
condition or work restriction. HR54.1 HRS1.1
HRSC.1 PA100
PA102 PA15.1
PA15.2 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PRSC.1
PMD-BEG-DATE Numeric 8 (yyyymmdd) PA15.1 PA15.2
Element: 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: Date Contains the ending date of the
emergency medical condition or work
restriction period.
PMD-SEQ-NBR Numeric 4 PA15.1 PA15.2
Element: Sequence NumbeAn 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 PA115 PA15.1
CODE 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
|