PAEMPAPP

UPDATED BY
BN305 HAP3.1 HCRE.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 PR13.9 PA520 PA533
HR15.1 HR155 HR156 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

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 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 PR13.9
PPP-APPLICANT
Element: Applicant		Numeric 9
BN305 HAP3.1
HCRE.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 PR13.9
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 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 PR13.9


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 HR15.1
HR155 HR156
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


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: Wed Jun 08 20:50:23 2016

Home
Contact Us



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