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

Field / columnTypeDescription & valuesUpdated by
#PCE-COMPANY PK
COMPANY		Numeric 4—PA94.1
#PCE-SIC PK
SIC		Numeric 6Contains the Canadian Standard Industry Code by the Canadian Government.PA94.1
#PCE-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5—PA94.1
#PCE-DEPARTMENT PK
DEPARTMENT		Alpha 5Contains the department.PA94.1
#PCE-LOCAT-CODE PK
LOCAT_CODE		Alpha 10Contains the location.PA94.1

Indexes (3)

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
PCESET1
  1. COMPANY
  2. SIC
  3. PROCESS-LEVEL
  4. DEPARTMENT
  5. LOCAT-CODE
PrimaryPA294, PA94.1
PCESET2
  1. COMPANY
  2. PROCESS-LEVEL
  3. DEPARTMENT
  4. LOCAT-CODE
PA594, PA94.1
PCESET3
  1. COMPANY
  2. LOCAT-CODE
  3. PROCESS-LEVEL
  4. DEPARTMENT
—

Relations

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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PCE-COMPANY→PRS-COMPANY (PRSSET1)
Spaces→PRS-PROCESS-LEVEL
DepartmentDEPTCODERequiredWhen PCE-DEPARTMENT != Spaces And PCE-DEPARTMENT != "*ALL"
PCE-COMPANY→DPT-COMPANY
PCE-PROCESS-LEVEL→DPT-PROCESS-LEVEL
PCE-DEPARTMENT→DPT-DEPARTMENT
LocationPCODESRequiredWhen PCE-LOCAT-CODE != Spaces
"LO"→PCO-TYPE
PCE-LOCAT-CODE→PCO-CODE
PacanhdrPACANHDRRequired
PCE-COMPANY→PHD-COMPANY
PCE-SIC→PHD-SIC
Process LevelPRSYSTEMRequiredWhen PCE-PROCESS-LEVEL != Spaces
PCE-COMPANY→PRS-COMPANY
PCE-PROCESS-LEVEL→PRS-PROCESS-LEVEL

Programs

Updated by (1)

Referenced by (2)