PRTIMEDATE – Web Time Entry Pay Period Date

System
Payroll (PR)
Prefix
PTM
Primary key
COMPANY, PLAN-CODE, EFFECT-DATE, PAY-START-DATE
Fields
9
Updated by
2 programs
Referenced by
6 programs

PRTIMEDATE is the Web Time Entry Pay Period Date table in Lawson Payroll (prefix PTM). It is indexed by COMPANY, PLAN-CODE, EFFECT-DATE, PAY-START-DATE (PTMSET1); alternate indexes: PTMSET2. It is related 1:1 to PRSYSTEM, PROVERTIME and PROTPAYPRD. It is updated by HS03.1 and HS536 and referenced by HS20.1, HS21.1, HS22.1, HS22.3, HS36.1 and HS535. The table has 9 fields, 2 indexes and 3 documented relations.

About PRTIMEDATE

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.

Fields (9)

Column = COBOL field name without the PTM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PTM-COMPANY PK
COMPANY		Numeric 4—HS03.1
#PTM-PLAN-CODE PK
PLAN_CODE		Alpha 4Contains the user-defined code that represents a pay plan.HS03.1
#PTM-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)Contains the effective date of the pay plan.HS03.1
#PTM-PAY-START-DATE PK
PAY_START_DATE		Numeric 8 (yyyymmdd)Contains the pay period start date.HS03.1
#PTM-PAY-STOP-DATE
PAY_STOP_DATE		Numeric 8 (yyyymmdd)Contains the pay period stop date.HS03.1
#PTM-TIME-REC-START
TIME_REC_START		Numeric 8 (yyyymmdd)Contains the Web time entry start date.HS03.1
#PTM-TIME-REC-STOP
TIME_REC_STOP		Numeric 8 (yyyymmdd)Contains the Web time entry stop date.HS03.1
#PTM-LOCK-OUT-START
LOCK_OUT_START		Numeric 8 (yyyymmdd)Contains the Web lock out start date.HS03.1
#PTM-LOCK-OUT-STOP
LOCK_OUT_STOP		Numeric 8 (yyyymmdd)Contains the Web lock out stop date.HS03.1

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PTMSET1
  1. COMPANY
  2. PLAN-CODE
  3. EFFECT-DATE
  4. PAY-START-DATE
PrimaryHS03.1, HS535, HS536
PTMSET2
  1. COMPANY
  2. PLAN-CODE
  3. EFFECT-DATE
  4. PAY-START-DATE ↓
HS20.1, HS21.1, HS22.1, HS22.3, HS36.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMPROVERTIMEPROTPAYPRDPRTIMEDATE

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PTM-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Overtime PlanPROVERTIMERequired
PTM-COMPANY→PRO-COMPANY
PTM-PLAN-CODE→PRO-PLAN-CODE
PTM-EFFECT-DATE→PRO-EFFECT-DATE
ProtpayprdPROTPAYPRDRequired
PTM-COMPANY→PRY-COMPANY
PTM-PLAN-CODE→PRY-PLAN-CODE
PTM-EFFECT-DATE→PRY-EFFECT-DATE
PTM-PAY-START-DATE→PRY-PAY-START-DATE

Programs

Updated by (2)

Referenced by (6)