PRHOURS

UPDATED BY
HR00.1 HR01.1 HR11.1 PA115 PR188 PR284
PR84.1 PR88.1 PR88.2 TA146 TA148

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PHS-COMPANY
Element: Company Hr
Numeric 4
PR188 PR84.1
PR88.1
PHS-EMPLOYEE
Element: Employee
Numeric 9
Contains 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
Element: Hours Type
Numeric 2

011 = Vacation
022 = Seniority
PR188 PR84.1
PR88.1
PHS-PAYROLL-YEAR
Element: Payroll Year
Numeric 4
Contains the payroll year in which the allocation was taken.
PR188 PR84.1
PR88.1
PHS-HOURS
Element: Hours
Signed 7.2
Contains the hours.
PR188 PR88.1
PHS-HOURS-FROZEN
Element: Hours Frozen
Signed 7.2
PR188 PR84.1
PR88.1
PHS-DATE-FROZEN
Element: Date Frozen
Numeric 8 (yyyymmdd)
PR188 PR84.1
PR88.1
PHS-TOT-PRHOURS
Element: Tot Prhours
Derived
PHS-DATE-STAMP
Element: 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
Element: 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
Element: User
Alpha 10 (Lower Case)
PR188 PR88.1


PRHOURS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PHSSET1 COMPANY
EMPLOYEE
HOURS-TYPE
PAYROLL-YEAR
HR00.1 HR01.1
HR11.1 PA115
PR188 PR284
PR84.1 PR88.2
TA146 TA148
PHSSET2 COMPANY
EMPLOYEE
HOURS-TYPE
PAYROLL-YEAR*
PR88.1
PHSSET3 COMPANY
HOURS-TYPE
PAYROLL-YEAR
EMPLOYEE
PR188


PRHOURS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PHS-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
PHS-COMPANY->EMP-COMPANY
PHS-EMPLOYEE->EMP-EMPLOYEE
Paemployee PAEMPLOYEE Not Required
PHS-COMPANY->PEM-COMPANY
PHS-EMPLOYEE->PEM-EMPLOYEE


PRHOURS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Prtime PRTIME
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
Quartwage QUARTWAGE
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


File created: Thu Jun 09 11:27:15 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.