Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRTIMEDATE


                            PRTIMEDATE FILE

The Time Date file contains the valid Web time entry date ranges and lock out
date ranges for the pay period date ranges in a pay plan.

REFERENCED BY

HS535     HS20.1    HS21.1    HS22.1    HS22.3    HS36.1

UPDATED BY

HS03.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PTM-COMPANY            Numeric 4                                 HS03.1
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

PTM-PLAN-CODE          Alpha 4                                   HS03.1
Element: Plan          Contains the user-defined code that
                       represents a pay plan.

PTM-EFFECT-DATE        Numeric 8  (yyyymmdd)                     HS03.1
Element: Date          Contains the effective date of the pay
                       plan.

PTM-PAY-START-DATE     Numeric 8  (yyyymmdd)                     HS03.1
Element: Pay Start DateContains the pay period start date.

PTM-PAY-STOP-DATE      Numeric 8  (yyyymmdd)                     HS03.1
Element: Pay Stop Date Contains the pay period stop date.

PTM-TIME-REC-START     Numeric 8  (yyyymmdd)                     HS03.1
Element: Time Rec StartContains the Web time entry start date.

PTM-TIME-REC-STOP      Numeric 8  (yyyymmdd)                     HS03.1
Element: Time Rec Stop Contains the Web time entry stop date.

PTM-LOCK-OUT-START     Numeric 8  (yyyymmdd)                     HS03.1
Element: Lock Out StartContains the Web lock out start date.

PTM-LOCK-OUT-STOP      Numeric 8  (yyyymmdd)                     HS03.1
Element: Lock Out Stop Contains the Web lock out stop date.

                         PRTIMEDATE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PTMSET1   COMPANY                                                HS03.1  HS535
          PLAN-CODE
          EFFECT-DATE
          PAY-START-DATE

PTMSET2   COMPANY                                                HS20.1  HS21.1
          PLAN-CODE                                              HS22.1  HS22.3
          EFFECT-DATE                                            HS36.1
          PAY-START-DATE*

                         PRTIMEDATE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PTM-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

Overtime Plan  PROVERTIME   Required

                            PTM-COMPANY           -> PRO-COMPANY
                            PTM-PLAN-CODE         -> PRO-PLAN-CODE
                            PTM-EFFECT-DATE       -> PRO-EFFECT-DATE

Protpayprd     PROTPAYPRD   Required

                            PTM-COMPANY           -> PRY-COMPANY
                            PTM-PLAN-CODE         -> PRY-PLAN-CODE
                            PTM-EFFECT-DATE       -> PRY-EFFECT-DATE
                            PTM-PAY-START-DATE    -> PRY-PAY-START-DATE