Manual Ticket Data Model

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

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

Attribute Name	Attribute Type	Relationship Type	Required
`ageInDays`	Calculated (Number)	N/A	No
`assigned`	Reference (User)	`BELONGS_TO`	No
`attachments`	Attachments	N/A	No
`baseRiskScore`	Calculated (Number)	N/A	No
`buid`	Text	N/A	No
`__BRINQA_TAGS__`	Text (Multivalued)	N/A	No
`categories`	Text (Multivalued)	N/A	No
`comments`	Comments	N/A	No
`complianceStatus`	Calculated (Single Choice)	N/A	No
`components`	Text	N/A	No
`connectorCategories`	Text (Multivalued)	N/A	No
`connectorNames`	Text (Multivalued)	N/A	No
`createdBy`	Text	N/A	No
`dataIntegrationTitles`	Text (Multivalued)	N/A	No
`dataModelName`	Calculated (Text)	N/A	No
`dateClosed`	Calculated (Date Time)	N/A	No
`dateCreated`	Date Time	N/A	No
`daysToFix`	Calculated (Number)	N/A	No
`delegates`	Reference (User)	`DELEGATED_TO`	No
`description`	Text Area	N/A	No
`displayName`	Calculated (Text)	N/A	Yes
`dueDate`	Calculated (Date Time)	N/A	No
`externalUids*`	Text (Multivalued)	N/A	No
`externalUrls*`	URL (Multivalued)	N/A	No
`findings`	Reference (Manual finding)	`HAS`	No
`flowState`	Text	N/A	No
`issueType`	Text	N/A	No
`lastFailedPush*`	Date Time	N/A	No
`lastFailedPushTransactionId*`	Text	N/A	No
`lastPushTransactionId*`	Text	N/A	No
`lastPushed*`	Date Time	N/A	No
`lastPushedStatus*`	Single Choice	N/A	No
`lastUpdated`	Date Time	N/A	No
`name`	Text	N/A	No
`lifecycleInactiveDate`	Date Time	N/A	No
`lifecyclePurgeDate`	Date Time	N/A	No
`lifecycleStatus`	Single Choice	N/A	No
`previousFindings`	Reference (Manual finding)	`PREVIOUS_HAS`	No
`__PREVIOUS_STATUS__`	Calculated (Text)	N/A	No
`progress`	Number	N/A	No
`project`	Text	N/A	No
`recommendation`	Text	N/A	No
`remediationCampaigns`	Reference (Remediation campaign)	HAS	No
`riskFactorOffset`	Calculated (Number)	N/A	No
`riskFactors`	Risk Factors	N/A	No
`riskRating`	Calculated (Single Choice)	N/A	No
`riskScore`	Calculated (Number)	N/A	No
`riskScoringModel`	Risk Scoring Model	N/A	No
`sla`	Calculated (Number)	N/A	No
`slaDefinition`	SLA	N/A	No
`slaDefinitionName`	Text	N/A	No
`slaLevel`	Calculated (Text)	N/A	No
`slaUid`	Text	N/A	No
`sourceFirstFound`	Date Time	N/A	No
`sourceLastFound`	Date Time	N/A	No
`sourceStatus`	Text	N/A	No
`sourceUids`	Text (Multivalued)	N/A	No
`sources`	Reference (Source model)	`SOURCED_FROM`	No
`sourcesIcons`	Source data models icons	N/A	No
`sprint`	Reference (Sprint Model)	`BELONGS_TO`	No
`status`	Status	N/A	No
`statusCategory`	Calculated (Single Choice)	N/A	No
`summary`	Text	N/A	No
`uid`	Text	N/A	Yes
`updatedBy`	Text	N/A	No

FOOTNOTES

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. For additional information, see Calculated attributes.
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 Category and Reference type attributes. You can use the relationship type keyword in BQL queries.
Attributes labled with an asterisk (*) are only created when a mapping exists to sync tickets with external systems such as Jira or ServiceNow.