HRUSERFLDS

HR User Fields

Contains user-defined user fields and their system-assigned 2-digit identifiers, as well as their associated attributes and defined valid values. This file also contains a field that indicates if the user field is applicable for both employees and applicants or for only applicants or employees.

REFERENCED BY
BN305 HC02.5 HC10.1 HAP3.1 HCRE.1 HEP4.1
HLTM.1 HPOS.1 HPQC.1 HPRS.1 HR11.1 HR11.2
HR11.4 HR15.1 HR170 HR28.1 HR50.1 HR511
HR515 HR54.1 HR55.1 HR55.3 HR65.2 HR65.4
HR65.5 HR65.7 HR68.1 HR70.1 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 HRS1.1
HRSC.1 LT10.1 LT101 LT11.5 LT111 LT13.5
LT22.5 ZH500 ZH510 LP03.1 LP03.2 LP03.3
LP03.4 LP03.5 LP03.6 LP07.1 LP140 LP145
LP198 LP201 LP203 PA02.1 PA100 PA102
PA115 PA13.1 PA13.2 PA213 PA50.1 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 HCDL.1
HCHP.1 HR204 HS703 HS705 PR282 HR210
PA31.1 HR211 PA120 PA210 PA231 PA311


UPDATED BY
HR04.4 HR04.5 HR04.6 HR10.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HRU-FIELD-KEY
Element: Field Key
Alpha 2
Contains the system-defined two-digit identifier of the user field.
01
99
HR04.4 HR04.5
HR04.6
HRU-FIELD-NAME
Element: Field Name
Alpha 20 (Lower Case)
Contains the field name.
HR04.4 HR04.5
HR04.6
HRU-FIELD-TYPE
Element: Field Type
Alpha 1
Indicates if the user field is an alphanumeric, numeric, or date user field.
A = Alphanumeric
N = Numeric
D = Date
HR04.4 HR04.5
HR04.6
HRU-BEG-NUMBER
Element: Beg Number
Signed 11.2
Contains the beginning value of a numeric range allowed for the user field.
HR04.4 HR04.5
HR04.6
HRU-END-NUMBER
Element: End Number
Signed 11.2
Contains the ending value of a numeric range allowed for the user field.
HR04.4 HR04.5
HR04.6
HRU-BEG-DATE
Element: Beg Date
Numeric 8 (yyyymmdd)
Contains the beginning date of a date range defined for a date user field.
HR04.4 HR04.5
HR04.6
HRU-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
Contains the ending date of a date range defined for a date user field.
HR04.4 HR04.5
HR04.6
HRU-PERS-ACTION
Element: Pers Action
Alpha 1
Determines if you can change this user field only with a personnel action.
X
HR04.4 HR04.5
HR04.6
HRU-LOG-FLAG
Element: Log Flag
Alpha 1
Determines whether the system creates a log record when you make a change to this user field.
X
HR04.4 HR04.5
HR04.6
HRU-REQ-FLAG
Element: Req Flag
Alpha 1
Determines if this field is required on an Add or Change function.
X
HR04.4 HR04.5
HR04.6 HR10.4
HRU-SEC-LEVEL
Element: Sec Level
Numeric 1
Contains the security level of the user field.
HR04.4 HR04.5
HR04.6
HRU-INDICATOR
Element: Indicator
Alpha 1
Indicates if the user field applies to employees, applicants, or both.
E = Employee
A = Applicant
B = Both
HR04.4 HR04.5
HR04.6 HR10.1
HR10.2 HR10.3
HR11.1 HR11.4
HR55.1 HR65.2
HR65.4 HR65.5
HR65.7 HR68.1
PA50.1
HRU-REQ-VALUE
Element: Req Value
Alpha 1
Indicates if the user field is defined as required.
Y = Yes
N = No
HR04.4 HR04.5
HR04.6
HRU-CURRENCY-FLAG
Element: Currency Flag
Alpha 1
Conversion Method for Currency - Multiply/Divide.
N = No
Y = Yes
HR04.4 HR04.5
HR04.6
HRU-ACTIVE-FLAG
Element: Active Flag
Alpha 1
The Active flag indicates if the employee/applicant user field can be entered for an employee (or applicant).
A = Active
I = Inactive
HR04.4 HR04.5
HR04.6


HRUSERFLDS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HRUSET1 FIELD-KEY
...
BN305 HC02.5
HC10.1 HAP3.1
HCRE.1 HEP4.1
HLTM.1 HPOS.1
HPQC.1 HPRS.1
HR04.2 HR04.3
HR04.4 HR04.5
HR04.6 HR04.7
HR04.8 HR10.1
HR10.2 HR10.3
HR10.4 HR11.1
HR11.2 HR11.4
HR15.1 HR170
HR28.1 HR50.1
HR511 HR515
HRUSET2 FIELD-NAME
KeyChange
HC02.5 HCDL.1
HCHP.1 HR04.4
HR04.5 HR04.6
HR10.4 HR15.1
HR204 HR515
HR55.1 HS703
HS705 PA50.1
PR282
HRUSET3 REQ-FLAG*
FIELD-NAME
KeyChange, Subset
WhereINDICATOR ="E"
OrINDICATOR ="B"
HR210
HRUSET4 REQ-FLAG*
FIELD-NAME
KeyChange, Subset
WhereINDICATOR ="A"
OrINDICATOR ="B"
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR210
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT111
ZH510 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA31.1
PA502 PA513
HRUSET5 FIELD-TYPE
FIELD-NAME
KeyChange
HR04.4 HR04.5
HR04.6 HR211
PA115 PA120
PA210 PA231
PA311


HRUSERFLDS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Emps And Apps HREMPUSF Delete Restricted
HRU-FIELD-KEY->HEU-FIELD-KEY
  HEU-EMP-APP
  HEU-COMPANY
  HEU-EMPLOYEE


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

Home
Contact Us



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