Lawson Insight Technical Documentation

                             HRWRKSCHD FILE

Contains the parent record for a work schedule

REFERENCED BY

HR221     HAP3.1    HEP4.1    HPOS.1    HPQC.1    HPRS.1
HR11.1    HR11.2    HR15.1    HR155     HR170     HR511
HR515     HR54.1    HR55.2    HR70.1    HRS1.1    HRSC.1
HWSC.1    PA02.1    PA100     PA102     PA103     PA113
PA13.1    PA13.2    PA16.1    PA20.1    PA202     PA21.1
PA22.1    PA24.1    PA242     PA27.1    PA272     PA31.1
PA34.1    PA35.1    PA36.1    PA38.1    PA42.1    PA42.3
PA502     PA513     PA52.1    PA52.3    PA52.4    PA52.5
PA520     PA53.1    PA531     PA532     PA535     PA54.1
PA66.3    TR21.1    TR22.1    TR26.1    TR500     PR110
PR113     PR120     PR13.1    PR13.5    PR13.6    PR13.8
PRSC.1

UPDATED BY

HR21.1    HR00.1    HR01.1    PBIP.1    PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WSC-COMPANY            Numeric 4                                 HR21.1
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

WSC-WORK-SCHED         Alpha 10                                  HR21.1
Element: Code

WSC-EFFECT-DATE        Numeric 8  (yyyymmdd)                     HR21.1
Element: Date

WSC-DESCRIPTION        Alpha 30  (Lower Case)                    HR21.1
Element: Description   This field displays the description.

WSC-TOT-DAYS           Signed 10.4
Element: Tot Days

WSC-DATE-STAMP         Numeric 8  (yyyymmdd)                     HR21.1
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

WSC-TIME-STAMP         Numeric 6  (hhmmss)                       HR21.1
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

WSC-USER-ID            Alpha 10  (Lower Case)                    HR21.1
Element: User          Contains the user ID of the person who
                       last changed this record.

                         HRWRKSCHD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WSCSET1   COMPANY                                                HR00.1  HR01.1
          WORK-SCHED                                             HR221   PBIP.1
          EFFECT-DATE                                            PR197

WSCSET2   COMPANY                                                HAP3.1  HEP4.1
          WORK-SCHED                                             HPOS.1  HPQC.1
          EFFECT-DATE*                                           HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR155   HR170
                                                                 HR21.1  HR221
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR70.1  HRS1.1
                                                                 HRSC.1  HWSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA103
                                                                 PA113   PA13.1
                                                                 PA13.2  PA16.1
                                                                 PA20.1  PA202
                                                                 ...

                         HRWRKSCHD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            WSC-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

                         HRWRKSCHD FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employee       PATHFIND

                            WSC-COMPANY        -> PTF-COMPANY
                            293                -> PTF-FLD-NBR
                            WSC-WORK-SCHED     -> PTF-FLD-VALUE
                                                  PTF-EMPLOYEE
                                                  PTF-POS-LEVEL

Work Dtl       HRWRKDTL     Delete Cascades

                            WSC-COMPANY        -> WSD-COMPANY
                            WSC-WORK-SCHED     -> WSD-WORK-SCHED
                            WSC-EFFECT-DATE    -> WSD-EFFECT-DATE
                                                  WSD-WORK-PERIOD