User interaction data weekly (LTC) with standard field set
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| keyid | varchar(255) | false | ||||
| userid | varchar(50) | true | ||||
| 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 | ||||
| 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 | ||||
| tuserresponsetimecount | integer | true | ||||
| tuserresponsetimetimesum | numeric(20,2) | true | ||||
| tuserresponsetimetimemax | numeric(20,2) | true | ||||
| tuserresponsetimetimemin | numeric(20,2) | true | ||||
| tagentresponsetimecount | integer | true | ||||
| tagentresponsetimetimesum | numeric(20,2) | true | ||||
| tagentresponsetimetimemax | numeric(20,2) | true | ||||
| tagentresponsetimetimemin | 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 |
| Name | Type | Definition |
|---|---|---|
| userinteractiondataweekly_pkey | PRIMARY KEY | PRIMARY KEY (keyid) |
| Name | Definition |
|---|---|
| userinteractiondataweekly_pkey | CREATE UNIQUE INDEX userinteractiondataweekly_pkey ON public.userinteractiondataweekly USING btree (keyid) |
| userinteractiondataweekly_date | CREATE INDEX userinteractiondataweekly_date ON public.userinteractiondataweekly USING btree (startdate) |
| userinteractiondataweekly_media | CREATE INDEX userinteractiondataweekly_media ON public.userinteractiondataweekly USING btree (mediatype) |
| userinteractiondataweekly_user | CREATE INDEX userinteractiondataweekly_user ON public.userinteractiondataweekly USING btree (userid) |
| userinteractiondataweekly_wrapup | CREATE INDEX userinteractiondataweekly_wrapup ON public.userinteractiondataweekly USING btree (wrapupcode) |
| userinteractiondataweekly_queue | CREATE INDEX userinteractiondataweekly_queue ON public.userinteractiondataweekly USING btree (queueid) |