Oracle ATG Web Commerce - Claimable Tables

Claimable Tables

Oracle ATG Web Commerce uses the following table to store claimable information:

dcspp_claimable

Column	Data Type	Constraint
`claimable_id`	VARCHAR(40)	NOT NULL
(primary key)	The repository id of the claimable repository item.
`version`	INTEGER	NOT NULL
	Used by the repository to detect “out of date” updates. This information is managed internally by the Oracle ATG Web Commerce repositories.
`type`	INTEGER	NOT NULL
	Indicates whether a particular instance of a repository item is a coupon or a gift certificate.
`status`	INTEGER	NULL
	Indicates if a particular item has been claimed or not.
`expiration_date`	DATE	NULL
	If there is an expiration date, then an item cannot be claimed after this date.
`last_modified`	DATETIME	NULL
	Indicates when the repository item was last changed.

dcspp_giftcert

Column	Data Type	Constraint
`giftcertificate_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the gift certificate. References `dcspp_claimable(claimable_id)`
`amount`	DOUBLE PRECISION	NOT NULL
	The amount of the gift certificate.
`amount_authorized`	DOUBLE PRECISION	NOT NULL
	The amount of the gift certificate authorized to be used at the time a purchase is made.
`amount_remaining`	DOUBLE PRECISION	NOT NULL
	The amount of the gift certificate remaining after it has been used. Before the gift certificate has been claimed, this amount is equal to the amount property.
`purchaser_id`	VARCHAR(40)	NULL
	The profile id of the person who purchased the gift certificate.
`purchase_date`	DATE	NULL
	The date on which the gift certificate is purchased
`last_used`	DATE	NULL
	The date on which the gift certificate was last used.

dcs_storecred_clm

This table includes information on store credit.

Column	Data Type	Constraint
`store_credit_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcspp_claimable(claimable_id)`
`amount`	DOUBLE PRECISION	NOT NULL
	Contains the original amount of the store credit
`amount_authorized`	DOUBLE PRECISION	NOT NULL
	Contains the amount of the store credit authorized.
`amount_remaining`	DOUBLE PRECISION	NOT NULL
	The amount of the store credit which has not been consumed yet.
`owner_id`	VARCHAR(40)	NULL
	The profile id of the owner of this store credit.
`issue_date`	DATETIME	NULL
	The date the store credit was issued.
`expiration_date`	DATETIME	NULL
	The date the store credit expires. Can be NULL.
`last_used`	DATETIME	NULL
	The date the store credit was last used.

dcspp_coupon

This table relates coupons to one or more promotions.

Column	Data Type	Constraint
`coupon_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the coupon. References `dcspp_claimable(claimable_id)`
`promotion_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the promotion.

dcspp_coupon_info

This table is used for coupon validation.

Column	Data Type	Constraint
`coupon_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the coupon. References `dcspp_claimable(claimable_id)`
`display_name`	VARCHAR(254)	NULL
	The name a user sees when viewing this coupon.
`use_promo_site`	INT	NULL
	Boolean indicating whether or not the coupon validation process should check for site or site group associations.
`parent_folder`	VARCHAR(40)	NULL
	Parent folder for the coupon. References `dcspp_cp_folder(folder_id)`.
`uses`	INT	NULL
	Number of times the coupon has been claimed.

dcspp_coupon_batch

Column	Data Type	Constraint
`id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the coupon batch.
`code_prefix`	VARCHAR(254)	NOT NULL

`number_of_coupons`	INT	NULL

`seed_value`	LONG	NULL

dcspp_batch_claimable

Column	Data Type	Constraint
`coupon_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the batch claimable.
`coupon_batch`	VARCHAR(254)	NULL

dcspp_cp_folder

This table holds information about coupon folders.

Column	Data Type	Constraint
`folder_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the folder.
`name`	VARCHAR(254)	NOT NULL
	The name a user sees when viewing this coupon.
`parent_folder`	VARCHAR(40)	NULL
	Parent folder for the coupon, if one is present. References `dcspp_cp_folder(folder_id)`.

Copyright © 1997, 2012 Oracle and/or its affiliates. All rights reserved.