public.budetails

public.budetails

Description

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) false
name varchar(50) true
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 See budetails table Table Definition CREATE VIEW vwbudetails AS ( SELECT budetails.id, budetails.name, budetails.updated FROM budetails ) Columns Name Type Default Nullable Children Parents Comment id varchar(50) true Primary Key name ...

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

      Description See WFMScheduleData: 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, ...

    • README

      Logo Genesys Adapter Data Dictionary Tables Name Columns Comment Type public.tabledefinitions 5 Subscription Detailed Data BASE TABLE public.activeqmembersdata 9 Historical Active Membership of Queues BASE TABLE public.activitycodedetails 11 Activity ...