USP_DATAFORMTEMPLATE_EDITLOAD_RELATIONSHIPCONFIGURATION

The load procedure used by the edit dataform template "Relationship Configuration Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@RELATIONSHIP	nvarchar(200)	INOUT	Relationship
@GENDERCODE	tinyint	INOUT	Gender
@APPLIESTOINDIVIDUALS	bit	INOUT	Individuals
@APPLIESTOORGANIZATIONS	bit	INOUT	Organizations
@APPLIESTOGROUPS	bit	INOUT	Groups/Households
@APPLIESTOSTUDENTS	bit	INOUT	Students
@RELATESTOINDIVIDUALS	bit	INOUT	Individuals
@RELATESTOORGANIZATIONS	bit	INOUT	Organizations
@RELATESTOGROUPS	bit	INOUT	Groups/Households
@RELATESTOSTUDENTS	bit	INOUT	Students
@ISEMPLOYEERELATIONSHIP	bit	INOUT	Is employee relationship type
@ISPEERRELATIONSHIPTYPE	bit	INOUT	Is corporate peer relationship type

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RELATIONSHIPCONFIGURATION
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @RELATIONSHIP nvarchar(200) = null output,
    @GENDERCODE tinyint = null output,
    @APPLIESTOINDIVIDUALS bit = null output,
    @APPLIESTOORGANIZATIONS bit = null output,
    @APPLIESTOGROUPS bit = null output,
    @APPLIESTOSTUDENTS bit = null output,
    @RELATESTOINDIVIDUALS bit = null output,
    @RELATESTOORGANIZATIONS bit = null output,
    @RELATESTOGROUPS bit = null output,
    @RELATESTOSTUDENTS bit = null output,
    @ISEMPLOYEERELATIONSHIP bit = null output,
    @ISPEERRELATIONSHIPTYPE bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;
    set @TSLONG = 0;

    select
        @DATALOADED = 1,
        @RELATIONSHIP = RELATIONSHIPTYPECODE.DESCRIPTION,
        @GENDERCODE = coalesce(CONFIG.GENDERCODE, 0),
        @APPLIESTOINDIVIDUALS = coalesce(CONFIG.APPLIESTOINDIVIDUALS, 1),
        @APPLIESTOORGANIZATIONS = coalesce(CONFIG.APPLIESTOORGANIZATIONS, 1),
        @APPLIESTOGROUPS = coalesce(CONFIG.APPLIESTOGROUPS, 1),
        @APPLIESTOSTUDENTS = coalesce(CONFIG.APPLIESTOSTUDENTS, 1),
        @RELATESTOINDIVIDUALS = coalesce(CONFIG.RELATESTOINDIVIDUALS, 1),
        @RELATESTOORGANIZATIONS = coalesce(CONFIG.RELATESTOORGANIZATIONS, 1),
        @RELATESTOGROUPS = coalesce(CONFIG.RELATESTOGROUPS, 1),
        @RELATESTOSTUDENTS = coalesce(CONFIG.RELATESTOSTUDENTS, 1),
        @ISEMPLOYEERELATIONSHIP = case when EMPLOYEECORPORATERELATIONSHIPTYPE.ID is not null then 1 else 0 end,
        @ISPEERRELATIONSHIPTYPE = coalesce(ISPEERRELATIONSHIPTYPE, 0)
    from
        dbo.RELATIONSHIPTYPECODE
    left join 
        dbo.RELATIONSHIPCONFIGURATION CONFIG on CONFIG.ID = RELATIONSHIPTYPECODE.ID
    left join
        dbo.EMPLOYEECORPORATERELATIONSHIPTYPE on EMPLOYEECORPORATERELATIONSHIPTYPE.RELATIONSHIPTYPECODEID = RELATIONSHIPTYPECODE.ID
    where 
        RELATIONSHIPTYPECODE.ID = @ID

    return 0;