ITINERARYITEMSTAFFRESOURCE (4.0SP20)

Describes the staff resources used by the itinerary item.

Primary Key
Primary Key Field Type

ID

uniqueidentifier

Foreign Key Fields
Foreign Key Field Type Null Notes Description

ITINERARYITEMID

uniqueidentifier

false

The itinerary item that this staff resource is for.

VOLUNTEERTYPEID

uniqueidentifier

false

The volunteer type id that is associated with this staff resource.

JOBID

uniqueidentifier

true

The job associated with this itinerary item staff resource.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

JOBOCCURRENCEID

uniqueidentifier

true

The job occurence associated with this itinerary item staff resource.

Fields
Field Field Type Null Notes Description

QUANTITYNEEDED

int

false

0

The quantity of this staff resource needed for the itinerary item.

FILLEDBYCODE

tinyint

false

0

The type of staff resource needed for this itinerary.

FILLEDBY

nvarchar(9) (Computed)

true

Provides a translation for the 'FILLEDBYCODE' field.

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.

PRICE

money

false

0

The price of the resource.

PRICINGSTRUCTURECODE

tinyint

false

0

Indicates the pricing structure for the resource.

PRICINGSTRUCTURE

nvarchar(24) (Computed)

true

Provides a translation for the 'PRICINGSTRUCTURECODE' field.

IGNORESQUANTITYFORCAPACITY

bit

false

0

For group check-in, bypass constraint on quantity required for capacity.

Indexes
Index Name Field(s) Unique Primary Clustered

IX_ITINERARYITEMSTAFFRESOURCE_DATEADDED

DATEADDED

False

False

True

IX_ITINERARYITEMSTAFFRESOURCE_DATECHANGED

DATECHANGED

False

False

False

PK_ITINERARYITEMSTAFFRESOURCE

ID

True

True

False

UIX_ITINERARYITEMSTAFFRESOURCE_ITINERARYITEMID_VOLUNTEERTYPEID_JOBID

ITINERARYITEMID

VOLUNTEERTYPEID

JOBID

True

False

False

Triggers
Trigger Name Description

TR_ITINERARYITEMSTAFFRESOURCE_INSERT_JOBOCCURRENCE

TR_ITINERARYITEMSTAFFRESOURCE_UPDATE_JOBOCCURRENCE

TR_ITINERARYITEMSTAFFRESOURCE_DELETE_JOBOCCURRENCE

TR_ITINERARYITEMSTAFFRESOURCE_AUDIT_UPDATE

TR_ITINERARYITEMSTAFFRESOURCE_AUDIT_DELETE

Referenced by
Referenced by Field

ITINERARYITEMSTAFFRESOURCEASSIGNMENT

ITINERARYITEMSTAFFRESOURCEID

SALESORDERITEMITINERARYITEMSTAFFRESOURCE

ITINERARYITEMSTAFFRESOURCEID