public.scheduledetails

Description

Schedule Details Lookup Data

Name	Type	Nullable	Comment
keyid	varchar(100)	false
businessunitid	varchar(50)	true	Schedule Business Unit GUID
scheduleid	varchar(50)	true
weekdate	date	true	Schedule Week
weekcount	bigint	true	Schedule Week Count
published	bit(1)	true	Schedule Published ?
shorttermforecastid	varchar(50)	true	Schedule Short Term Forecast GUID
modifiedby	varchar(50)	true	Schedule Modified By GUID
genresultsfailed	bit(1)	true	Schedule Results Failed ?
genresultsrunid	varchar(50)	true	Schedule Results GUID
updated	timestamp without time zone	true	Date Row Updated (UTC)
description	varchar(400)	true	Schedule Description

Name	Type	Definition
scheduledetails_pkey	PRIMARY KEY	PRIMARY KEY (keyid)

Name	Definition
scheduledetails_pkey	CREATE UNIQUE INDEX scheduledetails_pkey ON public.scheduledetails USING btree (keyid)

Related Articles
public.vwofferedforecast
Description Table Definition CREATE VIEW vwofferedforecast AS ( SELECT DISTINCT ofd.keyid, ofd.businessunitid, bu.name AS "BUSINESSUNITNAME", ofd.scheduleid, scd.description AS "SCHEDULEDESC", ofd.planninggroup AS "PLANNINGGROUPID", pgd.name AS ...
public.vwheadcountforecast
Description See HeadCountForecast - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwheadcountforecast AS ( SELECT hcf.businessunitid, bu.name AS businessunitname, hcf.planninggroup AS planninggroup_id, pg.name AS ...
public.participantattributesdynamic
Description 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 ...
public.evalquestiondata
Description 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 ...
public.userpresencedetaileddata
Description User Presence Detailed Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false Primary Key userid varchar(50) true Agent GUID starttime timestamp without time zone false Start Time (UTC) starttimeltc ...