PRHOURS – Payroll Hours

System
Payroll (PR)
Prefix
PHS
Primary key
COMPANY, EMPLOYEE, HOURS-TYPE, PAYROLL-YEAR
Fields
11
Updated by
7 programs
Referenced by
2 programs

PRHOURS is the Payroll Hours table in Lawson Payroll (prefix PHS). It is indexed by COMPANY, EMPLOYEE, HOURS-TYPE, PAYROLL-YEAR (PHSSET1); alternate indexes: PHSSET2 and PHSSET3. It is related 1:1 to PRSYSTEM, EMPLOYEE and PAEMPLOYEE and 1:M to PRTIME and QUARTWAGE. It is updated by HR00.1, HR01.1, HR11.1, PA115, PR188, PR84.1 and PR88.1 and referenced by PR284 and TA148. The table has 11 fields, 3 indexes and 5 documented relations.

About PRHOURS

No description in the Lawson data dictionary.

Fields (11)

Column = COBOL field name without the PHS- 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
#PHS-COMPANY PK
COMPANY		Numeric 4—PR188, PR84.1, PR88.1
#PHS-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.PR188, PR84.1, PR88.1
#PHS-HOURS-TYPE PK
HOURS_TYPE		Numeric 2—
  • 011 Vacation
  • 022 Seniority
PR188, PR84.1, PR88.1
#PHS-PAYROLL-YEAR PK
PAYROLL_YEAR		Numeric 4Contains the payroll year in which the allocation was taken.PR188, PR84.1, PR88.1
#PHS-HOURS
HOURS		Signed 7.2Contains the hours.PR188, PR88.1
#PHS-HOURS-FROZEN
HOURS_FROZEN		Signed 7.2—PR188, PR84.1, PR88.1
#PHS-DATE-FROZEN
DATE_FROZEN		Numeric 8 (yyyymmdd)—PR188, PR84.1, PR88.1
#PHS-TOT-PRHOURS
TOT_PRHOURS		Derived——
#PHS-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.PR188, PR88.1
#PHS-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.PR188, PR88.1
#PHS-USER-ID
USER_ID		Alpha 10 (Lower Case)—PR188, PR88.1

Indexes (3)

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
PHSSET1
  1. COMPANY
  2. EMPLOYEE
  3. HOURS-TYPE
  4. PAYROLL-YEAR
PrimaryHR00.1, HR01.1, HR11.1, PA115, PR188, PR284, PR84.1, PR88.2 +1 more
PHSSET2
  1. COMPANY
  2. EMPLOYEE
  3. HOURS-TYPE
  4. PAYROLL-YEAR ↓
PR88.1
PHSSET3
  1. COMPANY
  2. HOURS-TYPE
  3. PAYROLL-YEAR
  4. EMPLOYEE
PR188

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PHS-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
PHS-COMPANY→EMP-COMPANY
PHS-EMPLOYEE→EMP-EMPLOYEE
PaemployeePAEMPLOYEENot Required
PHS-COMPANY→PEM-COMPANY
PHS-EMPLOYEE→PEM-EMPLOYEE

One to many (2) — child tables

RelationTableRulesConditionField map
PrtimePRTIME
PHS-COMPANY→PRT-COMPANY
PHS-EMPLOYEE→PRT-EMPLOYEE
PHS-PAYROLL-YEAR→PRT-PAYROLL-YEAR
—→PRT-QUARTER
—→PRT-PAY-SUM-GRP
—→PRT-PROCESS-LEVEL
—→PRT-WORK-STATE
—→PRT-CHECK-ID
—→PRT-TIME-SEQ
QuartwageQUARTWAGE
PHS-COMPANY→QTW-COMPANY
PHS-EMPLOYEE→QTW-EMPLOYEE
PHS-PAYROLL-YEAR→QTW-PAYROLL-YEAR
—→QTW-QUARTER
—→QTW-COUNTRY-CODE
—→QTW-PAY-SUM-GRP
—→QTW-REPORT-ENTITY
—→QTW-BUS-NBR-GRP
—→QTW-QC-ENT-NBR-GRP
—→QTW-PROCESS-LEVEL
—→QTW-WORK-STATE
—→QTW-PENSION

Programs

Updated by (7)

Referenced by (2)