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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#PPP-COMPANY PKCOMPANY | Numeric 4 | — | BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +34 more |
#PPP-APPLICANT PKAPPLICANT | Numeric 9 | — | BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +34 more |
#PPP-EMPLOYEE PKEMPLOYEE | 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PPPSET1 |
| Primary | HR511, PA520, PA533 | |
PPPSET2 |
| 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
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