Parameters affect the state of the data mart after you perform an extraction. These parameters control the execution of the system and also control the analytic conclusions. Parameters are modified using the WebSphere Commerce Analyzer Parameter Manager.
The following is a representation of the WCA.PARAMETERS table as it might look after configuration (without the last_update and last_update_ID fields).
The REPORT_LANGUAGE and REPORT_CURRENCY parameter type values originate from the configuration tool. The TIME_CUT_OFF, TIME_CUT_OFF_PREV, TIME_CUT_OFF_LOCAL, EXTRACTION_COUNT, and EXTRACTION_SUCCEED parameter type values originate from the extraction process.
The values shown in this representation of the WCA.PARAMETERS table are default values. Use these parameters in SQL clauses only, for example, select param_value from wca.parameters where param_type='xxx'.
ROW_NUM | PARAM_TYPE | PARAM_VALUE |
1 | REPORT_LANGUAGE | |
1 | REPORT_CURRENCY | |
1 | ANALYSIS_CATALOG_ID | -9999 |
1 | PRODUCT_ID_DEFAULT | -9999 |
1 | DMT_PURCHASER_ORD_STATUS | 6 |
2 | DMT_PURCHASER_ORD_STATUS | 7 |
3 | DMT_PURCHASER_ORD_STATUS | 14 |
4 | DMT_PURCHASER_ORD_STATUS | 15 |
5 | DMT_PURCHASER_ORD_STATUS | 17 |
6 | DMT_PURCHASER_ORD_STATUS | 18 |
1 | DMT_PROSPECT_ORD_STATUS | 1 |
2 | DMT_PROSPECT_ORD_STATUS | 8 |
3 | DMT_PROSPECT_ORD_STATUS | 16 |
4 | DMT_PROSPECT_ORD_STATUS | 19 |
5 | DMT_PROSPECT_ORD_STATUS | 20 |
1 | FE_EFFECTIVE_ORD_STATUS | 7 |
2 | FE_EFFECTIVE_ORD_STATUS | 14 |
3 | FE_EFFECTIVE_ORD_STATUS | 15 |
4 | FE_EFFECTIVE_ORD_STATUS | 17 |
5 | FE_EFFECTIVE_ORD_STATUS | 18 |
1 | FE_EFFECTIVE_MINUTES | 60 |
1 | ABANDONED_MINUTES | 60 |
1 | ABANDONED_ORD_STATUS | 1 |
1 | TIME_CUT_OFF | 1000-01-01-00.00.00 |
1 | TIME_CUT_OFF_PREV | 1000-01-01-00.00.00 |
1 | TIME_CUT_OFF_LOCAL | 1000-01-01-00.00.00 |
1 | EXTRACTION_COUNT | 0 |
1 | EXTRACTION_TRACE | 0 |
1 | WSA_TIME_CUT_OFF | 1000-01-01-00.00.00 |
1 | WSA_TIME_CUT_OFF_PREV | 1000-01-01-00.00.00 |
1 | WSA_REPL_START | 1000-01-01-00.00.00 |
1 | WSA_EXTRACTION_COUNT | 0 |
1 | WSA_EXTRACTION_TRACE | 0 |
1 | FM_EFFECTIVE_MINUTES | 60 |
1 | FM_EFFECTIVE_ORD_STATUS | 7 |
2 | FM_EFFECTIVE_ORD_STATUS | 14 |
3 | FM_EFFECTIVE_ORD_STATUS | 15 |
4 | FM_EFFECTIVE_ORD_STATUS | 17 |
5 | FM_EFFECTIVE_ORD_STATUS | 18 |
1 | NON_PURGE_ORD_STATUS | 1 |
2 | NON_PURGE_ORD_STATUS | 8 |
3 | NON_PURGE_ORD_STATUS | 19 |
4 | NON_PURGE_ORD_STATUS | 20 |
1 | MINING_BASE_NAME | |
1 | WCS_SOURCE | 57be |
1 | MINING_TRAINING_INTERVAL | -1 |
1 | MINING_APPLY_INTERVAL | -1 |
1 | MINING_USER_NAME | martuser |
1 | MINING_PASSWORD | xxxxxxxx |
1 | MINING_TRAINING_TIME | 1000-01-01-00.00.00 |
1 | MINING_APPLY_TIME | 1000-01-01-00.00.00 |
1 | MINING_TRACE | 0 |
1 | MINING_CLOSED_LOOP | N |
1 | RFM_INTERVAL | 1 |
1 | RFM_LAST_RUN | 1000-01-01-00.00.00 |
1 | RFM_BINS | 5 |
1 | PRODUCT_PRICE_AGGREGATE | MIN |
1 | ORG_BUSINESS_TYPE | OrgEntityBusinessType |
2 | ORG_INDUSTRY_TYPE | OrgEntityIndustryType |
1 | ORDERS_AWAITING_PAYMENT | 4 |
1 | CONTRACT_ACTIVE | 3 |
1 | CONTRACT_IN_PREPARATION | 0 |
1 | RFQ_RESPONSE_IN_PREPARATION | 1 |
1 | RFQ_WINNING_RESPONSES | 8 |
2 | RFQ_WINNING_RESPONSES | 10 |
1 | RFQRSP_OUTSTANDING_ORDERS | 11 |
2 | RFQRSP_OUTSTANDING_ORDERS | 12 |
3 | RFQRSP_OUTSTANDING_ORDERS | 3 |
4 | RFQRSP_OUTSTANDING_ORDERS | 1 |
5 | RFQRSP_OUTSTANDING_ORDERS | 4 |
6 | RFQRSP_OUTSTANDING_ORDERS | 9 |
1 | ORDER_STATUS_CANCELLED | 2 |
1 | CONTRACT_CANCELLED | 5 |
1 | ORDER_STATUS_COLLECTED | 15 |
1 | ORDER_STATUS_BILLED | 7 |
2 | ORDER_STATUS_BILLED | 14 |
3 | ORDER_STATUS_BILLED | 15 |
4 | ORDER_STATUS_BILLED | 17 |
5 | ORDER_STATUS_BILLED | 18 |
1 | MEMBER_ADDRESS_TYPE_ID | 3 |
1 | ORDER_STATUS_ID_NOREV | 8 |
2 | ORDER_STATUS_ID_NOREV | 16 |
3 | ORDER_STATUS_ID_NOREV | 19 |
4 | ORDER_STATUS_ID_NOREV | 20 |
1 | ORDER_STATUS_ID_SUM_TRADING | 7 |
2 | ORDER_STATUS_ID_SUM_TRADING | 14 |
3 | ORDER_STATUS_ID_SUM_TRADING | 15 |
4 | ORDER_STATUS_ID_SUM_TRADING | 17 |
5 | ORDER_STATUS_ID_SUM_TRADING | 18 |
1 | ORDER_STATUS_ID_SUM_MEMBER | 7 |
2 | ORDER_STATUS_ID_SUM_MEMBER | 14 |
3 | ORDER_STATUS_ID_SUM_MEMBER | 15 |
4 | ORDER_STATUS_ID_SUM_MEMBER | 17 |
5 | ORDER_STATUS_ID_SUM_MEMBER | 18 |
1 | REQUEST_ETL_PROCESS | 0 |
1 | REPLICATION_START | 2004-11-02-16.02.37.919001 |
1 | REPLICATION_METHOD | N |
1 | REPLICATION_COUNT | 0 |
1 | CPN_REDEEMED_ORDER_STATUS | 7 |
2 | CPN_REDEEMED_ORDER_STATUS | 14 |
3 | CPN_REDEEMED_ORDER_STATUS | 15 |
4 | CPN_REDEEMED_ORDER_STATUS | 17 |
5 | CPN_REDEEMED_ORDER_STATUS | 18 |
1 | ORDER_STATUS_XFERRED | 14 |
2 | ORDER_STATUS_XFERRED | 17 |
3 | ORDER_STATUS_XFERRED | 18 |
1 | NF_EFFECTIVE_MINUTES | 60 |
1 | SRF_EFFECTIVE_MINUTES | 60 |
1 | NF_EFFECTIVE_ORD_STATUS_ID | 7 |
2 | NF_EFFECTIVE_ORD_STATUS_ID | 14 |
3 | NF_EFFECTIVE_ORD_STATUS_ID | 15 |
4 | NF_EFFECTIVE_ORD_STATUS_ID | 17 |
5 | NF_EFFECTIVE_ORD_STATUS_ID | 18 |
1 | EXTRACTION_TEMP | temp |
1 | TIME_WINDOW_MODE | 1 |
1 | WCA_STATUS | 0 |
1 | LAST_STEP_RUN | |
1 | ORDER_STATUS_SUBMITTED | 14 |
2 | ORDER_STATUS_SUBMITTED | 15 |
3 | ORDER_STATUS_SUBMITTED | 17 |
4 | ORDER_STATUS_SUBMITTED | 18 |
1 | ORDER_STATUS_SHIPPED | 7 |
1 | REQ_LIST_STATUS | Y |
2 | REQ_LIST_STATUS | Z |
1 | CO_ORDER_TYPE | ORD |
1 | CO_SSQ_TYPE | QOT |
1 | WCS_PROMOID_LABEL | promo_id |
1 | WCS_USERID_LABEL | users_id |
1 | wsa_category | catGroupId |
2 | wsa_category | categoryId |
3 | wsa_category | category_id |
1 | wsa_catalog | catalogId |
2 | wsa_catalog | catalog_id |
1 | wsa_coupon | couponIds |
2 | wsa_coupon | coupon_id |
1 | wsa_initiative | intv_id |
1 | wsa_mpe | mpe_id |
1 | wsa_order_id | orderId |
1 | wsa_orderitem_id | orderItemId |
1 | wsa_product | prodId |
2 | wsa_product | Product_id |
3 | wsa_product | productId |
4 | wsa_product | product_id |
1 | wsa_store | storeId |
2 | wsa_store | member_id |
1 | wsa_linkcount | sawt_linkCount |
1 | wsa_result_type | resultType |
1 | wsa_srch_scope | searchTermScope |
1 | wsa_srch_type | searchType |
1 | wsa_separator | : |
1 | wsa_connector | = |
1 | wsa_comma | , |
1 | wsa_hyphen | - |
1 | wsa_result_page | ResultPage |
1 | wsa_search_page | SearchPage |
1 | wsa_sawt_link | sawt_link |
1 | wsa_sawt_linktaken | sawt_link_taken |
1 | wsa_default_size | DefaultPageSize |
1 | wsa_url | URL |
1 | wsa_order_item | OrderItemDisplay |
1 | wsa_interest_item | InterestItemDisplay |
1 | wsa_param_type | 2 |
2 | wsa_param_type | 6 |
3 | wsa_param_type | 16 |
4 | wsa_param_type | 38 |
1 | wsa_commit_count | 1000 |