HRPOSFLDS – Position User Fields

System: Human Resources (HR)
Prefix: HRP
Primary key: TYPE, FIELD-KEY
Fields: 16
Updated by: 6 programs
Referenced by: 21 programs

HRPOSFLDS is the Position User Fields table in Lawson Human Resources (prefix HRP). It is indexed by TYPE, FIELD-KEY (HRPSET1); alternate indexes: HRPSET2 and HRPSET3. It is related 1:M to HRPOSUSD and HRPOSVAL. It is updated by HR26.2, HR26.3, HR26.4, PA04.2, PA04.3 and PA04.4 and referenced by HLTM.1, HR15.2, HR15.3, HR206, HR210, HR226, HR50.1, HR515 and 13 more. The table has 16 fields, 3 indexes and 4 documented relations.

About HRPOSFLDS

No description in the Lawson data dictionary.

Fields (16)

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

Field / column	Type	Description & values	Updated by
`HRP-TYPE` PK TYPE	Alpha 2	Contains the code that describes the class of data to which the user defined attributes are linked. `1` Position `2` Job Code	HR26.2, HR26.3, HR26.4, PA04.2, PA04.3, PA04.4
`HRP-FIELD-KEY` PK FIELD_KEY	Alpha 2	Contains the unique system assigned key to this record.	HR26.2, HR26.3, HR26.4, PA04.2, PA04.3, PA04.4
`HRP-FIELD-NAME` FIELD_NAME	Alpha 20 (Lower Case)	Contains the user defined name of the data being tracked. This name is unique per Field Key and Type.	HR26.2, HR26.3, HR26.4, PA04.2, PA04.3, PA04.4
`HRP-FIELD-TYPE` FIELD_TYPE	Alpha 1	Contains the type of data associated with this field name. `1` Alphanumeric `2` Numeric `3` Date	HR26.2, HR26.3, HR26.4, PA04.2, PA04.3, PA04.4
`HRP-BEG-NUMBER` BEG_NUMBER	Signed 11.2	For numeric field types, contains the lowest value in a defined range of valid values.	HR26.2, HR26.3, HR26.4, PA04.2, PA04.3, PA04.4
`HRP-END-NUMBER` END_NUMBER	Signed 11.2	For a numeric field type, contains the highest value in a user defined range of valid values.	HR26.2, HR26.3, HR26.4, PA04.2, PA04.3, PA04.4
`HRP-BEG-DATE` BEG_DATE	Numeric 8 (yyyymmdd)	For date field types, contains the lowest date in the user defined range of valid values.	HR26.2, HR26.3, HR26.4, PA04.2, PA04.3, PA04.4
`HRP-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	For date field types, contains the highest date in the user defined range of valid values.	HR26.2, HR26.3, HR26.4, PA04.2, PA04.3, PA04.4
`HRP-REQ-FLAG` REQ_FLAG	Alpha 1	Contains a value which indicates if data must be entered in this field when a record is created. For example, if a field called Succession Plan is flagged as required, then a position record can not be added until a value is entered in the Succession Plan field. `X` Field Always Required	HR26.2, HR26.3, HR26.4, PA04.2, PA04.3, PA04.4
`HRP-REQ-VALUE` REQ_VALUE	Alpha 1	Contains a value that indicates whether a value list must be created for this field name. This field is available only to alphanumeric user fields. `Y` Yes `N` No	HR26.2, HR26.3, HR26.4, PA04.2, PA04.3, PA04.4
`HRP-LOG-FLAG` LOG_FLAG	Alpha 1	Contains a value that indicates whether history should be kept for this field name. `X` Log Changes	HR26.2, HR26.3, HR26.4, PA04.2, PA04.3, PA04.4
`HRP-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	Contains the server date (month, date, and year) of the last change to this record.	HR26.2, HR26.3, HR26.4, PA04.2, PA04.3, PA04.4
`HRP-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	HR26.2, HR26.3, HR26.4, PA04.2, PA04.3, PA04.4
`HRP-USER-ID` USER_ID	Alpha 10 (Lower Case)	Contains the user ID of the person who last changed this record.	HR26.2, HR26.3, HR26.4, PA04.2, PA04.3, PA04.4
`HRP-CURRENCY-FLAG` CURRENCY_FLAG	Alpha 1	Indicates whether user field is a currency field. `N` No `Y` Yes	HR26.2, HR26.3, HR26.4, PA04.2, PA04.3, PA04.4
`HRP-ACTIVE-FLAG` ACTIVE_FLAG	Alpha 1	The Active flag indicates if the position user field can be newly added for a current position. `A` Active `I` Inactive	HR26.2, HR26.3, HR26.4, PA04.2, PA04.3, PA04.4

Indexes (3)

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

Index	Keys	Flags	Used in
`HRPSET1`	`TYPE`, `FIELD-KEY`	Primary	HLTM.1, HR15.2, HR15.3, HR206, HR210, HR226, HR26.2, HR26.3 +19 more
`HRPSET2`	`TYPE`, `FIELD-TYPE`, `FIELD-NAME`		HR226, HR26.2, HR26.3, HR26.4, HR515, PA04.2, PA04.3, PA04.4 +2 more
`HRPSET3`	`TYPE`, `REQ-FLAG*`, `FIELD-NAME`	KeyChange	HR15.2, HR15.3, HR26.2, HR26.3, HR26.4, LT101, LT111, PA02.1 +5 more

Relations

One to many (4) — child tables

Relation	Table	Rules	Condition	Field map
Job Data	HRPOSUSD	Delete Cascades		`"2 "` → `HPD-TYPE`, `HRP-FIELD-KEY` → `HPD-FIELD-KEY`, → `HPD-COMPANY`, → `HPD-OBJ-ID`, → `HPD-EFFECT-DATE`
Job Values	HRPOSVAL	Delete Cascades	Valid When (HRP-TYPE = "2") And (HRP-REQ-VALUE = "Y")	`HRP-TYPE` → `HVL-TYPE`, `HRP-FIELD-KEY` → `HVL-FIELD-KEY`, → `HVL-CODE`
Pos Data	HRPOSUSD	Delete Cascades		`"1 "` → `HPD-TYPE`, `HRP-FIELD-KEY` → `HPD-FIELD-KEY`, → `HPD-COMPANY`, → `HPD-OBJ-ID`, → `HPD-EFFECT-DATE`
Values	HRPOSVAL	Delete Cascades	Valid When (HRP-FIELD-TYPE = "1") And (HRP-REQ-VALUE = "Y")	`HRP-TYPE` → `HVL-TYPE`, `HRP-FIELD-KEY` → `HVL-FIELD-KEY`, → `HVL-CODE`

Programs

Updated by (6)

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
PA04.2 Alpha Fields
PA04.3 Numeric Fields
PA04.4 Date Fields

Referenced by (21)

HLTM.1 Lawson Talent Management Feed
HR15.2 Alphanumeric User Fields
HR15.3 Job Code User Fields
HR206 Job Code Listing
HR210 Data Item Attribute Listing
HR226 Job Code User Field Listing
HR50.1 Interface Rules
HR515 User Field Conversion
LT10.1 HRM Interface Data Items
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
PA02.1 Position
PA103 Mass Position Changes
PA202 Position Listing
PA204 Position User Field Listing
PA302 Position Purge
PA495 IPEDS Report
PA502 Position Conversion