Difference between revisions of "SSMT: Order Questions"
Jump to navigation
Jump to search
m (Created page with "==Description== This page will Stored Procedures used: *Extracting data: *Loading data: ==Column Listing and Descriptions== *'''Entry Code''' - == Migration Considerations...") |
|||
| Line 1: | Line 1: | ||
==Description== | ==Description== | ||
| − | This page will | + | This page will explain how to use the Order Questions SSMT content category to help manage the relationship between Additional Information (AOE) Questions and Orderable Items. The data extract basically presents a one-to-many representation between AOE question to orderable item. |
Stored Procedures used: | Stored Procedures used: | ||
| Line 7: | Line 7: | ||
==Column Listing and Descriptions== | ==Column Listing and Descriptions== | ||
| + | |||
| + | *'''Entry Code''' - | ||
| + | |||
| + | *'''Entry Code''' - | ||
| + | |||
| + | *'''Entry Code''' - | ||
| + | |||
| + | *'''Entry Code''' - | ||
| + | |||
| + | *'''Entry Code''' - | ||
| + | |||
| + | *'''Entry Code''' - | ||
| + | |||
| + | *'''Entry Code''' - | ||
| + | |||
| + | *'''Entry Code''' - | ||
*'''Entry Code''' - | *'''Entry Code''' - | ||
| Line 12: | Line 28: | ||
== Migration Considerations == | == Migration Considerations == | ||
| − | *'''Pre-requisite dictionary build''' - | + | *'''Pre-requisite dictionary build''' - the following dictionaries are referenced in this data extract and load and must be in place prior to utilizing this content category correctly. |
| + | **[[Additional Information]] | ||
| + | ***'''SSMT Category''' - [[SSMT: Additional Information]] | ||
| + | **[[Order Item Dictionary]] | ||
| + | ***'''SSMT Category''' - [[SSMT: OID - Orderable Item Dictionary]] | ||
| + | |||
| + | *'''Sequencing''' - since this content category includes mostly fields that are pulled from the Additional Information dictionary. To avoid chronic error and ensure more consistent data load it can be recommended to manually assign the AOE question to an orderable item, extract the content category, and then add additional order codes that you would like to subscribe to that AOE question. | ||
| + | |||
'''back to [[SSMT]] main page''' | '''back to [[SSMT]] main page''' | ||
Revision as of 19:36, 3 February 2011
Description
This page will explain how to use the Order Questions SSMT content category to help manage the relationship between Additional Information (AOE) Questions and Orderable Items. The data extract basically presents a one-to-many representation between AOE question to orderable item.
Stored Procedures used:
- Extracting data:
- Loading data:
Column Listing and Descriptions
- Entry Code -
- Entry Code -
- Entry Code -
- Entry Code -
- Entry Code -
- Entry Code -
- Entry Code -
- Entry Code -
- Entry Code -
Migration Considerations
- Pre-requisite dictionary build - the following dictionaries are referenced in this data extract and load and must be in place prior to utilizing this content category correctly.
- Additional Information
- SSMT Category - SSMT: Additional Information
- Order Item Dictionary
- SSMT Category - SSMT: OID - Orderable Item Dictionary
- Additional Information
- Sequencing - since this content category includes mostly fields that are pulled from the Additional Information dictionary. To avoid chronic error and ensure more consistent data load it can be recommended to manually assign the AOE question to an orderable item, extract the content category, and then add additional order codes that you would like to subscribe to that AOE question.
back to SSMT main page