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     PBIP.1    PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PHS-COMPANY          Numeric 4                                   PR188   PR84.1
Company              The company number represents an            PR88.1
                     established company and is entered on
                     all function codes.


PHS-EMPLOYEE         Numeric 9                                   PR188   PR84.1
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 3                                   PR188   PR84.1
Hours Type           001 = Vacation                              PR88.1
                     002 = Seniority

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


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

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

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

PHS-TOT-PRHOURS      Derived
Tot Prhours

PHS-DATE-STAMP       Numeric 8  (yyyymmdd)                       PR188   PR88.1
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
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
User ID Name         Contains the user ID of the person who
                     last changed this record.

                         PRHOURS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PHSSET1   COMPANY                                                HR00.1  HR01.1
          EMPLOYEE                                               HR11.1  PA115
          HOURS-TYPE                                             PBIP.1  PR188
          PAYROLL-YEAR                                           PR197   PR284
                                                                 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