Lawson Insight Technical Documentation |
|
PAEMPAPP
PAEMPAPP FILE
REFERENCED BY
PA520 PA533 HR15.1 HR155 HR170 HR515
HR55.2 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
HAP3.1 HEP4.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 HAP3.1 HEP4.1
Element: Company Hr Identifies the AP company if the HPOS.1 HPQC.1
resource type = V. Identifies the HR HPRS.1 HR511
company if the resource type = E. It is HR54.1 HRS1.1
blank for type A, P or Q resources. HRSC.1 PA100
PA102 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PRSC.1
PPP-APPLICANT Numeric 9 HAP3.1 HEP4.1
Element: Applicant 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
PPP-EMPLOYEE Numeric 9 HAP3.1 HEP4.1
Element: Employee Contains the employee number. Each HPOS.1 HPQC.1
person employed by the company is HPRS.1 HR511
assigned a unique number. The system HR54.1 HRS1.1
uses the employee number to correlate HRSC.1 PA100
all of the information related to that PA102 PA52.1
person. PA52.3 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 HAP3.1 HEP4.1
EMPLOYEE HPOS.1 HPQC.1
APPLICANT HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR170
HR511 HR515
HR54.1 HR55.2
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
Applicant APPLICANT Required
When PPP-APPLICANT != Zeroes
PPP-COMPANY -> APL-COMPANY
PPP-APPLICANT -> APL-APPLICANT
Employee EMPLOYEE Required
When (PPP-EMPLOYEE != Zeroes )
PPP-COMPANY -> EMP-COMPANY
PPP-EMPLOYEE -> EMP-EMPLOYEE
|