public.timeoffdata

Description

Name	Type	Nullable	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)

Name	Type	Definition
timeoffdata_pkey	PRIMARY KEY	PRIMARY KEY (keyid)

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