USP_DATAFORMTEMPLATE_ADD_ALTERNATESTUDENTID

The save procedure used by the add dataform template "Alternate Student ID 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.
@CONSTITUENTID uniqueidentifier IN Input parameter indicating the context ID for the record being added.
@ALTERNATELOOKUPIDTYPECODEID uniqueidentifier IN Type
@ALTERNATELOOKUPID nvarchar(100) IN Alternate Student ID

Definition

Copy


      CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_ALTERNATESTUDENTID
      (
          @ID uniqueidentifier = null output,
          @CHANGEAGENTID uniqueidentifier = null,    
          @CONSTITUENTID uniqueidentifier,
          @ALTERNATELOOKUPIDTYPECODEID uniqueidentifier = null,
          @ALTERNATELOOKUPID nvarchar(100) = ''
      ) as
        set nocount on;

      EXEC USP_DATAFORMTEMPLATE_ADD_ALTERNATELOOKUPID @ID,@CHANGEAGENTID,@CONSTITUENTID,@ALTERNATELOOKUPIDTYPECODEID,@ALTERNATELOOKUPID
      return 0;