USP_DATAFORMTEMPLATE_ADD_FACULTYACADEMICCATALOGDEPARTMENTBYFACULTY
The save procedure used by the add dataform template "Faculty Academic Catalog Department By Faculty Add Data Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | The output parameter indicating the ID of the record added. |
| @FACULTYID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @ACADEMICCATALOGDEPARTMENTID | uniqueidentifier | IN | Department |
| @ISDEPARTMENTHEAD | bit | IN | Faculty is department head |
| @ISTEACHERINDEPARTMENT | bit | IN | Faculty teaches in department |
| @ISPRIMARY | bit | IN | Primary department for faculty member |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FACULTYACADEMICCATALOGDEPARTMENTBYFACULTY
(
@ID uniqueidentifier = null output,
@FACULTYID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@ACADEMICCATALOGDEPARTMENTID uniqueidentifier = null,
@ISDEPARTMENTHEAD bit = false,
@ISTEACHERINDEPARTMENT bit = true,
@ISPRIMARY bit = true
)
as
set nocount on;
begin try
-- just call the other form
exec dbo.USP_DATAFORMTEMPLATE_ADD_FACULTYACADEMICCATALOGDEPARTMENT_BYDEPARTMENT
@ID,
@ACADEMICCATALOGDEPARTMENTID,
@CHANGEAGENTID,
@FACULTYID,
@ISDEPARTMENTHEAD,
@ISTEACHERINDEPARTMENT,
@ISPRIMARY
end try
begin catch
exec dbo.USP_RAISE_ERROR
return 1
end catch
return 0