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.

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

IndexKeysFlagsConditionUsed in
PHSSET1COMPANY, EMPLOYEE, HOURS-TYPE, PAYROLL-YEARPrimaryHR00.1, HR01.1, HR11.1, PA115, PR188, PR284, PR84.1, PR88.2 +1 more
PHSSET2COMPANY, EMPLOYEE, HOURS-TYPE, PAYROLL-YEAR*PR88.1
PHSSET3COMPANY, HOURS-TYPE, PAYROLL-YEAR, EMPLOYEEPR188

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredPHS-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredPHS-COMPANY → EMP-COMPANY, PHS-EMPLOYEE → EMP-EMPLOYEE
PaemployeePAEMPLOYEENot RequiredPHS-COMPANY → PEM-COMPANY, PHS-EMPLOYEE → PEM-EMPLOYEE

One to many (2) — child tables

RelationTableRulesConditionField map
PrtimePRTIMEPHS-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
QuartwageQUARTWAGEPHS-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)