USP_DATAFORMTEMPLATE_ADD_SPONSORSHIPGREATESTNEEDRULESETFORMFIELDS
The save procedure used by the add dataform template "Sponsorship Greatest Need Rule Set Form Fields Add Form".
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@ID | uniqueidentifier | INOUT | The output parameter indicating the ID of the record added. |
@CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
@SPONSORSHIPLOCATIONID | uniqueidentifier | IN | Location |
@SPONSORSHIPOPPORTUNITYAGERANGEID | uniqueidentifier | IN | Age range |
@GENDERCODE | tinyint | IN | Gender |
@SPROPPCHILDCONDITIONCODEID | uniqueidentifier | IN | Disability/Illness |
@SPROPPPROJECTCATEGORYCODEID | uniqueidentifier | IN | Category |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SPONSORSHIPGREATESTNEEDRULESETFORMFIELDS
(
@ID uniqueidentifier = null output,
@CHANGEAGENTID uniqueidentifier = null,
@SPONSORSHIPLOCATIONID uniqueidentifier = null,
@SPONSORSHIPOPPORTUNITYAGERANGEID uniqueidentifier = null,
@GENDERCODE tinyint = null,
@SPROPPCHILDCONDITIONCODEID uniqueidentifier = null,
@SPROPPPROJECTCATEGORYCODEID uniqueidentifier = null
)
as
-- THIS PROCEDURE IS NOT USED
return 0