Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HRPOSFLDS


                             HRPOSFLDS FILE

                          Position User Fields

REFERENCED BY

HR15.2    HR210     PA103     PA202     PA204     PA302
PA495     HR515     PA02.1    PA502

UPDATED BY

PA04.2    PA04.3    PA04.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HRP-TYPE               Alpha 2                                   PA04.2  PA04.3
Element: Type          Contains the code that describes the      PA04.4
                       class of data to which the user defined
                       attributes are linked.
                       1 = Position

HRP-FIELD-KEY          Alpha 2                                   PA04.2  PA04.3
Element: Field Key     Contains the unique system assigned key   PA04.4
                       to this record.

HRP-FIELD-NAME         Alpha 20  (Lower Case)                    PA04.2  PA04.3
Element: Field Name    Contains the user defined name of the     PA04.4
                       data being tracked. This name is unique
                       per Field Key and Type.

HRP-FIELD-TYPE         Alpha 1                                   PA04.2  PA04.3
Element: Field Type    Contains the type of data associated      PA04.4
                       with this field name.
                       1 = Alphanumeric
                       2 = Numeric
                       3 = Date

HRP-BEG-NUMBER         Signed 11.2                               PA04.2  PA04.3
Element: Begining ValueFor numeric field types, contains the     PA04.4
                       lowest value in a defined range of valid
                       values.

HRP-END-NUMBER         Signed 11.2                               PA04.2  PA04.3
Element: End Value     For a numeric field type, contains the    PA04.4
                       highest value in a user defined range of
                       valid values.

HRP-BEG-DATE           Numeric 8  (yyyymmdd)                     PA04.2  PA04.3
Element: Beginning DateFor date field types, contains the        PA04.4
                       lowest date in the user defined range of
                       valid values.

HRP-END-DATE           Numeric 8  (yyyymmdd)                     PA04.2  PA04.3
Element: End Date      For date field types, contains the        PA04.4
                       highest date in the user defined range
                       of valid values.

HRP-REQ-FLAG           Alpha 1                                   PA04.2  PA04.3
Element: Required      Contains a value which indicates if       PA04.4
                       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

HRP-REQ-VALUE          Alpha 1                                   PA04.2  PA04.3
Element: Required      Contains a value that indicates whether   PA04.4
                       a value list must be created for this
                       field name. This field is available only
                       to alphanumeric user fields.
                       Y = Yes
                       N = No

HRP-LOG-FLAG           Alpha 1                                   PA04.2  PA04.3
Element: History       Contains a value that indicates whether   PA04.4
                       history should be kept for this field
                       name.
                       X = Log Changes

HRP-DATE-STAMP         Numeric 8  (yyyymmdd)                     PA04.2  PA04.3
Element: Date Stamp    Contains the server date (month, date,    PA04.4
                       and year) of the last change to this
                       record.

HRP-TIME-STAMP         Numeric 6  (hhmmss)                       PA04.2  PA04.3
Element: Time Stamp    Contains the server time (hour, minute,   PA04.4
                       and second) when the record was last
                       changed.

HRP-USER-ID            Alpha 10  (Lower Case)                    PA04.2  PA04.3
Element: User ID       Contains the user ID of the person who    PA04.4
                       last changed this record.

HRP-CURRENCY-FLAG      Alpha 1                                   PA04.2  PA04.3
Element: Currency Flag Indicates whether user field is a         PA04.4
                       currency field.
                       N = No
                       Y = Yes

HRP-ACTIVE-FLAG        Alpha 1
Element: Status        The Active flag indicates if the
                       position user field can be newly added
                       for a current position.
                       A = Active
                       I = Inactive

                         HRPOSFLDS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HRPSET1   TYPE                                                   HR15.2  HR210
          FIELD-KEY                                              PA04.2  PA04.3
                                                                 PA04.4  PA04.5
                                                                 PA103   PA202
                                                                 PA204   PA302
                                                                 PA495

HRPSET2   TYPE                                                   HR515   PA04.2
          FIELD-TYPE                                             PA04.3  PA04.4
          FIELD-NAME                                             PA204   PA495

HRPSET3   TYPE          KeyChange                                HR15.2  PA02.1
          REQ-FLAG*                                              PA04.2  PA04.3
          FIELD-NAME                                             PA04.4  PA302
                                                                 PA502

                         HRPOSFLDS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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