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
HCDL.1 HCHP.1 HR155 HR170 HR211 HR511
HR55.2 HR70.1 PA02.1 PA113 PA13.1 PA13.2
PA16.1 PA20.1 PA21.1 PA210 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 HR89.8 HR89.9
UPDATED BY
HAP3.1 HEP4.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 HAP3.1 HEP4.1
Element: Company Hr Identifies the AP company if the HPOS.1 HPQC.1
resource type = V. Identifies the HR HPRS.1 HR11.1
company if the resource type = E. It is HR15.1 HR515
blank for type A, P or Q resources. 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 HAP3.1 HEP4.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 HAP3.1 HEP4.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 HAP3.1 HEP4.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 HAP3.1 HEP4.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 HAP3.1 HEP4.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) HAP3.1 HEP4.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 HAP3.1 HEP4.1
Element: Currency Code This field contains the company base HPOS.1 HPQC.1
currency code established in Company HPRS.1 HR11.1
(GL10.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-CURR-ND Numeric 1 HAP3.1 HEP4.1
Account Currency Represents the number of decimals HPOS.1 HPQC.1
Code defined for the currency of the object. 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-BASE-CURRENCY Alpha 5 HAP3.1 HEP4.1
Element: Base Currency The company base currency. HPOS.1 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
HEU-BASE-ND Numeric 1 HAP3.1 HEP4.1
Base Number Of The number of decimal positions defined HPOS.1 HPQC.1
Decimals for the company base currency. 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-BASE-AMOUNT Signed 15.2 HAP3.1 HEP4.1
Element: Base Amount The base amount to be posted to the HPOS.1 HPQC.1
General Ledger Account Master file. 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 HCDL.1 HCHP.1
EMP-APP HAP3.1 HEP4.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 HR70.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA120
PA13.1 PA13.2
PA16.1 PA20.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
Paemployee PAEMPLOYEE Required
When HEU-EMP-APP = Zeroes
HEU-COMPANY -> PEM-COMPANY
HEU-EMPLOYEE -> PEM-EMPLOYEE
|