VIEW: BIC.BIC_PARTY_SUMM#

Source

View Text - Preformatted

select PERIOD_START_DATE PERIOD_START_DATE, PARTY_ID PARTY_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, ORG_ID ORG_ID, LOYALTY LOYALTY, SATISFACTION SATISFACTION, SF_BILLING SF_BILLING, SF_CONTRACT SF_CONTRACT, SF_QUALITY SF_QUALITY, SF_SERVICE SF_SERVICE, SF_SHIPMENT SF_SHIPMENT, ORDER_AMT ORDER_AMT, ORDER_LINES_DELIVERED ORDER_LINES_DELIVERED, ORDER_LINES_ONTIME ORDER_LINES_ONTIME, ORDER_NUM ORDER_NUM, ORDER_QTY ORDER_QTY, ORDER_QTY_CUML ORDER_QTY_CUML, ORDER_RECENCY ORDER_RECENCY, PAYMENTS PAYMENTS, RETURNS RETURNS, RETURN_BY_VALUE RETURN_BY_VALUE, RETURN_BY_VALUE_PCT RETURN_BY_VALUE_PCT, RETURN_QTY RETURN_QTY, PCT_RETURN_QTY PCT_RETURN_QTY, OL_DEL_VALUE OL_DEL_VALUE, OL_ONTIME_VALUE OL_ONTIME_VALUE, ONTIME_PAYMENTS ONTIME_PAYMENTS, ONTIME_SHIP_PCT ONTIME_SHIP_PCT, ONTIME_VALUE_PCT ONTIME_VALUE_PCT, ON_TIME_PAYMENT_RATE ON_TIME_PAYMENT_RATE, ASSOCIATION_YRS ASSOCIATION_YRS, CLOSED_SRS CLOSED_SRS, COGS COGS, CONTRACTS_CUML CONTRACTS_CUML, CONTRACT_AMT CONTRACT_AMT, CONTRACT_DURATION CONTRACT_DURATION, INACTIVE_CONTRACTS INACTIVE_CONTRACTS, OPEN_CONTRACTS OPEN_CONTRACTS, NEW_CONTRACTS NEW_CONTRACTS, RENEWED_CONTRACTS RENEWED_CONTRACTS, ESC_SRS ESC_SRS, FIRST_CALL_CL_RATE FIRST_CALL_CL_RATE, INTERACTIONS INTERACTIONS, INTERAC_CUML INTERAC_CUML, NO_OF_COMPLAINTS NO_OF_COMPLAINTS, NO_OF_INTERACTIONS NO_OF_INTERACTIONS, NO_OF_TRANSFERS NO_OF_TRANSFERS, OPEN_SRS OPEN_SRS, PCT_ESC_SRS PCT_ESC_SRS, PCT_REOPENED_SRS PCT_REOPENED_SRS, PERCT_CALL_REWORK PERCT_CALL_REWORK, PRODUCTS PRODUCTS, REFERALS REFERALS, REOPENED_SRS REOPENED_SRS, SALES SALES, SRS_LOGGED SRS_LOGGED, SR_CLOSED_INT SR_CLOSED_INT, TOTAL_HOLD_TIME TOTAL_HOLD_TIME, TOTAL_LEN_OF_EMP TOTAL_LEN_OF_EMP, TOTAL_SR_RESL_TIME TOTAL_SR_RESL_TIME, TOTAL_SR_RESPONSE_TIME TOTAL_SR_RESPONSE_TIME, AVG_CLOSED_SRS AVG_CLOSED_SRS, AVG_COMPLAINTS AVG_COMPLAINTS, AVG_HOLD_TIME AVG_HOLD_TIME, AVG_INTERACTIONS AVG_INTERACTIONS, AVG_INTERACTIONS_PER_SR AVG_INTERACTIONS_PER_SR, AVG_LEN_OF_EMP AVG_LEN_OF_EMP, AVG_OUTSTANDING_SRS AVG_OUTSTANDING_SRS, AVG_PERIOD_FOR_ACTIVE_CONT AVG_PERIOD_FOR_ACTIVE_CONT, AVG_SRS_LOGGED AVG_SRS_LOGGED, AVG_SR_RESL_TIME AVG_SR_RESL_TIME, AVG_SR_RESPONSE_TIME AVG_SR_RESPONSE_TIME, AVG_TALK_TIME AVG_TALK_TIME, AVG_TRANSFERS_BEF_RESL AVG_TRANSFERS_BEF_RESL, AVG_TRANSFERS_PER_SR AVG_TRANSFERS_PER_SR, AVG_WORKLOAD AVG_WORKLOAD, CALLS CALLS, CALL_LENGTH CALL_LENGTH, CALL_TYPE_INTERACTIONS CALL_TYPE_INTERACTIONS, MARKET_SEGMENT_ID MARKET_SEGMENT_ID, PROFITABILITY PROFITABILITY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID from "BIC"."BIC_PARTY_SUMM"

View Text - HTML Formatted

SELECT PERIOD_START_DATE PERIOD_START_DATE
, PARTY_ID PARTY_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, ORG_ID ORG_ID
, LOYALTY LOYALTY
, SATISFACTION SATISFACTION
, SF_BILLING SF_BILLING
, SF_CONTRACT SF_CONTRACT
, SF_QUALITY SF_QUALITY
, SF_SERVICE SF_SERVICE
, SF_SHIPMENT SF_SHIPMENT
, ORDER_AMT ORDER_AMT
, ORDER_LINES_DELIVERED ORDER_LINES_DELIVERED
, ORDER_LINES_ONTIME ORDER_LINES_ONTIME
, ORDER_NUM ORDER_NUM
, ORDER_QTY ORDER_QTY
, ORDER_QTY_CUML ORDER_QTY_CUML
, ORDER_RECENCY ORDER_RECENCY
, PAYMENTS PAYMENTS
, RETURNS RETURNS
, RETURN_BY_VALUE RETURN_BY_VALUE
, RETURN_BY_VALUE_PCT RETURN_BY_VALUE_PCT
, RETURN_QTY RETURN_QTY
, PCT_RETURN_QTY PCT_RETURN_QTY
, OL_DEL_VALUE OL_DEL_VALUE
, OL_ONTIME_VALUE OL_ONTIME_VALUE
, ONTIME_PAYMENTS ONTIME_PAYMENTS
, ONTIME_SHIP_PCT ONTIME_SHIP_PCT
, ONTIME_VALUE_PCT ONTIME_VALUE_PCT
, ON_TIME_PAYMENT_RATE ON_TIME_PAYMENT_RATE
, ASSOCIATION_YRS ASSOCIATION_YRS
, CLOSED_SRS CLOSED_SRS
, COGS COGS
, CONTRACTS_CUML CONTRACTS_CUML
, CONTRACT_AMT CONTRACT_AMT
, CONTRACT_DURATION CONTRACT_DURATION
, INACTIVE_CONTRACTS INACTIVE_CONTRACTS
, OPEN_CONTRACTS OPEN_CONTRACTS
, NEW_CONTRACTS NEW_CONTRACTS
, RENEWED_CONTRACTS RENEWED_CONTRACTS
, ESC_SRS ESC_SRS
, FIRST_CALL_CL_RATE FIRST_CALL_CL_RATE
, INTERACTIONS INTERACTIONS
, INTERAC_CUML INTERAC_CUML
, NO_OF_COMPLAINTS NO_OF_COMPLAINTS
, NO_OF_INTERACTIONS NO_OF_INTERACTIONS
, NO_OF_TRANSFERS NO_OF_TRANSFERS
, OPEN_SRS OPEN_SRS
, PCT_ESC_SRS PCT_ESC_SRS
, PCT_REOPENED_SRS PCT_REOPENED_SRS
, PERCT_CALL_REWORK PERCT_CALL_REWORK
, PRODUCTS PRODUCTS
, REFERALS REFERALS
, REOPENED_SRS REOPENED_SRS
, SALES SALES
, SRS_LOGGED SRS_LOGGED
, SR_CLOSED_INT SR_CLOSED_INT
, TOTAL_HOLD_TIME TOTAL_HOLD_TIME
, TOTAL_LEN_OF_EMP TOTAL_LEN_OF_EMP
, TOTAL_SR_RESL_TIME TOTAL_SR_RESL_TIME
, TOTAL_SR_RESPONSE_TIME TOTAL_SR_RESPONSE_TIME
, AVG_CLOSED_SRS AVG_CLOSED_SRS
, AVG_COMPLAINTS AVG_COMPLAINTS
, AVG_HOLD_TIME AVG_HOLD_TIME
, AVG_INTERACTIONS AVG_INTERACTIONS
, AVG_INTERACTIONS_PER_SR AVG_INTERACTIONS_PER_SR
, AVG_LEN_OF_EMP AVG_LEN_OF_EMP
, AVG_OUTSTANDING_SRS AVG_OUTSTANDING_SRS
, AVG_PERIOD_FOR_ACTIVE_CONT AVG_PERIOD_FOR_ACTIVE_CONT
, AVG_SRS_LOGGED AVG_SRS_LOGGED
, AVG_SR_RESL_TIME AVG_SR_RESL_TIME
, AVG_SR_RESPONSE_TIME AVG_SR_RESPONSE_TIME
, AVG_TALK_TIME AVG_TALK_TIME
, AVG_TRANSFERS_BEF_RESL AVG_TRANSFERS_BEF_RESL
, AVG_TRANSFERS_PER_SR AVG_TRANSFERS_PER_SR
, AVG_WORKLOAD AVG_WORKLOAD
, CALLS CALLS
, CALL_LENGTH CALL_LENGTH
, CALL_TYPE_INTERACTIONS CALL_TYPE_INTERACTIONS
, MARKET_SEGMENT_ID MARKET_SEGMENT_ID
, PROFITABILITY PROFITABILITY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "BIC"."BIC_PARTY_SUMM"