[Home] [Help]
| Product: | BIC - Customer Intelligence (obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT S.PERIOD_START_DATE
, S.SF_QUALITY
, S.SF_SHIPMENT
, S.SF_BILLING
, S.SF_SERVICE
, S.SF_CONTRACT
, S.RETURNS
, S.RETURN_BY_VALUE
, S.PCT_RETURN_QTY
, S.RETURN_BY_VALUE_PCT
, S.SRS_LOGGED
, S.ONTIME_SHIP_PCT
, S.ONTIME_VALUE_PCT
, S.ON_TIME_PAYMENT_RATE
, S.AVG_SRS_LOGGED
, S.AVG_OUTSTANDING_SRS
, S.AVG_SR_RESL_TIME
, S.AVG_SR_RESPONSE_TIME
, S.PCT_ESC_SRS
, S.PERCT_CALL_REWORK
, S.AVG_INTERACTIONS_PER_SR
, S.AVG_TRANSFERS_PER_SR
, S.OPEN_CONTRACTS
, S.CONTRACT_AMT
, S.CONTRACT_DURATION
, S.AVG_PERIOD_FOR_ACTIVE_CONT
, S.PARTY_ID
, S.ORG_ID ORG_ID
, P.CATEGORY_CODE CUSTOMER_CATEGORY_FK
, P.PARTY_NAME
, P.CREATION_DATE
, P.ADDRESS1
, P.ADDRESS2
, P.ADDRESS3
, P.ADDRESS4
, P.CITY
, P.POSTAL_CODE
, P.STATE
, P.COUNTRY
, P.PROVINCE
, P.COUNTY
, P.EMAIL_ADDRESS
, S.MARKET_SEGMENT_ID MARKET_SEGMENT_FK
, T.ACT_PERIOD_NAME
, T.START_DATE
, T.ACT_PERIOD_START_DATE
, T.ACT_PERIOD_END_DATE
, T.ACT_YEAR
, T.ACT_PERIOD_NUM
, T.ACT_QUARTER
, T.ACT_HALF_YEAR
, T.ACT_YEAR_START_DATE
, T.ACT_QUARTER_START_DATE
FROM BIC_DIMV_TIME T
, HZ_PARTIES P
, BIC_PARTY_SUMM S
WHERE S.PERIOD_START_DATE = T.START_DATE
AND S.PARTY_ID = P.PARTY_ID WITH READ ONLY