Lawson Insight Technical Documentation

                              PRHOURS FILE

REFERENCED BY

PR284     TA146     TA148

UPDATED BY

PR188     PR84.1    PR88.1    HR00.1    HR01.1    HR11.1
PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PHS-COMPANY            Numeric 4                                 PR188   PR84.1
Element: Company Hr                                              PR88.1

PHS-EMPLOYEE           Numeric 9                                 PR188   PR84.1
Element: Employee      Contains the employee number. Each        PR88.1
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

PHS-HOURS-TYPE         Numeric 2                                 PR188   PR84.1
Element: Hours Type    011 = Vacation                            PR88.1
                       022 = Seniority

PHS-PAYROLL-YEAR       Numeric 4                                 PR188   PR84.1
Element: Payroll Year  Contains the payroll year in which the    PR88.1
                       allocation was taken.

PHS-HOURS              Signed 7.2                                PR188   PR88.1
Element: Hours         Contains the hours.

PHS-HOURS-FROZEN       Signed 7.2                                PR188   PR84.1
Element: Hours Frozen                                            PR88.1

PHS-DATE-FROZEN        Numeric 8  (yyyymmdd)                     PR188   PR84.1
Element: Date Frozen                                             PR88.1

PHS-TOT-PRHOURS        Derived
Element: Tot Prhours

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

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

PHS-USER-ID            Alpha 10  (Lower Case)                    PR188   PR88.1
Element: User

                         PRHOURS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PHSSET1   COMPANY                                                HR00.1  HR01.1
          EMPLOYEE                                               HR11.1  PA115
          HOURS-TYPE                                             PR188   PR284
          PAYROLL-YEAR                                           PR84.1  PR88.2
                                                                 TA146   TA148

PHSSET2   COMPANY                                                PR88.1
          EMPLOYEE
          HOURS-TYPE
          PAYROLL-YEAR*

PHSSET3   COMPANY                                                PR188
          HOURS-TYPE
          PAYROLL-YEAR
          EMPLOYEE

                         PRHOURS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PHS-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            PHS-COMPANY         -> EMP-COMPANY
                            PHS-EMPLOYEE        -> EMP-EMPLOYEE

Paemployee     PAEMPLOYEE   Not Required

                            PHS-COMPANY         -> PEM-COMPANY
                            PHS-EMPLOYEE        -> PEM-EMPLOYEE

                         PRHOURS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Prtime         PRTIME

                            PHS-COMPANY         -> PRT-COMPANY
                            PHS-EMPLOYEE        -> PRT-EMPLOYEE
                            PHS-PAYROLL-YEAR    -> PRT-PAYROLL-YEAR
                                                   PRT-QUARTER
                                                   PRT-PAY-SUM-GRP
                                                   PRT-PROCESS-LEVEL
                                                   PRT-WORK-STATE
                                                   PRT-CHECK-ID
                                                   PRT-TIME-SEQ

Quartwage      QUARTWAGE

                            PHS-COMPANY         -> QTW-COMPANY
                            PHS-EMPLOYEE        -> QTW-EMPLOYEE
                            PHS-PAYROLL-YEAR    -> QTW-PAYROLL-YEAR
                                                   QTW-QUARTER
                                                   QTW-COUNTRY-CODE
                                                   QTW-PAY-SUM-GRP
                                                   QTW-REPORT-ENTITY
                                                   QTW-BUS-NBR-GRP
                                                   QTW-QC-ENT-NBR-GRP
                                                   QTW-PROCESS-LEVEL
                                                   QTW-WORK-STATE
                                                   QTW-PENSION