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.

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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HEUSET1COMPANY, EMP-APP, EMPLOYEE, FIELD-KEYPrimaryBN305, HCDL.1, HCHP.1, HAP3.1, HCRE.1, HEP4.1, HLTM.1, HPOS.1 +22 more (list truncated in source)
HEUSET2FIELD-KEY, EMP-APP, COMPANY, EMPLOYEEBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR04.4 +22 more (list truncated in source)
HEUSET3FIELD-KEY, A-FIELD, COMPANY, EMP-APP, EMPLOYEEKeyChange, 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

One to one (8) — lookups and parents

RelationTableRulesConditionField map
ApplicantAPPLICANTRequiredWhen HEU-EMP-APP = 1HEU-COMPANY → APL-COMPANY, HEU-EMPLOYEE → APL-APPLICANT
Base CurrencyCUCODESRequiredWhen (HEU-CURRENCY-CODE != Spaces)HEU-BASE-CURRENCY → CUC-CURRENCY-CODE
CompanyPRSYSTEMRequiredHEU-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredWhen (HEU-CURRENCY-CODE != Spaces)HEU-CURRENCY-CODE → CUC-CURRENCY-CODE
EmployeeEMPLOYEERequiredWhen HEU-EMP-APP = ZeroesHEU-COMPANY → EMP-COMPANY, HEU-EMPLOYEE → EMP-EMPLOYEE
Field NameHRUSERFLDSRequiredHEU-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 = ZeroesHEU-COMPANY → PEM-COMPANY, HEU-EMPLOYEE → PEM-EMPLOYEE

Programs

Updated by (46)

Referenced by (144)