USP_DATAFORMTEMPLATE_ADD_FACULTYACADEMICCATALOGDEPARTMENTBYFACULTY_PRELOAD

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

Parameters

Parameter	Parameter Type	Mode	Description
@FACULTYID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@FACULTY	nvarchar(154)	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FACULTYACADEMICCATALOGDEPARTMENTBYFACULTY_PRELOAD
(
    @FACULTYID uniqueidentifier,
    @FACULTY nvarchar(154) = null output
)
as
    set nocount on;

    -- populate the fields that have default values that should be fetched from the database

    select 
        @FACULTY = CONSTITUENT.NAME
    from 
        dbo.CONSTITUENT
    where 
        ID = @FACULTYID

    return 0;