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