HREMPUSF – Employee/Applicant User Fields

System
Human Resources (HR)
Prefix
HEU
Primary key
COMPANY, EMP-APP, EMPLOYEE, FIELD-KEY
Fields
12
Updated by
46 programs
Referenced by
144 programs

HREMPUSF is the Employee/Applicant User Fields table in Lawson Human Resources (prefix HEU). It is indexed by COMPANY, EMP-APP, EMPLOYEE, FIELD-KEY (HEUSET1); alternate indexes: HEUSET2 and HEUSET3. It is related 1:1 to APPLICANT, CUCODES, PRSYSTEM, EMPLOYEE, HRUSERFLDS, PCODES and PAEMPLOYEE. It is updated by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 and 38 more and referenced by HCDL.1, HCHP.1, HLTM.1, HR04.2, HR04.3, HR04.4, HR04.5, HR04.6 and 136 more. The table has 12 fields, 3 indexes and 8 documented relations.

About HREMPUSF

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

Fields (12)

Column = COBOL field name without the HEU- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#HEU-COMPANY PK
COMPANY		Numeric 4—BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +37 more
#HEU-EMP-APP PK
EMP_APP		Numeric 1Indicates if the individual is an employee or an applicant.
  • 0 Employee
  • 1 Applicant
BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +37 more
#HEU-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +37 more
#HEU-FIELD-KEY PK
FIELD_KEY		Alpha 2Contains the system assigned two-digit user field identifier.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +37 more
#HEU-A-FIELD SET3
A_FIELD		Alpha 10Contains the employee values for alphanumeric user fields.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +37 more
#HEU-N-FIELD
N_FIELD		Signed 11.2Contains employee values for numeric user fields.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +37 more
#HEU-D-FIELD
D_FIELD		Numeric 8 (yyyymmdd)Contains employee values for date user fields.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +37 more
#HEU-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +36 more
#HEU-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +36 more
#HEU-BASE-CURRENCY
BASE_CURRENCY		Alpha 5The company base currency.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +36 more
#HEU-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +36 more
#HEU-BASE-AMOUNT
BASE_AMOUNT		Signed 15.2This is the amount of the transaction in the company base amount.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +36 more

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HEUSET1
  1. COMPANY
  2. EMP-APP
  3. EMPLOYEE
  4. FIELD-KEY
PrimaryBN305, HCDL.1, HCHP.1, HAP3.1, HCRE.1, HEP4.1, HLTM.1, HPOS.1 +22 more (list truncated in source)
HEUSET2
  1. FIELD-KEY
  2. EMP-APP
  3. COMPANY
  4. EMPLOYEE
BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR04.4 +22 more (list truncated in source)
HEUSET3
  1. FIELD-KEY
  2. A-FIELD
  3. COMPANY
  4. EMP-APP
  5. EMPLOYEE
KeyChange, SubsetWhere A-FIELD != SpacesHR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APPLICANTCUCODESPRSYSTEMEMPLOYEEHRUSERFLDSPCODESPAEMPLOYEEHREMPUSF

One to one (8) — lookups and parents

RelationTableRulesConditionField map
ApplicantAPPLICANTRequiredWhen HEU-EMP-APP = 1
HEU-COMPANY→APL-COMPANY
HEU-EMPLOYEE→APL-APPLICANT
Base CurrencyCUCODESRequiredWhen (HEU-CURRENCY-CODE != Spaces)
HEU-BASE-CURRENCY→CUC-CURRENCY-CODE
CompanyPRSYSTEMRequired
HEU-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredWhen (HEU-CURRENCY-CODE != Spaces)
HEU-CURRENCY-CODE→CUC-CURRENCY-CODE
EmployeeEMPLOYEERequiredWhen HEU-EMP-APP = Zeroes
HEU-COMPANY→EMP-COMPANY
HEU-EMPLOYEE→EMP-EMPLOYEE
Field NameHRUSERFLDSRequired
HEU-FIELD-KEY→HRU-FIELD-KEY
Hr CodePCODESRequiredWhen HRU-REQ-VALUE = "Y"
HEU-FIELD-KEY→PCO-TYPE
HEU-A-FIELD→PCO-CODE
PaemployeePAEMPLOYEERequiredWhen HEU-EMP-APP = Zeroes
HEU-COMPANY→PEM-COMPANY
HEU-EMPLOYEE→PEM-EMPLOYEE

Programs

Updated by (46)

Referenced by (144)