Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Name

Description

Example

ticketid

This is the unique ticket id for this ticket

633b65d660

status

The current status of the ticket.

  • CLOSED

  • FOLLOW-UP

  • IN-PROGRESS

  • STARTED

IN-PROGRESS

personid

The unique id for the person for this ticket. This can be linked to people table.

804269c9-d60d-45a3-84ba-ce4a7cbbc82d

formdata

This is the JSON object that contains the form data that was entered into the form.

{comments=Renee would like a call back next week 10/20/22 she is currently going through a divorce TT, requesttype=IN-PROGRESS, attemptdata=null, appointmentdata=null, assessmentdata=null, additionalresourcesdata={}, closereason=null, additonalclientinfoformdata={}}

ticketentry

Information about how this ticket was created.

[{entry=Member Ticket Created for client hfhs, entrydatetime=1665572581558}]

person

This is the person’s name

{familyname=TEST, givenname=TESTER, language=English}

assignedto

The social navigator that this ticket is assigned to.

theresa.trowell@liveunitedsem.org

updateddate

The date that this ticket was last updated

10/12/2022

createddatetime

The time that this ticket was created. This is in epoch format

1665572581558

referralid

This will be the service request id that was created when the service request was submitted to CIE hub and that was shared with the service organization when the service request was forwarded to them.

928d2da1-b605-450b-b049-93c5cedae4d8

logs

This is a array of JSON objects that contains information about actions that have been taken on this member ticket. It includes attempt logs, appointment logs, assignment logs, and assessement logs. Please note below we have a view to get data out of the attempt logs

[{attemptlogs=[[10/12/2022, 11:06:28 am, theresa.trowell@liveunitedsem.org started attempt, 10/12/2022, 11:07:57 am, theresa.trowell@liveunitedsem.org has saved progress and ended this attempt., Renee would like a call back next week 10/20/22 she is currently going through a divorce TT]], appointmentlogs=[No Appointment Logs], assessmentlogs=[{string=No Assessment Logs, struct=null}], additionalresourceslogs=[No Addtional Resources Logs]}]

MemberTicket Attempts View

This is a cross join of the logs to get the attempts.

Name

Description

Example

ticketid

*See Above in the main table

status

*See Above in the main table

closereason

This is reason that the ticket was closed

Unable to contact

referralid

*See Above in the main table

personid

*See Above in the main table

person

*See Above in the main table

attempt_datetime

The date and time the attempt was made

attempt_log

Information about the attempt