PRPAYTOTAL – The Pay Total file contains a record of the total hour for a pay period as entered by an employee using the Web Time…

System
Payroll (PR)
Prefix
PYT
Primary key
COMPANY, PAY-PER-START, EMPLOYEE
Fields
6
Updated by
5 programs
Referenced by
2 programs

PRPAYTOTAL is the The Pay Total file contains a record of the total hour for a pay period as entered by an employee using the Web Time… table in Lawson Payroll (prefix PYT). It is indexed by COMPANY, PAY-PER-START, EMPLOYEE (PYTSET1); alternate indexes: PYTSET2. It is related 1:1 to EMPLOYEE and PRSYSTEM. It is updated by HS04.1, HS35.1, HS36.1, HS535 and HS536 and referenced by HS22.1 and HS22.3. The table has 6 fields, 2 indexes and 2 documented relations.

About PRPAYTOTAL

The Pay Total file contains a record of the total hour for a pay period as entered by an employee using the Web Time Entry process. The total hours on this record are an accumulation of the hours on each PRPENDTIME record for the pay period.

Fields (6)

Column = COBOL field name without the PYT- 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
#PYT-COMPANY PK
COMPANY		Numeric 4—HS04.1, HS35.1, HS36.1
#PYT-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number. Each 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.HS04.1, HS35.1, HS36.1
#PYT-PAY-PER-START PK
PAY_PER_START		Numeric 8 (yyyymmdd)Contains the Pay Period Start date.HS04.1, HS35.1, HS36.1
#PYT-TOTAL-HOURS
TOTAL_HOURS		Signed 9.2Contain the total hours for the pay period.HS04.1, HS35.1, HS36.1
#PYT-STATUS
STATUS		Numeric 1This field displays the status of the transaction.
  • 1 Submitted
  • 2 Approved
  • 3 On Hold
  • 4 Rejected
  • 5 Entered; historical
  • 6 Submitted; historical
  • 7 Approved; historical
  • 8 On Hold; historical
  • 9 Rejected; historical
  • 0 Entered
HS04.1, HS35.1, HS36.1, HS535
#PYT-TIMECARD-TYPE
TIMECARD_TYPE		Numeric 1Contains the time record type. Valid values are: 2
  • 0 Normal.
  • 1 Exception.
HS04.1, HS35.1, HS36.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
PYTSET1
  1. COMPANY
  2. PAY-PER-START
  3. EMPLOYEE
PrimaryHS04.1, HS22.1, HS35.1, HS36.1, HS535, HS536
PYTSET2
  1. COMPANY
  2. EMPLOYEE
  3. PAY-PER-START
HS22.1, HS22.3

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
EmployeeEMPLOYEERequired
PYT-COMPANY→EMP-COMPANY
PYT-EMPLOYEE→EMP-EMPLOYEE
PrsystemPRSYSTEMRequired
PYT-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL

Programs

Updated by (5)

Referenced by (2)