Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             HRPOSFLDS FILE

                          Position User Fields

REFERENCED BY

HR15.2    HR210     PA202     PA204     PA302     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
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
Field Key            Contains the unique system assigned key     PA04.4
                     to this record.

HRP-FIELD-NAME       Alpha 20  (Lower Case)                      PA04.2  PA04.3
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
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
Begining Value       For 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
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
Beginning Date       For 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
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
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
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
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
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
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
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
Currency Flag        Indicates whether user field is a           PA04.4
                     currency field.
                     N = No
                     Y = Yes

HRP-ACTIVE-FLAG      Alpha 1
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
                                                                 PA202   PA204
                                                                 PA302

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

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