Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HRPOSVAL


                             HRPOSVAL FILE

                       Position User Field Values

REFERENCED BY

HR15.2    HR515     PA103     PA204     PA495

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HVL-TYPE               Alpha 2                                   PA04.5
Element: 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
Element: 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
Element: Code          Contains the user defined code which
                       can be used for each user field.

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

HVL-STATUS             Numeric 1                                 PA04.5
Element: 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
Element: 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
Element: 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
Element: User ID

                         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
                                                                 PA103   PA204
                                                                 PA495

                         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