Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              HRSUPER FILE

                              Supervisors

Contains the supervisor code and description as well as the employee number
of the individual who is assigned to the supervisor position.

REFERENCED BY

AC550     AC551     BN145     BN231     BN232     BN238
BN240     BN245     BN246     BN335     HCEM.1    HCOP.1
HCSU.1    HHSU.1    HR15.1    HR155     HR170     HR207
HR211     HR213     HR217     HR220     HR54.1    HR55.2
HR70.1    HRS1.1    HRSC.1    HS10.1    HS10.2    PA149
PA16.1    PA202     PA208     PA212     PA214     PA215
PA216     PA217     PA218     PA220     PA221     PA222
PA224     PA225     PA242     PA248     PA249     PA262
PA272     PA290     PA300     PA305     PA310     PA311
PA315     PA320     PA325     PA330     PA335     PA345
PA350     PA355     PA360     PA370     PA372     PA42.1
PA490     PA53.1    PA532     PA54.1    PA59.1    PA590
PA66.2    PA66.3    PA90.1    TR22.1    TR500     HS20.1
HS21.1    HS36.1    TM240     TM245     TM470     TM52.1
HS12.1    HS13.1    HS15.1    HS52.1    HS52.2    HS22.1
HS22.2    HC01.1

UPDATED BY

HR07.1    HR507     HR511     HR650     PA502     PA513
PR13.1    PR13.5    PR13.6    PR13.8    HR00.1    HR01.1
PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

HSU-COMPANY          Numeric 4                                   HR07.1  HR507
Company              The company number represents an            PA242
                     established company and is entered on
                     all function codes.

HSU-CODE             Alpha 10                                    HR07.1  HR507
Code                 Contains the supervisor code. The
                     supervisor code identifies the
                     supervisor position.

HSU-DESCRIPTION      Alpha 30  (Lower Case)                      HR07.1  HR507
Description          Contains the supervisor code                PA218
                     description.

HSU-EMPLOYEE         Numeric 9                                   HR07.1  HR507
Employee             Contains the employee number of the         HR511   HR650
                     individual who holds the supervisor         PA242   PA502
                     position.                                   PA513   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

HSU-OBJ-ID           Numeric 12                                  HR07.1  HR507
Object               Contains a system-assigned identifier
Identification       that provides access to data in related
                     files.

HSU-FULL-NAME        Derived
Full Name

HSU-EFFECT-DATE      Numeric 8  (yyyymmdd)                       HR07.1  HR507
Effective Date       Contains the date the supervisor code
                     becomes effective.

HSU-ACTIVE-FLAG      Alpha 1                                     HR07.1  HR507
Status               The Active flag of the credit card
                     type.
                     A = Active
                     I = Inactive

HSU-SUPER-RPTS-TO    Alpha 10                                    HR07.1  HR507
Super Rpts To        Indicates supervisor to whom this
                     supervisor reports.

HSU-USER1            Alpha 10                                    HR07.1  HR507
User1                Contains information from the first
                     user field.

HSU-USER2            Alpha 10                                    HR07.1  HR507
User2                Contains information from the second
                     supervisor user field.

HSU-USER3            Alpha 10                                    HR07.1  HR507
User3                Contains information from the third
                     user field.

HSU-USER4            Alpha 10                                    HR07.1  HR507
User4                Contains information from the fourth
                     user field.

HSU-USER5            Alpha 10                                    HR07.1  HR507
User5                Contains information from the fifth
                     user field.

HSU-FULL-NAME-SUFF   Derived
Full Name Suff

HSU-FULL-NAME-CND    Derived
Full Name Cnd

HSU-SHORT-NAME-CND   Derived
Short Name Cnd

HSU-LABEL-NAME-1     Derived
Label Name 1

                         HRSUPER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HSUSET1   COMPANY                                                AC550   AC551
          CODE                                                   BN145   BN231
                                                                 BN232   BN238
                                                                 BN240   BN245
                                                                 BN246   BN335
                                                                 HCEM.1  HCOP.1
                                                                 HCSU.1  HHSU.1
                                                                 HR00.1  HR01.1
                                                                 HR07.1  HR15.1
                                                                 HR155   HR170
                                                                 HR207   HR211
                                                                 HR213   HR217
                                                                 HR220   HR507
                                                                 HR511   HR54.1
                                                                 HR55.2  HR650
                                                                 ...

HSUSET2   OBJ-ID        KeyChange

HSUSET3   COMPANY       KeyChange                                HS10.1  HS10.2
          EMPLOYEE                                               HS12.1  HS13.1
          CODE                                                   HS15.1  HS52.1
                                                                 HS52.2  HS22.1
                                                                 HS22.2

HSUSET4   COMPANY       KeyChange, Subset                        HC01.1  HCSU.1
          SUPER-RPTS-TO Where (SUPER-RPTS-TO != Spaces )         HR07.1  HR507
          CODE                                                   HS10.1  HS10.2

                         HRSUPER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            HSU-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required
                            When HSU-EMPLOYEE != Zeroes

                            HSU-COMPANY          -> EMP-COMPANY
                            HSU-EMPLOYEE         -> EMP-EMPLOYEE

Emstatus       EMSTATUS     Not Required
                            Valid When HSU-EMPLOYEE != Zeroes

                            HSU-COMPANY          -> EMS-COMPANY
                            EMP-EMP-STATUS       -> EMS-EMP-STATUS

Parent         HRSUPER      Not Required
                            Valid When (HSU-SUPER-RPTS-TO != Spaces )

                            HSU-COMPANY          -> HSU-COMPANY
                            HSU-SUPER-RPTS-TO    -> HSU-CODE

User1          PCODES       Not Required
                            Valid When (HSU-USER1 != Spaces )

                            "S1"                 -> PCO-TYPE
                            HSU-USER1            -> PCO-CODE

User2          PCODES       Not Required
                            Valid When (HSU-USER2 != Spaces )

                            "S2"                 -> PCO-TYPE
                            HSU-USER2            -> PCO-CODE

User3          PCODES       Not Required
                            Valid When (HSU-USER3 != Spaces )

                            "S3"                 -> PCO-TYPE
                            HSU-USER3            -> PCO-CODE

User4          PCODES       Not Required
                            Valid When (HSU-USER4 != Spaces )

                            "S4"                 -> PCO-TYPE
                            HSU-USER4            -> PCO-CODE

User5          PCODES       Not Required
                            Valid When (HSU-USER5 != Spaces )

                            "S5"                 -> PCO-TYPE
                            HSU-USER5            -> PCO-CODE

                         HRSUPER FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employees      PATHFIND     Delete Restricted

                            HSU-COMPANY          -> PTF-COMPANY
                            18                   -> PTF-FLD-NBR
                            HSU-CODE             -> PTF-FLD-VALUE
                                                    PTF-EMPLOYEE
                                                    PTF-POS-LEVEL

History        HRHISTORY    Delete Cascades

                            HSU-COMPANY          -> HRH-COMPANY
                            Zeroes               -> HRH-EMPLOYEE
                            HSU-OBJ-ID           -> HRH-OBJ-ID
                                                    HRH-FLD-NBR
                                                    HRH-BEG-DATE
                                                    HRH-SEQ-NBR

Indirect Emps  PATHFIND

                            HSU-COMPANY          -> PTF-COMPANY
                            289                  -> PTF-FLD-NBR
                            HSU-CODE             -> PTF-FLD-VALUE
                                                    PTF-EMPLOYEE
                                                    PTF-POS-LEVEL