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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PTTSET1AUTHOR-NAME, TITLE, TOPICPrimaryHR64.1, HR65.1, HR65.2, HR65.4, HR65.5

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
TitlePWTITLERequiredPTT-AUTHOR-NAME → PWT-AUTHOR-NAME, PTT-TITLE → PWT-TITLE
TopicPWTOPICRequiredPWT-TYPE → PWP-TYPE, PTT-TOPIC → PWP-TOPIC

Programs

Updated by (3)