office overview
DESCRIPTION
Presentation for office overviewTRANSCRIPT
![Page 1: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/1.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The Module Title is used for
courses such as Payments
Basic Training that have a
modular structure.
Month and year
Payments Basic Training
Module 4: Office
![Page 2: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/2.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Provide introduction to using Office
• Post-transaction processing
Module Introduction
![Page 3: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/3.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Office architecture
• Getting started
• Extracting data
• Reconciliation
• Reports
• Maintenance tasks
Agenda
![Page 4: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/4.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Office architecture
• Office Framework
• Components
• Plug-ins
Section 1: Office architecture
![Page 5: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/5.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Synchronizes data:
o Realtime and Office databases
o Normalization
• Other functions:
o Synchronizes processes
o Provides process monitoring tools
o Manages cleaning tasks
o Provide centralized storage of business contacts, bank accounts, etc.
Office architecture | Getting started | Extracting data | Reconciliation…
Office Framework
First tier — Office Framework
![Page 6: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/6.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Uses data stored in Office database
• Functions:
o Extract — Creating data files for 3rd party processing
o Recon — Comparing Office records with 3rd parties
o Reporting — Scheduling and generating reports
o Settlement — Calculating amount splits and generating ACH files
Office architecture | Getting started | Extracting data | Reconciliation…
Components
Second tier — Components
![Page 7: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/7.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Tailor components to specific requirements
• Generic plug-ins available. Examples:
o Warehouse Extract
o Generic Recon
o Crystal Reports
• Multiple plug-ins per component
• Multiple entities per plug-in:
o Set of configuration parameters
o Usually relate to external entities
Office architecture | Getting started | Extracting data | Reconciliation…
Plug-ins
Third tier — Plug-ins
![Page 8: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/8.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Office services
• Office application security
• Office Management Console
• Scheduling jobs
• Running normalization
• Monitoring processes
• Querying transactions
Office architecture | Getting started | Extracting data | Reconciliation…
Section 2: Getting started
![Page 9: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/9.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Extract transactions for reconciliation
• Perform reconciliation with upstream network
• Generate report using report template
• Installed software:
o Office Framework
o Extract component and Warehouse Extract plug-in
o Recon component and Generic Recon plug-in
o Reports component and Crystal Reports plug-in
Office architecture | Getting started | Extracting data | Reconciliation…
Training scenario
Practical tasks
![Page 10: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/10.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Server installation
• Client installation
• Training computer setup:
o Server installation
o Access to complete Office system provided
Office architecture | Getting started | Extracting data | Reconciliation…
Training scenario
Office installations
![Page 11: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/11.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Required services:
o Microsoft SQL Server
o SQL Server Agent
o Office Sentinel
Office architecture | Getting started | Extracting data | Reconciliation…
Office services
Required services
![Page 12: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/12.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Office server — Direct login:
o Standard or Trusted connection
o Operators use client installations
o Trusted access from workstations on same domain
o Standard option applicable
Office architecture | Getting started | Extracting data | Reconciliation…
Office application security
Direct login
![Page 13: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/13.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Four default SQL server user accounts:
o dbo — Administrator
o post_cfg — Configure and modify
o post_mon — Monitoring
o post_audit — Read-only access (audit information)
• Each with different permissions
• No passwords assigned (no trusted users)
Office architecture | Getting started | Extracting data | Reconciliation…
Office application security
SQL server user accounts
![Page 14: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/14.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Trusted users:
o Secure username and password
o Permission assigned:
Use SQL Concept — Roles
Permission defined per role
Role assigned to user
• Three roles:
o postcfg
o postmon
o postaudit
Office architecture | Getting started | Extracting data | Reconciliation…
Trusted users & roles
Trusted users & roles
![Page 15: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/15.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• PCI DSS — Payment Card Industry (PCI) Data Security Standards (DSS)
• Requirements governing the safekeeping of account information:
o PANs to be masked when displayed
o Sensitive authentication data not to be stored subsequent to authorization
o Sensitive cardholder data to be rendered unreadable anywhere it is stored
• PCI DSS applies to all members, merchants, service providers, network components
Office architecture | Getting started | Extracting data | Reconciliation…
PCI Data Security Standards
PCI Data Security Standards: 1
![Page 16: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/16.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Office version 4.0 onwards implements PCI DSS requirements
• Sensitive cardholder data stored in Office database is encrypted
• Sensitive cardholder data is masked in:
o Query consoles
o Reports
o Informational messages
Office architecture | Getting started | Extracting data | Reconciliation…
PCI Data Security Standards
PCI Data Security Standards: 2
![Page 17: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/17.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Audit Trail:
o Records user configuration changes
o Used to troubleshoot Office configuration changes
• Audit Trail Query Console:
o Accessed by users with postaudit permissions
o Displays history of changes
o Queries allowed
Office architecture | Getting started | Extracting data | Reconciliation…
Office application security
Audit Trail
![Page 18: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/18.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Similar to Realtime
• Provides access to all Office consoles, reports, documentation
• Groups:
o Configuration
o Monitoring
o Queries
o Reports
o Documentation
o Tools
Office architecture | Getting started | Extracting data | Reconciliation…
Office Management Console
Office Management Console
![Page 19: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/19.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Jobs used to schedule and “kick off” processes
• Jobs created for entities — usually one per entity
• Job schedules differ, e.g.:
o Reports — once a day
o Normalization — every minute
• Jobs scheduled through SQL Server Enterprise Manager
Office architecture | Getting started | Extracting data | Reconciliation…
Scheduling jobs
Introduction
![Page 20: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/20.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Jobs installed by Office Framework:
o Normalization
o Cleaner:
Office - Cleaner - Transaction Tables
Office - Cleaner - Process Log Tables
Office - Cleaner - Data Summary Base Tables
Office - Cleaner - Batch Tables
Office - Cleaner - Audit Trail Table
• Refer to your manual for steps to alter a job schedule (page 4-18)
Office architecture | Getting started | Extracting data | Reconciliation…
Scheduling jobs
Office Framework jobs
![Page 21: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/21.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Transfers data from Realtime database to Office database
• Job created when Framework installed
• Runs every minute by default
• For higher transaction volumes:
o Use more frequent normalization schedule
• Training computers setup:
o Normalization scheduled to run every 10 minutes
Office architecture | Getting started | Extracting data | Reconciliation…
Running normalization
Normalization
![Page 22: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/22.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Data can be normalized from multiple Realtime databases or different transaction processors
• This flexibility is achieved through the use of :
o Normalization plug-ins
o Virtual servers
o Node name mappings
Office architecture | Getting started | Extracting data | Reconciliation…
Running normalization
Normalization from multiple sources
![Page 23: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/23.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Two consoles to monitor processes:
o Sentinel Monitor
Status of processes currently running
Processes in Sentinel queue
o Office Process Log
Displays result of processes run
Allows troubleshooting of unsuccessful processes
Office architecture | Getting started | Extracting data | Reconciliation…
Monitoring processes
Monitoring consoles
![Page 24: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/24.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Displays result of processes run
• Allows troubleshooting of unsuccessful processes
• To access Office Process Log:
o Go to Management Console
o Expand Monitoring
o Double-click Office Process Log
Office architecture | Getting started | Extracting data | Reconciliation…
Monitoring processes
Office Process Log
![Page 25: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/25.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Two query consoles
o Transaction Query Console
Successfully normalized transactions
o Exception Transaction Query Console
Normalization unsuccessful
Office architecture | Getting started | Extracting data | Reconciliation…
Querying transactions
Query consoles
![Page 26: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/26.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• View detailed information of transactions
• Useful for customer query responses:
o Declined transactions
o Cancelled transactions
• Similar to Realtime console
• Preferred for querying transactions
o Avoids impact in online processing
• To open:
o In Office Management Console, expand Queries
o Double-click Transactions
Office architecture | Getting started | Extracting data | Reconciliation…
Querying transactions
Transaction Query Console
![Page 27: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/27.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Specific transaction queries
• Allow multiple search criteria specification:
o Card number (PAN)
o Local Transaction Date
• Filter results by:
o Online System
o Source Node
o Card Acceptor
o Terminal ID
o Sequence number
Office architecture | Getting started | Extracting data | Reconciliation…
Querying transactions
Cardholder Query
![Page 28: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/28.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• General queries
• Query criteria specification
• Maximum number transactions returned — 1000
• Specific transaction searches:
o Office/Realtime Transaction number needed
• Filter results by:
o Online System
o Source/Sink node
o Card Acceptor
o Terminal ID
Office architecture | Getting started | Extracting data | Reconciliation…
Querying transactions
Operational Query
![Page 29: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/29.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Details
o Transaction queries
• Message Flow
o Graphical display of entire transaction chain messages
• Amounts
o All amounts, including fees, related to transaction
• Authorization
o Authorization and response codes
• Date and Time
o Date and time fields associated with transaction leg
Office architecture | Getting started | Extracting data | Reconciliation…
Querying transactions
All Transaction Information console tabs
![Page 30: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/30.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Terminal
o Information relating to terminal where transaction originated
• Additional information
o Check data and address verification
• ICC Data
o Applicable for Chip card (EMV) transactions
• Structured Data
o S1-specific addition to ISO 8583 specification
• Retention Data
o Data stored in Realtime database for later analysis
Office architecture | Getting started | Extracting data | Reconciliation…
Querying transactions
All Transaction Information console tabs
![Page 31: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/31.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Available Batch information:
o Business Date
o Begin Date/Time
o End Date/Time
• Does NOT display batch totals
• To view information:
o Specify query criteria — Node/Card Acceptor/Terminal ID
o Click Run Query button
• Matching batches displayed in Query Results section
Office architecture | Getting started | Extracting data | Reconciliation…
Querying transactions
Batch Query
![Page 32: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/32.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Transaction normalization failure
o Transaction normalized, corresponding batch already cleaned
o Duplicate of already normalized transaction
o Logically incorrect value of field in message
• To open console:
o In Management Console, expand Queries
o Double-click Exception Transactions
Office architecture | Getting started | Extracting data | Reconciliation…
Querying transactions
Exception Transaction Query Console
![Page 33: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/33.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Introduction
• Extract plug-ins
• Extract jobs
Office architecture | Getting started | Extracting data | Reconciliation…
Section 3: Extracting data
![Page 34: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/34.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Extract component
• Data extracted to file or output device
• Typically used for transaction activity data
o Transaction data also used for range of other purposes
• Results sent to third parties
• Recipient typically uses data for reconciliation
Office architecture | Getting started | Extracting data | Reconciliation…
Extracting data — Introduction
![Page 35: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/35.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Extract plug-in required
• Plug-in determines data and format of data to extract from database
Office architecture | Getting started | Extracting data | Reconciliation…
Extract plug-ins
Extract plug-ins
![Page 36: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/36.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Extract entity
o Created to specify transaction set and file format
o Groups set of parameter values required by plug-in
o Configured in console installed by Extract component
Office architecture | Getting started | Extracting data | Reconciliation…
Extract plug-ins
Extract entities
![Page 37: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/37.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Multiple extract entities per plug-in
o Different sets of transactions specified
o Different recipients
• Multiple plug-in installs
o Substantially different file formats
Office architecture | Getting started | Extracting data | Reconciliation…
Extract plug-ins
Extract plug-ins
![Page 38: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/38.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Check that Extract job started successfully:
o SQL Server Enterprise Manager
o Office Process Log
Office architecture | Getting started | Extracting data | Reconciliation…
Extract jobs
Monitoring an Extract job
![Page 39: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/39.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
In SQL Server Enterprise Manager check that the Extract job ran successfully
In the Office Process Log check the Extract process completed successfully:
No process run shown — may indicate SQL Server Agent could not add job to process queue
Troubleshoot using the SQL Server Agent – View Job History
Office architecture | Getting started | Extracting data | Reconciliation…
Extract jobs
Exercise 9
![Page 40: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/40.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Checks what transaction data was extracted
• To access Extract Query console: o In the Management Console expand Queries
o Expand Extract Component
o Double-click Extract
Office architecture | Getting started | Extracting data | Reconciliation…
Extract jobs
Extract Query console
![Page 41: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/41.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Criteria for open transactions differ per plug-in
• Plug-ins typically will not extract: o Incomplete transactions
o Transactions in open batches
• Usually will be closed in next Extract session
• Rerun query to ensure transaction was closed
• Transaction reflected in Closed in Session field
Office architecture | Getting started | Extracting data | Reconciliation…
Extract jobs
Open transactions
![Page 42: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/42.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Introduction
• Recon scope
• Recon plug-ins
• Recon jobs
Office architecture | Getting started | Extracting data | Reconciliation…
Section 4: Reconciliation
![Page 43: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/43.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Recon component
• Reconcile Realtime’s view of transaction processing with external entities
• Reconciliation performed with:
o Networks
o Processors
o Core banking systems
o Terminals
o Other EFT entities
• External entity provides file
Office architecture | Getting started | Extracting data | Reconciliation…
Introduction
Reconciliation
![Page 44: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/44.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Two phases in reconciliation process:
o Phase 1
Recon component parses external file
Stores transaction data in common format in tables in database
o Phase 2
Stored data compared with Office’s transaction record
• Recon result
o Transactions assigned to 1 of 4 categories
Office architecture | Getting started | Extracting data | Reconciliation…
Introduction
Reconciliation
![Page 45: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/45.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Matched and Equal
o Corresponding transaction records exist
o All significant fields equal
• Matched not Equal
o Corresponding Transaction records exist
o Values of significant fields differ
• Postilion Only
o Transaction present in Office database only
• External Only
o Transaction present in the external activity file only
Office architecture | Getting started | Extracting data | Reconciliation…
Introduction
Reconciliation categories
![Page 46: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/46.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Office must determine what transaction in its database to compare with external entity
• Recon with networks/switches
o Component determines scope using business date
o Business date set using settlement date of external entity
Office architecture | Getting started | Extracting data | Reconciliation…
Recon scope
Recon scope
![Page 47: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/47.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Recon plug-in required
• Enables component to deal with specific external file format:
o Payments Platform owner has no control on format supplied
• Determines significant fields:
o Matching criteria
o Recon criteria
Office architecture | Getting started | Extracting data | Reconciliation…
Recon plug-ins
Recon plug-ins
![Page 48: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/48.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• SQL Server Agent job per recon entity
• Scheduled to run regularly/daily
• NetworkRecon entity configured for this course
Office architecture | Getting started | Extracting data | Reconciliation…
Recon jobs
Recon jobs
![Page 49: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/49.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Similar process as that for Extract
Office architecture | Getting started | Extracting data | Reconciliation…
Recon jobs
Monitoring a Recon job
![Page 50: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/50.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
Office architecture | Getting started | Extracting data | Reconciliation…
Recon jobs
Querying a Recon process
• 3 views o Transaction Query
o Operational Query
o File Query
• Transaction Query o View all transactions for a Recon Session
o Filter by PAN, Card Acceptor, Terminal
• Operational Query o Find Recon result for transaction based on Transaction Number
o Transaction Number can be from Realtime, Office, External or Adjustment
• File Query o Query Recon file details relating to Recon Session
![Page 51: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/51.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Introduction
• Reports plug-in
• Reports jobs
• Scheduling and running a Reports job
… Reconciliation | Reports | Maintenance tasks
Section 5: Reports
![Page 52: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/52.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Reports component
• Provides scheduled production of reports
• Reports can be provided by:
o Office Framework
o Components
o Individual plug-ins
o Realtime
o Realtime applications
… Reconciliation | Reports | Maintenance tasks
Introduction
Reports
![Page 53: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/53.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Only one Reports plug-in
o Crystal Reports plug-in
• Enables use of Crystal Reports Template files (.rpt)
• Variety of file formats — pdf, html, xls, csv, rtf, etc…
• Reports entity configured for each report scheduled
• Configuration console installed by plug-in
… Reconciliation | Reports | Maintenance tasks
Reports plug-in
Reports Plug-in
![Page 54: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/54.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• SQL Server Agent job configured per Reports entity
o Multiple entities can be run by one job
• Scheduled to run regularly/daily
• NetworkMatchedEqual entity configured for purpose of this course
… Reconciliation | Reports | Maintenance tasks
Reports jobs
Reports jobs
![Page 55: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/55.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Scheduled in order to run on recurring basis
• Typically run daily
• New schedule can be added
• Recurring scheduled can be altered
… Reconciliation | Reports | Maintenance tasks
Reports jobs
Scheduling and running a Reports job
![Page 56: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/56.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Daily tasks
• Weekly tasks
• Monthly tasks
… Reconciliation | Reports | Maintenance tasks
Section 6: Maintenance tasks
![Page 57: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/57.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Daily tasks
o Backup database
o SQL Server statistics update
o Check the Windows Event Viewer
o Check that Office jobs are running successfully in SQL Server
o Check that normalization has been taking place successfully during the course of the day
o Check that each run of the key processes, such as Recon, has completed successfully
… Reconciliation | Reports | Maintenance tasks
Maintenance tasks
Daily tasks
![Page 58: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/58.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The top row is used to orient
participants by showing them
where they are in relation to
the sections in the participant
guide.
Underline the current section.
For non-terminal sections,
show at least one preceding
and one following section.
Use ellipses to indicated that
there are more preceding or
following sections that cannot
be shown.
Separate sections using the
pipe symbol (on the
backslash key).
Remember to update the
copyright date
The second row of the
heading is used to display
the heading 1 section in the
participant guide to which the
slide belongs.
The Slide Title should usually
relate to a heading in the
participant guide (typically
Heading 2 or Heading 3) but
this is not always possible.
If a slide is animated,
move the “play button”
onto the slide and
position it at: Horizontal
0 cm from top left corner
and Vertical 17.84 cm
from top left corner.
• Weekly tasks
o Full backup of database
o Check available hard drive space
o Check available virtual memory
o Monitor SQL Server resources
• Monthly tasks
o Defragment SQL Server indexes
o Check database integrity
o Test restore of database
… Reconciliation | Reports | Maintenance tasks
Maintenance tasks
Weekly & Monthly tasks
![Page 59: Office Overview](https://reader031.vdocuments.us/reader031/viewer/2022020308/568bdbae1a28ab2034af6a59/html5/thumbnails/59.jpg)
Copyright © 2009. S1 Global Ltd. All rights reserved.
The Module Title is used for
courses such as Payments
Basic Training that have a
modular structure.
Month and year
Thank you