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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PTMSET1COMPANY, PLAN-CODE, EFFECT-DATE, PAY-START-DATEPrimaryHS03.1, HS535, HS536
PTMSET2COMPANY, PLAN-CODE, EFFECT-DATE, PAY-START-DATE*HS20.1, HS21.1, HS22.1, HS22.3, HS36.1

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredPTM-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Overtime PlanPROVERTIMERequiredPTM-COMPANY → PRO-COMPANY, PTM-PLAN-CODE → PRO-PLAN-CODE, PTM-EFFECT-DATE → PRO-EFFECT-DATE
ProtpayprdPROTPAYPRDRequiredPTM-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)