PAEMPAPTST – Contains employee test information.
- System
- Personnel (PA)
- Prefix
PTS- Primary key
COMPANY,EMP-APP,EMPLOYEE,TEST,SEQ-NBR- Fields
- 28
- Updated by
- 50 programs
- Referenced by
- 6 programs
PAEMPAPTST is the Contains employee test information. table in Lawson Personnel (prefix PTS). It is indexed by COMPANY, EMP-APP, EMPLOYEE, TEST, SEQ-NBR (PTSSET1); alternate indexes: PTSSET2, PTSSET3, PTSSET4, PTSSET5 and PTSSET6. It is related 1:1 to APPLICANT, PRSYSTEM, EMPLOYEE, OSHESTAB, PATSTSETUP, OSHA, PCODES, PAEMPLOYEE and 1 more. It is updated by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR00.1 and 42 more and referenced by PA248, PA249, PA48.1, PA81.1, PA81.2 and ZH500. The table has 28 fields, 6 indexes and 13 documented relations.
About PAEMPAPTST
Contains employee test information. This file is maintained primarily by PA49.1 (Employee Tests).
Fields (28)
Column = COBOL field name without the PTS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PTS-COMPANY PKCOMPANY | Numeric 4 | — | PA149, PA49.1, PA49.3, PA549 |
PTS-EMP-APP PKEMP_APP | Numeric 1 | Indicates whether the person is an external or internal applicant. An external applicant is a person applying from outside the company; an internal applicant is an employee applying from inside the company.
| BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +38 more |
PTS-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 +38 more |
PTS-TEST PKTEST | Alpha 10 | Contains the test. | PA149, PA49.1, PA49.3, PA549 |
PTS-SEQ-NBR PKSEQ_NBR | Numeric 4 | An automatically assigned sequence number. | PA149, PA49.1, PA49.3, PA549 |
PTS-SCHED-DATESCHED_DATE | Numeric 8 (yyyymmdd) | Contains the date on which the test is scheduled. | PA149, PA49.1, PA49.3, PA549 |
PTS-STATUSSTATUS | Numeric 1 | Contains the status for the test.
| PA149, PA49.1, PA49.3, PA549 |
PTS-EFFECT-DATEEFFECT_DATE | Numeric 8 (yyyymmdd) | Contains the date on which the status is effective. | PA149, PA49.1, PA49.3, PA549 |
PTS-RESULT1RESULT1 | Alpha 10 | Contains the test result. | PA149, PA49.1, PA49.3, PA549 |
PTS-RESULT-DESCRESULT_DESC | Alpha 40 (Lower Case) | Contains the result description. | PA149, PA49.1, PA49.3, PA549 |
PTS-NEXT-DATENEXT_DATE | Numeric 8 (yyyymmdd) | Contains the date of the next follow up test. | PA149, PA49.1, PA49.3, PA549 |
PTS-REASONREASON | Alpha 10 | Contains the reason for the test. | PA149, PA49.1, PA49.3, PA549 |
PTS-NOTIFY-DATENOTIFY_DATE | Numeric 8 (yyyymmdd) | Contains the date on which the employee is notified. | PA149, PA49.1, PA49.3, PA549 |
PTS-NOTIFY-TYPENOTIFY_TYPE | Alpha 10 | Contains the method by which the employee is notified of the test. | PA149, PA49.1, PA49.3, PA549 |
PTS-ESTABLISHMENTESTABLISHMENT | Alpha 10 | If the test is the result of an incident, this field contains the establishment where the incident occurred. | PA149, PA49.1, PA49.3, PA549 |
PTS-INCIDENT-NBRINCIDENT_NBR | Numeric 4 | If the test is a result of an incident, this field contains the incident number. | PA149, PA49.1, PA49.3, PA549 |
PTS-REFUSE-REASONREFUSE_REASON | Alpha 10 | Contains the reason the employee refused to take the test. | PA149, PA49.1, PA49.3, PA549 |
PTS-RENEW-DATERENEW_DATE | Numeric 8 (yyyymmdd) | Contains the date for the renewal test. | PA149, PA49.1, PA49.3, PA549 |
PTS-RENEW-TESTRENEW_TEST | Alpha 10 | Contains the renewal test. | PA149, PA49.1, PA49.3, PA549 |
PTS-FOLLOW-DATEFOLLOW_DATE | Numeric 8 (yyyymmdd) | Contains the date for the follow up test. | PA149, PA49.1, PA49.3, PA549 |
PTS-FOLLOW-TESTFOLLOW_TEST | Alpha 10 | Contains the follow up test. | PA149, PA49.1, PA49.3, PA549 |
PTS-COMMENTCOMMENT | Alpha 40 (Lower Case) | Contains comments about the follow up test. | PA149, PA49.1, PA49.3, PA549 |
PTS-OBJ-IDOBJ_ID | Numeric 12 | This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. | BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +38 more |
PTS-PARENT-OBJ-IDPARENT_OBJ_ID | Numeric 12 | This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. | BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +38 more |
PTS-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | This field contains the server date (month, date, and year) of the last change to this record. | PA149, PA49.1, PA49.3, PA549 |
PTS-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | Contains the server time (hour, minute, and second) when the record was last changed. | PA149, PA49.1, PA49.3, PA549 |
PTS-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | PA149, PA49.1, PA49.3, PA549 |
PTS-WF-EMP-TST-SEQWF_EMP_TST_SEQ | Derived | — | — |
Indexes (6)
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 |
|---|---|---|---|---|
PTSSET1 | COMPANY, EMP-APP, EMPLOYEE, TEST, SEQ-NBR | Primary | BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR00.1 +22 more (list truncated in source) | |
PTSSET2 | PARENT-OBJ-ID, OBJ-ID | KeyChange | PA149, PA248, PA249, PA349, PA49.1, PA49.3, PA549 | |
PTSSET3 | COMPANY, NEXT-DATE, TEST, EMP-APP, EMPLOYEE, SEQ-NBR | KeyChange, Subset | Where (NEXT-DATE != Zeroes) | PA149 |
PTSSET4 | COMPANY, TEST, EMP-APP, EMPLOYEE, SEQ-NBR* | KeyChange | PA149, PA248, PA349, PA48.1, PA49.1, PA49.3, PA549, PA81.2 | |
PTSSET5 | COMPANY, EMP-APP, EMPLOYEE, TEST, SCHED-DATE*, SEQ-NBR | KeyChange | PA149, PA249, PA49.1, PA49.2, PA49.3, PA549, PA81.1 | |
PTSSET6 | COMPANY, SCHED-DATE, TEST, EMP-APP, EMPLOYEE, SEQ-NBR | KeyChange, Subset | Where STATUS < 3 | PA149 |
Relations
One to one (13) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Applicant | APPLICANT | Required | When (PTS-EMP-APP = 1) | PTS-COMPANY → APL-COMPANY, PTS-EMPLOYEE → APL-APPLICANT |
| Company | PRSYSTEM | Required | PTS-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL | |
| Employee | EMPLOYEE | Required | When (PTS-EMP-APP = Zeroes) | PTS-COMPANY → EMP-COMPANY, PTS-EMPLOYEE → EMP-EMPLOYEE |
| Establishment | OSHESTAB | Required | When (PTS-ESTABLISHMENT != Spaces) | PTS-COMPANY → OTB-COMPANY, PTS-ESTABLISHMENT → OTB-ESTABLISHMENT |
| Follow Test | PATSTSETUP | Required | When (PTS-FOLLOW-TEST != Spaces) | PTS-COMPANY → PAP-COMPANY, PTS-FOLLOW-TEST → PAP-TEST |
| Incident | OSHA | Required | When (PTS-INCIDENT-NBR != Zeroes) | PTS-COMPANY → OSH-COMPANY, PTS-EMPLOYEE → OSH-EMPLOYEE, PTS-ESTABLISHMENT → OSH-ESTABLISHMENT, PTS-INCIDENT-NBR → OSH-SEQ-NBR |
| Notify Type | PCODES | Required | When (PTS-NOTIFY-TYPE != Spaces) | "TN" → PCO-TYPE, PTS-NOTIFY-TYPE → PCO-CODE |
| Paemployee | PAEMPLOYEE | Required | When (PTS-EMP-APP = Zeroes) | PTS-COMPANY → PEM-COMPANY, PTS-EMPLOYEE → PEM-EMPLOYEE |
| Reason | PCODES | Required | When (PTS-REASON != Spaces) | "TA" → PCO-TYPE, PTS-REASON → PCO-CODE |
| Refusal | PCODES | Required | When (PTS-REFUSE-REASON != Spaces) | "TF" → PCO-TYPE, PTS-REFUSE-REASON → PCO-CODE |
| Renew Test | PATSTSETUP | Required | When (PTS-RENEW-TEST != Spaces) | PTS-COMPANY → PAP-COMPANY, PTS-RENEW-TEST → PAP-TEST |
| Results | PATSTRESLT | Required | When (PTS-RESULT1 != Spaces) | PTS-COMPANY → PTR-COMPANY, PTS-TEST → PTR-TEST, PTS-RESULT1 → PTR-CODE |
| Test | PATSTSETUP | Required | PTS-COMPANY → PAP-COMPANY, PTS-TEST → PAP-TEST |
Programs
Updated by (50)
- 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
- HR00.1 Company
- HR01.1 Process Level
- 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
- PA120 Applicant Purge
- PA13.1 Multiple Positions and Jobs
- PA13.2 Multiple Position and Job History
- PA149 Update Scheduled Tests
- PA349 Employee and Applicant Test Purge
- PA49.1 Employee Tests
- PA49.3 Applicant Tests
- 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
- PA549 Employee and Applicant Test Conversion
- 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