Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             HRPOSVAL FILE

                       Position User Field Values

REFERENCED BY

HR15.2    HR515     PA204

UPDATED BY

PA04.5    PA04.2    PA04.3    PA04.4

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

HVL-TYPE             Alpha 2                                     PA04.5
Type                 Contains a code that describes the
                     class of data to which the user defined
                     attributes are linked.
                     1 = Position

HVL-FIELD-KEY        Alpha 2                                     PA04.5
Line Action          Contain a unique system assigned key.
                     The value of this field is established
                     when an HRPOSFLDS record is created.
                     01
                     99

HVL-CODE             Alpha 10                                    PA04.5
Code                 Contains the user defined code which
                     can be used for each user field.

HVL-DESCRIPTION      Alpha 30  (Lower Case)                      PA04.5
Description          Contain the description of the code.

HVL-STATUS           Numeric 1                                   PA04.5
Status               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

HVL-DATE-STAMP       Numeric 8  (yyyymmdd)                       PA04.5
Date Stamp           This field contains the server date
                     (month, date, and year) of the last
                     change to this record.

HVL-TIME-STAMP       Numeric 6  (hhmmss)                         PA04.5
Time Stamp           Contains the server time (hour, minute,
                     and second) when the record was last
                     changed.

HVL-USER-ID          Alpha 10  (Lower Case)                      PA04.5
User ID              Contains the user ID of the person who
                     last changed this record.

                         HRPOSVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HVLSET1   TYPE                                                   HR15.2  HR515
          FIELD-KEY                                              PA04.2  PA04.3
          CODE                                                   PA04.4  PA04.5
                                                                 PA204

                         HRPOSVAL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Field Data     HRPOSFLDS    Required

                            HVL-TYPE         -> HRP-TYPE
                            HVL-FIELD-KEY    -> HRP-FIELD-KEY