DIMJOBTYPE

This dimension table stores information about the job types.

Columns

Column	Data type	Description
ARCHIVE	NUMBER	An indication of whether the job type record is archived or not. 0 means not archived, whereas 1 means it is archived.
BUILDID	NUMBER	Avionté’s unique identifier for each of its customers’ instances or builds. The value in this field is the same for all rows.
CUSTOMERKEY	NUMBER	A foreign key referencing the customer record in the DIMCUSTOMER table.
JOBTYPE	VARCHAR	The job type. Common examples are Contract, Permanent, and Contract to Perm.
JOBTYPEID	NUMBER	The unique identifier for the Job Type record.
JOBTYPEKEY	NUMBER	The primary key referencing a job type.
JOBTYPENAME	VARCHAR	The name of the job type. Common examples are Contract, Permanent, and Contract to Perm.