Campaign_Session_Denormalized_Data Table

the following table contains the list, definitions, and data attributes of columns of campaign session denormalized data table all durations are in milliseconds column name position source data type sample value column description setup id it is marked as ck (distinct ush rec no,curh id,cuah id, ush session id 1 character varying nullfor normal setup it is the id of the application setup it is used in case of central art setup where multiple application setups are being used setup name 2 character varying null for normal setup it represents the name of the setup it is used in case of central art setup, where multiple application setups are being used ush session id 3 character varying d646 53a91d0a ses agent 4907 2 it is the session id from user session history table of the logged in user ush user id 4 character varying agent it contains the id of the logged in user ush local ip 5 character varying 10 10 2 184 it contains the local ip address of the machine through which the user is loggedin ush public ip 6 character varying 10 10 2 184 it contains the public ip address of the machine from where the user is logged in ush login time 7 timestamp without time zone 06/24/14 01 00 pm it contains the login time of the user ush logout time 8 timestamp without time zone 06/24/14 01 00 pm it contains the logout time of the user, if any ush client type 9 character varying web client it is the type of the user’s machine fron which the user is logged in (java, webaccess, or other ) ush client version 10 character varying 02 22 20420140502 it contains the version of client machine ush browser info 11 character varying mozilla/5 0 (x11; linux x86 64; rv 24 0) gecko/20100101 firefox/24 0 it contains the information of the user’s machine browser, through which the user is logged in ush reason 12 character varying user logout it contains the logout reason of the user ush archive id 13 bigint 7 it is the archive id of the user session history (that is a unique value per record in user session history) ush interval start time 14 timestamp without time zone 06/24/14 12 50 pm it contains the start time of the user’s interval time ush interval end time 15 timestamp without time zone 06/24/14 12 50 pm it contains the end time of the user’s interval ush contributed login duration 16 bigint 102791 it contains the total login duration in the particular interval of the user ush total login duration 17 bigint 734201 it contains the total login duration of the user curh id 18 character varying d646 53a91d0a ses agent 4907 2 it contains the unique id of the campaign in which the user’s status was ready curh campaign id 19 integer 1 it is the campaign id in which the user changed its ready state curh session id 20 character varying d646 53a91d0a ses agent 4907 2 it is the session id of the user curh ready start time 21 timestamp without time zone 06/24/14 12 48 pm it contains the time when the user set ready status curh ready end time 22 timestamp without time zone 06/24/14 12 48 pm it contains the time when user set the break status curh break end time 23 timestamp without time zone 06/24/14 12 48 pm it contains the time when the user set ready status again curh break reason 24 character varying agent selected campaign it contains the reason for the break set by the system curh agent break reason 25 character varying it contains the break reason, selected by the user curh contact center id 26 integer 1 it contains the contact centre id in which the user’s ready state has been changed curh break end reason 27 character varying agent set ready it contains the end break reason curh archive id 28 bigint 6 it is the archive id of campaign user ready history (that is the unique value per record in campaign user ready history) cuah id 29 character varying d646 53a91d0a ses agent 4907 2 it contains the unique id of the campaign user auto call history cuah campaign id 30 integer 1 it is the campaign id in which auto call state changed cuah session id 31 character varying d646 53a91d0a ses agent 4907 2 it contains the session id of the user cuah auto call on start time 32 timestamp without time zone 06/24/14 12 48 pm it contains the time when user set auto call on status cuah auto call on end time 33 timestamp without time zone 06/24/14 12 48 pm it contains the time when user set auto call off status cuah auto call off end time 34 timestamp without time zone 06/24/14 12 48 pm it contains the time when user set auto call on status again cuah end reason 35 character varying agent selected campaign it is the auto call end reason cuah contact center id 36 integer 1 it is the id of the contact centre cuah auto call start reason 37 character varying agent set ready it contains the reason for which the auto call status has been changed to on cuah archive id 38 bigint 6 it is the archive id of campaign user auto call history (that is unique value per record in campaign user autocall history) curh contributed ready duration 39 bigint 0 it is the contributed ready duration in the interval curh ready tag 40 boolean curh contributed break duration 41 bigint 7749 it is the contributed break duration in the interval curh break tag 42 boolean curh total ready duration 43 bigint 0 it is the total ready duration of the user curh total break duration 44 bigint 7749 it is the total break duration of the user cuah contributed auto call on duration 45 bigint 0 it is the total contributed auto call on duration in the interval cuah contributed auto call off duration 46 bigint 7749 it is the total contributed auto call off duration in the interval cuah total auto call on duration 47 bigint 0 it is the total auto call on duration in the interval cuah total auto call off duration 48 bigint 7749 it is the total auto call off duration in the interval cuah interval start time 49 timestamp without time zone 06/24/14 12 40 pm it is the interval start time for the campaign user auto call history cuah interval end time 50 timestamp without time zone 06/24/14 12 40 pm it is the interval end time for the campaign user auto call history curh interval start time 51 timestamp without time zone 06/24/14 12 40 pm it is the interval start time for the campaign user ready history curh interval end time 52 timestamp without time zone 06/24/14 12 40 pm it is the interval end time for the campaign user ready history curh rec no 53 integer 1 it is the curh rec numbers when split in intervals cuah rec no 54 integer 1 it is the cuah record number when split in intervals ush rec no 55 integer 1 it contains the ush record number when split in intervals curh record number in interval 56 integer 1 it is total number of curh rec number in interval (count increases with join entries) ush record number in interval 57 integer 1 it is the ush rec number in interval (count increases with join entries) campaign name 58 character varying outbound it is the name of the campaign process name 59 character varying outbound it is the name of the process username 60 character varying agent it contains the name of the user interval start 30 minutes 61 timestamp without time zone 06/24/14 12 30 pm it is the start time of the 30 minute interval interval end 30 minutes 62 timestamp without time zone 06/24/14 12 30 pm it is the end time of the 30 minute interval interval start hour 63 timestamp without time zone 06/24/14 12 30 pm it is the start time of the 1 hour interval interval end hour 64 timestamp without time zone 06/24/14 12 30 pm it is the end time of the 1 hour interval interval start day 65 timestamp without time zone 06/24/14 12 30 pm it contains the start time of the day interval interval end day 66 timestamp without time zone 06/24/14 12 30 pm it contains the end time of the day interval