PWTITLETOP – HR Report Writer Title Topic

System
Human Resources (HR)
Prefix
PTT
Primary key
AUTHOR-NAME, TITLE, TOPIC
Fields
4
Updated by
3 programs
Referenced by
0 programs

PWTITLETOP is the HR Report Writer Title Topic table in Lawson Human Resources (prefix PTT). It is indexed by AUTHOR-NAME, TITLE, TOPIC (PTTSET1). It is related 1:1 to PWTITLE and PWTOPIC. It is updated by HR64.1, HR65.1 and HR65.2. The table has 4 fields, 1 index and 2 documented relations.

About PWTITLETOP

No description in the Lawson data dictionary.

Fields (4)

Column = COBOL field name without the PTT- 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
#PTT-AUTHOR-NAME PK
AUTHOR_NAME		Alpha 10Contains the author name.HR65.1
#PTT-TITLE PK
TITLE		Alpha 30 (Lower Case)Contains the title of the report.HR64.1, HR65.1
#PTT-TOPIC PK
TOPIC		Alpha 2Contains the detail topic for the report.HR65.1
#PTT-TOPIC-DESC
TOPIC_DESC		DerivedContains the description of the detail 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.

IndexKeysFlagsConditionUsed in
PTTSET1
  1. AUTHOR-NAME
  2. TITLE
  3. TOPIC
PrimaryHR64.1, HR65.1, HR65.2, HR65.4, HR65.5

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
TitlePWTITLERequired
PTT-AUTHOR-NAME→PWT-AUTHOR-NAME
PTT-TITLE→PWT-TITLE
TopicPWTOPICRequired
PWT-TYPE→PWP-TYPE
PTT-TOPIC→PWP-TOPIC

Programs

Updated by (3)