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.

Field / column	Type	Description & values	Updated by
`HRU-FIELD-KEY` PK FIELD_KEY	Alpha 2	Contains the system-defined two-digit identifier of the user field. 01 99	HR04.4, HR04.5, HR04.6
`HRU-FIELD-NAME` FIELD_NAME	Alpha 20 (Lower Case)	Contains the field name.	HR04.4, HR04.5, HR04.6
`HRU-FIELD-TYPE` FIELD_TYPE	Alpha 1	Indicates 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.2	Contains 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.2	Contains 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 1	Determines if you can change this user field only with a personnel action. X	HR04.4, HR04.5, HR04.6
`HRU-LOG-FLAG` LOG_FLAG	Alpha 1	Determines whether the system creates a log record when you make a change to this user field. X	HR04.4, HR04.5, HR04.6
`HRU-REQ-FLAG` REQ_FLAG	Alpha 1	Determines if this field is required on an Add or Change function. X	HR04.4, HR04.5, HR04.6, HR10.4
`HRU-SEC-LEVEL` SEC_LEVEL	Numeric 1	Contains the security level of the user field.	HR04.4, HR04.5, HR04.6
`HRU-INDICATOR` INDICATOR	Alpha 1	Indicates 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 1	Indicates if the user field is defined as required. `Y` Yes `N` No	HR04.4, HR04.5, HR04.6
`HRU-CURRENCY-FLAG` CURRENCY_FLAG	Alpha 1	Conversion Method for Currency - Multiply/Divide. `N` No `Y` Yes	HR04.4, HR04.5, HR04.6
`HRU-ACTIVE-FLAG` ACTIVE_FLAG	Alpha 1	The 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`HRUSET1`	`FIELD-KEY`	Primary		BN305, HC02.5, HC10.1, HAP3.1, HCRE.1, HEP4.1, HLTM.1, HPOS.1 +22 more (list truncated in source)
`HRUSET2`	`FIELD-NAME`	KeyChange		HC02.5, HCDL.1, HCHP.1, HR04.4, HR04.5, HR04.6, HR10.4, HR15.1 +7 more
`HRUSET3`	`REQ-FLAG*`, `FIELD-NAME`	KeyChange, Subset	Where INDICATOR = "E" Or INDICATOR = "B"	HR210
`HRUSET4`	`REQ-FLAG*`, `FIELD-NAME`	KeyChange, Subset	Where 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`	`FIELD-TYPE`, `FIELD-NAME`	KeyChange		HR04.4, HR04.5, HR04.6, HR211, PA115, PA120, PA210, PA231 +1 more

Relations

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Emps And Apps	HREMPUSF	Delete Restricted		`HRU-FIELD-KEY` → `HEU-FIELD-KEY`, → `HEU-EMP-APP`, → `HEU-COMPANY`, → `HEU-EMPLOYEE`

Programs

Updated by (4)

HR04.4 Alphanumeric User Fields
HR04.5 Numeric User Fields
HR04.6 Date User Fields
HR10.4 Required User Fields

Referenced by (180)

BN305 Highly Compensated Employees
HAP3.1 Applicant Option 4 Selection Invoke
HC02.5 Turnover Group Criteria
HC10.1 Compensation Data Mart Upgrade
HCDL.1 Olap Data Load
HCHP.1 Olap Data Load
HCRE.1 Action Reason Code Selects
HEP4.1 Employee Option 4 Selection Invoke
HLTM.1 Lawson Talent Management Feed
HPOS.1 Position Selection Invoke
HPQC.1 Prqcentgrp Select Invoke
HPRS.1 Process Level Select Invoke
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR15.1 User Fields
HR170 Human Resource Writer Report Request
HR204 Human Resource Code Listing
HR210 Data Item Attribute Listing
HR211 Employee Listing
HR28.1 Employee Ethnicity
HR50.1 Interface Rules
HR511 Employee Conversion
HR515 User Field Conversion
HR54.1 Employee History Correction
HR55.1 Employee Group Definition
HR55.3 Employee Groups By Criteria
HR65.2 Human Resource Writer Format Item Selection
HR65.4 Human Resource Writer Print Order
HR65.5 Human Resource Writer Population Selection
HR65.7 Human Resource Writer Detail Selection
HR68.1 Human Resource Writer Data Item Security
HR70.1 Human Resource Writer Inquiry
HR80.1 Job Occupation Type
HR80.2 Union
HR80.3 Bargaining Unit
HR80.4 Badge Code
HR80.5 Mail Group
HR80.6 Hire Source
HR80.7 User Level
HR80.8 Relationship
HR80.9 Primary Care Physician
HR81.1 Education Degree
HR81.2 Education Subject
HR81.3 Education Institution
HR81.4 Competency
HR81.5 Competency and Certification Source
HR81.6 Certification
HR81.7 Company Property
HR81.8 Emergency Medical
HR81.9 Work Restriction
HR82.1 Working Condition
HR82.2 Work Requirement
HR82.3 Parking Lot
HR82.4 Relocation
HR82.5 Benefit
HR82.6 Qualification
HR82.7 Proficiency
HR82.8 User Field
HR82.9 Association
HR83.1 Review Type
HR83.2 Performance Rating
HR83.3 Applicant Rating
HR83.4 Interview Rating
HR83.5 Personnel Action Reason
HR83.6 Review Type
HR83.7 Benefit Reason Code
HR83.8 Requisition Status
HR83.9 Reason Code
HR84.1 Position Reason Code
HR84.2 Budget Reason Code
HR84.3 Requisition Cost
HR84.4 Supervisor User Field 1
HR84.5 Supervisor User Field 2
HR84.6 Supervisor User Field 3
HR84.7 Supervisor User Field 4
HR84.8 Supervisor User Field 5
HR84.9 Incident Status
HR85.1 Incident Outcome
HR85.2 Incident Category
HR85.3 Incident
HR85.4 Illness
HR85.5 Body Part
HR85.6 Incident Cost Category
HR85.7 Incident Cost Type
HR85.8 Accommodations
HR86.1 Incident Follow Up Category
HR86.2 Incident Follow Up Type
HR86.3 Incident Follow Up Outcome
HR86.4 Test Type
HR86.5 Test Correspondence
HR86.6 Test Source
HR86.7 Test User Field 2
HR86.8 Test User Field 3
HR86.9 Test Eligibility Override Reason
HR87.1 Test Reason
HR87.2 Test Notification Type
HR87.3 Test Refusal Reason
HR87.4 Incident Severity
HR87.5 Incident User 2
HR87.6 Incident User 3
HR87.7 Grievance and Disciplinary Action Category
HR87.8 Grievance and Disciplinary Action Status
HR87.9 Grievance and Disciplinary Action Outcome
HR88.1 Grievance and Disciplinary Action Step Category
HR88.2 Grievance and Disciplinary Action Step Type
HR88.3 Grievance and Disciplinary Action Step Outcome
HR88.4 Human Resource Codes - Disability
HR88.5 Human Resource Codes - Religion
HR88.6 Contract Type
HR88.7 Census Metropolitan Area
HR89.1 HR Codes - Work Eligibility Document Type
HR89.2 HR Codes - Work Eligibility Document Description
HR89.3 Human Resource Codes - Work Eligibility Status
HR89.4 Human Resource Codes - Travel Doc Application Status
HR89.5 Human Resource Codes - Travel Document
HR89.6 Human Resource Codes - Contact Number Type
HR89.7 HR Codes - Official Languages - Bilingual Region
HR89.8 Sharp Device
HR89.9 Brand of Device
HR91.7 Objective Status
HR92.1 Day Codes
HR92.2 Leave Status
HR92.3 Leave Reason
HRS1.1 Select Control
HRSC.1 Select Control
HS703 LPMH Employee and Job Profile Extract
HS705 Emp Work Force Mgmt Extract
LP03.1 Service Rule
LP03.2 Accrual Rule
LP03.3 Eligibility Rule
LP03.4 Limit Rule
LP03.5 Payroll Rule
LP03.6 General Ledger Rule
LP07.1 Calculation
LP140 Employee Absence Plan Calculation
LP145 Allotment Adjustment Calculation
LP198 General Ledger Liability Update
LP201 Absence Plan Listing
LP203 Absence Plan Rules Listing
LT10.1 HRM Interface Data Items
LT101 HRM Receiver Update
LT11.5 HRM User Field Interface
LT111 HRM Receiver Update
LT13.5 HRM User Field Interface History
LT22.5 HRM Employee User Field Interface
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA115 Employee Purge
PA120 Applicant Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA210 Length of Service Report
PA213 Position and Job Listing
PA231 Applicant Profile
PA31.1 Applicant
PA311 Employee Profile
PA50.1 Action
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PA54.1 Personnel Action History Correction
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR13.1 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR282 Canada Record of Employment
PR30.2 Employee Automatic Time Record
PR512 Employee ACH Distribution Interface
ZH500 Employee Data Extract
ZH510 Update PCP from ZPENDPCP