Lawson Insight Technical Documentation |
|
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
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
DA15.1 HGLM.1 HPOS.1 HPQC.1 HPRS.1 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 DA15.1 HGLM.1
Element: Company The company number represents an HPOS.1 HPQC.1
established company and is entered on HPRS.1 HR11.1
all function codes. HR15.1 HR515
HR54.1 HRS1.1
HRSC.1 PA100
PA102 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PRSC.1
HEU-EMP-APP Numeric 1 DA15.1 HGLM.1
Element: Type Indicates if the individual is an HPOS.1 HPQC.1
employee or an applicant. HPRS.1 HR11.1
0 = Employee HR15.1 HR515
1 = Applicant HR54.1 HRS1.1
HRSC.1 PA100
PA102 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PRSC.1
HEU-EMPLOYEE Numeric 9 DA15.1 HGLM.1
Element: Employee Contains the employee number. Each HPOS.1 HPQC.1
person employed by the company is HPRS.1 HR11.1
assigned a unique number. The system HR15.1 HR515
uses the employee number to correlate HR54.1 HRS1.1
all of the information related to that HRSC.1 PA100
person. PA102 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PRSC.1
HEU-FIELD-KEY Alpha 2 DA15.1 HGLM.1
Element: Field Key Contains the system assigned two-digit HPOS.1 HPQC.1
user field identifier. HPRS.1 HR11.1
HR15.1 HR515
HR54.1 HRS1.1
HRSC.1 PA100
PA102 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PRSC.1
HEU-A-FIELD Alpha 10 DA15.1 HGLM.1
User Fields - Contains the employee values for HPOS.1 HPQC.1
Alphanumeric alphanumeric user fields. HPRS.1 HR11.1
HR15.1 HR515
HR54.1 HRS1.1
HRSC.1 PA100
PA102 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PRSC.1
HEU-N-FIELD Signed 11.2 DA15.1 HGLM.1
Element: N Field Contains employee values for numeric HPOS.1 HPQC.1
user fields. HPRS.1 HR11.1
HR15.1 HR515
HR54.1 HRS1.1
HRSC.1 PA100
PA102 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PRSC.1
HEU-D-FIELD Numeric 8 (yyyymmdd) DA15.1 HGLM.1
Element: D Field Contains employee values for date user HPOS.1 HPQC.1
fields. HPRS.1 HR11.1
HR15.1 HR515
HR54.1 HRS1.1
HRSC.1 PA100
PA102 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PRSC.1
HEU-CURRENCY-CODE Alpha 5 HGLM.1 HPOS.1
Element: Currency Code This field contains the company base HPQC.1 HPRS.1
currency code established in Company HR11.1 HR15.1
(GL10.1 ). HR515 HR54.1
HRS1.1 HRSC.1
PA100 PA102
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PRSC.1
HEU-CURR-ND Numeric 1 HGLM.1 HPOS.1
Account Currency HPQC.1 HPRS.1
Code HR11.1 HR15.1
HR515 HR54.1
HRS1.1 HRSC.1
PA100 PA102
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PRSC.1
HEU-BASE-CURRENCY Alpha 5 HGLM.1 HPOS.1
To Company Base HPQC.1 HPRS.1
Currency HR11.1 HR15.1
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 HGLM.1 HPOS.1
Account Currency HPQC.1 HPRS.1
Code HR11.1 HR15.1
HR515 HR54.1
HRS1.1 HRSC.1
PA100 PA102
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PRSC.1
HEU-BASE-AMOUNT Signed 15.2 HGLM.1 HPOS.1
Element: Adj Amt HPQC.1 HPRS.1
HR11.1 HR15.1
HR515 HR54.1
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 DA15.1 HGLM.1
EMPLOYEE HPOS.1 HPQC.1
FIELD-KEY HPRS.1 HR11.1
HR11.2 HR15.1
HR155 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
...
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
|