PADICT2 – HR Systems Data Dict Detail

System
Human Resources (HR)
Prefix
PA2
Primary key
TOPIC, FLD-NBR
Fields
6
Updated by
10 programs
Referenced by
86 programs

PADICT2 is the HR Systems Data Dict Detail table in Lawson Human Resources (prefix PA2). It is indexed by TOPIC, FLD-NBR (PA2SET1); alternate indexes: PA2SET2. It is related 1:1 to PADICT. It is updated by HR04.4, HR04.5, HR04.6, HR100, HR26.2, HR26.3, HR26.4, PA04.2 and 2 more and referenced by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR10.1 and 78 more. The table has 6 fields, 2 indexes and 1 documented relation.

About PADICT2

Contains the data dictionary item names with their associated topic, system-assigned field number, and print type, and indicates if the field can be totaled.

Fields (6)

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

Field / columnTypeDescription & valuesUpdated by
PA2-TOPIC PK
TOPIC
Alpha 2Contains the topic. For example, E1 contains fields on the first screen of HR11.1 (Employee).HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PA2-FLD-NBR PK
FLD_NBR
Numeric 4Contains the data dictionary field number.HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PA2-ITEM-NAME
ITEM_NAME
Alpha 20 (Lower Case)Contains the field description.HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PA2-SUM-FIELD
SUM_FIELD
Alpha 1Indicates if the data item can be totaled.HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PA2-PRT-TYPE
PRT_TYPE
Alpha 1Determines if duplicated information on subsequent print lines is suppressed. If the item is E it does not print more than once per employee. If the item is P it prints once for each second level detail item. If the item is blank, it always prints (second or third level detail item). Used exclusively by HR170 (HR Writer Report Request)HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PA2-DELIVERED
DELIVERED
Alpha 1Indicates if this field is delivered to clients. Only user-defined fields will have a value of N.
  • N No
  • Y Yes
HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more

Indexes (2)

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

IndexKeysFlagsConditionUsed in
PA2SET1TOPIC, FLD-NBRPrimaryBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR04.4 +22 more (list truncated in source)
PA2SET2TOPIC, ITEM-NAMEKeyChangeHR10.1, HR10.3, HR10.4, HR515, HR65.2, HR65.4, HR65.5, HR65.7 +2 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
PadictPADICTRequiredPA2-FLD-NBRPAD-FLD-NBR

Programs

Updated by (10)

Referenced by (86)