Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


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


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

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

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

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

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

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

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

PTM-LOCK-OUT-STOP    Numeric 8  (yyyymmdd)                       HS03.1
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