PAEMPAPP – No description in the Lawson data dictionary

System: Personnel (PA)
Prefix: PPP
Primary key: COMPANY, APPLICANT, EMPLOYEE
Fields: 3
Updated by: 42 programs
Referenced by: 32 programs

PAEMPAPP is a Lawson Personnel table (prefix PPP); no description in the lawson data dictionary. It is indexed by COMPANY, APPLICANT, EMPLOYEE (PPPSET1); alternate indexes: PPPSET2. It is related 1:1 to APPLICANT and EMPLOYEE. It is updated by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 and 34 more and referenced by HR15.1, HR155, HR156, HR170, HR515, HR55.2, HR70.1, LP100 and 24 more. The table has 3 fields, 2 indexes and 2 documented relations.

About PAEMPAPP

No description in the Lawson data dictionary.

Fields (3)

Column = COBOL field name without the PPP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`PPP-COMPANY` PK COMPANY	Numeric 4	—	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +34 more
`PPP-APPLICANT` PK APPLICANT	Numeric 9	—	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +34 more
`PPP-EMPLOYEE` PK 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 +34 more

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PPPSET1`	`COMPANY`, `APPLICANT`, `EMPLOYEE`	Primary		HR511, PA520, PA533
`PPPSET2`	`COMPANY`, `EMPLOYEE`, `APPLICANT`			BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (42)

BN305 Highly Compensated Employees
HAP3.1 Applicant Option 4 Selection Invoke
HCRE.1 Action Reason Code Selects
HEP4.1 Employee Option 4 Selection Invoke
HPOS.1 Position Selection Invoke
HPQC.1 Prqcentgrp Select Invoke
HPRS.1 Process Level Select Invoke
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR28.1 Employee Ethnicity
HR511 Employee Conversion
HR54.1 Employee History Correction
HRS1.1 Select Control
HRSC.1 Select Control
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PA54.1 Personnel Action History Correction
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR13.1 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR30.2 Employee Automatic Time Record
PR512 Employee ACH Distribution Interface
ZH510 Update PCP from ZPENDPCP

Referenced by (32)

HR15.1 User Fields
HR155 Employee Group Update
HR156 Employee Group Company Update
HR170 Human Resource Writer Report Request
HR515 User Field Conversion
HR55.2 Employee Groups By Employees
HR70.1 Human Resource Writer Inquiry
LP100 Employee Absence Plan Update
LP101 Mass Absence Plan Add
LT11.5 HRM User Field Interface
LT13.5 HRM User Field Interface History
PA113 Retroactive History Update
PA16.1 Company Property
PA20.1 Education
PA21.1 Competencies
PA22.1 Certifications
PA24.1 Relocation
PA27.1 Contracts
PA272 Budget and Assigned Resource Listing
PA34.1 Applicant Education
PA35.1 Applicant Competencies
PA36.1 Applicant Certification
PA38.1 Applicant Relocation
PA520 Employee and Applicant Code Conversion
PA53.1 Personnel Action Workflow Override
PA533 Job History Conversion
PA66.3 Employee Action Detail
TR21.1 Employee Training History
TR22.1 Session Completion
TR26.1 Employee Training Competency Maintenance
TR500 Training Conversion
ZH156 Employee Group Company Update