Query and Reports
Classe Report

T2S provides T2S actors with a number of pre-defined reports for periodical information on the production data. The Report Management Module, however, does not cover any regulatory reporting. The reports provided are set up as XML messages and comply to the largest possible extent with ISO 20022 standard. In cases where the standard is not able to meet T2S demands, proprietary messages are defined {T2S.13.160}. All reports are available in user-to-application mode and in application-to-application mode {T2S.13.170}. All securities instructions, balance and static data reports are available for all CSDs in T2S, T2S parties and NCBs {T2S.13.180}. Reports can be sent to CSDs and directly connected T2S parties, containing information on one or several accounts {T2S.13.210}.
T2S reports can either be sent on a business event (e.g. end-of-day) or on a time event (i.e. at a fixed time) {T2S.13.190}.
If a report got lost, it can be downloaded again by the affected T2S actor.

Attributi
<Primitive Type> String Report Name Report Name

Name of the stored report - possible values are:
• Statement of Holdings
• Statement of Transactions
• Statement of Pending Instructions
• Statement of Settlement Allegements
• Statement of Accounts
• SD T2S DCA Statement
• SD Securities Accounts Statement
• SD Securities Statement
• SD Party Statement
• Current Business Day Cash Forecast
• Next Business Day Cash Forecast
• Executed AI on Cash
• Executed AI on Securities
• Executed CI on Cash
• Executed CI on Securities
• Pending AI on Cash
• Pending AIon Securities
• Pending CI on Cash
• Pending CI on Securities
• Pending Restrictions on Cash
• Pending Restrictions on Securities
• Settled Restrictions on Cash
• Settled Restrictions on Securities

<Primitive Type> String Report Data Report Data

Report content stored as flat file

<Primitive Type> Timestamp Report Timestamp Report Timestamp

Timestamp reflecting date and time of the creation of the report

<<Entity>> <Class> Report Configuration Party Link is generated for is generated for
<Primitive Type> Boolean System Entity Wide Reporting Flag System Entity Wide Reporting Flag

Boolean attribute specifying whether the report should include information for the entire system entity data scope.

<Primitive Type> Timestamp FROM Date Time FROM Date Time

store the information on the point in time, when the queried report period starts.

<Primitive Type> Timestamp TO Date Time TO Date Time

store the information on the point in time, when the queried report period ends.

<Primitive Type> Boolean Delta Mode Delta Mode

It stores the information wether the created report is a FULL or a DELTA report. Possible values are:
- True (i.e. Delta report)
- False (i.e. Full report)

<Primitive Type> Timestamp Scheduled Time Scheduled Time

It stores the configured point in time/business event which triggered the creation of the report.

<Primitive Type> String Statement Number Statement Number

It stores the statement number of the report (composed of the business date and Report Type (2-letter-abbreviation depending on report name and Delta/Full-Flag) plus sequential number), which is unique in T2S.

<<Entity>> <Class> Party is based on is based on

Proprietà:

Is Abstractfalse
Is Activefalse
Is Leaffalse
NameReport
Namespace<Package> Query and Reports
Owner<Package> Query and Reports
Package<Package> Query and Reports
Qualified NameT2S Data Model::Query and Reports::Report
StereotypeBoundary
VisibilityPublic

Dettagli attributo

 Delta Mode
Public <Primitive Type> Boolean Delta Mode

It stores the information wether the created report is a FULL or a DELTA report. Possible values are:
- True (i.e. Delta report)
- False (i.e. Full report)

Vincoli:
Proprietà:

AggregationNone
Class<<Boundary>> <Class> Report
Is Compositefalse
Is Derivedfalse
Is Derived Unionfalse
Is Leaffalse
Is Orderedfalse
Is Read Onlyfalse
Is Staticfalse
Is Uniquetrue
Lower1
Multiplicity1
NameDelta Mode
Namespace<<Boundary>> <Class> Report
Owner<<Boundary>> <Class> Report
Qualified NameT2S Data Model::Query and Reports::Report::Delta Mode
Type<Primitive Type> Boolean
Upper1
VisibilityPublic


 FROM Date Time
Public <Primitive Type> Timestamp FROM Date Time

store the information on the point in time, when the queried report period starts.

Vincoli:
Proprietà:

AggregationNone
Class<<Boundary>> <Class> Report
Is Compositefalse
Is Derivedfalse
Is Derived Unionfalse
Is Leaffalse
Is Orderedfalse
Is Read Onlyfalse
Is Staticfalse
Is Uniquetrue
Lower1
Multiplicity1
NameFROM Date Time
Namespace<<Boundary>> <Class> Report
Owner<<Boundary>> <Class> Report
Qualified NameT2S Data Model::Query and Reports::Report::FROM Date Time
Type<Primitive Type> Timestamp
Upper1
VisibilityPublic


 is based on
Private <<Entity>> <Class> Party is based on
Vincoli:
Proprietà:

AggregationNone
Association<Association> A_is the basis_is based on
Class<<Boundary>> <Class> Report
Is Compositefalse
Is Derivedfalse
Is Derived Unionfalse
Is Leaffalse
Is Orderedfalse
Is Read Onlyfalse
Is Staticfalse
Is Uniquetrue
Lower1
Lower Value<Literal Integer> 1
Multiplicity1
Nameis based on
Namespace<<Boundary>> <Class> Report
Opposite<Property> is the basis : Report [0..*]
Owner<<Boundary>> <Class> Report
Qualified NameT2S Data Model::Query and Reports::Report::is based on
Type<<Entity>> <Class> Party
Upper1
Upper Value<Literal Unlimited Natural> 1
VisibilityPrivate


 is generated for
Private <<Entity>> <Class> Report Configuration Party Link is generated for
Vincoli:
Proprietà:

AggregationNone
Association<Association> A_report_is generated for
Class<<Boundary>> <Class> Report
Is Compositefalse
Is Derivedfalse
Is Derived Unionfalse
Is Leaffalse
Is Orderedfalse
Is Read Onlyfalse
Is Staticfalse
Is Uniquetrue
Lower0
Lower Value<Literal Integer> 0
Multiplicity*
Nameis generated for
Namespace<<Boundary>> <Class> Report
Opposite<Property> report : Report [0..1]
Owner<<Boundary>> <Class> Report
Qualified NameT2S Data Model::Query and Reports::Report::is generated for
Type<<Entity>> <Class> Report Configuration Party Link
Upper*
Upper Value<Literal Unlimited Natural> *
VisibilityPrivate


 Report Data
Public <Primitive Type> String Report Data

Report content stored as flat file

Vincoli:
Proprietà:

AggregationNone
Class<<Boundary>> <Class> Report
Is Compositefalse
Is Derivedfalse
Is Derived Unionfalse
Is Leaffalse
Is Orderedfalse
Is Read Onlyfalse
Is Staticfalse
Is Uniquetrue
Lower1
Multiplicity1
NameReport Data
Namespace<<Boundary>> <Class> Report
Owner<<Boundary>> <Class> Report
Qualified NameT2S Data Model::Query and Reports::Report::Report Data
Type<Primitive Type> String
Upper1
VisibilityPublic


 Report Name
Public <Primitive Type> String Report Name

Name of the stored report - possible values are:
• Statement of Holdings
• Statement of Transactions
• Statement of Pending Instructions
• Statement of Settlement Allegements
• Statement of Accounts
• SD T2S DCA Statement
• SD Securities Accounts Statement
• SD Securities Statement
• SD Party Statement
• Current Business Day Cash Forecast
• Next Business Day Cash Forecast
• Executed AI on Cash
• Executed AI on Securities
• Executed CI on Cash
• Executed CI on Securities
• Pending AI on Cash
• Pending AIon Securities
• Pending CI on Cash
• Pending CI on Securities
• Pending Restrictions on Cash
• Pending Restrictions on Securities
• Settled Restrictions on Cash
• Settled Restrictions on Securities

Vincoli:
Proprietà:

AggregationNone
Class<<Boundary>> <Class> Report
Is Compositefalse
Is Derivedfalse
Is Derived Unionfalse
Is Leaffalse
Is Orderedfalse
Is Read Onlyfalse
Is Staticfalse
Is Uniquetrue
Lower1
Multiplicity1
NameReport Name
Namespace<<Boundary>> <Class> Report
Owner<<Boundary>> <Class> Report
Qualified NameT2S Data Model::Query and Reports::Report::Report Name
Type<Primitive Type> String
Upper1
VisibilityPublic


 Report Timestamp
Public <Primitive Type> Timestamp Report Timestamp

Timestamp reflecting date and time of the creation of the report

Vincoli:
Proprietà:

AggregationNone
Class<<Boundary>> <Class> Report
Is Compositefalse
Is Derivedfalse
Is Derived Unionfalse
Is Leaffalse
Is Orderedfalse
Is Read Onlyfalse
Is Staticfalse
Is Uniquetrue
Lower1
Multiplicity1
NameReport Timestamp
Namespace<<Boundary>> <Class> Report
Owner<<Boundary>> <Class> Report
Qualified NameT2S Data Model::Query and Reports::Report::Report Timestamp
Type<Primitive Type> Timestamp
Upper1
VisibilityPublic


 Scheduled Time
Public <Primitive Type> Timestamp Scheduled Time

It stores the configured point in time/business event which triggered the creation of the report.

Vincoli:
Proprietà:

AggregationNone
Class<<Boundary>> <Class> Report
Is Compositefalse
Is Derivedfalse
Is Derived Unionfalse
Is Leaffalse
Is Orderedfalse
Is Read Onlyfalse
Is Staticfalse
Is Uniquetrue
Lower1
Multiplicity1
NameScheduled Time
Namespace<<Boundary>> <Class> Report
Owner<<Boundary>> <Class> Report
Qualified NameT2S Data Model::Query and Reports::Report::Scheduled Time
Type<Primitive Type> Timestamp
Upper1
VisibilityPublic


 Statement Number
Public <Primitive Type> String Statement Number

It stores the statement number of the report (composed of the business date and Report Type (2-letter-abbreviation depending on report name and Delta/Full-Flag) plus sequential number), which is unique in T2S.

Vincoli:
Proprietà:

AggregationNone
Class<<Boundary>> <Class> Report
Is Compositefalse
Is Derivedfalse
Is Derived Unionfalse
Is Leaffalse
Is Orderedfalse
Is Read Onlyfalse
Is Staticfalse
Is Uniquetrue
Lower1
Multiplicity1
NameStatement Number
Namespace<<Boundary>> <Class> Report
Owner<<Boundary>> <Class> Report
Qualified NameT2S Data Model::Query and Reports::Report::Statement Number
Type<Primitive Type> String
Upper1
VisibilityPublic


 System Entity Wide Reporting Flag
Public <Primitive Type> Boolean System Entity Wide Reporting Flag

Boolean attribute specifying whether the report should include information for the entire system entity data scope.

Vincoli:
Proprietà:

AggregationNone
Class<<Boundary>> <Class> Report
Is Compositefalse
Is Derivedfalse
Is Derived Unionfalse
Is Leaffalse
Is Orderedfalse
Is Read Onlyfalse
Is Staticfalse
Is Uniquetrue
Lower1
Multiplicity1
NameSystem Entity Wide Reporting Flag
Namespace<<Boundary>> <Class> Report
Owner<<Boundary>> <Class> Report
Qualified NameT2S Data Model::Query and Reports::Report::System Entity Wide Reporting Flag
Type<Primitive Type> Boolean
Upper1
VisibilityPublic


 TO Date Time
Public <Primitive Type> Timestamp TO Date Time

store the information on the point in time, when the queried report period ends.

Vincoli:
Proprietà:

AggregationNone
Class<<Boundary>> <Class> Report
Is Compositefalse
Is Derivedfalse
Is Derived Unionfalse
Is Leaffalse
Is Orderedfalse
Is Read Onlyfalse
Is Staticfalse
Is Uniquetrue
Lower1
Multiplicity1
NameTO Date Time
Namespace<<Boundary>> <Class> Report
Owner<<Boundary>> <Class> Report
Qualified NameT2S Data Model::Query and Reports::Report::TO Date Time
Type<Primitive Type> Timestamp
Upper1
VisibilityPublic