USP_DATAFORMTEMPLATE_EDIT_EDUCATIONALINSTITUTION_2

Maintained for backwards compatibility

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@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(150)	IN	City
@STATEID	uniqueidentifier	IN	State

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EDUCATIONALINSTITUTION_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @FICECODE nvarchar(50),
    @NAME nvarchar(100),
    @ISAFFILIATED bit,
    @COUNTRYID uniqueidentifier,
    @CITY nvarchar(150),
    @STATEID uniqueidentifier
)
as
begin

set nocount on

declare @ADDRESSBLOCK nvarchar(150)
declare @POSTCODE nvarchar(12)
declare @PHONENUMBER nvarchar(100)

exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EDUCATIONALINSTITUTION_2 
    @ID, 
    @ADDRESSBLOCK output,
    @POSTCODE output,
    @PHONENUMBER output

exec.USP_DATAFORMTEMPLATE_EDIT_EDUCATIONALINSTITUTION_3
    @ID,
    @CHANGEAGENTID,
    @FICECODE,
    @NAME,
    @ISAFFILIATED,
    @COUNTRYID,
    @CITY,
    @STATEID,
    @ADDRESSBLOCK,
    @POSTCODE,
    @PHONENUMBER

end