Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             HREMPUSF FILE

                     Employee/Applicant User Fields

Contains the system assigned identifier for user-fields, and the associated
alphanumeric, numeric, or date employee values for the fields.

REFERENCED BY

HCOP.1    HCOP.2    HR155     HR170     HR211     HR511
HR55.2    HR650     HR70.1    PA16.1    PA231     PA272
PA31.1    PA311     PA502     PA513     PA53.1    PA66.3
TR22.1    TR500     PR13.1    PR13.5    PR13.6    PR13.8
PR282     HR04.4    HR04.5    HR04.6    HR04.2    HR04.3
HR04.7    HR04.8    HR80.1    HR80.2    HR80.3    HR80.4
HR80.5    HR80.6    HR80.7    HR80.8    HR80.9    HR81.1
HR81.2    HR81.3    HR81.4    HR81.5    HR81.6    HR81.7
HR81.8    HR81.9    HR82.1    HR82.2    HR82.3    HR82.4
HR82.5    HR82.6    HR82.7    HR82.8    HR82.9    HR83.1
HR83.2    HR83.3    HR83.4    HR83.5    HR83.6    HR83.7
HR83.8    HR83.9    HR84.1    HR84.2    HR84.3    HR84.4
HR84.5    HR84.6    HR84.7    HR84.8    HR84.9    HR85.1
HR85.2    HR85.3    HR85.4    HR85.5    HR85.6    HR85.7
HR85.8    HR86.1    HR86.2    HR86.3    HR86.4    HR86.5
HR86.6    HR86.7    HR86.8    HR86.9    HR87.1    HR87.2
HR87.3    HR87.4    HR87.5    HR87.6    HR87.7    HR87.8
HR87.9    HR88.1    HR88.2    HR88.3    HR88.4    HR88.5
HR88.6    HR88.7    HR89.1    HR89.2    HR89.3    HR89.4
HR89.5    HR89.6    HR89.7

UPDATED BY

HR15.1    HR515     HR54.1    HRS1.1    HRSC.1    PA120
PA54.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

HEU-COMPANY          Numeric 4                                   HR15.1  HR515
Company              The company number represents an            HR54.1  HRS1.1
                     established company and is entered on       HRSC.1  PA54.1
                     all function codes.

HEU-EMP-APP          Numeric 1                                   HR15.1  HR515
Type                 Indicates if the individual is an           HR54.1  HRS1.1
                     employee or an applicant.                   HRSC.1  PA54.1
                     0 = Employee
                     1 = Applicant

HEU-EMPLOYEE         Numeric 9                                   HR15.1  HR515
Employee             Contains the employee number. Each          HR54.1  HRS1.1
                     person employed by the company is           HRSC.1  PA54.1
                     assigned a unique number. The system
                     uses the employee number to correlate
                     all of the information related to that
                     person.

HEU-FIELD-KEY        Alpha 2                                     HR15.1  HR515
Field Key            Contains the system assigned two-digit      HR54.1  HRS1.1
                     user field identifier.                      HRSC.1  PA54.1

HEU-A-FIELD          Alpha 10                                    HR15.1  HR515
User Fields -        Contains the employee values for            HR54.1  HRS1.1
Alphanumeric         alphanumeric user fields.                   HRSC.1  PA54.1

HEU-N-FIELD          Signed 11.2                                 HR15.1  HR515
N Field              Contains employee values for numeric        HR54.1  HRS1.1
                     user fields.                                HRSC.1  PA54.1

HEU-D-FIELD          Numeric 8  (yyyymmdd)                       HR15.1  HR515
D Field              Contains employee values for date user      HR54.1  HRS1.1
                     fields.                                     HRSC.1  PA54.1

HEU-CURRENCY-CODE    Alpha 5                                     HR15.1  HR515
Currency Code        This field contains the company base        HR54.1  HRS1.1
                     currency code established in Company        HRSC.1  PA54.1
                     (GL10.1 ).

HEU-CURR-ND          Numeric 1                                   HR15.1  HR515
Currency Number of   Represents the number of decimals           HR54.1  HRS1.1
Decimals             defined for the currency of the object.     HRSC.1  PA54.1

HEU-BASE-CURRENCY    Alpha 5                                     HR15.1  HR515
Base Currency        The company base currency.                  HR54.1  HRS1.1
                                                                 HRSC.1  PA54.1

HEU-BASE-ND          Numeric 1                                   HR15.1  HR515
Base Number Of       The number of decimal positions defined     HR54.1  HRS1.1
Decimals             for the company base currency.              HRSC.1  PA54.1

HEU-BASE-AMOUNT      Signed 15.2                                 HR15.1  HR515
Base Amount          The base amount to be posted to the         HR54.1  HRS1.1
                     General Ledger Account Master file.         HRSC.1  PA54.1

                         HREMPUSF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HEUSET1   COMPANY                                                HCOP.1  HCOP.2
          EMP-APP                                                HR15.1  HR155
          EMPLOYEE                                               HR170   HR211
          FIELD-KEY                                              HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR650   HR70.1
                                                                 HRS1.1  HRSC.1
                                                                 PA120   PA16.1
                                                                 PA231   PA272
                                                                 PA31.1  PA311
                                                                 PA502   PA513
                                                                 PA53.1  PA54.1
                                                                 PA66.3  TR22.1
                                                                 TR500   PR13.1
                                                                 PR13.5  PR13.6
                                                                 ...

HEUSET2   FIELD-KEY                                              HR04.4  HR04.5
          EMP-APP                                                HR04.6
          COMPANY
          EMPLOYEE

HEUSET3   FIELD-KEY     KeyChange, Subset                        HR04.2  HR04.3
          A-FIELD       Where A-FIELD != Spaces                  HR04.7  HR04.8
          COMPANY                                                HR80.1  HR80.2
          EMP-APP                                                HR80.3  HR80.4
          EMPLOYEE                                               HR80.5  HR80.6
                                                                 HR80.7  HR80.8
                                                                 HR80.9  HR81.1
                                                                 HR81.2  HR81.3
                                                                 HR81.4  HR81.5
                                                                 HR81.6  HR81.7
                                                                 HR81.8  HR81.9
                                                                 HR82.1  HR82.2
                                                                 HR82.3  HR82.4
                                                                 HR82.5  HR82.6
                                                                 HR82.7  HR82.8
                                                                 ...

                         HREMPUSF FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Applicant      APPLICANT    Required
                            When HEU-EMP-APP = 1

                            HEU-COMPANY          -> APL-COMPANY
                            HEU-EMPLOYEE         -> APL-APPLICANT

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

                            HEU-BASE-CURRENCY    -> CUC-CURRENCY-CODE

Company        PRSYSTEM     Required

                            HEU-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

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

                            HEU-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Employee       EMPLOYEE     Required
                            When HEU-EMP-APP = Zeroes

                            HEU-COMPANY          -> EMP-COMPANY
                            HEU-EMPLOYEE         -> EMP-EMPLOYEE

Field Name     HRUSERFLDS   Required

                            HEU-FIELD-KEY        -> HRU-FIELD-KEY

Hr Code        PCODES       Required
                            When HEU-REQ-VALUE = "Y"

                            HEU-FIELD-KEY        -> PCO-TYPE
                            HEU-A-FIELD          -> PCO-CODE