USP_DATAFORMTEMPLATE_ADD_ACADEMICCATALOGPROGRAM_PRELOAD
The load procedure used by the edit dataform template "Academic Catalog Program Add"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EDUCATIONALINSTITUTIONID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @PARENT | nvarchar(150) | INOUT | Institution |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_ACADEMICCATALOGPROGRAM_PRELOAD
(
@EDUCATIONALINSTITUTIONID uniqueidentifier,
@PARENT nvarchar(150) = null output
)
as
set nocount on;
select
@PARENT = NAME
from
dbo.EDUCATIONALINSTITUTION
where
ID = @EDUCATIONALINSTITUTIONID;