| Query and Reports Documentazione UML |
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 |
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 content stored as flat file
|
<Primitive Type> Timestamp | Report Timestamp |
Timestamp reflecting date and time of the creation of the report
|
<<Entity>> <Class> Report Configuration Party Link | is generated for | |
<Primitive Type> Boolean | 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 |
store the information on the point in time, when the queried report period starts.
|
<Primitive Type> Timestamp | TO Date Time |
store the information on the point in time, when the queried report period ends.
|
<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)
|
<Primitive Type> Timestamp | Scheduled Time |
It stores the configured point in time/business event which triggered the creation of the report.
|
<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.
|
<<Entity>> <Class> Party | is based on | |
Proprietà:
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à:
-
Aggregation | None |
Class | <<Boundary>> <Class> Report |
Is Composite | false |
Is Derived | false |
Is Derived Union | false |
Is Leaf | false |
Is Ordered | false |
Is Read Only | false |
Is Static | false |
Is Unique | true |
Lower | 1 |
Multiplicity | 1 |
Name | Delta Mode |
Namespace | <<Boundary>> <Class> Report |
Owner | <<Boundary>> <Class> Report |
Qualified Name | T2S Data Model::Query and Reports::Report::Delta Mode |
Type | <Primitive Type> Boolean |
Upper | 1 |
Visibility | Public |
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à:
-
Aggregation | None |
Class | <<Boundary>> <Class> Report |
Is Composite | false |
Is Derived | false |
Is Derived Union | false |
Is Leaf | false |
Is Ordered | false |
Is Read Only | false |
Is Static | false |
Is Unique | true |
Lower | 1 |
Multiplicity | 1 |
Name | FROM Date Time |
Namespace | <<Boundary>> <Class> Report |
Owner | <<Boundary>> <Class> Report |
Qualified Name | T2S Data Model::Query and Reports::Report::FROM Date Time |
Type | <Primitive Type> Timestamp |
Upper | 1 |
Visibility | Public |
is based on
Private <<Entity>> <Class> Party is based on
-
Vincoli:
-
Proprietà:
-
is generated for
Private <<Entity>> <Class> Report Configuration Party Link is generated for
-
Vincoli:
-
Proprietà:
-
Report Data
Public <Primitive Type> String Report Data
-
Report content stored as flat file
-
Vincoli:
-
Proprietà:
-
Aggregation | None |
Class | <<Boundary>> <Class> Report |
Is Composite | false |
Is Derived | false |
Is Derived Union | false |
Is Leaf | false |
Is Ordered | false |
Is Read Only | false |
Is Static | false |
Is Unique | true |
Lower | 1 |
Multiplicity | 1 |
Name | Report Data |
Namespace | <<Boundary>> <Class> Report |
Owner | <<Boundary>> <Class> Report |
Qualified Name | T2S Data Model::Query and Reports::Report::Report Data |
Type | <Primitive Type> String |
Upper | 1 |
Visibility | Public |
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à:
-
Aggregation | None |
Class | <<Boundary>> <Class> Report |
Is Composite | false |
Is Derived | false |
Is Derived Union | false |
Is Leaf | false |
Is Ordered | false |
Is Read Only | false |
Is Static | false |
Is Unique | true |
Lower | 1 |
Multiplicity | 1 |
Name | Report Name |
Namespace | <<Boundary>> <Class> Report |
Owner | <<Boundary>> <Class> Report |
Qualified Name | T2S Data Model::Query and Reports::Report::Report Name |
Type | <Primitive Type> String |
Upper | 1 |
Visibility | Public |
Report Timestamp
Public <Primitive Type> Timestamp Report Timestamp
-
Timestamp reflecting date and time of the creation of the report
-
Vincoli:
-
Proprietà:
-
Aggregation | None |
Class | <<Boundary>> <Class> Report |
Is Composite | false |
Is Derived | false |
Is Derived Union | false |
Is Leaf | false |
Is Ordered | false |
Is Read Only | false |
Is Static | false |
Is Unique | true |
Lower | 1 |
Multiplicity | 1 |
Name | Report Timestamp |
Namespace | <<Boundary>> <Class> Report |
Owner | <<Boundary>> <Class> Report |
Qualified Name | T2S Data Model::Query and Reports::Report::Report Timestamp |
Type | <Primitive Type> Timestamp |
Upper | 1 |
Visibility | Public |
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à:
-
Aggregation | None |
Class | <<Boundary>> <Class> Report |
Is Composite | false |
Is Derived | false |
Is Derived Union | false |
Is Leaf | false |
Is Ordered | false |
Is Read Only | false |
Is Static | false |
Is Unique | true |
Lower | 1 |
Multiplicity | 1 |
Name | Scheduled Time |
Namespace | <<Boundary>> <Class> Report |
Owner | <<Boundary>> <Class> Report |
Qualified Name | T2S Data Model::Query and Reports::Report::Scheduled Time |
Type | <Primitive Type> Timestamp |
Upper | 1 |
Visibility | Public |
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à:
-
Aggregation | None |
Class | <<Boundary>> <Class> Report |
Is Composite | false |
Is Derived | false |
Is Derived Union | false |
Is Leaf | false |
Is Ordered | false |
Is Read Only | false |
Is Static | false |
Is Unique | true |
Lower | 1 |
Multiplicity | 1 |
Name | Statement Number |
Namespace | <<Boundary>> <Class> Report |
Owner | <<Boundary>> <Class> Report |
Qualified Name | T2S Data Model::Query and Reports::Report::Statement Number |
Type | <Primitive Type> String |
Upper | 1 |
Visibility | Public |
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à:
-
Aggregation | None |
Class | <<Boundary>> <Class> Report |
Is Composite | false |
Is Derived | false |
Is Derived Union | false |
Is Leaf | false |
Is Ordered | false |
Is Read Only | false |
Is Static | false |
Is Unique | true |
Lower | 1 |
Multiplicity | 1 |
Name | System Entity Wide Reporting Flag |
Namespace | <<Boundary>> <Class> Report |
Owner | <<Boundary>> <Class> Report |
Qualified Name | T2S Data Model::Query and Reports::Report::System Entity Wide Reporting Flag |
Type | <Primitive Type> Boolean |
Upper | 1 |
Visibility | Public |
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à:
-
Aggregation | None |
Class | <<Boundary>> <Class> Report |
Is Composite | false |
Is Derived | false |
Is Derived Union | false |
Is Leaf | false |
Is Ordered | false |
Is Read Only | false |
Is Static | false |
Is Unique | true |
Lower | 1 |
Multiplicity | 1 |
Name | TO Date Time |
Namespace | <<Boundary>> <Class> Report |
Owner | <<Boundary>> <Class> Report |
Qualified Name | T2S Data Model::Query and Reports::Report::TO Date Time |
Type | <Primitive Type> Timestamp |
Upper | 1 |
Visibility | Public |
| Query and Reports Documentazione UML |