PADICT – HR Systems Data Dictionary

System
Human Resources (HR)
Prefix
PAD
Primary key
FLD-NBR
Fields
24
Updated by
10 programs
Referenced by
222 programs

PADICT is the HR Systems Data Dictionary table in Lawson Human Resources (prefix PAD). It is indexed by FLD-NBR (PADSET1). 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 BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 and 214 more. The table has 24 fields, 1 index and 0 documented relations.

About PADICT

Contains a record for each database element you can use with HR170 (HR Writer Report Request), PA100 (Action Update),or HR155 (Employee Group Update). The system stores information about each element, such as size and type, that is needed for the various features. The dictionary is loaded at installation and is not maintainable by any user programs.

Fields (24)

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

Field / columnTypeDescription & valuesUpdated by
PAD-FLD-NBR PK
FLD_NBR
Numeric 4Contains the HR data dictionary field number.HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PAD-TOPIC
TOPIC
Alpha 2Contains the topic. For example, this field could contain E1 for fields on the first screen of HR11 (Employee).HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PAD-ITEM-NAME
ITEM_NAME
Alpha 20 (Lower Case)Contains the data item (field) description.HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, HR55.3, PA03.1 +3 more
PAD-DATA-TYPE
DATA_TYPE
Alpha 1Indicates the data type.
  • A Alphanumeric
  • D Date (YYYYMMDD)
  • N Numeric
HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, HR55.3, PA04.2 +2 more
PAD-HEADING
HEADING
Alpha 15 (Lower Case)Occurs 2 Times Contains the headings for columns in the HR writer. The first occurrence is the top line of the heading; the second occurrence is the bottom line of the heading.HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PAD-DB-FILE
DB_FILE
Alpha 3Contains the three-character prefix of the database file in which the field is found.HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PAD-SIZE
SIZE
Numeric 2Contains the default field size (including decimal places).HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, HR55.3, PA04.2 +2 more
PAD-DECIMALS
DECIMALS
Numeric 1Contains the number of decimal places.HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, HR55.3, PA04.2 +3 more
PAD-REQ-KEY
REQ_KEY
Alpha 1Indicates if the field is required when an employee record is added or changed.
  • B Required for Benefits only
  • P Required for Personnel only
  • R Required for Payroll only
  • Y Always required
  • N Not Required
HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PAD-PERS-ACTION
PERS_ACTION
Alpha 1Indicates if the field can only be changed by a personnel action.
  • N No Personnel Actions allowed
  • Y Available for Personnel Action
HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PAD-PERS-GRP
PERS_GRP
Alpha 1Indicates if the item can be used in the definition of an employee group.
  • N Not allowed in Employee Groups
  • Y Available for Employee Groups
HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PAD-HEADER-SIZE
HEADER_SIZE
Numeric 2Contains the header size used by the HR Writer. The header size is determined by the larger of these two equations: The field size plus one, or the largest header plus one. The maximum header size is 60 characters.HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PAD-MIN-SIZE
MIN_SIZE
Numeric 2Contains the minimum header size used by the HR Writer. The minimum header size is determined by the smaller of these: The field size or the largest header length.HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PAD-CMP-FIELD
CMP_FIELD
Alpha 1Indicates if the item is available for use in the definition of a compute statement.HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PAD-PRT-TYPE
PRT_TYPE
Alpha 1Determines if duplicated information on subsequent print lines should be 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
PAD-CURRENCY-FLAG
CURRENCY_FLAG
Alpha 1Indicates whether field contains currency.
  • N No
  • Y Yes
HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PAD-LOG-AVAIL-FLAG
LOG_AVAIL_FLAG
Alpha 1Indicates the field is available to be setup as log to HR History on HR10.1.
  • N No
  • Y Yes
HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PAD-REQ-AVAIL-FLAG
REQ_AVAIL_FLAG
Alpha 1Indicates if field is available to be flagged as required on HR10.1.
  • N No
  • Y Yes
HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PAD-DFL-AVAIL-FLAG
DFL_AVAIL_FLAG
Alpha 1Indicates if a field can be flagged as a position default field on HR10.1.
  • N No
  • Y Yes
HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PAD-SETUP-FLAG
SETUP_FLAG
Alpha 1Indicates if a field should display on HR10.1.
  • N No
  • Y Yes
HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PAD-TOPIC-FLAG
TOPIC_FLAG
Alpha 1Indicates if a field is part of the GE topic.
  • N No
  • Y Yes
HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PAD-CASE-FLAG
CASE_FLAG
Alpha 1Indicates if values entered in this field should be converted to upper case on PA52.
  • N No
  • Y Yes
HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more
PAD-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
PAD-COLUMN-HEADING
COLUMN_HEADING
Alpha 40 (Lower Case)HR04.4, HR04.5, HR04.6, HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 +1 more

Indexes (1)

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

IndexKeysFlagsConditionUsed in
PADSET1FLD-NBRPrimaryBN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source)

Programs

Updated by (10)

Referenced by (222)