fct_tickets


Description

Tickets that exist within Lookout. Tickets are used to enhance the workflow of a company by tracking responses and procedures to certain events.

Columns

Column Type Children Parents Comments
ticket_id int8
fct_helper_leave_periods.ticket_id Implied Constraint R
fct_helper_verification_renewals.ticket_id Implied Constraint R
fct_incidents.ticket_id Implied Constraint R
fct_purchase_orders.ticket_id Implied Constraint R
fct_ticket_assignees.ticket_id Implied Constraint R
fct_ticket_todos.ticket_id Implied Constraint R

The unique ticket ID, e.g. 101.
ticket_link text

A link to the ticket, e.g. https://app.carecompany.com.au/admin/tickets/101.
state text

The state of the ticket. One of four values - open, closed, archived_open, archived_closed.
opened_at timestamp

The date and time at which the ticket was created (in UTC), e.g.: 2021-03-02 00:12:59.996101.
due_at timestamp

The due date and time for the ticket resolution (in UTC), e.g.: 2021-03-02 00:12:59.996101.
priority bool

If the ticket is a priority or not. E.g. True or False.
ticket_category_id int8

The unique ID associated with the ticket category, e.g. 50.
category text

The category of the ticket after removing leading and trailing whitespace. E.g. Helper Requests.
subject_type varchar

The type of subject related to the ticket. One of Helper, Membership.
subject_id int8

The unique ID of the subject related to the ticket. If the subject_type is a helper, this is the helper_id. If the subect_type is a membership, this is the membership_id. E.g. 512.
subject_profile_id int4

The unique profile ID of the subject when the subject_type is either “Helper” or “Membership”, e.g. 543.
closed_at timestamp

The date and time at which the ticket was closed (in UTC), e.g.: 2021-03-02 00:12:59.996101.
hours_to_close numeric

The number of hours it took to close the ticket from creation, e.g. 52.
days_to_close numeric

The number of days it took to close the ticket from creation. E.g. 12.
hours_open numeric

The number of hours the ticket has been open for, if not closed yet, e.g. 24.
days_open numeric

The number of days the ticket has been open for, if not closed yet, e.g. 3.
days_until_due numeric

The number of days until the ticket is due, if not closed yet, e.g. 5.
is_archived bool

Whether a ticket has been archived or not. One of True or False.
author_profile_id int8

The unique profile ID of the ticket author, e.g. 55.
tags text

The tags associated with the ticket_tag_id, comma separated. E.g. Existing Member, Roster Change.
snoozed_until date

The date until which the ticket is visible. E.g. 2023-01-12.
created_at timestamp

The date and time at which the ticket was created (in UTC), e.g.: 2021-03-02 00:12:59.996101.
updated_at timestamp

The date and time at which the ticket was last updated (in UTC), e.g.: 2021-03-02 00:12:59.996101.
archived_at timestamp
company_id int8
dim_companies.company_id Implied Constraint R

The unique ID associated with the company. E.g. 51.

Indexes

Constraint Name Type Sort Column(s)
fct_tickets_pkey Primary key Asc ticket_id
fct_tickets_company_id_idx Performance Asc company_id
fct_tickets_subject_id_idx Performance Asc subject_id

Relationships

Close relationships within degrees of separation