Get Issuer QUID by QUID

ftGetIssuerQUIDbyQUID

For a given QUID, returns all QUIDs that are related to all issues from the same issuer as of a given point in time. Primarily used to identify other share-classes and asset classes from the same issuer.

Usage:


                        SELECT *
                        
  FROM ftGetIssuerQUIDbyQUID(@QUID, @AsOfDate)

Parameter	Type	Wildcard?	Pass NULL?	Description	Notes
@QUID	nvarchar(50)			Alpha QUID
@AsOfDate	date			As of date

Example:


                        SELECT *
                        
  FROM ftGetIssuerQUIDbyQUID('XYZABC1212', '2012-02-29')
                        
 ORDER BY QUID, iQUID

Returns all related QUIDs for the same issuer as the supplied QUID as of 29 Feb 2012.