PATSTSETUP – Contains test setup information.

System: Personnel (PA)
Prefix: PAP
Primary key: COMPANY, TEST
Fields: 51
Updated by: 3 programs
Referenced by: 53 programs

PATSTSETUP is the Contains test setup information. table in Lawson Personnel (prefix PAP). It is indexed by COMPANY, TEST (PAPSET1). It is related 1:1 to CUCODES, PRSYSTEM, GLMASTER, PATSTSETUP, PERSGROUP, PATSTRESLT and PCODES and 1:M to PAEMPAPTST, PATESTOVER, JOBRELATE and PATSTRESLT. It is updated by HR00.1, HR01.1 and PA48.1 and referenced by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 and 45 more. The table has 51 fields, 1 index and 22 documented relations.

About PATSTSETUP

Contains test setup information. Maintained primarily by PA49.1 (Employee Tests).

Fields (51)

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

Field / column	Type	Description & values	Updated by
`PAP-COMPANY` PK COMPANY	Numeric 4	—	PA48.1
`PAP-TEST` PK TEST	Alpha 10	Contains the test.	PA48.1
`PAP-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	Contains the test description.	PA48.1
`PAP-WEB-DESC` WEB_DESC	Alpha 15 (Lower Case)	—	PA48.1
`PAP-WEB-AVAILABLE` WEB_AVAILABLE	Alpha 1	Indicates whether the test is available via the World Wide Web. `N` No `Y` Yes	PA48.1
`PAP-WEB-AVAIL-SUPV` WEB_AVAIL_SUPV	Alpha 1	Indicates whether the test is available to the employee's supervisor via the World Wide Web. `1` Not Available `2` Direct Supervisor `3` Indirect Supervisor `4` Direct;Indirect Supv	PA48.1
`PAP-ACTIVE-FLAG` ACTIVE_FLAG	Alpha 1	Indicates whether the test is active or inactive. `A` Active `I` Inactive	PA48.1
`PAP-TEST-TYPE` TEST_TYPE	Alpha 10	Contains the user-defined test type.	PA48.1
`PAP-TEST-SOURCE` TEST_SOURCE	Alpha 10	Contains the user-defined test source.	PA48.1
`PAP-EMP-APP` EMP_APP	Numeric 1	Indicates whether the test applies to employees, applicants, or both. `1` Applicant `2` Employee `3` Applicant;Emp	PA48.1
`PAP-RESULT-FL` RESULT_FL	Alpha 1	Indicates the type of results used for the test. `1` None `2` Positive;Negative `3` Other	PA48.1
`PAP-USER-FIELD-1` USER_FIELD_1	Alpha 30	Contains user-defined test information.	PA48.1
`PAP-USER2` USER2	Alpha 10	Contains user-defined test information.	PA48.1
`PAP-USER3` USER3	Alpha 10	Contains user-defined test information.	PA48.1
`PAP-PREREQ-TEST` PREREQ_TEST	Alpha 10	Contains the test prerequisite.	PA48.1
`PAP-REQ-FLAG` REQ_FLAG	Alpha 1	Indicates whether the test prerequisite is required. `N` No `Y` Yes	PA48.1
`PAP-PREREQ-RESULT1` PREREQ_RESULT1	Alpha 10	Contains the first result for the prerequisite result range.	PA48.1
`PAP-PREREQ-RESULT2` PREREQ_RESULT2	Alpha 10	Contains the second result for the prerequisite result range.	PA48.1
`PAP-PREREQ-FLAG` PREREQ_FLAG	Alpha 1	Indicates whether the prerequisite period is measured by the date on which the perquisite test was schedule or the date on which the prerequisite test was completed. `1` Schedule Date `2` Status Date	PA48.1
`PAP-ELIG-FLAG` ELIG_FLAG	Alpha 1	Indicates whether all employees or only specified employees are eligible for the test. `1` All Paid Employees `2` Specified Criteria	PA48.1
`PAP-TEST-COPY` TEST_COPY	Alpha 10	Indicates the test from which eligibility criteria is copied.	PA48.1
`PAP-GROUP-NAME` GROUP_NAME	Alpha 10	Contains the employee group.	PA48.1
`PAP-EMP-STATUS` EMP_STATUS	Alpha 2 Occurs 10 Times ×10	Contains the employee status.	PA48.1
`PAP-POS-FLAG` POS_FLAG	Alpha 1	Indicates whether employees who hold specific positions or jobs are eligible for the test. `N` No `Y` Yes	PA48.1
`PAP-DATE-MEASURE` DATE_MEASURE	Numeric 3	Indicates the period in which the test needs to be renewed.	PA48.1
`PAP-UNIT-TYPE` UNIT_TYPE	Alpha 1	Indicates the unit of measure for the date measure. `1` Days `2` Months `3` Years	PA48.1
`PAP-RENEW-FLAG` RENEW_FLAG	Alpha 1	Indicates whether the renewal date is measured by the date on which the test is scheduled or by the date on which the test was completed. `1` Schedule Date `2` Status Date	PA48.1
`PAP-RENEW-TEST` RENEW_TEST	Alpha 10	Contains the renewal test name.	PA48.1
`PAP-RESULT1` RESULT1	Alpha 10	Contains the first result for the test.	PA48.1
`PAP-RESULT2` RESULT2	Alpha 10	Contains the second result for the test.	PA48.1
`PAP-DATE-MEASURE2` DATE_MEASURE2	Numeric 3	Indicates the time period during which a follow up test must be taken.	PA48.1
`PAP-DATE-MEASURE3` DATE_MEASURE3	Numeric 3	Indicates the time period during which the employee needs to complete the prerequisite.	PA48.1
`PAP-UNIT-TYPE2` UNIT_TYPE2	Alpha 1	Indicates the unit of measure for the date measure 2. `1` Days `2` Months `3` Years	PA48.1
`PAP-UNIT-TYPE3` UNIT_TYPE3	Alpha 1	Indicates the unit of measure for the date measure 3. `1` Days `2` Months `3` Years	PA48.1
`PAP-FOLLOW-UP-FLAG` FOLLOW_UP_FLAG	Alpha 1	Indicates whether the follow up period is measured from the date on which the test is scheduled or the date on which the test is completed. `1` Schedule Date `2` Status Date	PA48.1
`PAP-FOLLOW-TEST` FOLLOW_TEST	Alpha 10	Contains the name of the follow up test.	PA48.1
`PAP-LETTER` LETTER	Alpha 10	Contains the user-defined follow up letter type.	PA48.1
`PAP-TEST-LOCATION` TEST_LOCATION	Alpha 10	Contains the follow up test location.	PA48.1
`PAP-EXP-COMPANY` EXP_COMPANY	Numeric 4	Contains the distribution expense company to which the test costs should be posted.	PA48.1
`PAP-EXP-ACCT-UNIT` EXP_ACCT_UNIT	Alpha 15	Contains the expense accounting unit to which the test costs should be posted.	PA48.1
`PAP-EXP-ACCOUNT` EXP_ACCOUNT	Numeric 6	Contains the expense account to which the test costs should be posted.	PA48.1
`PAP-EXP-SUB-ACCT` EXP_SUB_ACCT	Numeric 4	Contains the general ledger sub account to which the test costs should be posted.	PA48.1
`PAP-COST` COST	Signed 11.2	Contains the test cost.	PA48.1
`PAP-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	PA48.1
`PAP-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	PA48.1
`PAP-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	PA48.1
`PAP-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	Contains the currency in which the test cost is recorded.	PA48.1
`PAP-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	PA48.1
`PAP-BASE-CURRENCY` BASE_CURRENCY	Alpha 5	Contains the company's base currency.	PA48.1
`PAP-BASE-ND` BASE_ND	Numeric 1	The number of decimal positions defined for the company base currency.	PA48.1
`PAP-BASE-AMOUNT` BASE_AMOUNT	Signed 15.2	Contains the test cost in the company's base currency.	PA48.1

Indexes (1)

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
`PAPSET1`	`COMPANY`, `TEST`	Primary		BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR00.1 +22 more (list truncated in source)

Relations

One to one (17) — lookups and parents

Relation	Table	Rules	Condition	Field map
Base Currency	CUCODES	Required	When (PAP-CURRENCY-CODE != Spaces)	`PAP-BASE-CURRENCY` → `CUC-CURRENCY-CODE`
Company	PRSYSTEM	Required		`PAP-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Currency	CUCODES	Required	When (PAP-CURRENCY-CODE != Spaces)	`PAP-CURRENCY-CODE` → `CUC-CURRENCY-CODE`
Exp Account	GLMASTER	Required	When (PAP-EXP-ACCOUNT != Zeroes)	`PAP-EXP-COMPANY` → `GLM-COMPANY`, `PAP-EXP-ACCT-UNIT` → `GLM-ACCT-UNIT`, `PAP-EXP-ACCOUNT` → `GLM-ACCOUNT`, `PAP-EXP-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Follow Test	PATSTSETUP	Required	When (PAP-FOLLOW-TEST != Spaces)	`PAP-COMPANY` → `PAP-COMPANY`, `PAP-FOLLOW-TEST` → `PAP-TEST`
Group	PERSGROUP	Required	When (PAP-GROUP-NAME != Spaces)	`PAP-COMPANY` → `PRG-COMPANY`, `PAP-GROUP-NAME` → `PRG-GROUP-NAME`
Prereq Result1	PATSTRESLT	Required	When (PAP-PREREQ-RESULT1 != Spaces)	`PAP-COMPANY` → `PTR-COMPANY`, `PAP-PREREQ-TEST` → `PTR-TEST`, `PAP-PREREQ-RESULT1` → `PTR-CODE`
Prereq Result2	PATSTRESLT	Required	When (PAP-PREREQ-RESULT2 != Spaces)	`PAP-COMPANY` → `PTR-COMPANY`, `PAP-PREREQ-TEST` → `PTR-TEST`, `PAP-PREREQ-RESULT2` → `PTR-CODE`
Prereq Test	PATSTSETUP	Required	When (PAP-PREREQ-TEST != Spaces)	`PAP-COMPANY` → `PAP-COMPANY`, `PAP-PREREQ-TEST` → `PAP-TEST`
Renew Test	PATSTSETUP	Required	When (PAP-RENEW-TEST != Spaces)	`PAP-COMPANY` → `PAP-COMPANY`, `PAP-RENEW-TEST` → `PAP-TEST`
Result1	PATSTRESLT	Required	When (PAP-RESULT1 != Spaces)	`PAP-COMPANY` → `PTR-COMPANY`, `PAP-TEST` → `PTR-TEST`, `PAP-RESULT1` → `PTR-CODE`
Result2	PATSTRESLT	Required	When (PAP-RESULT2 != Spaces)	`PAP-COMPANY` → `PTR-COMPANY`, `PAP-TEST` → `PTR-TEST`, `PAP-RESULT2` → `PTR-CODE`
Test Copy	PATSTSETUP	Required	When (PAP-TEST-COPY != Spaces)	`PAP-COMPANY` → `PAP-COMPANY`, `PAP-TEST-COPY` → `PAP-TEST`
Test Letter	PCODES	Required	When (PAP-LETTER != Spaces)	`"TL"` → `PCO-TYPE`, `PAP-LETTER` → `PCO-CODE`
Test Location	PCODES	Required	When (PAP-TEST-LOCATION != Spaces)	`"TO"` → `PCO-TYPE`, `PAP-TEST-LOCATION` → `PCO-CODE`
Test Source	PCODES	Required	When (PAP-TEST-SOURCE != Spaces)	`"TS"` → `PCO-TYPE`, `PAP-TEST-SOURCE` → `PCO-CODE`
Test Type	PCODES	Required	When (PAP-TEST-TYPE != Spaces)	`"TT"` → `PCO-TYPE`, `PAP-TEST-TYPE` → `PCO-CODE`

One to many (5) — child tables

Relation	Table	Field map
Applicants	PAEMPAPTST	`PAP-COMPANY` → `PTS-COMPANY`, `PAP-TEST` → `PTS-TEST`, `1` → `PTS-EMP-APP`, → `PTS-EMPLOYEE`, → `PTS-SEQ-NBR`
Employees	PAEMPAPTST	`PAP-COMPANY` → `PTS-COMPANY`, `PAP-TEST` → `PTS-TEST`, `Zeroes` → `PTS-EMP-APP`, → `PTS-EMPLOYEE`, → `PTS-SEQ-NBR`
Override	PATESTOVER	`PAP-COMPANY` → `PAV-COMPANY`, `PAP-TEST` → `PAV-TEST`, → `PAV-EMPLOYEE`
Pos Job Req	JOBRELATE	`PAP-COMPANY` → `JBR-COMPANY`, `Spaces` → `JBR-PROCESS-LEVEL`, `"TS"` → `JBR-TYPE`, `PAP-TEST` → `JBR-PERS-CODE`, → `JBR-SUBJECT-CODE`, → `JBR-JOB-CODE`, → `JBR-POSITION`
Results	PATSTRESLT	`PAP-COMPANY` → `PTR-COMPANY`, `PAP-TEST` → `PTR-TEST`, → `PTR-CODE`

Programs

Updated by (3)

HR00.1 Company
HR01.1 Process Level
PA48.1 Test Setup

Referenced by (53)

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
HR55.1 Employee Group Definition
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
PA149 Update Scheduled Tests
PA248 Test Listing
PA249 Employee and Applicant Test Listing
PA349 Employee and Applicant Test Purge
PA49.1 Employee Tests
PA49.2 Employee Test Eligibility Override
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
PA81.1 Employee Test Inquiry
PA81.2 Test Inquiry
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