Merkle Insourcing

Question 1

What does the GAA.ONS_VEH table represent?

Answer 1

Any given vehicle that is equipped with an OnStar unit… this entity tracks all the attributes of the vehicle – as manufactured plus additional OnStar attributes… hence ONS_VEHICLE

Question 2

What is the primary key for GAA.ONS_VEH table and what does it represent?

Answer 2

ID (logical name, VEH_ID).

It uniquely identifies a vehicle equipped with an OnStar unit.

Question 3

What does the ONS_BNDL_OFFER table represent?

Answer 3

A Bundled Offer is a collection of Products and corresponding Offers, that must be purchased together in order to get those Products with the discounts associated with those Offers. All products and Offers are sold through a Bundled Offer – incuding bundles of consisting of one offer.

Question 4

What is the primary key for GAA.ONS_BNDL_OFFER and what does it represent?

Answer 4

ID, logical name BNDL_OFFER_ID

Idnetifier of a Bundled Offer. A Bundled Offer is a collection of Products and corresponding Offers, that must be purchased together in order to get those Products with the discounts associated with those Offers.

Note that in the DDL, this column is simply called ‘ID’.

Question 5

What does the ONS_ORDER table represent?

Answer 5

Specifies information about the list of offers made to a vehicle. Includes information about what offer was made, when the offer was made, was it accepted, which advisor made the offer (if applicable) and which subscriber was it made to.

Question 6

What is the primary key for ONS_ORDER and what does it represent?

Answer 6

ORDER_NBR.

Order number for a given product.

Question 7

What does the ONS_PROD table represent?

Answer 7

OnStar Products. This identifies the goods and services that are sold to Onstar subscribers.

Question 8

What is the primary key for the ONS_PROD table and what does it represent?

Answer 8

PRODUCT_ID logical name, ID physical name. Uniquely identifies a product.

Question 9

What does the ONS_ORDER_LINE table represent?

Answer 9

This is a vehicle order line item with the details about a product purchase identifying the product/quantity and duration and cancelation information if this line item is cancelled or voided.

Question 10

What is the primary key for the ONS_ORDER_LINE table?

Answer 10

ORDER_NBR, ORDER_LINE_NBR.

ORDER_NBR: Order number for a given product.

ORDER_LINE_NBR: A unique line number assigned to a order for a product, within a vehicle order.