Lawson Insight Technical Documentation


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    HR70.1    PA02.1    PA13.1    PA13.2    PA16.1
PA20.1    PA21.1    PA22.1    PA231     PA24.1    PA272
PA31.1    PA311     PA34.1    PA35.1    PA36.1    PA38.1
PA502     PA513     PA520     PA53.1    PA66.3    TR21.1
TR22.1    TR500     PR13.1    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.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

UPDATED BY

HR11.1    HR15.1    HR515     HR54.1    HR700     HRS1.1
HRSC.1    PA100     PA102     PA115     PA120     PA52.1
PA52.3    PA52.4    PA52.5    PA54.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

HEU-COMPANY          Numeric 4                                   HR11.1  HR15.1
Company              The company number represents an            HR515   HR54.1
                     established company and is entered on       HR700   HRS1.1
                     all function codes.                         HRSC.1  PA100
                                                                 PA102   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1

HEU-EMP-APP          Numeric 1                                   HR11.1  HR15.1
Type                 Indicates if the individual is an           HR515   HR54.1
                     employee or an applicant.                   HR700   HRS1.1
                     0 = Employee                                HRSC.1  PA100
                     1 = Applicant                               PA102   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1

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

HEU-FIELD-KEY        Alpha 2                                     HR11.1  HR15.1
Field Key            Contains the system assigned two-digit      HR515   HR54.1
                     user field identifier.                      HR700   HRS1.1
                                                                 HRSC.1  PA100
                                                                 PA102   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1

HEU-A-FIELD          Alpha 10                                    HR11.1  HR15.1
User Fields -        Contains the employee values for            HR515   HR54.1
Alphanumeric         alphanumeric user fields.                   HR700   HRS1.1
                                                                 HRSC.1  PA100
                                                                 PA102   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1

HEU-N-FIELD          Signed 11.2                                 HR11.1  HR15.1
N Field              Contains employee values for numeric        HR515   HR54.1
                     user fields.                                HR700   HRS1.1
                                                                 HRSC.1  PA100
                                                                 PA102   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1

HEU-D-FIELD          Numeric 8  (yyyymmdd)                       HR11.1  HR15.1
D Field              Contains employee values for date user      HR515   HR54.1
                     fields.                                     HR700   HRS1.1
                                                                 HRSC.1  PA100
                                                                 PA102   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1

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

HEU-CURR-ND          Numeric 1                                   HR11.1  HR15.1
Currency Number of   Represents the number of decimals           HR515   HR54.1
Decimals             defined for the currency of the object.     HR700   HRS1.1
                                                                 HRSC.1  PA100
                                                                 PA102   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1

HEU-BASE-CURRENCY    Alpha 5                                     HR11.1  HR15.1
Base Currency        The company base currency.                  HR515   HR54.1
                                                                 HR700   HRS1.1
                                                                 HRSC.1  PA100
                                                                 PA102   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1

HEU-BASE-ND          Numeric 1                                   HR11.1  HR15.1
Base Number Of       The number of decimal positions defined     HR515   HR54.1
Decimals             for the company base currency.              HR700   HRS1.1
                                                                 HRSC.1  PA100
                                                                 PA102   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1

HEU-BASE-AMOUNT      Signed 15.2                                 HR11.1  HR15.1
Base Amount          The base amount to be posted to the         HR515   HR54.1
                     General Ledger Account Master file.         HR700   HRS1.1
                                                                 HRSC.1  PA100
                                                                 PA102   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1

                         HREMPUSF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HEUSET1   COMPANY                                                HCOP.1  HCOP.2
          EMP-APP                                                HR11.1  HR15.1
          EMPLOYEE                                               HR155   HR170
          FIELD-KEY                                              HR211   HR511
                                                                 HR515   HR54.1
                                                                 HR55.2  HR70.1
                                                                 HR700   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA120
                                                                 PA13.1  PA13.2
                                                                 PA16.1  PA20.1
                                                                 PA21.1  PA22.1
                                                                 PA231   PA24.1
                                                                 PA272   PA31.1
                                                                 ...

HEUSET2   FIELD-KEY                                              HR04.4  HR04.5
          EMP-APP                                                HR04.6  HR700
          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.8  HR82.9
                                                                 ...

                         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