Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HRSUPER


                              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

BN145     BN231     BN232     BN234     BN238     BN240
BN245     BN246     BN335     ET700     HCDL.1    HCEM.1
HCHP.1    HCSU.1    HAP3.1    HEP4.1    HHSU.1    HPOS.1
HPQC.1    HPRS.1    HR15.1    HR155     HR170     HR207
HR211     HR213     HR217     HR220     HR515     HR54.1
HR55.2    HR70.1    HRS1.1    HRSC.1    HS10.1    HS10.2
HS208     LP100     LP101     LP251     LP260     LP262
PA103     PA113     PA149     PA16.1    PA20.1    PA202
PA208     PA21.1    PA210     PA212     PA214     PA215
PA216     PA217     PA218     PA22.1    PA220     PA221
PA222     PA223     PA224     PA225     PA227     PA24.1
PA242     PA248     PA249     PA262     PA27.1    PA272
PA290     PA310     PA311     PA315     PA320     PA325
PA330     PA335     PA34.1    PA345     PA35.1    PA350
PA355     PA36.1    PA360     PA370     PA372     PA38.1
PA42.1    PA42.3    PA490     PA520     PA53.1    PA532
PA535     PA54.1    PA59.1    PA590     PA66.2    PA66.3
PA90.1    TR21.1    TR22.1    TR26.1    TR500     HS20.1
HS21.1    HS36.1    TM240     TM245     TM470     TM52.1
HRLRD     HS12.1    HS12.2    HS13.1    HS13.2    HS15.1
HS52.1    HS52.2    HS22.1    HS22.2    HS22.3

UPDATED BY

BN305     HR07.1    HR11.1    HR11.2    HR507     HR511
PA02.1    PA100     PA102     PA115     PA13.1    PA13.2
PA502     PA513     PA52.1    PA52.3    PA52.4    PA52.5
PR110     PR113     PR120     PR13.1    PR13.5    PR13.6
PR13.8    HR00.1    HR01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HSU-COMPANY            Numeric 4                                 HR07.1  HR507
Element: Company Hr                                              PA242

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

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

HSU-EMPLOYEE           Numeric 9                                 BN305   HR07.1
Element: Employee      Contains the employee number of the       HR11.1  HR11.2
                       individual who holds the supervisor       HR507   HR511
                       position.                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA242   PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

HSU-OBJ-ID             Numeric 12                                HR07.1  HR507
Element: Obj Id        Contains a system-assigned identifier
                       that provides access to data in related
                       files.

HSU-FULL-NAME          Derived
Element: Full Name

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

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

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

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

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

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

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

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

HSU-FULL-NAME-SUFF     Derived
Element: Full Name Suff

HSU-FULL-NAME-CND      Derived
Element: Full Name Cnd

HSU-SHORT-NAME-CND     Derived
Element: Short Name Cnd

HSU-LABEL-NAME-1       Derived
Element: Label Name 1

HSU-FULL-NAME-COND     Derived
Element: Full Name Cond

HSU-SHRT-NAME-COND     Derived
Element: Shrt Name Cond

                         HRSUPER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HSUSET1   COMPANY                                                BN145   BN231
          CODE                                                   BN232   BN234
                                                                 BN238   BN240
                                                                 BN245   BN246
                                                                 BN305   BN335
                                                                 ET700   HCDL.1
                                                                 HCEM.1  HCHP.1
                                                                 HCSU.1  HAP3.1
                                                                 HEP4.1  HHSU.1
                                                                 HPOS.1  HPQC.1
                                                                 HPRS.1  HR00.1
                                                                 HR01.1  HR07.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR170   HR207
                                                                 ...

HSUSET2   OBJ-ID        KeyChange

HSUSET3   COMPANY       KeyChange                                HR11.1  HS10.1
          EMPLOYEE                                               HS10.2  HS12.1
          CODE                                                   HS12.2  HS13.1
                                                                 HS13.2  HS15.1
                                                                 HS52.1  HS52.2
                                                                 PA115   HS22.1
                                                                 HS22.2  HS22.3
                                                                 HRLRD

HSUSET4   COMPANY       KeyChange, Subset                        HCSU.1  HR07.1
          SUPER-RPTS-TO Where (SUPER-RPTS-TO != Spaces )         HR507   HS10.1
          CODE                                                   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

Paemployee     PAEMPLOYEE   Required

                            HSU-COMPANY          -> PEM-COMPANY
                            HSU-EMPLOYEE         -> PEM-EMPLOYEE

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

Requisition    PAJOBREQ

                            HSU-COMPANY          -> PJR-COMPANY
                            HSU-CODE             -> PJR-SUPERVISOR
                                                    PJR-REQUISITION