PRPAYTOTAL FILE
The Pay Total file contains a record of the total hour for a pay period as
entered by an employee using the Web Time Entry process. The total hours on
this record are an accumulation of the hours on each PRPENDTIME record for the
pay period.
REFERENCED BY
HS22.1 HS22.3
UPDATED BY
HS04.1 HS35.1 HS36.1 HS535
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PYT-COMPANY Numeric 4 HS04.1 HS35.1
Company The company number represents an HS36.1
established company and is entered on
all function codes.
PYT-EMPLOYEE Numeric 9 HS04.1 HS35.1
Employee Contains the employee number. Each HS36.1
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.
PYT-PAY-PER-START Numeric 8 (yyyymmdd) HS04.1 HS35.1
Pay Per Start Contains the Pay Period Start date. HS36.1
PYT-TOTAL-HOURS Signed 9.2 HS04.1 HS35.1
Total Hours Contain the total hours for the pay HS36.1
period.
PYT-STATUS Numeric 1 HS04.1 HS35.1
Status This field displays the status of the HS36.1 HS535
transaction.
1 = SUBMITTED
2 = APPROVED
3 = REJECTED
4 = HOLD
PYT-TIMECARD-TYPE Numeric 1 HS04.1 HS35.1
Timecard Type Contains the time record type. Valid HS36.1
values are:
0 = Normal.
1 = Exception.
2
PRPAYTOTAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PYTSET1 COMPANY HS04.1 HS22.1
PAY-PER-START HS35.1 HS36.1
EMPLOYEE HS535
PYTSET2 COMPANY HS22.1 HS22.3
EMPLOYEE
PAY-PER-START
PRPAYTOTAL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Employee EMPLOYEE Required
PYT-COMPANY -> EMP-COMPANY
PYT-EMPLOYEE -> EMP-EMPLOYEE
Prsystem PRSYSTEM Required
PYT-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
|
