Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             HRPOSUSD FILE

                        Position User Field Type

Contains user defined fields that have been established for tables other than
the applicant and employee. This file also holds the system-assigned 2-digit
code which identifies the class of data to which the user fields are linked
and the type of data associated with the user field, such as alpha, date, or
numeric.

REFERENCED BY

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

UPDATED BY

HR15.2    HR515     PA02.1    PA302     PA502     HR00.1
HR01.1    PBIP.1    PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

HPD-COMPANY          Numeric 4                                   HR15.2  HR515
Company              Contains the company number.                PA02.1  PA502

HPD-TYPE             Alpha 2                                     HR15.2  HR515
Type                 Contains a code that describes the          PA02.1  PA502
                     class of data to which the user defined
                     attributes are linked.
                     1 = Position

HPD-OBJ-ID           Numeric 12                                  HR15.2  HR515
Object               Contains the object identifier. It is       PA02.1  PA502
Identification       used to relate commitments or posted
                     transactions back to the originating
                     subsystems. Each subsystem record that
                     is updated as a commitment or posted
                     transaction is assigned an object
                     identifier. The object identifier is
                     maintained in the subsystem files and in
                     the Activity Commitments Detail and
                     Activity Transaction files. The object
                     identifier is a unique key used to drill
                     back from Activity Management to the
                     subsystems.

HPD-FIELD-KEY        Alpha 2                                     HR15.2  HR515
Field Key                                                        PA02.1  PA502

HPD-EFFECT-DATE      Numeric 8  (yyyymmdd)                       HR15.2  HR515
Begin Date           Contains the effective date for a           PA02.1  PA502
                     position.

HPD-END-DATE         Numeric 8  (yyyymmdd)                       HR15.2  HR515
End Date             Contains the end date for a position.       PA02.1  PA502

HPD-A-FIELD          Alpha 10                                    HR15.2  HR515
Alpha User Fields    Contains valid user defined                 PA02.1  PA502
                     alphanumeric values.

HPD-N-FIELD          Signed 11.2                                 HR15.2  HR515
Numeric User Fields  Contains valid user defined numeric         PA02.1  PA502
                     values.

HPD-D-FIELD          Numeric 8  (yyyymmdd)                       HR15.2  HR515
Date User Fields     Contains valid user defined date values.    PA02.1  PA502

HPD-DATE-STAMP       Numeric 8  (yyyymmdd)                       HR15.2  HR515
Date Stamp           This field contains the server date         PA02.1  PA502
                     (month, date, and year) of the last
                     change to this record.


HPD-TIME-STAMP       Numeric 6  (hhmmss)                         HR15.2  HR515
Time Stamp           Contains the server time (hour, minute,     PA02.1  PA502
                     and second) when the record was last
                     changed.

HPD-USER-ID          Alpha 10  (Lower Case)                      HR15.2  HR515
User ID              Contains the user ID of the person who      PA02.1  PA502
                     last changed this record.

HPD-CURRENCY-CODE    Alpha 5                                     HR15.2  HR515
Currency Code        If user field contains a currency           PA02.1  PA502
                     value, this field contains the currency
                     in which the value is recorded.

HPD-CURR-ND          Numeric 1                                   HR15.2  HR515
Currency Number of   Represents the number of decimals           PA02.1  PA502
Decimals             defined for the currency of the object.

HPD-BASE-CURRENCY    Alpha 5                                     HR15.2  HR515
Base Currency        Contains the company base currency.         PA02.1  PA502

HPD-BASE-ND          Numeric 1                                   HR15.2  HR515
Base Number Of       The number of decimal positions defined     PA02.1  PA502
Decimals             for the company base currency.

HPD-BASE-AMOUNT      Signed 15.2                                 HR15.2  HR515
Base Amount          Contains the amount in the company's        PA02.1  PA502
                     base currency.

                         HRPOSUSD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HPDSET1   COMPANY                                                HR00.1  HR01.1
          TYPE                                                   HR15.2  HR515
          OBJ-ID                                                 PA02.1  PA202
          EFFECT-DATE                                            PA302   PA502
          FIELD-KEY                                              PBIP.1  PR197

HPDSET2   TYPE                                                   PA04.2  PA04.3
          FIELD-KEY                                              PA04.4  PA04.5
          COMPANY
          OBJ-ID
          EFFECT-DATE*

                         HRPOSUSD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Base Currency  CUCODES      Required
                            When (HPD-CURRENCY-CODE != Spaces )

                            HPD-BASE-CURRENCY    -> CUC-CURRENCY-CODE

Company        PRSYSTEM     Required

                            HPD-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Currency       CUCODES      Required
                            When (HPD-CURRENCY-CODE != Spaces )

                            HPD-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Field Data     HRPOSFLDS    Required

                            HPD-TYPE             -> HRP-TYPE
                            HPD-FIELD-KEY        -> HRP-FIELD-KEY

Position       PAPOSITION   Required

                            HPD-COMPANY          -> POS-COMPANY
                            HPD-OBJ-ID           -> POS-OBJ-ID
                            HPD-EFFECT-DATE      -> POS-EFFECT-DATE

Values         HRPOSVAL     Required
                            When (HPD-REQ-VALUE = "Y" )

                            HPD-TYPE             -> HVL-TYPE
                            HPD-FIELD-KEY        -> HVL-FIELD-KEY
                            HPD-A-FIELD          -> HVL-CODE

                         HRPOSUSD FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Hr Hist Dt     HRHISTORY

                            HPD-COMPANY          -> HRH-COMPANY
                            Zeroes               -> HRH-EMPLOYEE
                            HPD-OBJ-ID           -> HRH-OBJ-ID
                            Zeroes               -> HRH-POS-LEVEL
                            HPD-EFFECT-DATE      -> HRH-BEG-DATE
                                                    HRH-FLD-NBR
                                                    HRH-SEQ-NBR