public.queueinteractiondataweekly
Columns
| keyid |
varchar(255) |
|
false |
|
|
|
| direction |
varchar(50) |
|
true |
|
|
|
| queueid |
varchar(50) |
|
true |
|
|
|
| mediatype |
varchar(50) |
|
true |
|
|
|
| wrapupcode |
varchar(255) |
|
true |
|
|
|
| startdate |
timestamp without time zone |
|
true |
|
|
|
| talertcount |
integer |
|
true |
|
|
|
| talerttimesum |
numeric(20,2) |
|
true |
|
|
|
| talerttimemax |
numeric(20,2) |
|
true |
|
|
|
| talerttimemin |
numeric(20,2) |
|
true |
|
|
|
| tansweredcount |
integer |
|
true |
|
|
|
| tansweredtimesum |
numeric(20,2) |
|
true |
|
|
|
| tansweredtimemax |
numeric(20,2) |
|
true |
|
|
|
| tansweredtimemin |
numeric(20,2) |
|
true |
|
|
|
| ttalkcount |
integer |
|
true |
|
|
|
| ttalktimesum |
numeric(20,2) |
|
true |
|
|
|
| ttalktimemax |
numeric(20,2) |
|
true |
|
|
|
| ttalktimemin |
numeric(20,2) |
|
true |
|
|
|
| ttalkcompletecount |
integer |
|
true |
|
|
|
| ttalkcompletetimesum |
numeric(20,2) |
|
true |
|
|
|
| ttalkcompletetimemax |
numeric(20,2) |
|
true |
|
|
|
| ttalkcompletetimemin |
numeric(20,2) |
|
true |
|
|
|
| tnotrespondingcount |
integer |
|
true |
|
|
|
| tnotrespondingtimesum |
numeric(20,2) |
|
true |
|
|
|
| tnotrespondingtimemax |
numeric(20,2) |
|
true |
|
|
|
| tnotrespondingtimemin |
numeric(20,2) |
|
true |
|
|
|
| theldcount |
integer |
|
true |
|
|
|
| theldtimesum |
numeric(20,2) |
|
true |
|
|
|
| theldtimemax |
numeric(20,2) |
|
true |
|
|
|
| theldtimemin |
numeric(20,2) |
|
true |
|
|
|
| theldcompletecount |
integer |
|
true |
|
|
|
| theldcompletetimesum |
numeric(20,2) |
|
true |
|
|
|
| theldcompletetimemax |
numeric(20,2) |
|
true |
|
|
|
| theldcompletetimemin |
numeric(20,2) |
|
true |
|
|
|
| thandlecount |
integer |
|
true |
|
|
|
| thandletimesum |
numeric(20,2) |
|
true |
|
|
|
| thandletimemax |
numeric(20,2) |
|
true |
|
|
|
| thandletimemin |
numeric(20,2) |
|
true |
|
|
|
| tacwcount |
integer |
|
true |
|
|
|
| tacwtimesum |
numeric(20,2) |
|
true |
|
|
|
| tacwtimemax |
numeric(20,2) |
|
true |
|
|
|
| tacwtimemin |
numeric(20,2) |
|
true |
|
|
|
| nconsult |
integer |
|
true |
|
|
|
| nconsulttransferred |
integer |
|
true |
|
|
|
| noutbound |
integer |
|
true |
|
|
|
| nerror |
integer |
|
true |
|
|
|
| ntransferred |
integer |
|
true |
|
|
|
| nblindtransferred |
integer |
|
true |
|
|
|
| nconnected |
integer |
|
true |
|
|
|
| noffered |
integer |
|
true |
|
|
|
| noversla |
integer |
|
true |
|
|
|
| tacdcount |
integer |
|
true |
|
|
|
| tacdtimesum |
numeric(20,2) |
|
true |
|
|
|
| tacdtimemax |
numeric(20,2) |
|
true |
|
|
|
| tacdtimemin |
numeric(20,2) |
|
true |
|
|
|
| tdialingcount |
integer |
|
true |
|
|
|
| tdialingtimesum |
numeric(20,2) |
|
true |
|
|
|
| tdialingtimemax |
numeric(20,2) |
|
true |
|
|
|
| tdialingtimemin |
numeric(20,2) |
|
true |
|
|
|
| tcontactingcount |
integer |
|
true |
|
|
|
| tcontactingtimesum |
numeric(20,2) |
|
true |
|
|
|
| tcontactingtimemax |
numeric(20,2) |
|
true |
|
|
|
| tcontactingtimemin |
numeric(20,2) |
|
true |
|
|
|
| tvoicemailcount |
integer |
|
true |
|
|
|
| tvoicemailtimesum |
numeric(20,2) |
|
true |
|
|
|
| tvoicemailtimemax |
numeric(20,2) |
|
true |
|
|
|
| tvoicemailtimemin |
numeric(20,2) |
|
true |
|
|
|
| tflowoutcount |
integer |
|
true |
|
|
|
| tflowouttimesum |
numeric(20,2) |
|
true |
|
|
|
| tflowouttimemax |
numeric(20,2) |
|
true |
|
|
|
| tflowouttimemin |
numeric(20,2) |
|
true |
|
|
|
| twaitcount |
integer |
|
true |
|
|
|
| twaittimesum |
numeric(20,2) |
|
true |
|
|
|
| twaittimemax |
numeric(20,2) |
|
true |
|
|
|
| twaittimemin |
numeric(20,2) |
|
true |
|
|
|
| tabandoncount |
integer |
|
true |
|
|
|
| tabandontimesum |
numeric(20,2) |
|
true |
|
|
|
| tabandontimemax |
numeric(20,2) |
|
true |
|
|
|
| tabandontimemin |
numeric(20,2) |
|
true |
|
|
|
| servicelevelnumerator |
numeric(20,2) |
|
true |
|
|
|
| serviceleveldenominator |
numeric(20,2) |
|
true |
|
|
|
| av1count |
integer |
|
true |
|
|
|
| av1timesum |
numeric(20,2) |
|
true |
|
|
|
| av1timemax |
numeric(20,2) |
|
true |
|
|
|
| av1timemin |
numeric(20,2) |
|
true |
|
|
|
| av2count |
integer |
|
true |
|
|
|
| av2timesum |
numeric(20,2) |
|
true |
|
|
|
| av2timemax |
numeric(20,2) |
|
true |
|
|
|
| av2timemin |
numeric(20,2) |
|
true |
|
|
|
| av3count |
integer |
|
true |
|
|
|
| av3timesum |
numeric(20,2) |
|
true |
|
|
|
| av3timemax |
numeric(20,2) |
|
true |
|
|
|
| av3timemin |
numeric(20,2) |
|
true |
|
|
|
| av4count |
integer |
|
true |
|
|
|
| av4timesum |
numeric(20,2) |
|
true |
|
|
|
| av4timemax |
numeric(20,2) |
|
true |
|
|
|
| av4timemin |
numeric(20,2) |
|
true |
|
|
|
| av5count |
integer |
|
true |
|
|
|
| av5timesum |
numeric(20,2) |
|
true |
|
|
|
| av5timemax |
numeric(20,2) |
|
true |
|
|
|
| av5timemin |
numeric(20,2) |
|
true |
|
|
|
| av6count |
integer |
|
true |
|
|
|
| av6timesum |
numeric(20,2) |
|
true |
|
|
|
| av6timemax |
numeric(20,2) |
|
true |
|
|
|
| av6timemin |
numeric(20,2) |
|
true |
|
|
|
| av7count |
integer |
|
true |
|
|
|
| av7timesum |
numeric(20,2) |
|
true |
|
|
|
| av7timemax |
numeric(20,2) |
|
true |
|
|
|
| av7timemin |
numeric(20,2) |
|
true |
|
|
|
| av8count |
integer |
|
true |
|
|
|
| av8timesum |
numeric(20,2) |
|
true |
|
|
|
| av8timemax |
numeric(20,2) |
|
true |
|
|
|
| av8timemin |
numeric(20,2) |
|
true |
|
|
|
| av9count |
integer |
|
true |
|
|
|
| av9timesum |
numeric(20,2) |
|
true |
|
|
|
| av9timemax |
numeric(20,2) |
|
true |
|
|
|
| av9timemin |
numeric(20,2) |
|
true |
|
|
|
| av10count |
integer |
|
true |
|
|
|
| av10timesum |
numeric(20,2) |
|
true |
|
|
|
| av10timemax |
numeric(20,2) |
|
true |
|
|
|
| av10timemin |
numeric(20,2) |
|
true |
|
|
|
| updated |
timestamp without time zone |
|
true |
|
|
|
| startdateltc |
timestamp without time zone |
|
true |
|
|
|
Constraints
| queueinteractiondataweekly_pkey |
PRIMARY KEY |
PRIMARY KEY (keyid) |
Indexes
| queueinteractiondataweekly_pkey |
CREATE UNIQUE INDEX queueinteractiondataweekly_pkey ON
public.queueinteractiondataweekly USING btree (keyid) |