Lawson Insight Technical Documentation |
|
PAEMPAPP
PAEMPAPP FILE
REFERENCED BY
PA520 PA533 HR15.1 HR155 HR170 HR515
HR55.2 HR650 HR70.1 PA02.1 PA113 PA13.1
PA13.2 PA16.1 PA20.1 PA21.1 PA22.1 PA24.1
PA27.1 PA272 PA34.1 PA35.1 PA36.1 PA38.1
PA502 PA513 PA53.1 PA66.3 TR21.1 TR22.1
TR26.1 TR500 PR110 PR113 PR120 PR13.1
PR13.5 PR13.6 PR13.8
UPDATED BY
HGLM.1 HPOS.1 HPQC.1 HPRS.1 HR511 HR54.1
HRS1.1 HRSC.1 PA100 PA102 PA52.1 PA52.3
PA52.4 PA52.5 PA54.1 PRSC.1 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PPP-COMPANY Numeric 4 HGLM.1 HPOS.1
Element: Company The company number represents an HPQC.1 HPRS.1
established company and is entered on HR511 HR54.1
all function codes. HRS1.1 HRSC.1
PA100 PA102
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PRSC.1
PPP-APPLICANT Numeric 9 HGLM.1 HPOS.1
Element: Applicant HPQC.1 HPRS.1
HR511 HR54.1
HRS1.1 HRSC.1
PA100 PA102
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PRSC.1
PPP-EMPLOYEE Numeric 9 HGLM.1 HPOS.1
Element: Employee Contains the employee number. Each HPQC.1 HPRS.1
person employed by the company is HR511 HR54.1
assigned a unique number. The system HRS1.1 HRSC.1
uses the employee number to correlate PA100 PA102
all of the information related to that PA52.1 PA52.3
person. PA52.4 PA52.5
PA54.1 PRSC.1
PAEMPAPP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PPPSET1 COMPANY HR511 PA520
APPLICANT PA533
EMPLOYEE
PPPSET2 COMPANY HGLM.1 HPOS.1
EMPLOYEE HPQC.1 HPRS.1
APPLICANT HR11.1 HR11.2
HR15.1 HR155
HR170 HR511
HR515 HR54.1
HR55.2 HR650
HR70.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
...
PAEMPAPP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Employee EMPLOYEE Required
When (PPP-EMPLOYEE != Zeroes )
PPP-COMPANY -> EMP-COMPANY
PPP-EMPLOYEE -> EMP-EMPLOYEE
|