PAACTREAS – This table is used to hold reason codes.
- System
- Personnel (PA)
- Prefix
CRE- Primary key
COMPANY,ACT-REASON-CD,ACTION-CODE- Fields
- 8
- Updated by
- 3 programs
- Referenced by
- 27 programs
PAACTREAS is the This table is used to hold reason codes. table in Lawson Personnel (prefix CRE). It is indexed by COMPANY, ACT-REASON-CD, ACTION-CODE (CRESET1); alternate indexes: CRESET2, CRESET3, CRESET4 and CRESET5. It is related 1:1 to PERSACTYPE and PRSYSTEM. It is updated by PA57.1, PA57.2 and PA57.3 and referenced by HCRE.1, HR00.1, HR170, HR200, HR51.2, HR51.6, HR70.1, LT101 and 19 more. The table has 8 fields, 5 indexes and 2 documented relations.
About PAACTREAS
This table is used to hold reason codes. The reason codes can be generic and used for any personnel action or defined specifically for one of more personnel actions.
Fields (8)
Column = COBOL field name without the CRE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
CRE-COMPANY PKCOMPANY | Numeric 4 | Contains the HR company. | PA57.1, PA57.2, PA57.3 |
CRE-ACT-REASON-CD PKACT_REASON_CD | Alpha 10 | This is the reason code that can be used for actions with a specific action code or in general. | PA57.1, PA57.2, PA57.3 |
CRE-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | — | PA57.1, PA57.2, PA57.3 |
CRE-ACTION-CODE PKACTION_CODE | Alpha 10 | — | PA57.1, PA57.2, PA57.3 |
CRE-ACTIVE-FLAGACTIVE_FLAG | Alpha 1 | The Active flag of the reason code.
| PA57.1, PA57.2, PA57.3 |
CRE-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | — | PA57.1, PA57.2, PA57.3 |
CRE-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | — | PA57.1, PA57.2, PA57.3 |
CRE-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | PA57.1, PA57.2, PA57.3 |
Indexes (5)
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 |
|---|---|---|---|---|
CRESET1 | COMPANY, ACT-REASON-CD, ACTION-CODE | Primary | HCRE.1, HR00.1, HR170, HR200, HR70.1, LT101, LT111, PA105 +11 more | |
CRESET2 | COMPANY, ACTION-CODE, ACT-REASON-CD | PA57.3 | ||
CRESET3 | COMPANY, ACT-REASON-CD, ACTION-CODE | Subset | Where (ACTION-CODE = Spaces) | HR51.2, HR51.6, PA102, PA13.1, PA13.2, PA52.1, PA52.2, PA52.3 +5 more |
CRESET4 | COMPANY, ACTION-CODE, ACT-REASON-CD | Subset | Where (ACTION-CODE != Spaces) | HR51.2, HR51.6, LT101, LT111, PA102, PA13.1, PA13.2, PA257 +6 more |
CRESET5 | COMPANY, ACT-REASON-CD, ACTION-CODE | Subset | Where (ACTION-CODE != Spaces) | PA257, PA57.1, PA57.2 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Action Code | PERSACTYPE | Required | When (CRE-ACTION-CODE != Spaces) | CRE-COMPANY → PAT-COMPANY, CRE-ACTION-CODE → PAT-ACTION-CODE |
| Company | PRSYSTEM | Required | CRE-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL |
Programs
Updated by (3)
- PA57.1 Personnel Action Reason Codes
- PA57.2 Personnel Action by Reason Code
- PA57.3 Reason Codes by Personnel Action
Referenced by (27)
- HCRE.1 Action Reason Code Selects
- HR00.1 Company
- HR170 Human Resource Writer Report Request
- HR200 Company Listing
- HR51.2 Employee Interface Data
- HR51.6 Emp Position Interface Data
- HR70.1 Human Resource Writer Inquiry
- LT101 HRM Receiver Update
- LT111 HRM Receiver Update
- PA102 Position Update
- PA105 Employee Audit Report
- PA13.1 Multiple Positions and Jobs
- PA13.2 Multiple Position and Job History
- PA223 Starters and Leavers Report
- PA257 Action Reason Code Listing
- PA355 Active Actions Report
- PA50.1 Action
- PA52.1 Individual Action
- PA52.2 Mass Pay Action
- PA52.3 Mass Action
- PA52.4 Hire an Applicant
- PA52.5 Position and Job Action
- PA54.1 Personnel Action History Correction
- PA594 EECRS CSV Interface
- PA66.3 Employee Action Detail
- PA66.4 Employee Action Comments
- PR282 Canada Record of Employment