USP_DATAFORMTEMPLATE_ADD_EDUCATIONALINSTITUTION_2

The save procedure used by the add dataform template "Educational Institution Add Form 2".

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.
@FICECODE	nvarchar(50)	IN	FICE code
@NAME	nvarchar(100)	IN	Name
@ISAFFILIATED	bit	IN	This institution is affiliated with our organization
@COUNTRYID	uniqueidentifier	IN	Country
@CITY	nvarchar(50)	IN	City
@STATEID	uniqueidentifier	IN	State
@ADDRESSBLOCK	nvarchar(150)	IN	Address
@POSTCODE	nvarchar(12)	IN	Zip
@PHONENUMBER	nvarchar(100)	IN	Phone number

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_EDUCATIONALINSTITUTION_2
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @FICECODE nvarchar(50) = null,
    @NAME nvarchar(100),
    @ISAFFILIATED bit = 0,
    @COUNTRYID uniqueidentifier,
    @CITY nvarchar(50) = null,
    @STATEID uniqueidentifier = null,
    @ADDRESSBLOCK nvarchar(150) = '',
    @POSTCODE nvarchar(12) = '',
    @PHONENUMBER nvarchar(100) = ''
)
as
    set nocount on;

    exec dbo.USP_EDUCATIONALINSTITUTION_ADD @ID output, @CHANGEAGENTID, @NAME, @FICECODE, @ISAFFILIATED, '', null, 0, null, null, 0, @COUNTRYID, @STATEID, @ADDRESSBLOCK, @CITY, @POSTCODE, null, @PHONENUMBER, 0, null, '', 0, '', '', '', null, null, null, '', 0, null, 0;

    return 0;