Lawson Insight Technical Documentation

                             HRWRKSCHD FILE

Contains the parent record for a work schedule

REFERENCED BY

HR221     BN305     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    LP100     LP101     PA02.1    PA100
PA102     PA103     PA113     PA115     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

UPDATED BY

HR21.1    HR00.1    HR01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WSC-COMPANY            Numeric 4                                 HR21.1
Element: Company Hr

WSC-WORK-SCHED         Alpha 10                                  HR21.1
Element: Code          Code that is valid for the specified
                       record type.

WSC-EFFECT-DATE        Numeric 8  (yyyymmdd)                     HR21.1
Element: Date          This field displays the system date
                       when this was created.

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

                         HRWRKSCHD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

WSCSET2   COMPANY                                                BN305   HAP3.1
          WORK-SCHED                                             HEP4.1  HPOS.1
          EFFECT-DATE*                                           HPQC.1  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  LP100
                                                                 LP101   PA02.1
                                                                 PA100   PA102
                                                                 PA103   PA113
                                                                 PA115   PA13.1
                                                                 ...

                         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