public.budetails

public.budetails

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) false
name varchar(50) true
divisionid varchar(50) true Business Unit Division GUID
updated timestamp without time zone true

Constraints

Name Type Definition
bu2details_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
bu2details_pkey CREATE UNIQUE INDEX bu2details_pkey ON public.budetails USING btree (id)

    • Related Articles

    • public.vwbudetails

      Description Business unit details Table Definition CREATE VIEW vwbudetails AS ( SELECT bu.id, bu.name, bu.updated, bu.divisionid AS division_id, dd.name AS division_name FROM (budetails bu LEFT JOIN divisiondetails dd ON (((dd.id)::text = ...

    • public.vwplanninggroupbusinessunit

      Description Convenience view joining planning groups to their business units Table Definition CREATE VIEW vwplanninggroupbusinessunit AS ( SELECT pg.id AS planninggroupid, pg.name AS planninggroupname, pg.businessunitid AS ...

    • 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, ...

    • 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.z_wfmscheduledata

      Description WFM schedule data combining schedule and time off information Table Definition CREATE VIEW z_wfmscheduledata AS ( SELECT sc.userid, sc.shiftstartdate, sc.shiftlengthtime, sc.activitystartdate, sc.activitystartdateltc, ...