HRUTILITY – HR Utility

System
Human Resources (HR)
Prefix
HUT
Primary key
SYSTEM, RELEASE, REL-LEVEL, KEY1, KEY2, KEY3, KEY4, KEY5, KEY6, KEY7, KEY8, SEQ-NUMBER
Fields
13
Updated by
11 programs
Referenced by
3 programs

HRUTILITY is the HR Utility table in Lawson Human Resources (prefix HUT). It is indexed by SYSTEM, RELEASE, REL-LEVEL, KEY1, KEY2, KEY3, KEY4, KEY5, KEY6, KEY7, KEY8, SEQ-NUMBER (HUTSET1). It is updated by BN180, BN80.1, HR06.1, HR11.1, HR506, LT101, LT11.6, LT111 and 3 more and referenced by BN190, PA392 and ZP567. The table has 13 fields, 1 index and 0 documented relations.

About HRUTILITY

Contains fields that can be loaded, updated, and accessed by any program. This file allows you to make changes to the system without changing the database which is particularly useful when making year-end changes.

Fields (13)

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

Field / columnTypeDescription & valuesUpdated by
HUT-SYSTEM PK
SYSTEM		Alpha 2Contains a two-character code that represents a Lawson system. For example, Payable, and so on.
  • GL General Ledger, AP = Accounts
BN180, BN80.1, LT11.6, LT111, PA93.5, PA93.6
HUT-RELEASE PK
RELEASE		Numeric 1Contains the release number of the system.BN180, BN80.1, LT11.6, LT111, PA93.5, PA93.6
HUT-REL-LEVEL PK
REL_LEVEL		Numeric 2Contains the release level of the system.BN180, BN80.1, LT11.6, LT111, PA93.5, PA93.6
HUT-KEY1 PK
KEY1		Alpha 10This is a free-form field that can be loaded, updated and accessed by any program to create changes to the system without changing the existing database definition.BN180, BN80.1, LT11.6, LT111, PA93.5, PA93.6
HUT-KEY2 PK
KEY2		Alpha 10This is a free-form field that can be loaded, updated, and accessed by any program to create changes to the system without changing the existing database definition.BN180, BN80.1, LT11.6, LT111, PA93.5, PA93.6
HUT-KEY3 PK
KEY3		Alpha 10This is a free-form field that can be loaded, updated, or accessed by any program to create changes to the system without changing the existing database definition.BN180, BN80.1, LT11.6, LT111, PA93.5, PA93.6
HUT-KEY4 PK
KEY4		Alpha 10This is a free-form field that can be loaded, updated, or accessed by any program to create changes to the system without changing the existing database definition.BN180, BN80.1, LT11.6, LT111, PA93.5, PA93.6
HUT-KEY5 PK
KEY5		Alpha 10This is a free-form field that can be loaded, updated, or accessed by any program to create changes to the system without changing the existing database definition.BN180, BN80.1, LT11.6, LT111, PA93.5, PA93.6
HUT-KEY6 PK
KEY6		Alpha 10This is a free-form field that can be loaded, updated, or accessed by any program to create changes to the system without changing the existing database definition.BN180, BN80.1, LT11.6, LT111, PA93.5, PA93.6
HUT-KEY7 PK
KEY7		Alpha 10This is a free-form field that can be loaded, updated, or accessed by any program to create changes to the system without changing the existing database definition.BN180, BN80.1, LT11.6, LT111, PA93.5, PA93.6
HUT-KEY8 PK
KEY8		Alpha 10This is a free-form field that can be loaded, updated, or accessed by any program to create changes to the system without changing the existing database definition.BN180, BN80.1, LT11.6, LT111, PA93.5, PA93.6
HUT-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6Contains a unique number assigned to each transaction.LT11.6, LT111, PA93.5, PA93.6
HUT-DATA
DATA		Alpha 500 (Lower Case)Contains miscellaneous data.BN180, BN80.1, LT11.6, PA93.5, PA93.6

Indexes (1)

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

IndexKeysFlagsConditionUsed in
HUTSET1SYSTEM, RELEASE, REL-LEVEL, KEY1, KEY2, KEY3, KEY4, KEY5, KEY6, KEY7, KEY8, SEQ-NUMBERPrimaryBN180, BN190, BN80.1, HR06.1, HR11.1, HR506, LT101, LT11.6 +6 more

Programs

Updated by (11)

Referenced by (3)