Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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

HC02.5    HAP3.1    HEP4.1    HPOS.1    HPQC.1    HPRS.1
HR11.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    HR89.8    HR89.9    HRS1.1    HRSC.1
PA100     PA102     PA213     PA50.1    PA52.1    PA52.3
PA52.4    PA52.5    PA54.1    PRSC.1    HCDL.1    HCHP.1
HR204     PR282     HR210     PA31.1    HR211     PA115
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: Beginning NumbContains 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: Beginning DateContains 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: 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
Element: Personnel ActiDetermines 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
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: Security LevelContains 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
Element: 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.5  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
                                                                 HR15.1  HR170
                                                                 HR515   HR54.1
                                                                 HR55.1  HR55.3
                                                                 HR65.2  HR65.4
                                                                 HR65.5  HR65.7
                                                                 HR68.1  HR70.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  PA50.1
                                                                 PR282

HRUSET3   REQ-FLAG*     KeyChange, Subset                        HR210
          FIELD-NAME    Where INDICATOR = "E"
                        Or    INDICATOR = "B"

HRUSET4   REQ-FLAG*     KeyChange, Subset                        HAP3.1  HEP4.1
          FIELD-NAME    Where INDICATOR = "A"                    HPOS.1  HPQC.1
                        Or    INDICATOR = "B"                    HPRS.1  HR11.1
                                                                 HR15.1  HR210
                                                                 HR515   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA100   PA102
                                                                 PA31.1  PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PRSC.1

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