PACANEEA – No description in the Lawson data dictionary
- System
- Personnel (PA)
- Prefix
PCE- Primary key
COMPANY,SIC,PROCESS-LEVEL,DEPARTMENT,LOCAT-CODE- Fields
- 5
- Updated by
- 1 program
- Referenced by
- 2 programs
PACANEEA is a Lawson Personnel table (prefix PCE); no description in the lawson data dictionary. It is indexed by COMPANY, SIC, PROCESS-LEVEL, DEPARTMENT, LOCAT-CODE (PCESET1); alternate indexes: PCESET2 and PCESET3. It is related 1:1 to PRSYSTEM, DEPTCODE, PCODES and PACANHDR. It is updated by PA94.1 and referenced by PA294 and PA594. The table has 5 fields, 3 indexes and 5 documented relations.
About PACANEEA
No description in the Lawson data dictionary.
Fields (5)
Column = COBOL field name without the PCE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PCE-COMPANY PKCOMPANY | Numeric 4 | — | PA94.1 |
PCE-SIC PKSIC | Numeric 6 | Contains the Canadian Standard Industry Code by the Canadian Government. | PA94.1 |
PCE-PROCESS-LEVEL PKPROCESS_LEVEL | Alpha 5 | — | PA94.1 |
PCE-DEPARTMENT PKDEPARTMENT | Alpha 5 | Contains the department. | PA94.1 |
PCE-LOCAT-CODE PKLOCAT_CODE | Alpha 10 | Contains the location. | PA94.1 |
Indexes (3)
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 |
|---|---|---|---|---|
PCESET1 | COMPANY, SIC, PROCESS-LEVEL, DEPARTMENT, LOCAT-CODE | Primary | PA294, PA94.1 | |
PCESET2 | COMPANY, PROCESS-LEVEL, DEPARTMENT, LOCAT-CODE | PA594, PA94.1 | ||
PCESET3 | COMPANY, LOCAT-CODE, PROCESS-LEVEL, DEPARTMENT | — |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | PRSYSTEM | Required | PCE-COMPANY → PRS-COMPANY (PRSSET1), Spaces → PRS-PROCESS-LEVEL | |
| Department | DEPTCODE | Required | When PCE-DEPARTMENT != Spaces And PCE-DEPARTMENT != "*ALL" | PCE-COMPANY → DPT-COMPANY, PCE-PROCESS-LEVEL → DPT-PROCESS-LEVEL, PCE-DEPARTMENT → DPT-DEPARTMENT |
| Location | PCODES | Required | When PCE-LOCAT-CODE != Spaces | "LO" → PCO-TYPE, PCE-LOCAT-CODE → PCO-CODE |
| Pacanhdr | PACANHDR | Required | PCE-COMPANY → PHD-COMPANY, PCE-SIC → PHD-SIC | |
| Process Level | PRSYSTEM | Required | When PCE-PROCESS-LEVEL != Spaces | PCE-COMPANY → PRS-COMPANY, PCE-PROCESS-LEVEL → PRS-PROCESS-LEVEL |
Programs
Updated by (1)
- PA94.1 Canada EEA Setup