WCA.PARAMETERS table after configuration
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 WCS_SOURCE 57be 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_canceled 2 1 CONTRACT_canceled 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 (C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.