Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HRPOSUSD


                             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
Element: Company       Contains the company number.              PA02.1  PA502

HPD-TYPE               Alpha 2                                   HR15.2  HR515
Element: 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
Element: Field Key                                               PA02.1  PA502

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

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

HPD-A-FIELD            Alpha 10                                  HR15.2  HR515
Element: Alpha User FieContains valid user defined               PA02.1  PA502
                       alphanumeric values.

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

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

HPD-DATE-STAMP         Numeric 8  (yyyymmdd)                     HR15.2  HR515
Element: 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
Element: 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
Element: User ID                                                 PA02.1  PA502

HPD-CURRENCY-CODE      Alpha 5                                   HR15.2  HR515
Element: 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
Account Currency                                                 PA02.1  PA502
Code

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

HPD-BASE-ND            Numeric 1                                 HR15.2  HR515
Account Currency                                                 PA02.1  PA502
Code

HPD-BASE-AMOUNT        Signed 15.2                               HR15.2  HR515
Element: Adj Amt       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 (HRP-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