Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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