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) |