The Ticket Data Model

The Ticket data model is a record that documents the interactions and progress made on a single or group of findings. It extends the Entity Model data model.

The following table details the default attributes of the Ticket data model:

Order	Attribute Name	Attribute Type	Relationship Type	Required
1	buid	Text	N/A	No
2	assigned	Reference (User)	BELONGS_TO	No
3	externalUids	Text	N/A	No
4	delegates	Reference (User)	DELEGATED_TO	No
5	findings	Reference (Finding)	HAS	No
6	previousFindings	Reference (Finding)	PREVIOUS_HAS	No
7	attachments	Attachments	N/A	No
8	status	Status	N/A	No
9	sourceFirstFound	Date Time	N/A	No
10	sourceLastFound	Date Time	N/A	No
11	recommendation	Text	N/A	No
12	statusCategory	Calculated (Single Choice)	N/A	No
13	riskScore	Calculated (Number)	N/A	No
14	riskRating	Calculated (Single Choice)	N/A	No
15	sprint	Reference (Sprint Model)	BELONGS_TO	No
16	slaDefinitionName	Text	N/A	No
17	progress	Number	N/A	No
18	dateClosed	Calculated (Date Time)	N/A	No
19	sla	Calculated (Number)	N/A	No
20	slaLevel	Calculated (Text)	N/A	No
21	dueDate	Calculated (Date Time)	N/A	No
22	complianceStatus	Calculated (Single Choice)	N/A	No
23	ageInDays	Calculated (Number)	N/A	No
24	riskScoringModel	Risk Scoring Model	N/A	No
25	slaDefinition	SLA	N/A	No
26	uid	Text	N/A	Yes
27	dataModelName	Calculated (Text)	N/A	No
28	sourceUids	Text (Multivalued)	N/A	No
29	connectorCategories	Text (Multivalued)	N/A	No
30	connectorNames	Text (Multivalued)	N/A	No
31	dataIntegrationTitles	Text (Multivalued)	N/A	No
32	sourcesIcons	Source data models icons	N/A	No
33	name	Text	N/A	No
34	displayName	Text	N/A	Yes
35	summary	Text	N/A	No
36	description	Text	N/A	No
37	categories	Text (Multivalued)	N/A	No
38	flowState	Text	N/A	No
39	sources	Reference (Base model)	SOURCED_FROM	No
40	dateCreated	Date Time	N/A	No
41	lastUpdated	Date Time	N/A	No
42	createdBy	Text	N/A	No
43	updatedBy	Text	N/A	No

FOOTNOTES

• The Order column specifies the order of attributes being calculated in data computation.
• The attribute names are used in Brinqa Query Language (BQL) queries and Brinqa Condition Language (BCL) predicates.
• In the Type column, Calculated means that the value of the attribute is computed by executing a script. The text in the parentheses after Calculated denotes the type of the outcome.
• In the Type column, Reference means that two data models are related. The name in the parentheses after Reference indicates the other data model.
• The Relationship Type column only applies to the Reference type attributes. You can use the relationship type keyword in BQL queries.