Lawson Insight Technical Documentation |
|
HRUSERFLDS
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
BN305 HC02.5 HC10.1 HAP3.1 HEP4.1 HPOS.1
HPQC.1 HPRS.1 HR11.1 HR11.2 HR15.1 HR170
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 HRS1.1 HRSC.1 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 PR120 PR13.1
PR13.5 PR13.6 PR13.8 HCDL.1 HCHP.1 HR204
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 Alpha 2 HR04.4 HR04.5
Element: 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
Element: Field Name Contains the field name. HR04.6
HRU-FIELD-TYPE Alpha 1 HR04.4 HR04.5
Element: 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
Element: Beg 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
Element: 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
Element: Beg 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
Element: End 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
Element: Pers 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
Element: Log Flag Determines whether the system creates a HR04.6
log record when you make a change to
this user field.
X
HRU-REQ-FLAG Alpha 1 HR04.4 HR04.5
Element: 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
Element: Sec Level Contains the security level of the user HR04.6
field.
HRU-INDICATOR Alpha 1 HR04.4 HR04.5
Element: Indicator Indicates if the user field applies to HR04.6 HR10.1
employees, applicants, or both. HR10.2 HR10.3
E = Employee HR11.1 HR55.1
A = Applicant HR65.2 HR65.4
B = Both HR65.5 HR65.7
HR68.1 PA50.1
HRU-REQ-VALUE Alpha 1 HR04.4 HR04.5
Element: 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
Element: Currency Flag Conversion Method for Currency - HR04.6
Multiply/Divide.
N = No
Y = Yes
HRU-ACTIVE-FLAG Alpha 1 HR04.4 HR04.5
Element: Active Flag The Active flag indicates if the HR04.6
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 BN305 HC02.5
HC10.1 HAP3.1
HEP4.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 HR511
HR515 HR54.1
HR55.1 HR55.3
HR65.2 HR65.4
...
HRUSET2 FIELD-NAME KeyChange HC02.5 HCDL.1
HCHP.1 HR04.4
HR04.5 HR04.6
HR10.4 HR15.1
HR204 HR515
HR55.1 LP140
LP145 LP198
PA50.1 PR282
HRUSET3 REQ-FLAG* KeyChange, Subset HR210
FIELD-NAME Where INDICATOR = "E"
Or INDICATOR = "B"
HRUSET4 REQ-FLAG* KeyChange, Subset BN305 HAP3.1
FIELD-NAME Where INDICATOR = "A" HEP4.1 HPOS.1
Or INDICATOR = "B" 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 PR110
...
HRUSET5 FIELD-TYPE KeyChange HR04.4 HR04.5
FIELD-NAME HR04.6 HR211
PA115 PA120
PA210 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
|