USP_DATAFORMTEMPLATE_ADD_ACADEMICCATALOGSUBDEPARTMENT_PRELOAD

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

Parameters

Parameter	Parameter Type	Mode	Description
@ACADEMICCATALOGDEPARTMENTID	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_ACADEMICCATALOGSUBDEPARTMENT_PRELOAD
(
    @ACADEMICCATALOGDEPARTMENTID uniqueidentifier,
    @PARENT nvarchar(150) = null output,
    @TYPE_CODE tinyint = null output
)
as
    set nocount on;

    select
        @PARENT = NAME,
        @TYPE_CODE = 6 --Sub department

    from
        dbo.ACADEMICCATALOGDEPARTMENT
    where
        ID = @ACADEMICCATALOGDEPARTMENTID;