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.

Field / columnTypeDescription & valuesUpdated by
PWP-TYPE PK
TYPE		Alpha 2Indicates 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 PK
TOPIC		Alpha 2Contains the topics that are available for the report.—
PWP-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Contains the topic description.—
PWP-DTL-TOP
DTL_TOP		Alpha 1Indicates if the topic is a Detail or Master topic.
  • Y Yes
  • N No
—
PWP-SEC-TOP
SEC_TOP		Alpha 1Determines if security is defined in HR68.1 (HR Writer Data Item Security) for data items associated with the topic.
  • Y Yes
  • N No
—

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PWPSET1TYPE, TOPICPrimaryHR100, HR65.1, HR65.2, HR65.4, HR65.5, HR68.1

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
Padict2PADICT2PWP-TOPIC → PA2-TOPIC, → PA2-ITEM-NAME

Programs

Updated by (1)

Referenced by (5)