public.timeoffrequestdata

public.timeoffrequestdata

Description

WFM Time off requests entered by the Agents / or by proxys on their behalf

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(100) false Primary Keyid
id varchar(50) true Time Off Request GUID
userid varchar(50) true Agent GUID
isfulldayrequest bit(1) true If this a Full Day off request (True/False)
status varchar(50) true Request Status
startdate timestamp without time zone true Request Start Date (UTC)
startdateltc timestamp without time zone true Request Start Date (LTC)
notes varchar(400) true Request Notes
timeoffduration integer true Request Duration
submittedbyid varchar(50) true Request Submitted By GUID
submittedate timestamp without time zone true Request Submitted Date (UTC)
reviewedbyid varchar(50) true Request Reviewed By GUID
revieweddate timestamp without time zone true Request Reviewed by Date (UTC)
modifiedbyid varchar(50) true Request Modified By GUID
modifieddate timestamp without time zone true Request Modified by Date (UTC)
updated timestamp without time zone true

Constraints

Name Type Definition
timeoffrequestdata_pkey PRIMARY KEY PRIMARY KEY (keyid)

Indexes

Name Definition
timeoffrequestdata_pkey CREATE UNIQUE INDEX timeoffrequestdata_pkey ON public.timeoffrequestdata USING btree (keyid)