USP_DATAFORMTEMPLATE_ADD_ACADEMICCATALOGDEGREE_PRELOAD

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

Parameters

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

    select
        @PARENT = PROGRAM,
        @TYPE_CODE = 2 --Degree

    from
        dbo.ACADEMICCATALOGPROGRAM
    where
        ID = @ACADEMICCATALOGPROGRAMID;