USP_DATAFORMTEMPLATE_ADD_ACADEMICCATALOGDEPARTMENT_PRELOAD

The load procedure used by the edit dataform template "Academic Catalog Department Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ACADEMICCATALOGCOLLEGEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@PARENT	nvarchar(150)	INOUT	Parent
@TYPE_CODE	tinyint	INOUT	Type code

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_ACADEMICCATALOGDEPARTMENT_PRELOAD
(
    @ACADEMICCATALOGCOLLEGEID uniqueidentifier,
    @PARENT nvarchar(150) = null output,
    @TYPE_CODE tinyint = null output
)
as
    set nocount on;

    select
        @PARENT = NAME,
        @TYPE_CODE = 5 --Department

    from
        dbo.ACADEMICCATALOGCOLLEGE
    where
        ID = @ACADEMICCATALOGCOLLEGEID;