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           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