Time off request data with lookup expansion
CREATE VIEW vwtimeoffrequestdata AS (
SELECT tr.id,
tr.userid,
tr.isfulldayrequest,
tr.status,
tr.startdate,
tr.notes,
tr.timeoffduration,
tr.submittedbyid,
tr.submittedate,
tr.reviewedbyid,
tr.revieweddate,
tr.modifiedbyid,
tr.modifieddate,
ud.name AS agentname,
ud.managerid,
ud.managername
FROM (timeoffrequestdata tr
LEFT JOIN vwuserdetail ud ON (((ud.id)::text = (tr.userid)::text)))
)| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | varchar(50) | true | Time Off Request GUID | |||
| userid | varchar(50) | true | User GUID | |||
| isfulldayrequest | bit(1) | true | Full Day Request | |||
| status | varchar(50) | true | Request Status | |||
| startdate | timestamp without time zone | true | Start Date | |||
| notes | varchar(400) | true | Notes/Comments | |||
| timeoffduration | integer | true | Time Off Duration | |||
| submittedbyid | varchar(50) | true | Submitted By | |||
| submittedate | timestamp without time zone | true | Submission Date | |||
| reviewedbyid | varchar(50) | true | Reviewed By | |||
| revieweddate | timestamp without time zone | true | Review Date | |||
| modifiedbyid | varchar(50) | true | Last Modified By | |||
| modifieddate | timestamp without time zone | true | Last Modified Date | |||
| agentname | varchar(200) | true | Agent Name | |||
| managerid | varchar(50) | true | Manager GUID | |||
| managername | varchar(200) | true | Manager Name |
| Name | Columns | Comment | Type |
|---|---|---|---|
| public.timeoffrequestdata | 16 | WFM Time off requests entered by the Agents / or by proxys on their behalf | BASE TABLE |
| public.vwuserdetail | 18 | User details with manager and division context | VIEW |