Lawson Insight Technical Documentation |
|
PAEMPAPP
PAEMPAPP FILE
REFERENCED BY
PA520 PA533 HR15.1 HR155 HR170 HR515
HR55.2 HR70.1 LP100 LP101 PA113 PA16.1
PA20.1 PA21.1 PA22.1 PA24.1 PA27.1 PA272
PA34.1 PA35.1 PA36.1 PA38.1 PA53.1 PA66.3
TR21.1 TR22.1 TR26.1 TR500
UPDATED BY
BN305 HAP3.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
PA502 PA513 PA52.1 PA52.3 PA52.4 PA52.5
PA54.1 PR110 PR113 PR120 PR13.1 PR13.5
PR13.6 PR13.8
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PPP-COMPANY Numeric 4 BN305 HAP3.1
Element: Company Hr 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
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PPP-APPLICANT Numeric 9 BN305 HAP3.1
Element: Applicant 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
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PPP-EMPLOYEE Numeric 9 BN305 HAP3.1
Element: Employee Contains the employee number. Each HEP4.1 HPOS.1
person employed by the company is HPQC.1 HPRS.1
assigned a unique number. The system HR11.1 HR11.2
uses the employee number to correlate HR511 HR54.1
all of the information related to that HRS1.1 HRSC.1
person. PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PAEMPAPP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PPPSET1 COMPANY HR511 PA520
APPLICANT PA533
EMPLOYEE
PPPSET2 COMPANY BN305 HAP3.1
EMPLOYEE HEP4.1 HPOS.1
APPLICANT HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR170 HR511
HR515 HR54.1
HR55.2 HR70.1
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA16.1
PA20.1 PA21.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
|