P1253553531RsjEQ

1
The Importance of Architecture in Modeling SCOR
Database Conversion
Presented by Gary Shell CTO StreamlineSCM
1
2
Integration is the Key to Success

• Seamless integration of the SCOR model leads to
  successful supply chain deployment
• Successful and seamless integration requires
  fulfillment of two tenets of the SCC mission

• Common Language
• Common Architecture

2 (3)
3
Mission of SCOR Model

• Promote a common language and architecture for
  integration between functional units
• Common language a prerequisite for communication
  amongst functional units
• Common architecture a prerequisite to
  universally implement process controls

3 (3)
4
Advantages to a SCOR Database Architecture

• Creation of that Common Architecture
• Show relationship between all variables in the
  Model
• Reduced Redundancy
• NO Disconnects
• Allows the SCOR model to be used as a foundation
  for modeling and execution tools

4 (5)
5
Step 1 Move to Hard Drive Step 2 Double Click
SCOR Rev5 Public

• The SCOR Database Application is made up of two
  separate databases
• SCOR Rev 5 Data
• Contains model structure and SCOR data
• SCOR Rev 5 Public
• Controls code for queries, forms, and reports.

Files must be moved to a single folder on your
hard drive in order for the links to be applied.
5 (4)
6
Step 3 Update of database links.
Click OK, This will allow the database links to
be updated to their current location
6 (1)
7
Application Switchboard
Model Maintenance Forms for adding and editing
elements within the SCOR Model Reports Generate a
printed SCOR Model, Cross Reference Report and
Glossary Documentation Map detailing the database
structure
7 (3)
8
Process Brower
Double Click to open Level 1 Maintenance Form
Double Click to open Level 2 Maintenance Form
Double Click to open Level 3 Maintenance Form
8 (3)
9
Level One Maintenance
Double Click to open the Level 2 Maintenance Form
for selected item.
Click to add/edit Level 2 Process.
9 (2)
10
Level 2 Maintenance
Assigns Process Type Plan, Execute or Enable
Allows configuration of Level 3 Processes to
Level 2 Categories.
Add or Edit (Selected Level Three Process)
10 (3)
11
Level 3 Creation
Form for Add / Edit of Level Three Processes.
11 (1)
12
Level 2 Metrics
List of All available Metrics
Flag for User Defined Non SCOR Elements
Key Metric Flag
Adds Metrics to Specific Level Two Process
Double Click Metric Detail on an window pop ups.
Lists related Level 3 Process Elements
Forms for Add / Edit of Metric Elements.
12 (7)
13
Level Three Input / Output
List of All available I/Os
Flag for User Defined Not Officially recognized
SCOR Elements
Adds I/O to Specific Level Three Process
Configurations
Double Click I/O Detail window pops up. Lists
related Level 3 Process Elements
Form for Add / Edit of I/O Elements.
13 (6)
14
Level 3 Best Practices
List of All available Best Practices
Flag for User Defined Non SCOR Elements
Adds Best Practices to Specific Level Three
Process Configurations
Double Click BP Detail on an window pop ups.
Lists related Level 3 Process Elements
Form for Add / Edit of BP Elements.
14 (6)
15
Level 3 Metrics
List of All available Metrics
Flag for User Defined Non SCOR Elements
Key Metric Flag
Adds Metrics to Specific Level Three Process
Configurations
Double Click Metric Detail on an window pop ups.
Lists related Level 3 Process Elements
Forms for Add / Edit of Metric Elements.
15 (7)
16
Reports
16
17
Documentation
17
18
White Paper
Application Design SCOR Data Definition
Conversion Database Map
18
19
Data Definition
19
20
Thank You for your Time questions
comments gary_at_streamlinescm.com
20