UFN_CONSTITUENT_GETPARENTORGNAME
This function returns a table returning the name/id of the top parent org.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ORGID | uniqueidentifier | IN | |
| @TOPPARENTCODE | uniqueidentifier | IN | |
| @TOPSUBCODE | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_CONSTITUENT_GETPARENTORGNAME(@ORGID uniqueidentifier,@TOPPARENTCODE uniqueidentifier,@TOPSUBCODE uniqueidentifier)
returns table
as return
select CONS.KEYNAME as TOPPARENT,CONS.ID as TOPPARENTID from dbo.RELATIONSHIP
inner join dbo.CONSTITUENT as CONS on RELATIONSHIP.RELATIONSHIPCONSTITUENTID = CONS.ID
where RELATIONSHIP.RECIPROCALCONSTITUENTID = @ORGID and RELATIONSHIP.RELATIONSHIPTYPECODEID = @TOPPARENTCODE
and RELATIONSHIP.RECIPROCALTYPECODEID = @TOPSUBCODE
and (RELATIONSHIP.ENDDATE is null or RELATIONSHIP.ENDDATE >= getdate())