HREMPUSF

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 HLTM.1 HR155 HR156 HR170
HR211 HR55.2 HR70.1 HS703 HS705 LT11.5
LT13.5 ZH156 ZH230 ZH500 LP100 LP101
LP102 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 HR92.1 HR92.2 HR92.3


UPDATED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR11.1 HR11.2 HR11.4 HR15.1 HR28.1
HR511 HR515 HR54.1 HRS1.1 HRSC.1 LT101
LT111 ZH510 PA02.1 PA100 PA102 PA115
PA120 PA13.1 PA13.2 PA502 PA513 PA52.1
PA52.3 PA52.4 PA52.5 PA54.1 PR110 PR113
PR12.6 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 PR30.2 PR512 ZP296

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HEU-COMPANY
Element: Company Hr		Numeric 4
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
ZP296
HEU-EMP-APP
Element: Emp App		Numeric 1
Indicates if the individual is an employee or an applicant.
0 = Employee
1 = Applicant
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
ZP296
HEU-EMPLOYEE
Element: Employee		Numeric 9
Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
ZP296
HEU-FIELD-KEY
Element: Field Key		Alpha 2
Contains the system assigned two-digit user field identifier.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
ZP296
HEU-A-FIELD
User Fields -
Alphanumeric		Alpha 10
Contains the employee values for alphanumeric user fields.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH230
ZH510
HEU-N-FIELD
Element: N Field		Signed 11.2
Contains employee values for numeric user fields.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH230
ZH510
HEU-D-FIELD
Element: D Field		Numeric 8 (yyyymmdd)
Contains employee values for date user fields.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
ZP296
HEU-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
HEU-CURR-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
HEU-BASE-CURRENCY
Element: Base Currency		Alpha 5
The company base currency.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
HEU-BASE-ND
Element: Base Nd		Numeric 1
The number of decimal positions defined for the company base currency.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
HEU-BASE-AMOUNT
Element: Base Amt		Signed 15.2
This is the amount of the transaction in the company base amount.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510


HREMPUSF FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HEUSET1 COMPANY
EMP-APP
EMPLOYEE
FIELD-KEY
...
BN305 HCDL.1
HCHP.1 HAP3.1
HCRE.1 HEP4.1
HLTM.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR11.4 HR15.1
HR155 HR156
HR170 HR211
HR28.1 HR511
HR515 HR54.1
HR55.2 HR70.1
HRS1.1 HRSC.1
HS703 HS705
LT101 LT11.5
HEUSET2 FIELD-KEY
EMP-APP
COMPANY
EMPLOYEE
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR04.4
HR04.5 HR04.6
HR11.1 HR11.2
HR11.4 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 LT111
ZH510 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
HEUSET3 FIELD-KEY
A-FIELD
COMPANY
EMP-APP
EMPLOYEE
KeyChange, Subset
WhereA-FIELD !=Spaces
...
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


HREMPUSF FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 02:16:14 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.