Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of the parameter set.
 DESCRIPTION nvarchar(255)   Default = '' Details describing this parameter set
 CHILDGENDERCODE tinyint   Default = 0 0=Any, 1=Male, 2=Female, 3=Balanced
 ISHIVPOSITIVECODE tinyint   Default = 0 0=Any, 1=Yes, 2=No
 ISHIVPOSITIVE nvarchar(3) (Computed) CASE [ISHIVPOSITIVECODE] WHEN 0 THEN N'Any' WHEN 1 THEN N'Yes' WHEN 2 THEN N'No' END Provides a translation for the 'ISHIVPOSITIVECODE' field.
 HASCONDITIONCODE tinyint   Default = 0 0=Any, 1=Yes, 2=No
 HASCONDITION nvarchar(3) (Computed) CASE [HASCONDITIONCODE] WHEN 0 THEN N'Any' WHEN 1 THEN N'Yes' WHEN 2 THEN N'No' END Provides a translation for the 'HASCONDITIONCODE' field.
 ISORPHANEDCODE tinyint   Default = 0 0=Any, 1=Yes, 2=No
 ISORPHANED nvarchar(3) (Computed) CASE [ISORPHANEDCODE] WHEN 0 THEN N'Any' WHEN 1 THEN N'Yes' WHEN 2 THEN N'No' END Provides a translation for the 'ISORPHANEDCODE' field.
 SPROPPAGERANGEID uniqueidentifier Age ranges
 MAXKEYNUMBER int   Default = 0
 ENDDATE datetime
 STATUSCODE tinyint   Default = 0 The status code of a reservation key.
 STATUS nvarchar(8) (Computed) CASE [STATUSCODE] WHEN 0 THEN N'Inactive' WHEN 1 THEN N'Reserved' END Provides a translation for the 'STATUSCODE' field.
 INCLUDEPENDING bit   Default = 0 Indicates pending opportunities included in the selection.
 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) CONVERT(bigint, TS) Numeric representation of the timestamp.
 CHILDGENDER nvarchar(8) (Computed) CASE [CHILDGENDERCODE] WHEN 0 THEN N'Any' WHEN 1 THEN N'Male' WHEN 2 THEN N'Female' WHEN 3 THEN N'Balanced' END Provides a translation for the 'CHILDGENDERCODE' field.
 MULTIPLELOCATION xml Multiple location selection ability for children selection.

Foreign Key Field Type Null Notes Description
 IDSETREGISTERID uniqueidentifier IDSETREGISTER.ID FK to IDSETREGISTER
 GROUPID uniqueidentifier SPONSORSHIPOPPORTUNITYGROUP.ID Program selected
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_SPONSORSHIPOPPORTUNITYRESERVEPROCESS_DATEADDED DATEADDED    
 IX_SPONSORSHIPOPPORTUNITYRESERVEPROCESS_DATECHANGED DATECHANGED      
 IX_SPONSORSHIPOPPORTUNITYRESERVEPROCESS_GROUPID GROUPID      
 IX_SPONSORSHIPOPPORTUNITYRESERVEPROCESS_IDSETREGISTERID IDSETREGISTERID      
 PK_SPONSORSHIPOPPORTUNITYRESERVEPROCESS ID  
 UC_SPONSORSHIPOPPORTUNITYRESERVEPROCESS_NAME NAME    

Trigger Name Description
 TR_SPONSORSHIPOPPORTUNITYRESERVEPROCESS_AUDIT_UPDATE
 TR_SPONSORSHIPOPPORTUNITYRESERVEPROCESS_AUDIT_DELETE

Referenced by Field
 BATCHSPONSORSHIP RESERVATIONKEYID
 SPONSORSHIPOPPORTUNITY RESERVATIONKEYID
 SPONSORSHIPOPPORTUNITYRESERVATIONSTATUS OPPORTUNITYRESERVATIONKEYID
 SPONSORSHIPOPPORTUNITYRESERVEPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table