Open topic with navigation

JOB (4.0SP12)

dbo-4.0-4.0SP1

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

Stores information pertaining to a job to be performed by volunteers.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
VOLUNTEERTYPEID	uniqueidentifier	true	VOLUNTEERTYPE.ID	The type of volunteer to be assigned to this job.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
SITEID	uniqueidentifier	true	SITE.ID	The job's site.
BASECURRENCYID	uniqueidentifier	true	CURRENCY.ID	The base currency associated with this job.
ORGANIZATIONEXCHANGERATEID	uniqueidentifier	true	CURRENCYEXCHANGERATE.ID	The exchange rate used to convert base currency amounts to organization amounts.

Fields
Field	Field Type	Null	Notes	Description
NAME	nvarchar(100)	false	''	The name of the job.
DESCRIPTION	nvarchar(255)	false	''	A brief description of the job.
ISACTIVE	bit	false	1	Indicates whether or not the job is active.
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
ESTIMATEDVALUE	money	false	0	The estimated value per hour for the job, stored in the job's base currency.
ORGANIZATIONESTIMATEDVALUE	money	false	0	The estimated value per hour for the job, stored in the organization currency.

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_JOB_DATEADDED	DATEADDED	False	False	True
IX_JOB_DATECHANGED	DATECHANGED	False	False	False
PK_JOB	ID	True	True	False
UC_JOB_NAME	NAME	True	False	False

Triggers
Trigger Name	Description
TR_JOB_INSERTUPDATE_CURRENCY
TR_JOB_AUDIT_UPDATE
TR_JOB_AUDIT_DELETE

Referenced by
Referenced by	Field
EVENTSTAFFRESOURCE	JOBID
GROUPTYPEREQUIREDSTAFFRESOURCE	JOBID
ITINERARYITEMSTAFFRESOURCE	JOBID
ITINERARYSTAFFRESOURCE	JOBID
JOBADMINISTRATIVE	JOBID
JOBATTACHMENT	JOBID
JOBCERTIFICATION	JOBID
JOBCOURSE	JOBID
JOBINTEREST	JOBID
JOBLICENSE	JOBID
JOBMEDIALINK	JOBID
JOBMEDICAL	JOBID
JOBNOTE	JOBID
JOBOCCURRENCE	JOBID
JOBSKILL	JOBID
JOBSPECIALNEED	JOBID
PROGRAMSTAFFRESOURCE	JOBID
TRACKITEMSTAFFRESOURCE	JOBID
TRACKSTAFFRESOURCE	JOBID