public.timeoffdata

public.timeoffdata

Description

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(100) false
userid varchar(50) true Agent GUID
buid varchar(50) true Business Unit GUID
scheduleid varchar(50) true Schedule GUID
businessunitdate timestamp without time zone true Business Unit Date (UTC)
length integer true Length of Time Off (Seconds)
description varchar(200) true Description of Time Off
activitycode varchar(50) true Activity Code GUID
paid bit(1) true Paid Time Off (True/False)
timeoffrequestid varchar(50) true Time Off Request GUID
isfulldayrequest bit(1) true Is Full Day Request (True/False)
updated timestamp without time zone true Date Row Updated (UTC)

Constraints

Name Type Definition
timeoffdata_pkey PRIMARY KEY PRIMARY KEY (keyid)

Indexes

Name Definition
timeoffdata_pkey CREATE UNIQUE INDEX timeoffdata_pkey ON public.timeoffdata USING btree (keyid)

    • Related Articles

    • public.vwtimeoffdata

      Description See TimeOffData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwtimeoffdata AS ( SELECT td.userid, td.buid, td.scheduleid, td.businessunitdate, td.length, td.description, td.activitycode, td.paid, ...

    • public.vwscheduledatacomplete

      Description Combined view of schedule data and full-day time-off data - Use this view to see complete schedule including users on time-off Table Definition CREATE VIEW vwscheduledatacomplete AS ( SELECT sc.scheduleid, sc.userid, sc.shiftid, ...

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

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