Home > Technical > Table Definitions > JOBTYPE

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)