Home > Technical > Table Definitions > JOBTYPE
A job type record identifies a type of job, for example bar person, checkout operator. Specific combinations of job types and pay rates are set up as separate records.
Column |
Type |
Description |
STRCODE |
VARCHAR(10) |
A unique code to identify the job type. This is assigned by the user. |
STRDESCRIPTION |
VARCHAR(50) |
A description about the job. |
STRPAYTYPE |
VARCHAR(10) |
Indicates the type of job, for example CASUAL, PARTTIME, FULLTIME and MANAGEMENT. |
DBLBASEHOURSPERWEEK |
DECIMAL(9)19,4 |
The minimum number of hours which must be worked. |
DBLBASERATEPERHOUR |
DECIMAL(9)19,4 |
The dollar value paid per hour. |
DBLONCOSTRATEPERHOUR |
DECIMAL(9)19,4 |
The On Costs (payroll tax, leave loading, superannuation) expressed as a percentage of the base rate per hour. |
DBLHRSBEFOREOVERTIME |
DECIMAL(9)19,4 |
The number of hours which must be worked before overtime is paid. If overtime is not paid, set this to 999. |
DBLMAXHRSFORPAYROLL |
DECIMAL(9)19,4 |
The maximum number of hours which will be exported to a payroll package. If someone is paid for x hours work, regardless of how many more hours are actually worked, set this to x. |
DBLBASEHRSPERDAY |
DECIMAL(9)19,4 |
The number of hours per day that are to be worked. |
STRPOSDESCRIPTION |
VARCHAR(20) |
The description which will appear on the POS for this job type. |
Primary Key: STRCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |