[Home] [Help] [Dependency Information]
Object Name: | BIC_PARTY_SUMM# |
---|---|
Object Type: | VIEW |
Owner: | BIC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIOD_START_DATE | DATE | Yes | ||
PARTY_ID | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATED_BY | NUMBER | Yes | ||
ORG_ID | NUMBER | |||
LOYALTY | NUMBER | |||
SATISFACTION | NUMBER | |||
SF_BILLING | NUMBER | |||
SF_CONTRACT | NUMBER | |||
SF_QUALITY | NUMBER | |||
SF_SERVICE | NUMBER | |||
SF_SHIPMENT | NUMBER | |||
ORDER_AMT | NUMBER | |||
ORDER_LINES_DELIVERED | NUMBER | |||
ORDER_LINES_ONTIME | NUMBER | |||
ORDER_NUM | NUMBER | |||
ORDER_QTY | NUMBER | |||
ORDER_QTY_CUML | NUMBER | |||
ORDER_RECENCY | NUMBER | |||
PAYMENTS | NUMBER | |||
RETURNS | NUMBER | |||
RETURN_BY_VALUE | NUMBER | |||
RETURN_BY_VALUE_PCT | NUMBER | |||
RETURN_QTY | NUMBER | |||
PCT_RETURN_QTY | NUMBER | |||
OL_DEL_VALUE | NUMBER | |||
OL_ONTIME_VALUE | NUMBER | |||
ONTIME_PAYMENTS | NUMBER | |||
ONTIME_SHIP_PCT | NUMBER | |||
ONTIME_VALUE_PCT | NUMBER | |||
ON_TIME_PAYMENT_RATE | NUMBER | |||
ASSOCIATION_YRS | NUMBER | |||
CLOSED_SRS | NUMBER | |||
COGS | NUMBER | |||
CONTRACTS_CUML | NUMBER | |||
CONTRACT_AMT | NUMBER | |||
CONTRACT_DURATION | NUMBER | |||
INACTIVE_CONTRACTS | NUMBER | |||
OPEN_CONTRACTS | NUMBER | |||
NEW_CONTRACTS | NUMBER | |||
RENEWED_CONTRACTS | NUMBER | |||
ESC_SRS | NUMBER | |||
FIRST_CALL_CL_RATE | NUMBER | |||
INTERACTIONS | NUMBER | |||
INTERAC_CUML | NUMBER | |||
NO_OF_COMPLAINTS | NUMBER | |||
NO_OF_INTERACTIONS | NUMBER | |||
NO_OF_TRANSFERS | NUMBER | |||
OPEN_SRS | NUMBER | |||
PCT_ESC_SRS | NUMBER | |||
PCT_REOPENED_SRS | NUMBER | |||
PERCT_CALL_REWORK | NUMBER | |||
PRODUCTS | NUMBER | |||
REFERALS | NUMBER | |||
REOPENED_SRS | NUMBER | |||
SALES | NUMBER | |||
SRS_LOGGED | NUMBER | |||
SR_CLOSED_INT | NUMBER | |||
TOTAL_HOLD_TIME | NUMBER | |||
TOTAL_LEN_OF_EMP | NUMBER | |||
TOTAL_SR_RESL_TIME | NUMBER | |||
TOTAL_SR_RESPONSE_TIME | NUMBER | |||
AVG_CLOSED_SRS | NUMBER | |||
AVG_COMPLAINTS | NUMBER | |||
AVG_HOLD_TIME | NUMBER | |||
AVG_INTERACTIONS | NUMBER | |||
AVG_INTERACTIONS_PER_SR | NUMBER | |||
AVG_LEN_OF_EMP | NUMBER | |||
AVG_OUTSTANDING_SRS | NUMBER | |||
AVG_PERIOD_FOR_ACTIVE_CONT | NUMBER | |||
AVG_SRS_LOGGED | NUMBER | |||
AVG_SR_RESL_TIME | NUMBER | |||
AVG_SR_RESPONSE_TIME | NUMBER | |||
AVG_TALK_TIME | NUMBER | |||
AVG_TRANSFERS_BEF_RESL | NUMBER | |||
AVG_TRANSFERS_PER_SR | NUMBER | |||
AVG_WORKLOAD | NUMBER | |||
CALLS | NUMBER | |||
CALL_LENGTH | NUMBER | |||
CALL_TYPE_INTERACTIONS | NUMBER | |||
MARKET_SEGMENT_ID | NUMBER | |||
PROFITABILITY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
SECURITY_GROUP_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT PERIOD_START_DATE
, PARTY_ID
, LAST_UPDATE_DATE
, CREATION_DATE
, LAST_UPDATED_BY
, CREATED_BY
, ORG_ID
, LOYALTY
, SATISFACTION
, SF_BILLING
, SF_CONTRACT
, SF_QUALITY
, SF_SERVICE
, SF_SHIPMENT
, ORDER_AMT
, ORDER_LINES_DELIVERED
, ORDER_LINES_ONTIME
, ORDER_NUM
, ORDER_QTY
, ORDER_QTY_CUML
, ORDER_RECENCY
, PAYMENTS
, RETURNS
, RETURN_BY_VALUE
, RETURN_BY_VALUE_PCT
, RETURN_QTY
, PCT_RETURN_QTY
, OL_DEL_VALUE
, OL_ONTIME_VALUE
, ONTIME_PAYMENTS
, ONTIME_SHIP_PCT
, ONTIME_VALUE_PCT
, ON_TIME_PAYMENT_RATE
, ASSOCIATION_YRS
, CLOSED_SRS
, COGS
, CONTRACTS_CUML
, CONTRACT_AMT
, CONTRACT_DURATION
, INACTIVE_CONTRACTS
, OPEN_CONTRACTS
, NEW_CONTRACTS
, RENEWED_CONTRACTS
, ESC_SRS
, FIRST_CALL_CL_RATE
, INTERACTIONS
, INTERAC_CUML
, NO_OF_COMPLAINTS
, NO_OF_INTERACTIONS
, NO_OF_TRANSFERS
, OPEN_SRS
, PCT_ESC_SRS
, PCT_REOPENED_SRS
, PERCT_CALL_REWORK
, PRODUCTS
, REFERALS
, REOPENED_SRS
, SALES
, SRS_LOGGED
, SR_CLOSED_INT
, TOTAL_HOLD_TIME
, TOTAL_LEN_OF_EMP
, TOTAL_SR_RESL_TIME
, TOTAL_SR_RESPONSE_TIME
, AVG_CLOSED_SRS
, AVG_COMPLAINTS
, AVG_HOLD_TIME
, AVG_INTERACTIONS
, AVG_INTERACTIONS_PER_SR
, AVG_LEN_OF_EMP
, AVG_OUTSTANDING_SRS
, AVG_PERIOD_FOR_ACTIVE_CONT
, AVG_SRS_LOGGED
, AVG_SR_RESL_TIME
, AVG_SR_RESPONSE_TIME
, AVG_TALK_TIME
, AVG_TRANSFERS_BEF_RESL
, AVG_TRANSFERS_PER_SR
, AVG_WORKLOAD
, CALLS
, CALL_LENGTH
, CALL_TYPE_INTERACTIONS
, MARKET_SEGMENT_ID
, PROFITABILITY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SECURITY_GROUP_ID
FROM BIC.BIC_PARTY_SUMM#;
|
|
|