Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HREMPUSF


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

DA15.1    HGLM.1    HPOS.1    HPQC.1    HPRS.1    HR11.1
HR15.1    HR515     HR54.1    HRS1.1    HRSC.1    PA100
PA102     PA120     PA52.1    PA52.3    PA52.4    PA52.5
PA54.1    PRSC.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HEU-COMPANY            Numeric 4                                 DA15.1  HGLM.1
Element: Company       The company number represents an          HPOS.1  HPQC.1
                       established company and is entered on     HPRS.1  HR11.1
                       all function codes.                       HR15.1  HR515
                                                                 HR54.1  HRS1.1
                                                                 HRSC.1  PA100
                                                                 PA102   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PRSC.1

HEU-EMP-APP            Numeric 1                                 DA15.1  HGLM.1
Element: Type          Indicates if the individual is an         HPOS.1  HPQC.1
                       employee or an applicant.                 HPRS.1  HR11.1
                       0 = Employee                              HR15.1  HR515
                       1 = Applicant                             HR54.1  HRS1.1
                                                                 HRSC.1  PA100
                                                                 PA102   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PRSC.1

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

HEU-FIELD-KEY          Alpha 2                                   DA15.1  HGLM.1
Element: Field Key     Contains the system assigned two-digit    HPOS.1  HPQC.1
                       user field identifier.                    HPRS.1  HR11.1
                                                                 HR15.1  HR515
                                                                 HR54.1  HRS1.1
                                                                 HRSC.1  PA100
                                                                 PA102   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PRSC.1

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

HEU-N-FIELD            Signed 11.2                               DA15.1  HGLM.1
Element: N Field       Contains employee values for numeric      HPOS.1  HPQC.1
                       user fields.                              HPRS.1  HR11.1
                                                                 HR15.1  HR515
                                                                 HR54.1  HRS1.1
                                                                 HRSC.1  PA100
                                                                 PA102   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PRSC.1

HEU-D-FIELD            Numeric 8  (yyyymmdd)                     DA15.1  HGLM.1
Element: D Field       Contains employee values for date user    HPOS.1  HPQC.1
                       fields.                                   HPRS.1  HR11.1
                                                                 HR15.1  HR515
                                                                 HR54.1  HRS1.1
                                                                 HRSC.1  PA100
                                                                 PA102   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PRSC.1

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

HEU-CURR-ND            Numeric 1                                 HGLM.1  HPOS.1
Account Currency                                                 HPQC.1  HPRS.1
Code                                                             HR11.1  HR15.1
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA100   PA102
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PRSC.1

HEU-BASE-CURRENCY      Alpha 5                                   HGLM.1  HPOS.1
To Company Base                                                  HPQC.1  HPRS.1
Currency                                                         HR11.1  HR15.1
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA100   PA102
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PRSC.1

HEU-BASE-ND            Numeric 1                                 HGLM.1  HPOS.1
Account Currency                                                 HPQC.1  HPRS.1
Code                                                             HR11.1  HR15.1
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA100   PA102
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PRSC.1

HEU-BASE-AMOUNT        Signed 15.2                               HGLM.1  HPOS.1
Element: Adj Amt                                                 HPQC.1  HPRS.1
                                                                 HR11.1  HR15.1
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA100   PA102
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PRSC.1

                         HREMPUSF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HEUSET1   COMPANY                                                HCOP.1  HCOP.2
          EMP-APP                                                DA15.1  HGLM.1
          EMPLOYEE                                               HPOS.1  HPQC.1
          FIELD-KEY                                              HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR155   HR170
                                                                 HR211   HR511
                                                                 HR515   HR54.1
                                                                 HR55.2  HR650
                                                                 HR70.1  HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA115
                                                                 PA120   PA13.1
                                                                 PA13.2  PA16.1
                                                                 ...

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 HRU-REQ-VALUE = "Y"

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