Adherence actual data with lookup expansion
CREATE VIEW vwadherenceactdata AS (
SELECT ad.userid,
ad.startdate,
ad.enddate,
ad.startdateltc,
ad.enddateltc,
ad.durationsecs,
((ad.durationsecs)::numeric / 86400.00) AS durationsecsday,
ad.actualactivitycategory,
ud.name AS agentname,
ud.managerid,
ud.managername
FROM (adherenceactdata 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 Date (UTC) | |||
| enddate | timestamp without time zone | true | End Time (UTC) | |||
| startdateltc | timestamp without time zone | true | Start Date (LTC) | |||
| enddateltc | timestamp without time zone | true | End Time (LTC) | |||
| durationsecs | integer | true | Duration in Sec(s) | |||
| durationsecsday | numeric | true | Durations seconds | |||
| actualactivitycategory | varchar(50) | true | Actual Activity Category | |||
| agentname | varchar(200) | true | Agent Name | |||
| managerid | varchar(50) | true | Manager GUID | |||
| managername | varchar(200) | true | Manager Name |
| Name | Columns | Comment | Type |
|---|---|---|---|
| public.adherenceactdata | 9 | Adherence Actual Activity Data | BASE TABLE |
| public.vwuserdetail | 18 | User details with manager and division context | VIEW |