PAEMPAPP

REFERENCED BY
PA520 PA533 HR15.1 HR155 HR156 HR170
HR515 HR55.2 HR70.1 LT11.5 LT13.5 ZH156
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 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
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
PPP-COMPANY
Element: Company Hr		Numeric 4
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 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
PPP-APPLICANT
Element: Applicant		Numeric 9
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 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
PPP-EMPLOYEE
Element: Employee		Numeric 9
Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.
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 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


PAEMPAPP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PPPSET1 COMPANY
APPLICANT
EMPLOYEE
HR511 PA520
PA533
PPPSET2 COMPANY
EMPLOYEE
APPLICANT
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HR156 HR170
HR28.1 HR511
HR515 HR54.1
HR55.2 HR70.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
ZH156 ZH510
LP100 LP101


PAEMPAPP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 02:24:55 2016

Home
Contact Us



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