Open topic with navigation

TRACKSTAFFRESOURCE (4.0SP17)

dbo-4.0-4.0SP1

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers

Describes the staff resources used by the track.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
TRACKID	uniqueidentifier	false	TRACK.ID	The track that the resource is used for.
VOLUNTEERTYPEID	uniqueidentifier	false	VOLUNTEERTYPE.ID	The volunteer type that represents this resource.
JOBID	uniqueidentifier	true	JOB.ID	The job associated with this track item staff resource.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.

Fields
Field	Field Type	Null	Notes	Description
QUANTITYNEEDED	int	false	0	The quantity of the resource needed for this track.
FILLEDBYCODE	tinyint	false	0	The type of staff resource needed for this track.
FILLEDBY	nvarchar(9) (Computed)	true		Provides a translation for the 'FILLEDBYCODE' field.
JOBNAME	nvarchar(100)	false	''	The name of the job to create when the track is used.
JOBDESCRIPTION	nvarchar(255)	false	''	The description of the job to create when the track is used
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.

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_TRACKSTAFFRESOURCE_DATEADDED	DATEADDED	False	False	True
IX_TRACKSTAFFRESOURCE_DATECHANGED	DATECHANGED	False	False	False
PK_TRACKSTAFFRESOURCE	ID	True	True	False
UIX_TRACKSTAFFRESOURCE_TRACKID_VOLUNTEERTYPEID	TRACKID VOLUNTEERTYPEID	True	False	False

Triggers
Trigger Name	Description
TR_TRACKSTAFFRESOURCE_AUDIT_UPDATE
TR_TRACKSTAFFRESOURCE_AUDIT_DELETE