Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRHOURS


                              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
Element: Company       The company number represents an          PR88.1
                       established company and is entered on
                       all function codes.

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 3                                 PR188   PR84.1
Element: Hours Type    001 = Vacation                            PR88.1
                       002 = Seniority

PHS-PAYROLL-YEAR       Numeric 4                                 PR188   PR84.1
Element: Current PayrolContains 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                                             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