PACANHDR – No description in the Lawson data dictionary
- System
- Personnel (PA)
- Prefix
PHD- Primary key
COMPANY,SIC- Fields
- 3
- Updated by
- 3 programs
- Referenced by
- 2 programs
PACANHDR is a Lawson Personnel table (prefix PHD); no description in the lawson data dictionary. It is indexed by COMPANY, SIC (PHDSET1). It is related 1:1 to PRSYSTEM and PACANHDR and 1:M to PACANEEA. It is updated by HR00.1, HR01.1 and PA94.1 and referenced by PA294 and PA594. The table has 3 fields, 1 index and 3 documented relations.
About PACANHDR
No description in the Lawson data dictionary.
Fields (3)
Column = COBOL field name without the PHD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PHD-COMPANY PKCOMPANY | Numeric 4 | — | PA94.1 |
PHD-SIC PKSIC | Numeric 6 | Contains Canadian Standard Industry Code (SIC) provided by Canadian Government. | PA94.1 |
PHD-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | PA94.1 |
Indexes (1)
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 |
|---|---|---|---|---|
PHDSET1 | COMPANY, SIC | Primary | HR00.1, HR01.1, PA294, PA594, PA94.1 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | PRSYSTEM | Required | PHD-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL | |
| Pacanhdr | PACANHDR | Required | PHD-COMPANY → PHD-COMPANY, PHD-SIC → PHD-SIC |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Pacaneea | PACANEEA | PHD-COMPANY → PCE-COMPANY, PHD-SIC → PCE-SIC, PCE-PROCESS-LEVEL, PCE-DEPARTMENT, PCE-LOCAT-CODE |