 |
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 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
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 HR11.1 HR15.1
Company The company number represents an HR515 HR54.1
established company and is entered on HRS1.1 HRSC.1
all function codes. PA100 PA102
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PRSC.1
HEU-EMP-APP Numeric 1 HR11.1 HR15.1
Type Indicates if the individual is an HR515 HR54.1
employee or an applicant. HRS1.1 HRSC.1
0 = Employee PA100 PA102
1 = Applicant PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PRSC.1
HEU-EMPLOYEE Numeric 9 HR11.1 HR15.1
Employee Contains the employee number. Each HR515 HR54.1
person employed by the company is HRS1.1 HRSC.1
assigned a unique number. The system PA100 PA102
uses the employee number to correlate PA52.1 PA52.3
all of the information related to that PA52.4 PA52.5
person. PA54.1 PRSC.1
HEU-FIELD-KEY Alpha 2 HR11.1 HR15.1
Field Key Contains the system assigned two-digit HR515 HR54.1
user field identifier. HRS1.1 HRSC.1
PA100 PA102
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PRSC.1
HEU-A-FIELD Alpha 10 HR11.1 HR15.1
User Fields - Contains the employee values for HR515 HR54.1
Alphanumeric alphanumeric user fields. HRS1.1 HRSC.1
PA100 PA102
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PRSC.1
HEU-N-FIELD Signed 11.2 HR11.1 HR15.1
N Field Contains employee values for numeric HR515 HR54.1
user fields. HRS1.1 HRSC.1
PA100 PA102
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PRSC.1
HEU-D-FIELD Numeric 8 (yyyymmdd) HR11.1 HR15.1
D Field Contains employee values for date user HR515 HR54.1
fields. HRS1.1 HRSC.1
PA100 PA102
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PRSC.1
HEU-CURRENCY-CODE Alpha 5 HR11.1 HR15.1
Currency Code This field contains the company base HR515 HR54.1
currency code established in Company HRS1.1 HRSC.1
(GL10.1 ). PA100 PA102
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PRSC.1
HEU-CURR-ND Numeric 1 HR11.1 HR15.1
Currency Number of Represents the number of decimals HR515 HR54.1
Decimals defined for the currency of the object. HRS1.1 HRSC.1
PA100 PA102
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PRSC.1
HEU-BASE-CURRENCY Alpha 5 HR11.1 HR15.1
Base Currency The company base currency. 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 HR11.1 HR15.1
Base Number Of The number of decimal positions defined HR515 HR54.1
Decimals for the company base currency. HRS1.1 HRSC.1
PA100 PA102
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PRSC.1
HEU-BASE-AMOUNT Signed 15.2 HR11.1 HR15.1
Base Amount The base amount to be posted to the HR515 HR54.1
General Ledger Account Master file. 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 HR11.1 HR11.2
EMPLOYEE HR15.1 HR155
FIELD-KEY 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 PA20.1
PA21.1 PA22.1
PA231 PA24.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 HEU-REQ-VALUE = "Y"
HEU-FIELD-KEY -> PCO-TYPE
HEU-A-FIELD -> PCO-CODE
|