gonzalo migracion reportes hyperion falabella (8)
TRANSCRIPT
Reportes Hyperion - Banco Falabella
Nombre en Reporte Tabla/Vista Reporte Original Campo Reporte OriginalFecha/Hora T_Grofags_No_Agg Begin_Time
Nombre Grupo O_Grofags_No_Agg Presentation_NameT Login R_Grofags_No_Agg T_LoginT Hold R_Grofags_No_Agg T_Hold
T Unknown R_Grofags_No_Agg T_UnknownLlam Dialing R_Grofags_No_Agg N_Dialing
Llam Not Ready R_Grofags_No_Agg N_Not_ReadyLlam Hold R_Grofags_No_Agg N_HoldT Dialing R_Grofags_No_Agg T_Dialing
Llam Inbound R_Grofags_No_Agg N_InboundLlam Internal R_Grofags_No_Agg N_Internal
Llam Unknown R_Grofags_No_Agg N_UnknownLlam Calls V_Grofags_No_Agg N_Calls
Llam Conferences R_Grofags_No_Agg N_ConferencesLlam Cust Calls V_Grofags_No_Agg N_Cust_Calls
T Inbound R_Grofags_No_Agg T_InboundT Consult R_Grofags_No_Agg T_Consult
T Wait R_Grofags_No_Agg T_WaitT Talk R_Grofags_No_Agg T_Talk
Llam Outbound R_Grofags_No_Agg N_OutboundLlam Consult R_Grofags_No_Agg N_Consult
Llam Talk R_Grofags_No_Agg N_TalkLlam Srv Calls V_Grofags_No_Agg N_Srv_Calls
T Internal R_Grofags_No_Agg T_InternalLlam Ringing R_Grofags_No_Agg N_Ringing
Llam Wait R_Grofags_No_Agg N_WaitT Ringing R_Grofags_No_Agg T_Ringing
Llam Work R_Grofags_No_Agg N_WorkLlam Transfers Made R_Grofags_No_Agg N_Transfers_MadeLlam Transfers Taken R_Grofags_No_Agg N_Transfers_Taken
T Work R_Grofags_No_Agg T_WorkT Not Ready R_Grofags_No_Agg T_Not_ReadyT Outbound R_Grofags_No_Agg T_Outbound
Prom Llam Call P Hour V_Grofags_No_Agg Av_N_Calls_P_Hour
Av T Consult V_Grofags_No_Agg Av_T_Consult
Av T Cust Calls V_Grofags_No_Agg Av_T_Cust_Calls
Av T Dialing V_Grofags_No_Agg Av_T_Dialing
Av T Hold V_Grofags_No_Agg Av_T_Hold
Av T Inbound V_Grofags_No_Agg Av_T_Inbound
Av T Internal V_Grofags_No_Agg Av_T_Internal
Av T Not Ready V_Grofags_No_Agg Av_T_Not_Ready
Av T Outbound V_Grofags_No_Agg Av_T_Outbound
Av T Ringing V_Grofags_No_Agg Av_T_Ringing
Av T Srv Calls V_Grofags_No_Agg Av_T_Srv_Calls
Av T Calls V_Grofags_No_Agg Av_T_Calls
Av T Unknown V_Grofags_No_Agg Av_T_Unknown
Av T Wait V_Grofags_No_Agg Av_T_Wait
Av T Work V_Grofags_No_Agg Av_T_Work
Av T Handle V_Grofags_No_Agg Av_T_Handle
T Srv Calls V_Grofags_No_Agg T_Srv_CallsT Calls V_Grofags_No_Agg T_Calls
T Cust Calls V_Grofags_No_Agg T_Cust_Calls
% Llam Hold V_Grofags_No_Agg Pc_N_Hold
% Llam Conferences V_Grofags_No_Agg Pc_N_Conferences
% Llam Consult V_Grofags_No_Agg Pc_N_Consult
% T° Consult V_Grofags_No_Agg Pc_T_Consult
% Llam Cust Calls V_Grofags_No_Agg Pc_N_Cust_Calls
% T° Cust Calls V_Grofags_No_Agg Pc_T_Cust_Calls
% T° Dialing V_Grofags_No_Agg Pc_T_Dialing
% T° Hold V_Grofags_No_Agg Pc_T_Hold
% Llam Inbound V_Grofags_No_Agg Pc_N_Inbound
% T° Inbound V_Grofags_No_Agg Pc_T_Inbound
% Llam Internal V_Grofags_No_Agg Pc_N_Internal
% T° Internal V_Grofags_No_Agg Pc_T_Internal
% T Not Ready V_Grofags_No_Agg Pc_T_Not_Ready
% Llam Outbound V_Grofags_No_Agg Pc_N_Outbound
% T° Outbound V_Grofags_No_Agg Pc_T_Outbound
% T° Ringing V_Grofags_No_Agg Pc_T_Ringing
% Llam Srv Calls V_Grofags_No_Agg Pc_N_Srv_Calls
% T° Srv Calls V_Grofags_No_Agg Pc_T_Srv_Calls
% T° Calls V_Grofags_No_Agg Pc_T_Calls
% Llam Trans Made V_Grofags_No_Agg Pc_N_Trans_Made
% Llam Trans Taken V_Grofags_No_Agg Pc_N_Trans_Taken
% Llam Unknown V_Grofags_No_Agg Pc_N_Unknown
% T° Unknown V_Grofags_No_Agg Pc_T_Unknown
% T° Wait V_Grofags_No_Agg Pc_T_Wait
% Llam Work V_Grofags_No_Agg Pc_N_Work
% T° Work V_Grofags_No_Agg Pc_T_Work
T Work2 R_Grofags_No_Agg T_WorkT Not Ready2 R_Grofags_No_Agg T_Not_Ready
T Dialing2 R_Grofags_No_Agg T_Dialing
Reportes Hyperion - Banco Falabella
Tabla/Vista Reporte Migrado Campo Reporte MigradoT Voice Gag No Agg Begin TimeO Voice Gag No Agg Presentation NameR Voice Gag No Agg T LoginR Voice Gag No Agg T HoldR Voice Gag No Agg T UnknownR Voice Gag No Agg N DialingR Voice Gag No AggR Voice Gag No AggR Voice Gag No Agg T DialingR Voice Gag No Agg N InboundR Voice Gag No AggR Voice Gag No AggV Voice Gag No Agg N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWNR Voice Gag No AggV Voice Gag No AggR Voice Gag No Agg T InboundR Voice Gag No Agg T ConsultR Voice Gag No AggR Voice Gag No Agg T TalkR Voice Gag No Agg N OutboundR Voice Gag No Agg N ConsultR Voice Gag No AggV Voice Gag No AggR Voice Gag No Agg T InternalR Voice Gag No AggR Voice Gag No AggR Voice Gag No Agg T RingingR Voice Gag No AggR Voice Gag No Agg N Transfer MadeR Voice Gag No Agg N Transfer TakenR Voice Gag No Agg T WorkR Voice Gag No Agg T Not ReadyR Voice Gag No Agg T Outbound
case T_LOGINwhen 0 then 0else convert( float, N_INBOUND + N_OUTBOUND + N_INTERNAL +N_CONSULT + N_UNKNOWN ) * 3600 / T_LOGINend
case N_CONSULTwhen 0 then 0else convert( float, T_CONSULT ) / N_CONSULTend
case N_INBOUND + N_OUTBOUNDwhen 0 then 0else convert( float, T_INBOUND + T_OUTBOUND ) /( N_INBOUND + N_OUTBOUND )end
case N_DIALINGwhen 0 then 0else convert( float, T_DIALING ) / N_DIALINGend
case N_HOLDwhen 0 then 0else convert( float, T_HOLD ) / N_HOLDend
case N_INBOUNDwhen 0 then 0else convert( float, T_INBOUND ) / N_INBOUNDend
case N_INTERNALwhen 0 then 0else convert( float, T_INTERNAL ) / N_INTERNALend
case N_NOT_READYwhen 0 then 0else convert( float, T_NOT_READY ) / N_NOT_READYend
case N_OUTBOUNDwhen 0 then 0else convert( float, T_OUTBOUND ) / N_OUTBOUNDend
case N_RINGINGwhen 0 then 0else convert( float, T_RINGING ) / N_RINGINGend
V Voice Gag No AggV Voice Gag No Agg T_INBOUND + T_OUTBOUND + T_INTERNAL + T_CONSULT + T_UNKNOWNV Voice Gag No Agg
case N_INTERNAL + N_CONSULTwhen 0 then 0else convert( float, T_INTERNAL + T_CONSULT ) /( N_INTERNAL + N_CONSULT )end
case N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT +N_UNKNOWNwhen 0 then 0else convert( float, T_INBOUND + T_OUTBOUND + T_INTERNAL +T_CONSULT + T_UNKNOWN ) /( N_INBOUND + N_OUTBOUND + N_INTERNAL +N_CONSULT + N_UNKNOWN )end
case N_UNKNOWNwhen 0 then 0else convert( float, T_UNKNOWN ) / N_UNKNOWNend
case N_WAITwhen 0 then 0else convert( float, T_WAIT ) / N_WAITend
case N_WORKwhen 0 then 0else convert( float, T_WORK ) / N_WORKend
case N_INBOUND + N_OUTBOUNDwhen 0 then 0else convert( float, T_INBOUND + T_OUTBOUND + T_WORK ) /( N_INBOUND + N_OUTBOUND )end
casewhen N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT +N_UNKNOWN = 0 then 0when N_HOLD > N_INBOUND + N_OUTBOUND + N_INTERNAL +N_CONSULT + N_UNKNOWN then 100else convert( float, N_HOLD ) * 100 / ( N_INBOUND +N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN )end
casewhen N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT +N_UNKNOWN = 0 then 0when N_CONFERENCES > N_INBOUND + N_OUTBOUND + N_INTERNAL+N_CONSULT + N_UNKNOWN then 100else convert( float, N_CONFERENCES ) * 100 /( N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT +N_UNKNOWN )end
case N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT +N_UNKNOWNwhen 0 then 0else convert( float, N_CONSULT ) * 100 /( N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT +N_UNKNOWN )end
casewhen T_LOGIN = 0 then 0when T_CONSULT > T_LOGIN then 100else convert( float, T_CONSULT ) * 100 / T_LOGINend
case N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT +N_UNKNOWNwhen 0 then 0else convert( float, N_INBOUND + N_OUTBOUND ) * 100 /( N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT +N_UNKNOWN )end
casewhen T_LOGIN = 0 then 0when T_INBOUND + T_OUTBOUND > T_LOGIN then 100else convert( float, T_INBOUND + T_OUTBOUND ) * 100 /T_LOGINend
casewhen T_LOGIN = 0 then 0when T_DIALING > T_LOGIN then 100else convert( float, T_DIALING ) * 100 / T_LOGINend
casewhen T_LOGIN = 0 then 0when T_HOLD > T_LOGIN then 100else convert( float, T_HOLD ) * 100 / T_LOGINend
case N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT +N_UNKNOWNwhen 0 then 0else convert( float, N_INBOUND ) * 100 / ( N_INBOUND +N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN )end
casewhen T_LOGIN = 0 then 0when T_INBOUND > T_LOGIN then 100else convert( float, T_INBOUND ) * 100 / T_LOGINend
case N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT +N_UNKNOWNwhen 0 then 0else convert( float, N_INTERNAL ) * 100 / ( N_INBOUND +N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN )end
casewhen T_LOGIN = 0 then 0when T_INTERNAL > T_LOGIN then 100else convert( float, T_INTERNAL ) * 100 / T_LOGINend
casewhen T_LOGIN = 0 then 0when T_NOT_READY > T_LOGIN then 100else convert( float, T_NOT_READY ) * 100 / T_LOGINend
case N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT +N_UNKNOWNwhen 0 then 0else convert( float, N_OUTBOUND ) * 100 / ( N_INBOUND +N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN )end
casewhen T_LOGIN = 0 then 0when T_OUTBOUND > T_LOGIN then 100else convert( float, T_OUTBOUND ) * 100 / T_LOGINend
casewhen T_LOGIN = 0 then 0when T_RINGING > T_LOGIN then 100else convert( float, T_RINGING ) * 100 / T_LOGINend
case N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT +N_UNKNOWNwhen 0 then 0else convert( float, N_INTERNAL + N_CONSULT ) * 100 /( N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT +N_UNKNOWN )end
casewhen T_LOGIN = 0 then 0when T_INTERNAL + T_CONSULT > T_LOGIN then 100else convert( float, T_INTERNAL + T_CONSULT ) * 100 /T_LOGINend
casewhen T_LOGIN = 0 then 0when T_INBOUND + T_OUTBOUND + T_INTERNAL + T_CONSULT +T_UNKNOWN >T_LOGIN then 100else convert( float, T_INBOUND + T_OUTBOUND + T_INTERNAL +T_CONSULT + T_UNKNOWN ) * 100 / T_LOGINend
casewhen N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT +N_UNKNOWN = 0 then 0when N_TRANSFERS_MADE > N_INBOUND + N_OUTBOUND +N_INTERNAL +N_CONSULT + N_UNKNOWN then 100else convert( float, N_TRANSFERS_MADE ) * 100 / (N_INBOUND +N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN )end
casewhen N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT +N_UNKNOWN = 0 then 0when N_TRANSFERS_TAKEN > N_INBOUND + N_OUTBOUND +N_INTERNAL +N_CONSULT + N_UNKNOWN then 100else convert( float, N_TRANSFERS_TAKEN ) * 100 / (N_INBOUND +N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN )end
case N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT +N_UNKNOWNwhen 0 then 0else convert( float, N_UNKNOWN ) * 100 /( N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT +N_UNKNOWN )end
casewhen T_LOGIN = 0 then 0when T_UNKNOWN > T_LOGIN then 100else convert( float, T_UNKNOWN ) * 100 / T_LOGINend
casewhen T_LOGIN = 0 then 0when T_WAIT > T_LOGIN then 100else convert( float, T_WAIT ) * 100 / T_LOGINend
R Voice Gag No AggR Voice Gag No Agg T Not ReadyR Voice Gag No Agg T Dialing
casewhen N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT +N_UNKNOWN = 0 then 0when N_WORK > N_INBOUND + N_OUTBOUND + N_INTERNAL +N_CONSULT +N_UNKNOWN then 100else convert( float, N_WORK ) * 100 / ( N_INBOUND +N_OUTBOUND +N_INTERNAL + N_CONSULT + N_UNKNOWN )end
casewhen T_LOGIN = 0 then 0when T_WORK > T_LOGIN then 100else convert( float, T_WORK ) * 100 / T_LOGINend
Reportes Hyperion - Banco Falabella
OBS
Total_Not_Ready_NumberTotal_Number_on_Hold
TotalNumberInternalCallsTotalNumberUnknownCalls
N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWNTotal_Number_of_ConferencesN_INBOUND + N_OUTBOUND
T_READY
Total_Status_TalkN_INTERNAL + N_CONSULT
Total_Ringing_NumberTotal_Wait_Number
Total_Work_Number
T_ACW
T_INTERNAL + T_CONSULTT_INBOUND + T_OUTBOUND + T_INTERNAL + T_CONSULT + T_UNKNOWN
T_INBOUND + T_OUTBOUND
Reportes Hyperion - Banco Falabella
Nombre en Reporte Tabla/Vista Reporte Original Campo Reporte OriginalFecha / Hora T_Queue_No_Agg Begin_TimeNombre Cola O_Queue_No_Agg Object_Name
Av T Answered V_Queue_No_Agg Av_T_AnsweredAv T Abandoned V_Queue_No_Agg Av_T_AbandonedAv T Distributed V_Queue_No_Agg Av_T_Distributed
Max T Abandoned V_Queue_No_Agg Max_T_AbandonedMax T Answered V_Queue_No_Agg Max_T_Answered
% Llam Abandonadas V_Queue_No_Agg Pc_N_Abandoved% Llam Contestadas V_Queue_No_Agg Pc_N_Answered
Factor Servicio V_Queue_No_Agg Service_Factor
Llamadas Aband V_Queue_No_Agg N_AbandonedLlamadas Contestadas V_Queue_No_Agg N_AnsweredLlamadas Distribuidas V_Queue_No_Agg N_Distributed
Llamadas Distribuidas en Tr V_Queue_No_Agg N_Distrib_In_TrDay Of Week T_Queue_No_Agg Day_Of_Week
Llamadas Entrantes V_Queue_No_Agg N_EnteredLlamadas Aband en Tr V_Queue_No_Agg N_Abandoned_In_Tr
T Abandoned V_Queue_No_Agg T_AbandonedT Answered V_Queue_No_Agg T_Answered
T Distributed V_Queue_No_Agg T_Distributed% Llamadas Distribuidas V_Queue_No_Agg Pc_N_Distrib
Hour Hh24 T_Queue_No_Agg Hour_Hh24Total Calls Answer R_641_Stat_Res Total_Calls_AnswerDate Yyyymmdd T_Queue_No_Agg Date_YyyymmddTot Call Clear Chi R_Queue_Te_3_No_Agg Tot_Call_Clear_ChiTot Forw Call Chi R_Queue_Te_3_No_Agg Tot_Forw_Call_Chi
To Call Aband Ring V_201_Compstat To_Call_Aband_RingTo Call Aband Rin2 V_201_Compstat To_Call_Aband_Rin2
Time Hh24Mi T_Queue_No_Agg Time_Hh24Mi
Reportes Hyperion - Banco Falabella
Tabla/Vista Reporte Migrado Campo Reporte MigradoT Voice Q No Agg Begin TimeO Voice Q No Agg Object Name
V Voice Q No Agg N AbandonedV Voice Q No Agg N AnsweredV Voice Q No Agg N Distributed
T Voice Q No Agg Day Of WeekV Voice Q No Agg N Entered
V Voice Q No Agg T AbandonedV Voice Q No Agg T Answered
T Voice Q No Agg Hour Hh24
T Voice Q No Agg Date Yyyymmdd
T Voice Q No Agg Time Hh24Mi
Reportes Hyperion - Banco Falabella
OBS
MAX_T_ABANDONEDMAX_T_ANSWERED
N_DISTRIBUTED_TH
N_ABANDONED_TH
T_DISTRIBUTED
N_ANSWERED
N_CLEAREDN_ABANDONED_TH
N_ABAND_RINGN_ABAND_RING
Nivel de Servicio= N_DISTRIBUTED_TH / N_ANSWERED + N_ABANDONED - N_ABANDONED_TH) * 100