USP_DATAFORMTEMPLATE_ADD_STUDENTSIMPLIFIED

The save procedure used by the add dataform template "Student Simplified Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@LASTNAME	nvarchar(100)	IN	Last name
@FIRSTNAME	nvarchar(50)	IN	First name
@MIDDLENAME	nvarchar(50)	IN	Middle name
@NICKNAME	nvarchar(50)	IN	Nickname
@SUFFIXCODEID	uniqueidentifier	IN	Suffix
@SCHOOLID	uniqueidentifier	IN	School
@ACADEMICYEARID	uniqueidentifier	IN	Academic year
@SCHOOLGRADELEVELID	uniqueidentifier	IN	Grade level
@DATEENROLLED	UDT_FUZZYDATE	IN	Date enrolled
@GENDERCODE	tinyint	IN	Gender
@BIRTHDATE	UDT_FUZZYDATE	IN	Birth date
@ADVISORID	uniqueidentifier	IN	Advisor
@STUDENTENROLLMENTSTATUS	uniqueidentifier	IN	Current status
@TITLECODEID	uniqueidentifier	IN	Title

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_STUDENTSIMPLIFIED
(
    @ID uniqueidentifier = null output,
    @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @LASTNAME nvarchar(100),
    @FIRSTNAME nvarchar(50) = '',
    @MIDDLENAME nvarchar(50) = '',
    @NICKNAME nvarchar(50) = '',
    @SUFFIXCODEID uniqueidentifier = null,
    @SCHOOLID uniqueidentifier = null,
    @ACADEMICYEARID uniqueidentifier = null,
    @SCHOOLGRADELEVELID uniqueidentifier = null,
    @DATEENROLLED dbo.UDT_FUZZYDATE = null,    
    @GENDERCODE tinyint = 0,
    @BIRTHDATE dbo.UDT_FUZZYDATE = '00000000',
    @ADVISORID uniqueidentifier = null,
    @STUDENTENROLLMENTSTATUS uniqueidentifier,
    @TITLECODEID uniqueidentifier = null
)    
as

set nocount on;

exec dbo.USP_DATAFORMTEMPLATE_ADD_STUDENT 
    @ID=@ID output,
    @CURRENTAPPUSERID=@CURRENTAPPUSERID,
    @CHANGEAGENTID=@CHANGEAGENTID,
    @LASTNAME=@LASTNAME,
    @FIRSTNAME=@FIRSTNAME,
    @MIDDLENAME=@MIDDLENAME,
    @NICKNAME=@NICKNAME,
    @TITLECODEID=@TITLECODEID,
    @SUFFIXCODEID=@SUFFIXCODEID,
    @SCHOOLID=@SCHOOLID,
    @ACADEMICYEARID=@ACADEMICYEARID,
    @SCHOOLGRADELEVELID=@SCHOOLGRADELEVELID,
    @DATEENROLLED=@DATEENROLLED,
    @GENDERCODE=@GENDERCODE,
    @BIRTHDATE=@BIRTHDATE,
    @ADVISORID=@ADVISORID,
    @STUDENTENROLLMENTSTATUS=@STUDENTENROLLMENTSTATUS

return 0