 |
Lawson Insight Technical Documentation |
|
HRUSERFLDS FILE
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.3 HC02.1 HCOP.2 HCOP.1 HCUF.1 HR15.1
HR170 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
HRS1.1 HRSC.1 PA213 PA50.1 PA54.1 HR204
PR282 HR210 PA31.1 HC01.1 HR211 PA120
PA231 PA311
UPDATED BY
HR04.4 HR04.5 HR04.6 HR10.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HRU-FIELD-KEY Alpha 2 HR04.4 HR04.5
Field Key Contains the system-defined two-digit HR04.6
identifier of the user field.
01
99
HRU-FIELD-NAME Alpha 20 (Lower Case) HR04.4 HR04.5
Field Name Contains the field name. HR04.6
HRU-FIELD-TYPE Alpha 1 HR04.4 HR04.5
Field Type Indicates if the user field is an HR04.6
alphanumeric, numeric, or date user
field.
A = Alphanumeric
N = Numeric
D = Date
HRU-BEG-NUMBER Signed 11.2 HR04.4 HR04.5
Beginning Number Contains the beginning value of a HR04.6
numeric range allowed for the user
field.
HRU-END-NUMBER Signed 11.2 HR04.4 HR04.5
End Number Contains the ending value of a numeric HR04.6
range allowed for the user field.
HRU-BEG-DATE Numeric 8 (yyyymmdd) HR04.4 HR04.5
Beginning Date Contains the beginning date of a date HR04.6
range defined for a date user field.
HRU-END-DATE Numeric 8 (yyyymmdd) HR04.4 HR04.5
Ending Date Contains the ending date of a date HR04.6
range defined for a date user field.
HRU-PERS-ACTION Alpha 1 HR04.4 HR04.5
Personnel Action Determines if you can change this user HR04.6
field only with a personnel action.
X
HRU-LOG-FLAG Alpha 1 HR04.4 HR04.5
Logfile Record Determines whether the system creates a HR04.6
Created Flag log record when you make a change to
this user field.
X
HRU-REQ-FLAG Alpha 1 HR04.4 HR04.5
Req Flag Determines if this field is required on HR04.6 HR10.4
an Add or Change function.
X
HRU-SEC-LEVEL Numeric 1 HR04.4 HR04.5
Security Level Contains the security level of the user HR04.6
field.
HRU-INDICATOR Alpha 1 HR04.4 HR04.5
Indicator Indicates if the user field applies to HR04.6 HR10.1
employees, applicants, or both. HR10.2 HR10.3
E = Employee HR55.1 HR65.2
A = Applicant HR65.4 HR65.5
B = Both HR65.7 HR68.1
PA50.1
HRU-REQ-VALUE Alpha 1 HR04.4 HR04.5
Req Value Indicates if the user field is defined HR04.6
as required.
Y = Yes
N = No
HRU-CURRENCY-FLAG Alpha 1 HR04.4 HR04.5
Currency Flag Conversion Method for Currency - HR04.6
Multiply/Divide.
N = No
Y = Yes
HRU-ACTIVE-FLAG Alpha 1
Status The Active flag idicates if the
employee/applicant user field can be
entered for an employee (or applicant).
A = Active
I = Inactive
HRUSERFLDS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HRUSET1 FIELD-KEY HC02.3 HCOP.2
HCUF.1 HR04.2
HR04.3 HR04.4
HR04.5 HR04.6
HR04.7 HR04.8
HR10.1 HR10.2
HR10.3 HR10.4
HR15.1 HR170
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
...
HRUSET2 FIELD-NAME KeyChange HC02.1 HC02.3
HCOP.1 HCOP.2
HCUF.1 HR04.4
HR04.5 HR04.6
HR10.4 HR15.1
HR204 HR515
HR55.1 PA50.1
PR282
HRUSET3 REQ-FLAG* KeyChange, Subset HR210
FIELD-NAME Where INDICATOR = "E"
Or INDICATOR = "B"
HRUSET4 REQ-FLAG* KeyChange, Subset HR15.1 HR210
FIELD-NAME Where INDICATOR = "A" HR515 HR54.1
Or INDICATOR = "B" HRS1.1 HRSC.1
PA31.1 PA54.1
HRUSET5 FIELD-TYPE KeyChange HC01.1 HR04.4
FIELD-NAME HR04.5 HR04.6
HR211 PA120
PA231 PA311
HRUSERFLDS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Emps And Apps HREMPUSF Delete Restricted
HRU-FIELD-KEY -> HEU-FIELD-KEY
HEU-EMP-APP
HEU-COMPANY
HEU-EMPLOYEE
|