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 HR55.2
HR70.1 LP100 LP101 LP140 LP145 LP198
PA113 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 PA520 PA53.1
PA66.3 TR21.1 TR22.1 TR26.1 TR500 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 HR91.7
UPDATED BY
BN305 HAP3.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1
HR11.1 HR11.2 HR15.1 HR511 HR515 HR54.1
HRS1.1 HRSC.1 PA02.1 PA100 PA102 PA115
PA120 PA13.1 PA13.2 PA502 PA513 PA52.1
PA52.3 PA52.4 PA52.5 PA54.1 PR110 PR113
PR120 PR13.1 PR13.5 PR13.6 PR13.8
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HEU-COMPANY Numeric 4 BN305 HAP3.1
Element: Company Hr HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
HEU-EMP-APP Numeric 1 BN305 HAP3.1
Element: Emp App Indicates if the individual is an HEP4.1 HPOS.1
employee or an applicant. HPQC.1 HPRS.1
0 = Employee HR11.1 HR11.2
1 = Applicant HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
HEU-EMPLOYEE Numeric 9 BN305 HAP3.1
Element: Employee Contains the employee number. Each HEP4.1 HPOS.1
person employed by the company is HPQC.1 HPRS.1
assigned a unique number. The system HR11.1 HR11.2
uses the employee number to correlate HR15.1 HR511
all of the information related to that HR515 HR54.1
person. HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
HEU-FIELD-KEY Alpha 2 BN305 HAP3.1
Element: Field Key Contains the system assigned two-digit HEP4.1 HPOS.1
user field identifier. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
HEU-A-FIELD Alpha 10 BN305 HAP3.1
User Fields - Contains the employee values for HEP4.1 HPOS.1
Alphanumeric alphanumeric user fields. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
HEU-N-FIELD Signed 11.2 BN305 HAP3.1
Element: N Field Contains employee values for numeric HEP4.1 HPOS.1
user fields. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
HEU-D-FIELD Numeric 8 (yyyymmdd) BN305 HAP3.1
Element: D Field Contains employee values for date user HEP4.1 HPOS.1
fields. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
HEU-CURRENCY-CODE Alpha 5 BN305 HAP3.1
Element: Currency Code This field contains the company base HEP4.1 HPOS.1
currency code established in Company HPQC.1 HPRS.1
(GL10.1 ). HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
HEU-CURR-ND Numeric 1 BN305 HAP3.1
Element: Acct Nd The number of decimals assigned to a HEP4.1 HPOS.1
particular account as determined by the HPQC.1 HPRS.1
account currency. HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
HEU-BASE-CURRENCY Alpha 5 BN305 HAP3.1
Element: Base Currency The company base currency. HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
HEU-BASE-ND Numeric 1 BN305 HAP3.1
Element: Base Nd The number of decimal positions defined HEP4.1 HPOS.1
for the company base currency. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
HEU-BASE-AMOUNT Signed 15.2 BN305 HAP3.1
Element: Base Amt This is the amount of the transaction in HEP4.1 HPOS.1
the company base amount. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
HREMPUSF FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HEUSET1 COMPANY BN305 HCDL.1
EMP-APP HCHP.1 HAP3.1
EMPLOYEE HEP4.1 HPOS.1
FIELD-KEY HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR170 HR211
HR511 HR515
HR54.1 HR55.2
HR70.1 HRS1.1
HRSC.1 LP100
LP101 LP140
LP145 LP198
PA02.1 PA100
PA102 PA113
...
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
|