USP_DATAFORMTEMPLATE_ADD_ACADEMICCATALOGCOLLEGE_PRELOAD

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

Parameters

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

    select
        @PARENT = NAME,
        @TYPE_CODE = 3 --College

    from
        dbo.ACADEMICCATALOGDEGREE
    where
        ID = @ACADEMICCATALOGDEGREEID;