 |
Lawson Insight Technical Documentation |
|
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 PA16.1 PA231 PA272
PA31.1 PA311 PA502 PA513 PA53.1 PA66.3
TR22.1 TR500 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
HR15.1 HR515 HR54.1 HRS1.1 HRSC.1 PA120
PA54.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HEU-COMPANY Numeric 4 HR15.1 HR515
Company The company number represents an HR54.1 HRS1.1
established company and is entered on HRSC.1 PA54.1
all function codes.
HEU-EMP-APP Numeric 1 HR15.1 HR515
Type Indicates if the individual is an HR54.1 HRS1.1
employee or an applicant. HRSC.1 PA54.1
0 = Employee
1 = Applicant
HEU-EMPLOYEE Numeric 9 HR15.1 HR515
Employee Contains the employee number. Each HR54.1 HRS1.1
person employed by the company is HRSC.1 PA54.1
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
HEU-FIELD-KEY Alpha 2 HR15.1 HR515
Field Key Contains the system assigned two-digit HR54.1 HRS1.1
user field identifier. HRSC.1 PA54.1
HEU-A-FIELD Alpha 10 HR15.1 HR515
User Fields - Contains the employee values for HR54.1 HRS1.1
Alphanumeric alphanumeric user fields. HRSC.1 PA54.1
HEU-N-FIELD Signed 11.2 HR15.1 HR515
N Field Contains employee values for numeric HR54.1 HRS1.1
user fields. HRSC.1 PA54.1
HEU-D-FIELD Numeric 8 (yyyymmdd) HR15.1 HR515
D Field Contains employee values for date user HR54.1 HRS1.1
fields. HRSC.1 PA54.1
HEU-CURRENCY-CODE Alpha 5 HR15.1 HR515
Currency Code This field contains the company base HR54.1 HRS1.1
currency code established in Company HRSC.1 PA54.1
(GL10.1 ).
HEU-CURR-ND Numeric 1 HR15.1 HR515
Currency Number of Represents the number of decimals HR54.1 HRS1.1
Decimals defined for the currency of the object. HRSC.1 PA54.1
HEU-BASE-CURRENCY Alpha 5 HR15.1 HR515
Base Currency The company base currency. HR54.1 HRS1.1
HRSC.1 PA54.1
HEU-BASE-ND Numeric 1 HR15.1 HR515
Base Number Of The number of decimal positions defined HR54.1 HRS1.1
Decimals for the company base currency. HRSC.1 PA54.1
HEU-BASE-AMOUNT Signed 15.2 HR15.1 HR515
Base Amount The base amount to be posted to the HR54.1 HRS1.1
General Ledger Account Master file. HRSC.1 PA54.1
HREMPUSF FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HEUSET1 COMPANY HCOP.1 HCOP.2
EMP-APP HR15.1 HR155
EMPLOYEE HR170 HR211
FIELD-KEY HR511 HR515
HR54.1 HR55.2
HR650 HR70.1
HRS1.1 HRSC.1
PA120 PA16.1
PA231 PA272
PA31.1 PA311
PA502 PA513
PA53.1 PA54.1
PA66.3 TR22.1
TR500 PR13.1
PR13.5 PR13.6
...
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 HEU-REQ-VALUE = "Y"
HEU-FIELD-KEY -> PCO-TYPE
HEU-A-FIELD -> PCO-CODE
|