Standard Export generates a Pay Information record for each employee job code per day.
An employee can have Other Pay assigned without a job code reference. The record outputs a payroll entry with an empty Job Code Number and Job Code Name.
An employee can have more than one Other Pay assigned with the same business day and job code, but with different pay type, rate, and description. The record combines the first Other Pay and Employee_Daily_Job_Code_Total records based on location and business date, and then creates new payroll entries for subsequent Other Pay entries with empty standard regular pay data.
An employee can have more than one Other Pay assigned with the same business day, job code, pay type, pay rate, and description. The record combines all such Other Pay into a single payroll entry.
Table 20-20 Pay Information Export Format
Field | Field Type | Description |
---|---|---|
Record Type |
Varchar (255) |
String must contain PAYID. |
PAYID |
Varchar (255) |
Employee payroll ID. When using Oracle Hospitality RES 3700 without Oracle Hospitality Labor Management, the record uses the employee Social Security Number. If the employee does not have a Social Security Number, the record uses the RES 3700 payroll ID. |
Business Date |
YYYYMMDD |
Current business date. |
Job Code Number |
Numeric (10) |
Job code ID number. |
Job Code Name |
Varchar (255) |
Job code name. |
Regular Hours |
Numeric (12,2) |
Regular hours worked. |
Regular Pay |
Numeric (12,2) |
Amount owed for regular hours. |
Overtime Hours |
Numeric (12,2) |
Overtime hours worked. |
Overtime Pay |
Numeric (12,2) |
Amount owed for overtime hours. |
Other Overtime Hours |
Numeric (12,2) |
Other overtime hours worked. |
Other Overtime Pay |
Numeric (12,2) |
Amount owed for other overtime hours. |
Other Pay Type |
Varchar (255) |
Other pay types. |
Other Pay Hours |
Numeric (12,2) |
Other pay type hours worked. |
Other Pay |
Numeric (12,2) |
Amount owed for other pay types. |
Other Pay Rate |
Numeric (12,2) |
Pay rate for other pay type hours. |
F&B gross Receipts |
Numeric (12,2) |
Food and Beverage gross receipts. |
Tips Paid |
Numeric (12,2) |
Amount of tips paid. |
Charged Receipts |
Numeric (12,2) |
Amount of receipts charged. |
Charged Tips |
Numeric (12,2) |
Amount of tips charged. |
Indirect Tips |
Numeric (12,2) |
Amount owed for indirect tips. |
Declared Tips |
Numeric (12,2) |
Amount owed for declared tips. |
Home Store |
Varchar (255) |
Not used. |
NonRvc Regular Hours |
Numeric (12,2) |
Regular salaried hours worked. |
NonRvc Regular Pay |
Numeric (12,2) |
Amount owed for regular salaried hours. |
NonRvc Overtime Hours |
Numeric (12,2) |
Overtime salaried hours worked. |
NonRvc Overtime Pay |
Numeric (12,2) |
Amount owed for overtime salaried hours. |
Other Pay Description |
Varchar (255) |
Description for other pay. |
Related Topics
Parent topic: Standard Export