PRWEEKS FILE
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.
REFERENCED BY
PR291 PR292 HR170 HR70.1
UPDATED BY
PR289 PR83.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PWK-COMPANY Numeric 4 PR289 PR83.1
Element: Company The company number represents an
established company and is entered on
all function codes.
PWK-PAYROLL-YEAR Numeric 4 PR289 PR83.1
Element: Current PayrolContains the payroll year for which you
want to display or adjust weeks worked.
PWK-QUARTER Numeric 1 PR289 PR83.1
Element: Quarter Contains the fiscal quarter for the
data stored in this record.
1
2
3
4
PWK-EMPLOYEE Numeric 9 PR289 PR83.1
Element: Employee 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.
PWK-PROCESS-LEVEL Alpha 5 PR289 PR83.1
Element: Process Level Contains the process level of employees
who worked in weeks associated with the
payroll year and quarter defined.
PWK-WORK-STATE Alpha 2 PR289 PR83.1
Element: Work State Contains the work state on the employee
record at the time of payment.
PWK-NBR-WEEKS Signed 2.0 PR289 PR83.1
Element: Nbr Weeks Contains the number of weeks the
employee worked during the defined
payroll year and quarter.
PWK-REPORT-ENTITY Alpha 5
Element: Process Level
PRWEEKS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PWKSET1 COMPANY PR289 PR291
PAYROLL-YEAR PR292 PR83.1
QUARTER
EMPLOYEE
REPORT-ENTITY
PROCESS-LEVEL
WORK-STATE
PWKSET2 COMPANY HR170 HR70.1
EMPLOYEE
PAYROLL-YEAR
QUARTER
REPORT-ENTITY
PROCESS-LEVEL
WORK-STATE
PRWEEKS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
