PRWEEKS

Employee Weeks Worked

This file contains the number of weeks an employee worked during the defined payroll year and quarter. This includes the process level and work state on the employee record at the time of payment.
UPDATED BY
HR170 HR70.1 PR289 PR291 PR292 PR83.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PWK-COMPANY
Element: Company Hr
Numeric 4
PR289 PR83.1
PWK-PAYROLL-YEAR
Element: Payroll Year
Numeric 4
Contains the payroll year for which you want to display or adjust weeks worked.
PR289 PR83.1
PWK-QUARTER
Element: Quarter
Numeric 1
Contains the fiscal quarter for the data stored in this record.
1
2
3
4
PR289 PR83.1
PWK-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.
PR289 PR83.1
PWK-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
Contains the process level of employees who worked in weeks associated with the payroll year and quarter defined.
PR289 PR83.1
PWK-WORK-STATE
Element: Work State
Alpha 2
Contains the work state on the employee record at the time of payment.
PR289 PR83.1
PWK-NBR-WEEKS
Element: Nbr Weeks
Signed 2.0
Contains the number of weeks the employee worked during the defined payroll year and quarter.
PR289 PR83.1
PWK-REPORT-ENTITY
Element: Report Entity
Alpha 5


PRWEEKS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PWKSET1 COMPANY
PAYROLL-YEAR
QUARTER
EMPLOYEE
REPORT-ENTITY
PROCESS-LEVEL
WORK-STATE
PR289 PR291
PR292 PR83.1
PWKSET2 COMPANY
EMPLOYEE
PAYROLL-YEAR
QUARTER
REPORT-ENTITY
PROCESS-LEVEL
WORK-STATE
HR170 HR70.1


PRWEEKS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PWK-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
PWK-COMPANY->EMP-COMPANY
PWK-EMPLOYEE->EMP-EMPLOYEE
Process Level PRSYSTEM Required
PWK-COMPANY->PRS-COMPANY
PWK-PROCESS-LEVEL->PRS-PROCESS-LEVEL
Work State PRSTATE Required
PWK-WORK-STATE->PSA-STATE


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

Home
Contact Us



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