PWAUTHOR – HR Report Writer Author

System
Human Resources (HR)
Prefix
PWA
Primary key
AUTHOR-NAME
Fields
4
Updated by
4 programs
Referenced by
1 program

PWAUTHOR is the HR Report Writer Author table in Lawson Human Resources (prefix PWA). It is indexed by AUTHOR-NAME (PWASET1). It is related 1:M to PWCOMPUTE and PWTITLE. It is updated by HR60.1, HR64.1, HR65.1 and HR67.1 and referenced by HR70.1. The table has 4 fields, 1 index and 2 documented relations.

About PWAUTHOR

Contains information about an author. HR60.1 (HR Writer Authors) is the primary program that updates this file.

Fields (4)

Column = COBOL field name without the PWA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PWA-AUTHOR-NAME PK
AUTHOR_NAME		Alpha 10Contains the user-defined author name.HR60.1
PWA-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Contains the author description that further defines the author.HR60.1
PWA-LST-TITLE-NBR
LST_TITLE_NBR		Numeric 4Contains the sequence number used to store the last title record for this author.HR64.1, HR65.1
PWA-LAST-COMP-NBR
LAST_COMP_NBR		Numeric 4Contains the sequence number used to store the last compute record for this author.HR67.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
PWASET1AUTHOR-NAMEPrimaryHR60.1, HR64.1, HR65.1, HR65.2, HR65.3, HR65.4, HR65.5, HR65.6 +4 more

Relations

One to many (2) — child tables

RelationTableRulesConditionField map
ComputesPWCOMPUTEDelete RestrictedPWA-AUTHOR-NAME → PWC-AUTHOR-NAME, → PWC-COLUMN-NAME
TitlesPWTITLEDelete RestrictedPWA-AUTHOR-NAME → PWT-AUTHOR-NAME, → PWT-TITLE

Programs

Updated by (4)

Referenced by (1)