Adherence exception data with lookup expansion
CREATE VIEW vwadherenceexcdata AS (
SELECT ad.userid,
ad.startdate,
ad.enddate,
ad.startdateltc,
ad.enddateltc,
ad.durationsecs,
((ad.durationsecs)::numeric / 86400.00) AS durationsecsday,
ad.tolerance,
((ad.tolerance)::numeric / 86400.00) AS toleranceday,
ad.actualdurationsecs,
((ad.actualdurationsecs)::numeric / 86400.00) AS actualdurationsecsday,
ad.scheduledactivitycategory,
ad.actualactivitycategory,
ad.systempresence,
ad.routingstatus,
ad.impact,
ud.name AS agentname,
ud.managerid,
ud.managername
FROM (adherenceexcdata ad
LEFT JOIN vwuserdetail ud ON (((ud.id)::text = (ad.userid)::text)))
)| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| userid | varchar(50) | true | User GUID | |||
| startdate | timestamp without time zone | true | Start Time (UTC) | |||
| enddate | timestamp without time zone | true | ||||
| startdateltc | timestamp without time zone | true | Start Time (LTC) | |||
| enddateltc | timestamp without time zone | true | End Time (LTC) | |||
| durationsecs | integer | true | Total Duration of Exception in sec(s) - Tolerance Time in sec(s) | |||
| durationsecsday | numeric | true | Total Duration of Exception in sec(s) - Tolerance Time in sec(s) | |||
| tolerance | integer | true | The tolerance before exception starts | |||
| toleranceday | numeric | true | The tolerance Day before exception starts | |||
| actualdurationsecs | integer | true | The actual time of the exception | |||
| actualdurationsecsday | numeric | true | The actual time of the exception in seconds | |||
| scheduledactivitycategory | varchar(50) | true | The Activity Category | |||
| actualactivitycategory | varchar(50) | true | The Actual Activity Category | |||
| systempresence | varchar(50) | true | Presense GUID | |||
| routingstatus | varchar(50) | true | Routing Status GUID | |||
| impact | varchar(50) | true | Impact of the Exception | |||
| agentname | varchar(200) | true | Agent Name | |||
| managerid | varchar(50) | true | ||||
| managername | varchar(200) | true | Manager Name |
| Name | Columns | Comment | Type |
|---|---|---|---|
| public.adherenceexcdata | 15 | Adherence Detailed Exception Data | BASE TABLE |
| public.vwuserdetail | 18 | User details with manager and division context | VIEW |