HRUSERFLDS – HR User Fields

System
Human Resources (HR)
Prefix
HRU
Primary key
FIELD-KEY
Fields
15
Updated by
4 programs
Referenced by
180 programs

HRUSERFLDS is the HR User Fields table in Lawson Human Resources (prefix HRU). It is indexed by FIELD-KEY (HRUSET1); alternate indexes: HRUSET2, HRUSET3, HRUSET4 and HRUSET5. It is related 1:M to HREMPUSF. It is updated by HR04.4, HR04.5, HR04.6 and HR10.4 and referenced by BN305, HAP3.1, HC02.5, HC10.1, HCDL.1, HCHP.1, HCRE.1, HEP4.1 and 172 more. The table has 15 fields, 5 indexes and 1 documented relation.

About HRUSERFLDS

Contains user-defined user fields and their system-assigned 2-digit identifiers, as well as their associated attributes and defined valid values. This file also contains a field that indicates if the user field is applicable for both employees and applicants or for only applicants or employees.

Fields (15)

Column = COBOL field name without the HRU- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#HRU-FIELD-KEY PK
FIELD_KEY		Alpha 2Contains the system-defined two-digit identifier of the user field. 01 99HR04.4, HR04.5, HR04.6
#HRU-FIELD-NAME SET2 SET3 SET4 SET5
FIELD_NAME		Alpha 20 (Lower Case)Contains the field name.HR04.4, HR04.5, HR04.6
#HRU-FIELD-TYPE SET5
FIELD_TYPE		Alpha 1Indicates if the user field is an alphanumeric, numeric, or date user field.
  • A Alphanumeric
  • N Numeric
  • D Date
HR04.4, HR04.5, HR04.6
#HRU-BEG-NUMBER
BEG_NUMBER		Signed 11.2Contains the beginning value of a numeric range allowed for the user field.HR04.4, HR04.5, HR04.6
#HRU-END-NUMBER
END_NUMBER		Signed 11.2Contains the ending value of a numeric range allowed for the user field.HR04.4, HR04.5, HR04.6
#HRU-BEG-DATE
BEG_DATE		Numeric 8 (yyyymmdd)Contains the beginning date of a date range defined for a date user field.HR04.4, HR04.5, HR04.6
#HRU-END-DATE
END_DATE		Numeric 8 (yyyymmdd)Contains the ending date of a date range defined for a date user field.HR04.4, HR04.5, HR04.6
#HRU-PERS-ACTION
PERS_ACTION		Alpha 1Determines if you can change this user field only with a personnel action. XHR04.4, HR04.5, HR04.6
#HRU-LOG-FLAG
LOG_FLAG		Alpha 1Determines whether the system creates a log record when you make a change to this user field. XHR04.4, HR04.5, HR04.6
#HRU-REQ-FLAG SET3 SET4
REQ_FLAG		Alpha 1Determines if this field is required on an Add or Change function. XHR04.4, HR04.5, HR04.6, HR10.4
#HRU-SEC-LEVEL
SEC_LEVEL		Numeric 1Contains the security level of the user field.HR04.4, HR04.5, HR04.6
#HRU-INDICATOR
INDICATOR		Alpha 1Indicates if the user field applies to employees, applicants, or both.
  • E Employee
  • A Applicant
  • B Both
HR04.4, HR04.5, HR04.6, HR10.1, HR10.2, HR10.3, HR11.1, HR11.4 +7 more
#HRU-REQ-VALUE
REQ_VALUE		Alpha 1Indicates if the user field is defined as required.
  • Y Yes
  • N No
HR04.4, HR04.5, HR04.6
#HRU-CURRENCY-FLAG
CURRENCY_FLAG		Alpha 1Conversion Method for Currency - Multiply/Divide.
  • N No
  • Y Yes
HR04.4, HR04.5, HR04.6
#HRU-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1The Active flag indicates if the employee/applicant user field can be entered for an employee (or applicant).
  • A Active
  • I Inactive
HR04.4, HR04.5, HR04.6

Indexes (5)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HRUSET1
  1. FIELD-KEY
PrimaryBN305, HC02.5, HC10.1, HAP3.1, HCRE.1, HEP4.1, HLTM.1, HPOS.1 +22 more (list truncated in source)
HRUSET2
  1. FIELD-NAME
KeyChangeHC02.5, HCDL.1, HCHP.1, HR04.4, HR04.5, HR04.6, HR10.4, HR15.1 +7 more
HRUSET3
  1. REQ-FLAG ↓
  2. FIELD-NAME
KeyChange, SubsetWhere INDICATOR = "E" Or INDICATOR = "B"HR210
HRUSET4
  1. REQ-FLAG ↓
  2. FIELD-NAME
KeyChange, SubsetWhere INDICATOR = "A" Or INDICATOR = "B"BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
HRUSET5
  1. FIELD-TYPE
  2. FIELD-NAME
KeyChangeHR04.4, HR04.5, HR04.6, HR211, PA115, PA120, PA210, PA231 +1 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
HREMPUSFHRUSERFLDS

One to many (1) — child tables

RelationTableRulesConditionField map
Emps And AppsHREMPUSFDelete Restricted
HRU-FIELD-KEY→HEU-FIELD-KEY
—→HEU-EMP-APP
—→HEU-COMPANY
—→HEU-EMPLOYEE

Programs

Updated by (4)

Referenced by (180)