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

HCDL.1    HCHP.1    HR155     HR170     HR211     HR55.2
HR70.1    LP100     LP101     LP140     LP145     LP198
PA113     PA16.1    PA20.1    PA21.1    PA210     PA22.1
PA231     PA24.1    PA27.1    PA272     PA31.1    PA311
PA34.1    PA35.1    PA36.1    PA38.1    PA520     PA53.1
PA66.3    TR21.1    TR22.1    TR26.1    TR500     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    HR89.8    HR89.9    HR91.7

UPDATED BY

BN305     HAP3.1    HEP4.1    HPOS.1    HPQC.1    HPRS.1
HR11.1    HR11.2    HR15.1    HR511     HR515     HR54.1
HRS1.1    HRSC.1    PA02.1    PA100     PA102     PA115
PA120     PA13.1    PA13.2    PA502     PA513     PA52.1
PA52.3    PA52.4    PA52.5    PA54.1    PR110     PR113
PR120     PR13.1    PR13.5    PR13.6    PR13.8

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HEU-COMPANY            Numeric 4                                 BN305   HAP3.1
Element: Company Hr                                              HEP4.1  HPOS.1
                                                                 HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

HEU-EMP-APP            Numeric 1                                 BN305   HAP3.1
Element: Emp App       Indicates if the individual is an         HEP4.1  HPOS.1
                       employee or an applicant.                 HPQC.1  HPRS.1
                       0 = Employee                              HR11.1  HR11.2
                       1 = Applicant                             HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

HEU-EMPLOYEE           Numeric 9                                 BN305   HAP3.1
Element: Employee      Contains the employee number. Each        HEP4.1  HPOS.1
                       person employed by the company is         HPQC.1  HPRS.1
                       assigned a unique number. The system      HR11.1  HR11.2
                       uses the employee number to correlate     HR15.1  HR511
                       all of the information related to that    HR515   HR54.1
                       person.                                   HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

HEU-FIELD-KEY          Alpha 2                                   BN305   HAP3.1
Element: Field Key     Contains the system assigned two-digit    HEP4.1  HPOS.1
                       user field identifier.                    HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

HEU-A-FIELD            Alpha 10                                  BN305   HAP3.1
User Fields -          Contains the employee values for          HEP4.1  HPOS.1
Alphanumeric           alphanumeric user fields.                 HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

HEU-N-FIELD            Signed 11.2                               BN305   HAP3.1
Element: N Field       Contains employee values for numeric      HEP4.1  HPOS.1
                       user fields.                              HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

HEU-D-FIELD            Numeric 8  (yyyymmdd)                     BN305   HAP3.1
Element: D Field       Contains employee values for date user    HEP4.1  HPOS.1
                       fields.                                   HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

HEU-CURRENCY-CODE      Alpha 5                                   BN305   HAP3.1
Element: Currency Code This field contains the company base      HEP4.1  HPOS.1
                       currency code established in Company      HPQC.1  HPRS.1
                       (GL10.1 ).                                HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

HEU-CURR-ND            Numeric 1                                 BN305   HAP3.1
Element: Acct Nd       The number of decimals assigned to a      HEP4.1  HPOS.1
                       particular account as determined by the   HPQC.1  HPRS.1
                       account currency.                         HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

HEU-BASE-CURRENCY      Alpha 5                                   BN305   HAP3.1
Element: Base Currency The company base currency.                HEP4.1  HPOS.1
                                                                 HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

HEU-BASE-ND            Numeric 1                                 BN305   HAP3.1
Element: Base Nd       The number of decimal positions defined   HEP4.1  HPOS.1
                       for the company base currency.            HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

HEU-BASE-AMOUNT        Signed 15.2                               BN305   HAP3.1
Element: Base Amt      This is the amount of the transaction in  HEP4.1  HPOS.1
                       the company base amount.                  HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR511
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

                         HREMPUSF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HEUSET1   COMPANY                                                BN305   HCDL.1
          EMP-APP                                                HCHP.1  HAP3.1
          EMPLOYEE                                               HEP4.1  HPOS.1
          FIELD-KEY                                              HPQC.1  HPRS.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR170   HR211
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR70.1  HRS1.1
                                                                 HRSC.1  LP100
                                                                 LP101   LP140
                                                                 LP145   LP198
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 ...

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

Paemployee     PAEMPLOYEE   Required
                            When HEU-EMP-APP = Zeroes

                            HEU-COMPANY          -> PEM-COMPANY
                            HEU-EMPLOYEE         -> PEM-EMPLOYEE