ITINERARYSTAFFRESOURCE

Describes the staff resources used by the itinerary.

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
QUANTITYNEEDED int Default = 0 The quantity of the resource needed for this itinerary.
FILLEDBYCODE tinyint Default = 0 The type of staff resource needed for this itinerary.
FILLEDBY nvarchar(9) (Computed) yes CASE [FILLEDBYCODE] WHEN 0 THEN N'Volunteer' WHEN 1 THEN N'Staff' WHEN 2 THEN N'Board' END Provides a translation for the 'FILLEDBYCODE' field.
DATEADDED datetime Default = getdate() Indicates the date this record was added.
DATECHANGED datetime Default = getdate() Indicates the date this record was last changed.
TS timestamp Timestamp.
TSLONG bigint (Computed) yes CONVERT(bigint, TS) Numeric representation of the timestamp.
PRICE money Default = 0 The price of the resource.
PRICINGSTRUCTURECODE tinyint Default = 0 Indicates the pricing structure for the resource.
PRICINGSTRUCTURE nvarchar(24) (Computed) yes CASE [PRICINGSTRUCTURECODE] WHEN 0 THEN N'No charge' WHEN 1 THEN N'Flat rate per resource' WHEN 2 THEN N'Hourly rate per resource' END Provides a translation for the 'PRICINGSTRUCTURECODE' field.
IGNORESQUANTITYFORCAPACITY bit Default = 0 For group check-in, bypass constraint on quantity required for capacity.

Foreign Keys

Foreign Key Field Type Null Notes Description
ITINERARYID uniqueidentifier ITINERARY.ID The itinerary that the resource is used for.
VOLUNTEERTYPEID uniqueidentifier VOLUNTEERTYPE.LOCALID The volunteer type that represents this resource.
JOBID uniqueidentifier yes JOB.ID The job that represents this resource.
ADDEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.
CHANGEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.
JOBOCCURRENCEID uniqueidentifier yes JOBOCCURRENCE.ID The job occurrence associated with this itinerary item staff resource.

Indexes

Index Name Fields Unique Primary Clustered
IX_ITINERARYSTAFFRESOURCE_DATEADDED DATEADDED yes
IX_ITINERARYSTAFFRESOURCE_DATECHANGED DATECHANGED
PK_ITINERARYSTAFFRESOURCE ID yes yes
UIX_ITINERARYSTAFFRESOURCE_ITINERARYID_VOLUNTEERTYPEID_JOBID ITINERARYID, VOLUNTEERTYPEID, JOBID yes

Triggers

Trigger Name Description
TR_ITINERARYSTAFFRESOURCE_INSERT_JOBOCCURRENCE
TR_ITINERARYSTAFFRESOURCE_UPDATE_JOBOCCURRENCE
TR_ITINERARYSTAFFRESOURCE_DELETE_JOBOCCURRENCE
TR_ITINERARYSTAFFRESOURCE_DELETE_REQUIREDSTAFFRESOURCECANNOTBEDELETED
TR_ITINERARYSTAFFRESOURCE_AUDIT_UPDATE
TR_ITINERARYSTAFFRESOURCE_AUDIT_DELETE

Referenced by

Referenced by Field
ITINERARYSTAFFRESOURCEASSIGNMENT ITINERARYSTAFFRESOURCEID
SALESORDERITEMITINERARYSTAFFRESOURCE ITINERARYSTAFFRESOURCEID