PWTOPIC – HR Report Writer Topics
- System
- Human Resources (HR)
- Prefix
PWP- Primary key
TYPE,TOPIC- Fields
- 5
- Updated by
- 1 program
- Referenced by
- 5 programs
PWTOPIC is the HR Report Writer Topics table in Lawson Human Resources (prefix PWP). It is indexed by TYPE, TOPIC (PWPSET1). It is related 1:M to PADICT2. It is updated by HR100 and referenced by HR65.1, HR65.2, HR65.4, HR65.5 and HR68.1. The table has 5 fields, 1 index and 1 documented relation.
About PWTOPIC
Contains the report type, and topics available for the HR Writer report. This file also identifies the fields that have security defined.
Fields (5)
Column = COBOL field name without the PWP- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#PWP-TYPE PKTYPE | Alpha 2 | Indicates if the report type is A (Applicant), E (Employee), or H (History). The report type determines which topics are available for the report. | — |
#PWP-TOPIC PKTOPIC | Alpha 2 | Contains the topics that are available for the report. | — |
#PWP-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | Contains the topic description. | — |
#PWP-DTL-TOPDTL_TOP | Alpha 1 | Indicates if the topic is a Detail or Master topic.
| — |
#PWP-SEC-TOPSEC_TOP | Alpha 1 | Determines if security is defined in HR68.1 (HR Writer Data Item Security) for data items associated with the topic.
| — |
Indexes (1)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PWPSET1 |
| Primary | HR100, HR65.1, HR65.2, HR65.4, HR65.5, HR68.1 |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Padict2 | PADICT2 |
|
Programs
Updated by (1)
- HR100 Lawson Delivered Files Purge