ATG Commerce Service Center uses the following database tables to store audit logging information.
These tables are installed by the <ATG9dir>/CSC9.3/DCS-CSR/sql/
db_components/database-vendor
/DCS-CSR_logging_ddl.sql
script.
The tables described in this section are all used by the agent audit repository. The Nucleus component for this repository is /atg/agent/logging/AuditRepository
.
csr_grant_appease
This table stores log records about the granting of appeasements (store credits).
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the log record. | |
appeasement_id | varchar(40) | null |
The ID of the store credit. | ||
amount | double precision | null |
The amount of the store credit. |
csr_price_override
This table stores log records of manual price overrides.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the log record. | |
order_id | varchar(40) | null |
The ID of the order containing the price override. | ||
component_id | varchar(40) | null |
The ID of the order component (item or shipping group) whose price was overridden. | ||
component_type | varchar(40) | null |
The type of the order component whose price was overridden. Possible values: commerceItem, shippingGroup. | ||
old_price | double precision | null |
The previous price of the item or shipping group. | ||
new_price | double precision | null |
The new price of the item or shipping group. |
csr_order_event
This table stores log records about orders that have been modified.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the log record. | |
order_id | varchar(40) | null |
The ID of the modified order. | ||
amount | double precision | null |
The total cost of the order. |
csr_return_order
This table stores log records of returned orders.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the log record. | |
ret_req_id | varchar(40) | null |
The ID of the return request. | ||
repl_order_id | varchar(40) | null |
The ID of the replacement order (for an exchange). |
csr_recv_rtrn_item
This table stores log records of receipt of returned items.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the log record. | |
item_id | varchar(40) | null |
The commerce item ID of the returned item. | ||
quantity | integer | null |
The quantity of the item that was returned. |
csr_claim_item
This table stores log records of the claiming of coupons, gift certificates, and store credits.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the log record. | |
claimable_id | varchar(40) | null |
The ID of the coupon, gift certificate, or store credit. | ||
claimable_type | varchar(40) | null |
Type of item claimed (coupon, gift certificate, or store credit). |
csr_ci_event
This table stores log records about changes to the quantities of items in orders.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the log record. | |
item_id | varchar(40) | null |
The ID of the commerce item whose quantity was changed. | ||
old_quantity | integer | null |
The previous quantity of the item. | ||
new_quantity | integer | null |
The new quantity of the item. |
csr_pg_event
This table stores log records about changes to payment groups in orders.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the log record. | |
pay_group_id | varchar(40) | null |
The ID of the payment group that was changed. | ||
update_type | tinyint | not null |
The type of update performed. 0=modify; 1=remove; 2=add. |
csr_split_sg
This table stores log records about splitting up items in orders among multiple shipping groups.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the log record. | |
src_ship_group_id | varchar(40) | null |
The shipping group the item was moved from. | ||
dest_ship_group_id | varchar(40) | null |
The shipping group the item was moved to. | ||
commerce_item_id | varchar(40) | null |
The ID of the commerce item that was moved. | ||
quantity | integer | not null |
The quantity of the item that was moved. |
csr_split_cc
This table stores log records about splitting up item costs among multiple cost centers.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of this log record. | |
src_cost_ctr_id | varchar(40) | null |
The cost center that the item’s costs were moved from. | ||
dest_cost_ctr_id | varchar(40) | null |
The cost center that the item’s costs were moved into. | ||
commerce_ident_id | varchar(40) | null |
The ID of the commerce item whose costs were moved. | ||
quantity | integer | not null |
The quantity of the item whose costs were moved. |
csr_sg_event
This table stores log records about changes to shipping groups in orders.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the log record. | |
ship_group_id | varchar(40) | null |
The ID of the shipping group that was changed. | ||
update_type | integer | not null |
The type of update performed. 0=modify; 1=remove; 2=add. |
csr_upd_props
This table stores log records about changes to properties of repository items.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the log record. | |
audit_id | varchar(40) | null |
The ID of the log record this change is associated with. (For example, if the change is to a shipping group, this value is the ID of the log record in the csr_sg_event table.) | ||
property_name | varchar(40) | null |
The name of the property that was modified. | ||
old_value | varchar(255) | null |
The previous value of the property. | ||
new_value | varchar(255) | null |
The new value of the property. | ||
version | integer | not null |
The GSA version of the modified property. |
csr_order_comment
This table stores log records about order comments submitted by agents.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the log record. | |
comment_id | varchar(40) | null |
The ID of the comment. |
csr_view_card
This table stores log records of agents viewing customers’ credit card information.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the log record. | |
cc_number | varchar(20) | null |
The credit card number of the card that was viewed. |
csr_oma_event
This table stores log records about order adjustments submitted by agents.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the log record. | |
man_adj_id | varchar(40) | null |
The unique ID of the manual adjustment. | ||
adjustment_type | Integer | not null |
The type of adjustment. | ||
update_type | integer | null |
The type of update performed. | ||
reason | one-digit | null |
The reason for the adjustment |
csr_schd_event
This table stores log records of scheduled events.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the log record. | |
sch_order_id | varchar(40) | null |
The unique ID of the scheduled order. | ||
update_type | one-digit | not null |
The type of update. |