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", ...
public.vwheadcountforecast
Description Headcount forecast data with lookup expansion Table Definition CREATE VIEW vwheadcountforecast AS ( SELECT hcf.businessunitid, bu.name AS businessunitname, pg.businessunitid AS planninggroup_businessunitid, hcf.planninggroup AS ...
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 ...