Lusid.Fund.ValuationPointData.Breakdown

Providing you have sufficient access control permissions, the Lusid.Fund.ValuationPointData.Breakdown provider enables you to write a Luminesce SQL query that retrieves a breakdown of fund-level valuation data.

You can join this provider to others to retrieve more information:

• Join to Lusid.Fund.ValuationPointData to retrieve a fund-level summary of GAV and NAV.

• Join to Lusid.Fund.ValuationPointData.Fee to retrieve fund-level fee accruals.

Basic usage

You must specify an end date that is either:

• An arbitrary datetime using the EndDate parameter.

• A pre-defined valuation point using the DiaryEntryCode parameter.

select * from Lusid.Fund.ValuationPointData.Breakdown
where FundScope = <scope> 
and FundCode = <code>
and <date-or-diary-entry>
;

Query parameters

Lusid.Fund.ValuationPointData.Breakdown has parameters that enable you to filter or refine a query.

To list available parameters, their data types, default values, and an explanation for each, run the following query using a suitable tool:

select FieldName, DataType, ParamDefaultValue, Description from Sys.Field where TableName = 'Lusid.Fund.ValuationPointData.Breakdown' and FieldType = 'Parameter';

Data fields

By default, Lusid.Fund.ValuationPointData.Breakdown returns a table of data populated with particular fields (columns). You can return a subset of these fields.

To list fields available to return, their data types, whether fields are considered 'main', and an explanation for each, run the following query using a suitable tool:

select FieldName, DataType, IsMain, IsPrimaryKey, SampleValues, Description from Sys.Field where TableName = 'Lusid.Fund.ValuationPointData.Breakdown' and FieldType = 'Column';

Note: Fields marked 'main' are returned by queries that select a ^ character, for example select ^ from Lusid.Fund.ValuationPointData.Breakdown.

Examples

Note: For more example Luminesce SQL queries, visit our Github repo.

Example 1: Retrieve a breakdown at an arbitrary point in time

You can use the EndDate parameter to retrieve a fund-level breakdown at an arbitrary point in time.

select * from Lusid.Fund.ValuationPointData.Breakdown
where FundScope = 'Growth'
and FundCode = 'Equities'
and EndDate = #2024-06-13 17:00:00#
;

Example 2: Retrieve a breakdown at an official valuation point

Publishing an official fund valuation is a workflow with checks and balances, not all of which is possible using Luminesce.

Assuming an accounting diary entry of type ValuationPoint exists, you can use the DiaryEntryCode parameter to retrieve a fund-level breakdown at an official valuation point.

select * from Lusid.Fund.ValuationPointData.Breakdown
where FundScope = 'Growth'
and FundCode = 'Equities'
and DiaryEntryCode = '13June2024-5pm-asAt7pm'
;

Example 3: Retrieve GAV and NAV as well as a breakdown

You can join this provider to Lusid.Fund.ValuationPointData in order to also retrieve a fund-level summary. Note you must specify the same EndDate or DiaryEntryCode for both providers.

select
    d.GAV, d.NAV,
    f.*
from
    Lusid.Fund.ValuationPointData d
    inner join Lusid.Fund.ValuationPointData.Breakdown f
        on d.FundScope = f.FundScope
        and d.FundCode = f.FundCode
where
    d.FundScope = 'Growth'
    and d.FundCode = 'Equities' 
    and d.DiaryEntryCode = '13June2024-5pm-asAt7pm'
    and f.DiaryEntryCode = '13June2024-5pm-asAt7pm'
;