DIMHIREDTYPE

This dimension table stores information about placement types.

Columns

Column	Data type	Description
ACTIVITYID	NUMBER	The identifier for the activity.
ACTIVITYORDER	NUMBER	The numeric order for the activity.
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.
HIREDSUBTYPE	VARCHAR	The subtype of the placement/assignment (for example, Pipeline, Interview, Extension, Offer, General, Accepted Offer, Decline, Web Apply, Declined, Fallout subtypes).
HIREDTYPEKEY	NUMBER	The primary key referencing the type of the placement.
HIREDTYPENAME	VARCHAR	The name of the placement type.
ISARCHIVE	NUMBER	The indication of whether the placement type is archived or not.
MODDATE	TIMESTAMP_NTZ	The date and time when the placement type was modified.