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
HC02.5 HC10.1 HLTM.1 HR170 HR50.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 LT10.1 LP03.1 LP03.2 LP03.3 LP03.4
LP03.5 LP03.6 LP07.1 LP140 LP145 LP198
LP201 LP203 PA50.1 HCDL.1 HCHP.1 HS703
HS705 PR282 PA210


UPDATED BY
HR04.4 HR04.5 HR04.6 HR10.4 BN305 HAP3.1
HCRE.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 PA13.1
PA13.2 PA213 PA502 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PA54.1 PR110 PR113 PR120
PR13.1 PR13.5 PR13.6 PR13.8 PR13.9 HR204
HR210 PA31.1 HR211 PA120 PA231 PA311

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 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 HR15.1
HR170 HR50.1
HR511 HR515
HR54.1 HR55.1
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 HR15.1
HR210 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA31.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
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: Wed Jun 08 20:49:09 2016

Home
Contact Us



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