HRPOSVAL – Position User Field Values

System: Human Resources (HR)
Prefix: HVL
Primary key: TYPE, FIELD-KEY, CODE
Fields: 8
Updated by: 8 programs
Referenced by: 12 programs

HRPOSVAL is the Position User Field Values table in Lawson Human Resources (prefix HVL). It is indexed by TYPE, FIELD-KEY, CODE (HVLSET1). It is related 1:1 to HRPOSFLDS. It is updated by HR26.2, HR26.3, HR26.4, HR26.5, PA04.2, PA04.3, PA04.4 and PA04.5 and referenced by HR15.2, HR15.3, HR226, HR515, LT101, LT11.7, LT111, LT13.7 and 4 more. The table has 8 fields, 1 index and 2 documented relations.

About HRPOSVAL

No description in the Lawson data dictionary.

Fields (8)

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

Field / column	Type	Description & values	Updated by
`HVL-TYPE` PK TYPE	Alpha 2	Contains a code that describes the class of data to which the user defined attributes are linked. `1` Position `2` Job Code	HR26.5, PA04.5
`HVL-FIELD-KEY` PK FIELD_KEY	Alpha 2	Contain a unique system assigned key. The value of this field is established when an HRPOSFLDS record is created. 01 99	HR26.5, PA04.5
`HVL-CODE` PK CODE	Alpha 10	Contains the user defined code which can be used for each user field.	HR26.5, PA04.5
`HVL-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	Contain the description of the code.	HR26.5, PA04.5
`HVL-STATUS` STATUS	Numeric 1	Contains a value which indicates whether the code is active. Inactive codes are not available for use when user fields are added or changed. `1` Active `2` Inactive	HR26.5, PA04.5
`HVL-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	HR26.5, PA04.5
`HVL-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	HR26.5, PA04.5
`HVL-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	HR26.5, PA04.5

Indexes (1)

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
`HVLSET1`	`TYPE`, `FIELD-KEY`, `CODE`	Primary		HR15.2, HR15.3, HR226, HR26.2, HR26.3, HR26.4, HR26.5, HR515 +12 more

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Field Data	HRPOSFLDS	Required		`"1 "` → `HRP-TYPE`, `HVL-FIELD-KEY` → `HRP-FIELD-KEY`
Job Field Data	HRPOSFLDS	Required		`"2 "` → `HRP-TYPE`, `HVL-FIELD-KEY` → `HRP-FIELD-KEY`

Programs

Updated by (8)

HR26.2 Job Code Alpha User Field Set Up
HR26.3 Job Code Numeric User Field Set Up
HR26.4 Job Code Date User Field Set Up
HR26.5 Value List
PA04.2 Alpha Fields
PA04.3 Numeric Fields
PA04.4 Date Fields
PA04.5 Alpha Field Values

Referenced by (12)

HR15.2 Alphanumeric User Fields
HR15.3 Job Code User Fields
HR226 Job Code User Field Listing
HR515 User Field Conversion
LT101 HRM Receiver Update
LT11.7 HRM Position User Field Interface
LT111 HRM Receiver Update
LT13.7 HRM Pos UserFld Interface History
LT22.7 HRM Position User Field Interface
PA103 Mass Position Changes
PA204 Position User Field Listing
PA495 IPEDS Report