public.vwmudetails

public.vwmudetails

Description

Management unit details

Table Definition 
CREATE VIEW vwmudetails AS (
 SELECT mu.id,
    mu.name,
    mu.startofweek,
    mu.timezone,
    mu.severealertthresholdminutes,
    mu.adherencetargetpercent,
    mu.adherenceexceptionthresholdseconds,
    mu.nononqueueactivitiesequivalent,
    mu.trackonqueueactivity,
    mu.updated,
    mu.businessunitid AS business_unit_id,
    bu.name AS business_unit_name,
    mu.divisionid AS division_id,
    dd.name AS division_name
   FROM ((mudetails mu
     LEFT JOIN budetails bu ON (((bu.id)::text = (mu.businessunitid)::text)))
     LEFT JOIN divisiondetails dd ON (((dd.id)::text = (mu.divisionid)::text)))
)

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) true Primary Key
name varchar(100) true Name
startofweek varchar(50) true Start of Week
timezone varchar(50) true Timezone
severealertthresholdminutes integer true Severe Alert Threshold Minutes
adherencetargetpercent numeric(20,2) true Adherence Target Percentage
adherenceexceptionthresholdseconds integer true
nononqueueactivitiesequivalent bit(1) true Non-On-Queue Activities Equivalent
trackonqueueactivity bit(1) true Track On-Queue Activity
updated timestamp without time zone true Last Updated
business_unit_id varchar(50) true Business Unit GUID
business_unit_name varchar(50) true Business Unit Name
division_id varchar(50) true Management Unit Division GUID
division_name varchar(50) true Management Unit Division Name

Referenced Tables

Name Columns Comment Type
public.mudetails 12 BASE TABLE
public.budetails 4 BASE TABLE
public.divisiondetails 5 BASE TABLE

    • Related Articles

    • README

      Logo Genesys Adapter Data Dictionary Tables Name Columns Comment Type public.tabledefinitions 5 Subscription Detailed Data BASE TABLE public.activeqmembersdata 9 Historical Active Membership of Queues BASE TABLE public.activitycodedetails 11 Activity ...

    • public.evalquestiondata

      Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false evaluationid varchar(50) false evaluationformid varchar(50) false questiongroupid varchar(50) true questionid varchar(50) true answerid varchar(50) true score ...

    • public.participantattributesdynamic

      Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false conversationid varchar(50) false conversationstartdate timestamp without time zone false conversationstartdateltc timestamp without time zone true conversationenddate ...

    • public.hoursblockdata

      Columns Name Type Default Nullable Children Parents Comment keyid varchar(200) false userid varchar(50) true startdate timestamp without time zone true startdateltc timestamp without time zone true enddate timestamp without time zone true enddateltc ...

    • public.userinteractionpresencedetaileddata

      Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false userid varchar(50) true starttime timestamp without time zone false starttimeltc timestamp without time zone true endtime timestamp without time zone true endtimeltc ...