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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PAP-COMPANY PK
COMPANY		Numeric 4—PA48.1
#PAP-TEST PK
TEST		Alpha 10Contains 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 1Indicates whether the test is available via the World Wide Web.
  • N No
  • Y Yes
PA48.1
#PAP-WEB-AVAIL-SUPV
WEB_AVAIL_SUPV		Alpha 1Indicates 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 1Indicates whether the test is active or inactive.
  • A Active
  • I Inactive
PA48.1
#PAP-TEST-TYPE
TEST_TYPE		Alpha 10Contains the user-defined test type.PA48.1
#PAP-TEST-SOURCE
TEST_SOURCE		Alpha 10Contains the user-defined test source.PA48.1
#PAP-EMP-APP
EMP_APP		Numeric 1Indicates whether the test applies to employees, applicants, or both.
  • 1 Applicant
  • 2 Employee
  • 3 Applicant;Emp
PA48.1
#PAP-RESULT-FL
RESULT_FL		Alpha 1Indicates 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 30Contains user-defined test information.PA48.1
#PAP-USER2
USER2		Alpha 10Contains user-defined test information.PA48.1
#PAP-USER3
USER3		Alpha 10Contains user-defined test information.PA48.1
#PAP-PREREQ-TEST
PREREQ_TEST		Alpha 10Contains the test prerequisite.PA48.1
#PAP-REQ-FLAG
REQ_FLAG		Alpha 1Indicates whether the test prerequisite is required.
  • N No
  • Y Yes
PA48.1
#PAP-PREREQ-RESULT1
PREREQ_RESULT1		Alpha 10Contains the first result for the prerequisite result range.PA48.1
#PAP-PREREQ-RESULT2
PREREQ_RESULT2		Alpha 10Contains the second result for the prerequisite result range.PA48.1
#PAP-PREREQ-FLAG
PREREQ_FLAG		Alpha 1Indicates 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 1Indicates 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 10Indicates the test from which eligibility criteria is copied.PA48.1
#PAP-GROUP-NAME
GROUP_NAME		Alpha 10Contains the employee group.PA48.1
#PAP-EMP-STATUS
EMP_STATUS		Alpha 2 Occurs 10 Times ×10Contains the employee status.PA48.1
#PAP-POS-FLAG
POS_FLAG		Alpha 1Indicates 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 3Indicates the period in which the test needs to be renewed.PA48.1
#PAP-UNIT-TYPE
UNIT_TYPE		Alpha 1Indicates the unit of measure for the date measure.
  • 1 Days
  • 2 Months
  • 3 Years
PA48.1
#PAP-RENEW-FLAG
RENEW_FLAG		Alpha 1Indicates 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 10Contains the renewal test name.PA48.1
#PAP-RESULT1
RESULT1		Alpha 10Contains the first result for the test.PA48.1
#PAP-RESULT2
RESULT2		Alpha 10Contains the second result for the test.PA48.1
#PAP-DATE-MEASURE2
DATE_MEASURE2		Numeric 3Indicates the time period during which a follow up test must be taken.PA48.1
#PAP-DATE-MEASURE3
DATE_MEASURE3		Numeric 3Indicates the time period during which the employee needs to complete the prerequisite.PA48.1
#PAP-UNIT-TYPE2
UNIT_TYPE2		Alpha 1Indicates the unit of measure for the date measure 2.
  • 1 Days
  • 2 Months
  • 3 Years
PA48.1
#PAP-UNIT-TYPE3
UNIT_TYPE3		Alpha 1Indicates 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 1Indicates 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 10Contains the name of the follow up test.PA48.1
#PAP-LETTER
LETTER		Alpha 10Contains the user-defined follow up letter type.PA48.1
#PAP-TEST-LOCATION
TEST_LOCATION		Alpha 10Contains the follow up test location.PA48.1
#PAP-EXP-COMPANY
EXP_COMPANY		Numeric 4Contains the distribution expense company to which the test costs should be posted.PA48.1
#PAP-EXP-ACCT-UNIT
EXP_ACCT_UNIT		Alpha 15Contains the expense accounting unit to which the test costs should be posted.PA48.1
#PAP-EXP-ACCOUNT
EXP_ACCOUNT		Numeric 6Contains the expense account to which the test costs should be posted.PA48.1
#PAP-EXP-SUB-ACCT
EXP_SUB_ACCT		Numeric 4Contains the general ledger sub account to which the test costs should be posted.PA48.1
#PAP-COST
COST		Signed 11.2Contains 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 5Contains the currency in which the test cost is recorded.PA48.1
#PAP-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.PA48.1
#PAP-BASE-CURRENCY
BASE_CURRENCY		Alpha 5Contains the company's base currency.PA48.1
#PAP-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.PA48.1
#PAP-BASE-AMOUNT
BASE_AMOUNT		Signed 15.2Contains the test cost in the company's base currency.PA48.1

Indexes (1)

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.

IndexKeysFlagsConditionUsed in
PAPSET1
  1. COMPANY
  2. TEST
PrimaryBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR00.1 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
CUCODESPRSYSTEMGLMASTERPATSTSETUPPERSGROUPPATSTRESLTPCODESPAEMPAPTSTPATESTOVERJOBRELATEPATSTRESLTPATSTSETUP

One to one (17) — lookups and parents

RelationTableRulesConditionField map
Base CurrencyCUCODESRequiredWhen (PAP-CURRENCY-CODE != Spaces)
PAP-BASE-CURRENCY→CUC-CURRENCY-CODE
CompanyPRSYSTEMRequired
PAP-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredWhen (PAP-CURRENCY-CODE != Spaces)
PAP-CURRENCY-CODE→CUC-CURRENCY-CODE
Exp AccountGLMASTERRequiredWhen (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 TestPATSTSETUPRequiredWhen (PAP-FOLLOW-TEST != Spaces)
PAP-COMPANY→PAP-COMPANY
PAP-FOLLOW-TEST→PAP-TEST
GroupPERSGROUPRequiredWhen (PAP-GROUP-NAME != Spaces)
PAP-COMPANY→PRG-COMPANY
PAP-GROUP-NAME→PRG-GROUP-NAME
Prereq Result1PATSTRESLTRequiredWhen (PAP-PREREQ-RESULT1 != Spaces)
PAP-COMPANY→PTR-COMPANY
PAP-PREREQ-TEST→PTR-TEST
PAP-PREREQ-RESULT1→PTR-CODE
Prereq Result2PATSTRESLTRequiredWhen (PAP-PREREQ-RESULT2 != Spaces)
PAP-COMPANY→PTR-COMPANY
PAP-PREREQ-TEST→PTR-TEST
PAP-PREREQ-RESULT2→PTR-CODE
Prereq TestPATSTSETUPRequiredWhen (PAP-PREREQ-TEST != Spaces)
PAP-COMPANY→PAP-COMPANY
PAP-PREREQ-TEST→PAP-TEST
Renew TestPATSTSETUPRequiredWhen (PAP-RENEW-TEST != Spaces)
PAP-COMPANY→PAP-COMPANY
PAP-RENEW-TEST→PAP-TEST
Result1PATSTRESLTRequiredWhen (PAP-RESULT1 != Spaces)
PAP-COMPANY→PTR-COMPANY
PAP-TEST→PTR-TEST
PAP-RESULT1→PTR-CODE
Result2PATSTRESLTRequiredWhen (PAP-RESULT2 != Spaces)
PAP-COMPANY→PTR-COMPANY
PAP-TEST→PTR-TEST
PAP-RESULT2→PTR-CODE
Test CopyPATSTSETUPRequiredWhen (PAP-TEST-COPY != Spaces)
PAP-COMPANY→PAP-COMPANY
PAP-TEST-COPY→PAP-TEST
Test LetterPCODESRequiredWhen (PAP-LETTER != Spaces)
"TL"→PCO-TYPE
PAP-LETTER→PCO-CODE
Test LocationPCODESRequiredWhen (PAP-TEST-LOCATION != Spaces)
"TO"→PCO-TYPE
PAP-TEST-LOCATION→PCO-CODE
Test SourcePCODESRequiredWhen (PAP-TEST-SOURCE != Spaces)
"TS"→PCO-TYPE
PAP-TEST-SOURCE→PCO-CODE
Test TypePCODESRequiredWhen (PAP-TEST-TYPE != Spaces)
"TT"→PCO-TYPE
PAP-TEST-TYPE→PCO-CODE

One to many (5) — child tables

RelationTableRulesConditionField map
ApplicantsPAEMPAPTST
PAP-COMPANY→PTS-COMPANY
PAP-TEST→PTS-TEST
1→PTS-EMP-APP
—→PTS-EMPLOYEE
—→PTS-SEQ-NBR
EmployeesPAEMPAPTST
PAP-COMPANY→PTS-COMPANY
PAP-TEST→PTS-TEST
Zeroes→PTS-EMP-APP
—→PTS-EMPLOYEE
—→PTS-SEQ-NBR
OverridePATESTOVER
PAP-COMPANY→PAV-COMPANY
PAP-TEST→PAV-TEST
—→PAV-EMPLOYEE
Pos Job ReqJOBRELATE
PAP-COMPANY→JBR-COMPANY
Spaces→JBR-PROCESS-LEVEL
"TS"→JBR-TYPE
PAP-TEST→JBR-PERS-CODE
—→JBR-SUBJECT-CODE
—→JBR-JOB-CODE
—→JBR-POSITION
ResultsPATSTRESLT
PAP-COMPANY→PTR-COMPANY
PAP-TEST→PTR-TEST
—→PTR-CODE

Programs

Updated by (3)

Referenced by (53)