PERSACTYPE – Personnel Action Code

System
Personnel (PA)
Prefix
PAT
Primary key
COMPANY, ACTION-CODE
Fields
17
Updated by
6 programs
Referenced by
88 programs

PERSACTYPE is the Personnel Action Code table in Lawson Personnel (prefix PAT). It is indexed by COMPANY, ACTION-CODE (PATSET1); alternate indexes: PATSET2. It is related 1:1 to PRSYSTEM and PADICT and 1:M to PAACTREAS, HISTERR, PERSACTION and PERSACTHST. It is updated by HR00.1, HR01.1, PA100, PA50.1, PA56.1 and PA57.1 and referenced by BN16.2, BN16.3, BN16.4, BN216, BN305, ES03.1, HAP3.1, HC02.5 and 80 more. The table has 17 fields, 2 indexes and 7 documented relations.

About PERSACTYPE

The Personnel Action Code file contains information about personnel actions. PA50.1 (Action) is the primary program that updates this file.

Fields (17)

Column = COBOL field name without the PAT- 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
#PAT-COMPANY PK
COMPANY		Numeric 4Contains the company number which represents an established company.PA50.1
#PAT-ACTION-CODE PK
ACTION_CODE		Alpha 10Contains the code that represents the personnel action.PA50.1
#PAT-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Contains the description of the personnel action.PA50.1
#PAT-FLD-NBR
FLD_NBR		Numeric 4 Occurs 36 Times ×36Contains the data dictionary item number corresponding to the field used in the personnel action.PA50.1
#PAT-LAST-CMT-SEQ
LAST_CMT_SEQ		Numeric 4Contains the last sequence number used for personnel action comments.PA100, PA56.1
#PAT-WEB-AVAILABLE
WEB_AVAILABLE		Alpha 1Indicates whether the employee can change information on the Web by using this action code.
  • N No
  • Y Yes
PA50.1
#PAT-WEB-AVAIL-SUPV
WEB_AVAIL_SUPV		Alpha 1Indicates whether the employee's supervisor can see results of the action on the web. " "
  • 1 Not Available
  • 2 Direct Supervisor
  • 3 Indirect Supervisor
  • 4 Direct; Indirect Supvr
PA50.1
#PAT-WEB-IMMEDIATE
WEB_IMMEDIATE		Alpha 1Indicates whether an employee or supervisor can make the action immediate using the Web.
  • N No
  • Y Yes
PA50.1
#PAT-WORKFLOW-FLAG
WORKFLOW_FLAG		Alpha 1Indicates whether to initiate a workflow service.
  • N No
  • Y Yes
PA50.1
#PAT-HIST-CORR-FLAG
HIST_CORR_FLAG		Alpha 2Indicates default method the system uses to correct employee history audit files when a retroactive change is performed.
  • 1 Create pending upd
  • 2 Delete
  • 3 Move to Hist Error
PA50.1
#PAT-ERECRUIT-FLAG
ERECRUIT_FLAG		Alpha 1—
  • N No
  • Y Yes
—
#PAT-REQUIRE-REASON
REQUIRE_REASON		Numeric 1Field used to indicate the number of reason codes that must be entered on a personnel action.PA50.1
#PAT-DFT-REASON
DFT_REASON		Alpha 10 Occurs 2 Times ×2Default reasons for personnel actions.PA50.1
#PAT-DFT-UPD-BN
DFT_UPD_BN		Alpha 1Default personnel action value for updating benefits.
  • N No
  • Y Yes
PA50.1
#PAT-DFT-UPD-LP
DFT_UPD_LP		Alpha 1Default personnel action value for LP (Absence Management).
  • N No
  • Y Yes
PA50.1
#PAT-DFT-UPD-RQ-DED
DFT_UPD_RQ_DED		Alpha 1Default personnel action value for updating required deductions.
  • N No
  • Y Yes
PA50.1
#PAT-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1The Active flag of the personnel action.
  • 1 Active
  • 2 Inactive
PA50.1

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.

IndexKeysFlagsConditionUsed in
PATSET1
  1. COMPANY
  2. ACTION-CODE
PrimaryBN16.2, BN16.3, BN16.4, BN216, BN305, HC02.5, ES03.1, HAP3.1 +22 more (list truncated in source)
PATSET2
  1. COMPANY
  2. ACTION-CODE
SubsetWhere (ACTIVE-FLAG = "1")—

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PAT-COMPANY→PRS-COMPANY (PRSSET1)
Spaces→PRS-PROCESS-LEVEL
Field NbrPADICTRequiredWhen PAT-FLD-NBR != Zeroes
PAT-FLD-NBR→PAD-FLD-NBR

One to many (5) — child tables

RelationTableRulesConditionField map
Action ReasonPAACTREAS
PAT-COMPANY→CRE-COMPANY
PAT-ACTION-CODE→CRE-ACTION-CODE
—→CRE-ACT-REASON-CD
Hist ErrHISTERRDelete Cascades
PAT-COMPANY→HER-COMPANY
PAT-ACTION-CODE→HER-ACTION-CODE
—→HER-EMPLOYEE
—→HER-OBJ-ID
—→HER-EFFECT-DATE
—→HER-ACTION-NBR
—→HER-FLD-NBR
—→HER-SEQ-NBR
Pers ActionsPERSACTIONDelete Restricted
PAT-COMPANY→PCT-COMPANY
PAT-ACTION-CODE→PCT-ACTION-CODE
—→PCT-ACTION-TYPE
—→PCT-EFFECT-DATE
—→PCT-EMPLOYEE
—→PCT-ACTION-NBR
PersacthstPERSACTHSTDelete Restricted
PAT-COMPANY→PAH-COMPANY
PAT-ACTION-CODE→PAH-ACTION-CODE
—→PAH-EMPLOYEE
—→PAH-EFFECT-DATE
—→PAH-ACTION-NBR
ReasonPAACTREASValid When (PAT-DFT-REASON != Spaces)
PAT-COMPANY→CRE-COMPANY
PAT-DFT-REASON→CRE-ACT-REASON-CD
—→CRE-ACTION-CODE

Programs

Updated by (6)

Referenced by (88)