Retrieve all entity types

get/admin/storedObjects/all
Internal-Use Only

Retrieves all entity types in the full representation.

Request Samples

1

Response Samples

1[
2 {
3 "id": 100924,
4 "createdBy": "sasboot",
5 "createdAt": "2023-06-23T20:47:03.513Z",
6 "lastUpdatedBy": "videmo",
7 "lastUpdatedAt": "2023-06-28T18:19:17.984Z",
8 "label": "Person",
9 "description": "Person",
10 "localizedLabels": [
11 {
12 "id": 102942,
13 "createdBy": "sasboot",
14 "createdAt": "2023-06-23T20:47:03.514Z",
15 "lastUpdatedBy": "sasboot",
16 "lastUpdatedAt": "2023-06-23T20:47:03.514Z",
17 "label": "Person",
18 "version": 0,
19 "localeCd": "en-US"
20 }
21 ],
22 "localizedDescriptions": [
23 {
24 "id": 101015,
25 "createdBy": "sasboot",
26 "createdAt": "2023-06-23T20:47:03.514Z",
27 "lastUpdatedBy": "sasboot",
28 "lastUpdatedAt": "2023-06-23T20:47:03.514Z",
29 "description": "Person",
30 "version": 0,
31 "localeCd": "en-US"
32 }
33 ],
34 "name": "person",
35 "dataStoreName": "DEFAULT_STORE",
36 "dataStoreDefaultSchemaName": "fdhdata",
37 "tableName": "person",
38 "systemReserved": false,
39 "historyEnabled": true,
40 "version": 6,
41 "validFromFieldName": "birthday",
42 "lastUpdatedAtTimeFieldName": "last_updated_at_dttm",
43 "createdAtTimeFieldName": "created_at_dttm",
44 "displayTextFields": [
45 {
46 "name": "first_name",
47 "displayIndex": 0
48 },
49 {
50 "name": "last_name",
51 "displayIndex": 1
52 }
53 ],
54 "dataStoreAssignedTimeZone": "Etc/UTC",
55 "solutionName": "sas_visual_investigator_default",
56 "solutionLabel": "SAS Visual Investigator",
57 "historyTableName": "person",
58 "lastUpdatedByUserIdFieldName": "last_updated_by_user_id",
59 "versionNumberFieldName": "version",
60 "createFlagHistoryColumnName": "created_flg",
61 "deleteFlagHistoryColumnName": "archived_flg",
62 "deleteTableName": "VdkDmdiNifqGgq8jOL3QwNHwZQxVkD",
63 "updateFlagHistoryColumnName": "updated_flg",
64 "type": "MANAGED",
65 "markerColor": "#0293a0",
66 "nodeShape": "square",
67 "nodeColor": "#ffffff",
68 "borderColor": "#BFBFBF",
69 "borderWidth": 1,
70 "scale": 1,
71 "nodeDecoration": {},
72 "elementGroupRoot": false,
73 "indexedForSearch": true,
74 "attachmentsIndexedForSearch": false,
75 "reindexRequired": false,
76 "fields": [
77 {
78 "id": 102858,
79 "createdBy": "sasboot",
80 "createdAt": "2023-06-23T20:47:03.515Z",
81 "lastUpdatedBy": "videmo",
82 "lastUpdatedAt": "2023-06-28T18:19:17.986Z",
83 "label": "Person Id",
84 "localizedLabels": [
85 {
86 "id": 102948,
87 "createdBy": "sasboot",
88 "createdAt": "2023-06-23T20:47:03.515Z",
89 "lastUpdatedBy": "sasboot",
90 "lastUpdatedAt": "2023-06-23T20:47:03.515Z",
91 "label": "Person Id",
92 "version": 0,
93 "localeCd": "en-US"
94 }
95 ],
96 "name": "id",
97 "columnName": "id",
98 "dataType": "STRING",
99 "length": 36,
100 "required": true,
101 "primaryKeyField": true,
102 "unique": true,
103 "autoGenerated": true,
104 "systemReserved": true,
105 "displayIndex": 0,
106 "version": 6,
107 "primaryKeySeqNo": 1,
108 "readOnly": true,
109 "indexedForSearch": true,
110 "showTimeZone": false,
111 "ownerName": "person",
112 "masked": false
113 },
114 {
115 "id": 102856,
116 "createdBy": "sasboot",
117 "createdAt": "2023-06-23T20:47:03.514Z",
118 "lastUpdatedBy": "videmo",
119 "lastUpdatedAt": "2023-06-28T18:19:17.986Z",
120 "label": "First Name",
121 "localizedLabels": [
122 {
123 "id": 102946,
124 "createdBy": "sasboot",
125 "createdAt": "2023-06-23T20:47:03.515Z",
126 "lastUpdatedBy": "sasboot",
127 "lastUpdatedAt": "2023-06-23T20:47:03.515Z",
128 "label": "First Name",
129 "version": 0,
130 "localeCd": "en-US"
131 }
132 ],
133 "name": "first_name",
134 "columnName": "first_name",
135 "dataType": "STRING",
136 "length": 15,
137 "required": true,
138 "primaryKeyField": false,
139 "unique": false,
140 "autoGenerated": false,
141 "systemReserved": false,
142 "displayIndex": 1,
143 "version": 6,
144 "readOnly": false,
145 "indexedForSearch": true,
146 "showTimeZone": false,
147 "ownerName": "person",
148 "masked": false
149 },
150 {
151 "id": 102859,
152 "createdBy": "sasboot",
153 "createdAt": "2023-06-23T20:47:03.515Z",
154 "lastUpdatedBy": "videmo",
155 "lastUpdatedAt": "2023-06-28T18:19:17.986Z",
156 "label": "Last Name",
157 "localizedLabels": [
158 {
159 "id": 102949,
160 "createdBy": "sasboot",
161 "createdAt": "2023-06-23T20:47:03.515Z",
162 "lastUpdatedBy": "sasboot",
163 "lastUpdatedAt": "2023-06-23T20:47:03.515Z",
164 "label": "Last Name",
165 "version": 0,
166 "localeCd": "en-US"
167 }
168 ],
169 "name": "last_name",
170 "columnName": "last_name",
171 "dataType": "STRING",
172 "length": 15,
173 "required": true,
174 "primaryKeyField": false,
175 "unique": false,
176 "autoGenerated": false,
177 "systemReserved": false,
178 "displayIndex": 2,
179 "version": 6,
180 "readOnly": false,
181 "indexedForSearch": true,
182 "showTimeZone": false,
183 "ownerName": "person",
184 "masked": false
185 },
186 {
187 "id": 102853,
188 "createdBy": "sasboot",
189 "createdAt": "2023-06-23T20:47:03.514Z",
190 "lastUpdatedBy": "videmo",
191 "lastUpdatedAt": "2023-06-28T18:19:17.986Z",
192 "label": "Birthday",
193 "localizedLabels": [
194 {
195 "id": 102943,
196 "createdBy": "sasboot",
197 "createdAt": "2023-06-23T20:47:03.514Z",
198 "lastUpdatedBy": "sasboot",
199 "lastUpdatedAt": "2023-06-23T20:47:03.514Z",
200 "label": "Birthday",
201 "version": 0,
202 "localeCd": "en-US"
203 }
204 ],
205 "name": "birthday",
206 "columnName": "birthday",
207 "dataType": "TIMESTAMP",
208 "required": false,
209 "primaryKeyField": false,
210 "unique": false,
211 "autoGenerated": false,
212 "systemReserved": false,
213 "displayIndex": 3,
214 "version": 6,
215 "readOnly": false,
216 "indexedForSearch": true,
217 "showTimeZone": false,
218 "ownerName": "person",
219 "masked": false
220 },
221 {
222 "id": 102862,
223 "createdBy": "sasboot",
224 "createdAt": "2023-06-23T20:47:03.515Z",
225 "lastUpdatedBy": "videmo",
226 "lastUpdatedAt": "2023-06-28T18:19:17.986Z",
227 "label": "Version",
228 "localizedLabels": [
229 {
230 "id": 102952,
231 "createdBy": "sasboot",
232 "createdAt": "2023-06-23T20:47:03.515Z",
233 "lastUpdatedBy": "sasboot",
234 "lastUpdatedAt": "2023-06-23T20:47:03.515Z",
235 "label": "Version",
236 "version": 0,
237 "localeCd": "en-US"
238 }
239 ],
240 "name": "version",
241 "columnName": "version",
242 "dataType": "LONG",
243 "required": true,
244 "primaryKeyField": false,
245 "unique": false,
246 "autoGenerated": false,
247 "systemReserved": true,
248 "displayIndex": 4,
249 "version": 6,
250 "readOnly": true,
251 "indexedForSearch": true,
252 "showTimeZone": false,
253 "ownerName": "person",
254 "masked": false
255 },
256 {
257 "id": 102855,
258 "createdBy": "sasboot",
259 "createdAt": "2023-06-23T20:47:03.514Z",
260 "lastUpdatedBy": "videmo",
261 "lastUpdatedAt": "2023-06-28T18:19:17.986Z",
262 "label": "Created By",
263 "localizedLabels": [
264 {
265 "id": 102945,
266 "createdBy": "sasboot",
267 "createdAt": "2023-06-23T20:47:03.514Z",
268 "lastUpdatedBy": "sasboot",
269 "lastUpdatedAt": "2023-06-23T20:47:03.514Z",
270 "label": "Created By",
271 "version": 0,
272 "localeCd": "en-US"
273 }
274 ],
275 "name": "created_by_user_id",
276 "columnName": "created_by_user_id",
277 "dataType": "STRING",
278 "length": 255,
279 "required": false,
280 "primaryKeyField": false,
281 "unique": false,
282 "autoGenerated": false,
283 "systemReserved": true,
284 "displayIndex": 5,
285 "version": 6,
286 "readOnly": true,
287 "indexedForSearch": true,
288 "showTimeZone": false,
289 "ownerName": "person",
290 "masked": false
291 },
292 {
293 "id": 102854,
294 "createdBy": "sasboot",
295 "createdAt": "2023-06-23T20:47:03.514Z",
296 "lastUpdatedBy": "videmo",
297 "lastUpdatedAt": "2023-06-28T18:19:17.986Z",
298 "label": "Created At",
299 "localizedLabels": [
300 {
301 "id": 102944,
302 "createdBy": "sasboot",
303 "createdAt": "2023-06-23T20:47:03.514Z",
304 "lastUpdatedBy": "sasboot",
305 "lastUpdatedAt": "2023-06-23T20:47:03.514Z",
306 "label": "Created At",
307 "version": 0,
308 "localeCd": "en-US"
309 }
310 ],
311 "name": "created_at_dttm",
312 "columnName": "created_at_dttm",
313 "dataType": "TIMESTAMP",
314 "required": false,
315 "primaryKeyField": false,
316 "unique": false,
317 "autoGenerated": false,
318 "systemReserved": true,
319 "displayIndex": 6,
320 "version": 6,
321 "readOnly": true,
322 "indexedForSearch": true,
323 "showTimeZone": false,
324 "ownerName": "person",
325 "masked": false
326 },
327 {
328 "id": 102861,
329 "createdBy": "sasboot",
330 "createdAt": "2023-06-23T20:47:03.515Z",
331 "lastUpdatedBy": "videmo",
332 "lastUpdatedAt": "2023-06-28T18:19:17.986Z",
333 "label": "Last Updated By",
334 "localizedLabels": [
335 {
336 "id": 102951,
337 "createdBy": "sasboot",
338 "createdAt": "2023-06-23T20:47:03.515Z",
339 "lastUpdatedBy": "sasboot",
340 "lastUpdatedAt": "2023-06-23T20:47:03.515Z",
341 "label": "Last Updated By",
342 "version": 0,
343 "localeCd": "en-US"
344 }
345 ],
346 "name": "last_updated_by_user_id",
347 "columnName": "last_updated_by_user_id",
348 "dataType": "STRING",
349 "length": 255,
350 "required": false,
351 "primaryKeyField": false,
352 "unique": false,
353 "autoGenerated": false,
354 "systemReserved": true,
355 "displayIndex": 7,
356 "version": 6,
357 "readOnly": true,
358 "indexedForSearch": true,
359 "showTimeZone": false,
360 "ownerName": "person",
361 "masked": false
362 },
363 {
364 "id": 102860,
365 "createdBy": "sasboot",
366 "createdAt": "2023-06-23T20:47:03.515Z",
367 "lastUpdatedBy": "videmo",
368 "lastUpdatedAt": "2023-06-28T18:19:17.986Z",
369 "label": "Last Updated At",
370 "localizedLabels": [
371 {
372 "id": 102950,
373 "createdBy": "sasboot",
374 "createdAt": "2023-06-23T20:47:03.515Z",
375 "lastUpdatedBy": "sasboot",
376 "lastUpdatedAt": "2023-06-23T20:47:03.515Z",
377 "label": "Last Updated At",
378 "version": 0,
379 "localeCd": "en-US"
380 }
381 ],
382 "name": "last_updated_at_dttm",
383 "columnName": "last_updated_at_dttm",
384 "dataType": "TIMESTAMP",
385 "required": false,
386 "primaryKeyField": false,
387 "unique": false,
388 "autoGenerated": false,
389 "systemReserved": true,
390 "displayIndex": 8,
391 "version": 6,
392 "readOnly": true,
393 "indexedForSearch": true,
394 "showTimeZone": false,
395 "ownerName": "person",
396 "masked": false
397 },
398 {
399 "id": 102857,
400 "createdBy": "sasboot",
401 "createdAt": "2023-06-23T20:47:03.515Z",
402 "lastUpdatedBy": "videmo",
403 "lastUpdatedAt": "2023-06-28T18:19:17.986Z",
404 "label": "Gender",
405 "localizedLabels": [
406 {
407 "id": 102947,
408 "createdBy": "sasboot",
409 "createdAt": "2023-06-23T20:47:03.515Z",
410 "lastUpdatedBy": "sasboot",
411 "lastUpdatedAt": "2023-06-23T20:47:03.515Z",
412 "label": "Gender",
413 "version": 0,
414 "localeCd": "en-US"
415 }
416 ],
417 "name": "gender",
418 "columnName": "gender",
419 "dataType": "REFERENCE_DATA",
420 "length": 10,
421 "required": false,
422 "primaryKeyField": false,
423 "unique": false,
424 "autoGenerated": false,
425 "systemReserved": false,
426 "displayIndex": 9,
427 "version": 6,
428 "constrainingListName": "Gender",
429 "readOnly": false,
430 "indexedForSearch": true,
431 "showTimeZone": false,
432 "ownerName": "person",
433 "masked": false
434 },
435 {
436 "id": 103052,
437 "createdBy": "videmo",
438 "createdAt": "2023-06-28T17:22:53.701Z",
439 "lastUpdatedBy": "videmo",
440 "lastUpdatedAt": "2023-06-28T18:19:17.986Z",
441 "label": "Ps Inc",
442 "localizedLabels": [
443 {
444 "id": 103282,
445 "createdBy": "videmo",
446 "createdAt": "2023-06-28T17:22:53.702Z",
447 "lastUpdatedBy": "videmo",
448 "lastUpdatedAt": "2023-06-28T17:22:53.702Z",
449 "label": "Ps Inc",
450 "version": 0,
451 "localeCd": "en-US"
452 }
453 ],
454 "name": "ps_inc",
455 "columnName": "ps_inc",
456 "dataType": "NUMERIC",
457 "precision": 6,
458 "scale": 6,
459 "required": false,
460 "primaryKeyField": false,
461 "unique": false,
462 "autoGenerated": false,
463 "systemReserved": false,
464 "displayIndex": 10,
465 "version": 2,
466 "readOnly": false,
467 "indexedForSearch": true,
468 "showTimeZone": false,
469 "ownerName": "person",
470 "masked": false
471 }
472 ],
473 "relationshipsTo": [
474 {
475 "id": 101324,
476 "createdBy": "sasboot",
477 "createdAt": "2023-06-23T20:47:09.117Z",
478 "lastUpdatedBy": "sasboot",
479 "lastUpdatedAt": "2023-06-23T20:47:29.144Z",
480 "label": "Primary Victim",
481 "localizedLabels": [
482 {
483 "id": 103227,
484 "createdBy": "sasboot",
485 "createdAt": "2023-06-23T20:47:09.119Z",
486 "lastUpdatedBy": "sasboot",
487 "lastUpdatedAt": "2023-06-23T20:47:09.119Z",
488 "label": "Primary Victim",
489 "version": 0,
490 "localeCd": "en-US"
491 }
492 ],
493 "name": "primary_victim",
494 "dataStoreName": "DEFAULT_STORE",
495 "dataStoreDefaultSchemaName": "fdhdata",
496 "tableName": "primary_victim",
497 "systemReserved": false,
498 "historyEnabled": true,
499 "version": 1,
500 "lastUpdatedAtTimeFieldName": "last_updated_at_dttm",
501 "createdAtTimeFieldName": "created_at_dttm",
502 "dataStoreAssignedTimeZone": "Etc/UTC",
503 "solutionName": "sas_visual_investigator_default",
504 "solutionLabel": "SAS Visual Investigator",
505 "historyTableName": "primary_victim",
506 "lastUpdatedByUserIdFieldName": "last_updated_by_user_id",
507 "versionNumberFieldName": "version",
508 "createFlagHistoryColumnName": "created_flg",
509 "deleteFlagHistoryColumnName": "archived_flg",
510 "updateFlagHistoryColumnName": "updated_flg",
511 "reverseName": "police_report",
512 "reverseLabel": "Police Report",
513 "fromObjectName": "police_report",
514 "fromObjectLabel": "Police Report",
515 "toObjectName": "person",
516 "toObjectLabel": "Person",
517 "required": false,
518 "cascadeType": "NONE",
519 "cardinality": "MANY_TO_ONE",
520 "type": "LINK",
521 "symmetric": false,
522 "managed": true,
523 "joinConditions": [
524 {
525 "type": "Conditional",
526 "leftOperand": {
527 "type": "FieldRef",
528 "objectName": "police_report",
529 "fieldName": "id"
530 },
531 "rightOperands": [
532 {
533 "type": "FieldRef",
534 "objectName": "^RELATION^",
535 "fieldName": "police_report_id"
536 }
537 ],
538 "operator": "EQ"
539 },
540 {
541 "type": "Conditional",
542 "leftOperand": {
543 "type": "FieldRef",
544 "objectName": "^RELATION^",
545 "fieldName": "person_id"
546 },
547 "rightOperands": [
548 {
549 "type": "FieldRef",
550 "objectName": "person",
551 "fieldName": "id"
552 }
553 ],
554 "operator": "EQ"
555 }
556 ],
557 "fields": [
558 {
559 "id": 101570,
560 "createdBy": "sasboot",
561 "createdAt": "2023-06-23T20:47:09.119Z",
562 "lastUpdatedBy": "sasboot",
563 "lastUpdatedAt": "2023-06-23T20:47:29.144Z",
564 "label": "Auto Generated Sk",
565 "localizedLabels": [
566 {
567 "id": 103228,
568 "createdBy": "sasboot",
569 "createdAt": "2023-06-23T20:47:09.119Z",
570 "lastUpdatedBy": "sasboot",
571 "lastUpdatedAt": "2023-06-23T20:47:09.119Z",
572 "label": "Auto Generated Sk",
573 "version": 0,
574 "localeCd": "en-US"
575 }
576 ],
577 "name": "auto_generated_sk",
578 "columnName": "auto_generated_sk",
579 "dataType": "STRING",
580 "length": 36,
581 "required": true,
582 "primaryKeyField": true,
583 "unique": false,
584 "autoGenerated": true,
585 "systemReserved": true,
586 "displayIndex": 0,
587 "version": 1,
588 "primaryKeySeqNo": 1,
589 "readOnly": true,
590 "indexedForSearch": false,
591 "showTimeZone": false,
592 "ownerName": "police_report.primary_victim",
593 "masked": false
594 },
595 {
596 "id": 101576,
597 "createdBy": "sasboot",
598 "createdAt": "2023-06-23T20:47:09.120Z",
599 "lastUpdatedBy": "sasboot",
600 "lastUpdatedAt": "2023-06-23T20:47:29.144Z",
601 "label": "Police Report ID",
602 "localizedLabels": [
603 {
604 "id": 103234,
605 "createdBy": "sasboot",
606 "createdAt": "2023-06-23T20:47:09.120Z",
607 "lastUpdatedBy": "sasboot",
608 "lastUpdatedAt": "2023-06-23T20:47:09.120Z",
609 "label": "Police Report ID",
610 "version": 0,
611 "localeCd": "en-US"
612 }
613 ],
614 "name": "police_report_id",
615 "columnName": "police_report_id",
616 "dataType": "STRING",
617 "length": 36,
618 "required": true,
619 "primaryKeyField": false,
620 "unique": false,
621 "autoGenerated": false,
622 "systemReserved": true,
623 "displayIndex": 1,
624 "version": 1,
625 "readOnly": false,
626 "indexedForSearch": false,
627 "showTimeZone": false,
628 "ownerName": "police_report.primary_victim",
629 "masked": false
630 },
631 {
632 "id": 101575,
633 "createdBy": "sasboot",
634 "createdAt": "2023-06-23T20:47:09.119Z",
635 "lastUpdatedBy": "sasboot",
636 "lastUpdatedAt": "2023-06-23T20:47:29.144Z",
637 "label": "Person Id",
638 "localizedLabels": [
639 {
640 "id": 103233,
641 "createdBy": "sasboot",
642 "createdAt": "2023-06-23T20:47:09.120Z",
643 "lastUpdatedBy": "sasboot",
644 "lastUpdatedAt": "2023-06-23T20:47:09.120Z",
645 "label": "Person Id",
646 "version": 0,
647 "localeCd": "en-US"
648 }
649 ],
650 "name": "person_id",
651 "columnName": "person_id",
652 "dataType": "STRING",
653 "length": 36,
654 "required": true,
655 "primaryKeyField": false,
656 "unique": false,
657 "autoGenerated": false,
658 "systemReserved": true,
659 "displayIndex": 2,
660 "version": 1,
661 "readOnly": false,
662 "indexedForSearch": false,
663 "showTimeZone": false,
664 "ownerName": "police_report.primary_victim",
665 "masked": false
666 },
667 {
668 "id": 101577,
669 "createdBy": "sasboot",
670 "createdAt": "2023-06-23T20:47:09.120Z",
671 "lastUpdatedBy": "sasboot",
672 "lastUpdatedAt": "2023-06-23T20:47:29.144Z",
673 "label": "Version",
674 "localizedLabels": [
675 {
676 "id": 103235,
677 "createdBy": "sasboot",
678 "createdAt": "2023-06-23T20:47:09.120Z",
679 "lastUpdatedBy": "sasboot",
680 "lastUpdatedAt": "2023-06-23T20:47:09.120Z",
681 "label": "Version",
682 "version": 0,
683 "localeCd": "en-US"
684 }
685 ],
686 "name": "version",
687 "columnName": "version",
688 "dataType": "LONG",
689 "required": true,
690 "primaryKeyField": false,
691 "unique": false,
692 "autoGenerated": false,
693 "systemReserved": true,
694 "displayIndex": 3,
695 "version": 1,
696 "readOnly": true,
697 "indexedForSearch": false,
698 "showTimeZone": false,
699 "ownerName": "police_report.primary_victim",
700 "masked": false
701 },
702 {
703 "id": 101572,
704 "createdBy": "sasboot",
705 "createdAt": "2023-06-23T20:47:09.119Z",
706 "lastUpdatedBy": "sasboot",
707 "lastUpdatedAt": "2023-06-23T20:47:29.144Z",
708 "label": "Created By User Id",
709 "localizedLabels": [
710 {
711 "id": 103230,
712 "createdBy": "sasboot",
713 "createdAt": "2023-06-23T20:47:09.119Z",
714 "lastUpdatedBy": "sasboot",
715 "lastUpdatedAt": "2023-06-23T20:47:09.119Z",
716 "label": "Created By User Id",
717 "version": 0,
718 "localeCd": "en-US"
719 }
720 ],
721 "name": "created_by_user_id",
722 "columnName": "created_by_user_id",
723 "dataType": "STRING",
724 "length": 255,
725 "required": false,
726 "primaryKeyField": false,
727 "unique": false,
728 "autoGenerated": false,
729 "systemReserved": true,
730 "displayIndex": 4,
731 "version": 1,
732 "readOnly": true,
733 "indexedForSearch": false,
734 "showTimeZone": false,
735 "ownerName": "police_report.primary_victim",
736 "masked": false
737 },
738 {
739 "id": 101571,
740 "createdBy": "sasboot",
741 "createdAt": "2023-06-23T20:47:09.119Z",
742 "lastUpdatedBy": "sasboot",
743 "lastUpdatedAt": "2023-06-23T20:47:29.144Z",
744 "label": "Created at Date/Time",
745 "localizedLabels": [
746 {
747 "id": 103229,
748 "createdBy": "sasboot",
749 "createdAt": "2023-06-23T20:47:09.119Z",
750 "lastUpdatedBy": "sasboot",
751 "lastUpdatedAt": "2023-06-23T20:47:09.119Z",
752 "label": "Created at Date/Time",
753 "version": 0,
754 "localeCd": "en-US"
755 }
756 ],
757 "name": "created_at_dttm",
758 "columnName": "created_at_dttm",
759 "dataType": "TIMESTAMP",
760 "required": false,
761 "primaryKeyField": false,
762 "unique": false,
763 "autoGenerated": false,
764 "systemReserved": true,
765 "displayIndex": 5,
766 "version": 1,
767 "readOnly": true,
768 "indexedForSearch": false,
769 "showTimeZone": false,
770 "ownerName": "police_report.primary_victim",
771 "masked": false
772 },
773 {
774 "id": 101574,
775 "createdBy": "sasboot",
776 "createdAt": "2023-06-23T20:47:09.119Z",
777 "lastUpdatedBy": "sasboot",
778 "lastUpdatedAt": "2023-06-23T20:47:29.144Z",
779 "label": "Last Updated By User Id",
780 "localizedLabels": [
781 {
782 "id": 103232,
783 "createdBy": "sasboot",
784 "createdAt": "2023-06-23T20:47:09.119Z",
785 "lastUpdatedBy": "sasboot",
786 "lastUpdatedAt": "2023-06-23T20:47:09.119Z",
787 "7label": "Last Updated By User Id",
788 "version": 0,
789 "localeCd": "en-US"
790 }
791 ],
792 "name": "last_updated_by_user_id",
793 "columnName": "last_updated_by_user_id",
794 "dataType": "STRING",
795 "length": 255,
796 "required": false,
797 "primaryKeyField": false,
798 "unique": false,
799 "autoGenerated": false,
800 "systemReserved": true,
801 "displayIndex": 6,
802 "version": 1,
803 "readOnly": true,
804 "indexedForSearch": false,
805 "showTimeZone": false,
806 "ownerName": "police_report.primary_victim",
807 "masked": false
808 },
809 {
810 "id": 101573,
811 "createdBy": "sasboot",
812 "createdAt": "2023-06-23T20:47:09.119Z",
813 "lastUpdatedBy": "sasboot",
814 "lastUpdatedAt": "2023-06-23T20:47:29.144Z",
815 "label": "Last Updated at Date/Time",
816 "localizedLabels": [
817 {
818 "id": 103231,
819 "createdBy": "sasboot",
820 "createdAt": "2023-06-23T20:47:09.119Z",
821 "lastUpdatedBy": "sasboot",
822 "lastUpdatedAt": "2023-06-23T20:47:09.119Z",
823 "label": "Last Updated at Date/Time",
824 "version": 0,
825 "localeCd": "en-US"
826 }
827 ],
828 "name": "last_updated_at_dttm",
829 "columnName": "last_updated_at_dttm",
830 "dataType": "TIMESTAMP",
831 "required": false,
832 "primaryKeyField": false,
833 "unique": false,
834 "autoGenerated": false,
835 "systemReserved": true,
836 "displayIndex": 7,
837 "version": 1,
838 "readOnly": true,
839 "indexedForSearch": false,
840 "showTimeZone": false,
841 "ownerName": "police_report.primary_victim",
842 "masked": false
843 }
844 ],
845 "localizedReverseLabels": [
846 {
847 "id": 103236,
848 "createdBy": "sasboot",
849 "createdAt": "2023-06-23T20:47:09.120Z",
850 "lastUpdatedBy": "sasboot",
851 "lastUpdatedAt": "2023-06-23T20:47:09.120Z",
852 "label": "Police Report",
853 "version": 0,
854 "localeCd": "en-US"
855 }
856 ],
857 "useCustomIndex": false,
858 "color": "#c3c3c3",
859 "width": 1,
860 "dashType": "solid",
861 "reindexRequired": false,
862 "readOnly": false,
863 "qualifiedName": "police_report__primary_victim"
864 },
865 {
866 "id": 101323,
867 "createdBy": "sasboot",
868 "createdAt": "2023-06-23T20:47:08.750Z",
869 "lastUpdatedBy": "sasboot",
870 "lastUpdatedAt": "2023-06-23T20:47:29.363Z",
871 "label": "Witnessed by",
872 "localizedLabels": [
873 {
874 "id": 103216,
875 "createdBy": "sasboot",
876 "createdAt": "2023-06-23T20:47:08.753Z",
877 "lastUpdatedBy": "sasboot",
878 "lastUpdatedAt": "2023-06-23T20:47:08.753Z",
879 "label": "Witnessed by",
880 "version": 0,
881 "localeCd": "en-US"
882 }
883 ],
884 "name": "witnessed_by",
885 "dataStoreName": "DEFAULT_STORE",
886 "dataStoreDefaultSchemaName": "fdhdata",
887 "tableName": "witnessed_by",
888 "systemReserved": false,
889 "historyEnabled": true,
890 "version": 1,
891 "lastUpdatedAtTimeFieldName": "last_updated_at_dttm",
892 "createdAtTimeFieldName": "created_at_dttm",
893 "dataStoreAssignedTimeZone": "Etc/UTC",
894 "solutionName": "sas_visual_investigator_default",
895 "solutionLabel": "SAS Visual Investigator",
896 "historyTableName": "witnessed_by",
897 "lastUpdatedByUserIdFieldName": "last_updated_by_user_id",
898 "versionNumberFieldName": "version",
899 "createFlagHistoryColumnName": "created_flg",
900 "deleteFlagHistoryColumnName": "archived_flg",
901 "updateFlagHistoryColumnName": "updated_flg",
902 "reverseName": "witnessed",
903 "reverseLabel": "Witnessed",
904 "fromObjectName": "intel_report",
905 "fromObjectLabel": "Intelligence Report",
906 "toObjectName": "person",
907 "toObjectLabel": "Person",
908 "required": false,
909 "cascadeType": "NONE",
910 "cardinality": "MANY_TO_MANY",
911 "type": "LINK",
912 "symmetric": false,
913 "managed": true,
914 "joinConditions": [
915 {
916 "type": "Conditional",
917 "leftOperand": {
918 "type": "FieldRef",
919 "objectName": "intel_report",
920 "fieldName": "id"
921 },
922 "rightOperands": [
923 {
924 "type": "FieldRef",
925 "objectName": "^RELATION^",
926 "fieldName": "intelReportId"
927 }
928 ],
929 "operator": "EQ"
930 },
931 {
932 "type": "Conditional",
933 "leftOperand": {
934 "type": "FieldRef",
935 "objectName": "^RELATION^",
936 "fieldName": "personId"
937 },
938 "rightOperands": [
939 {
940 "type": "FieldRef",
941 "objectName": "person",
942 "fieldName": "id"
943 }
944 ],
945 "operator": "EQ"
946 }
947 ],
948 "fields": [
949 {
950 "id": 101561,
951 "createdBy": "sasboot",
952 "createdAt": "2023-06-23T20:47:08.753Z",
953 "lastUpdatedBy": "sasboot",
954 "lastUpdatedAt": "2023-06-23T20:47:29.363Z",
955 "label": "Auto Generated Sk",
956 "localizedLabels": [
957 {
958 "id": 103217,
959 "createdBy": "sasboot",
960 "createdAt": "2023-06-23T20:47:08.753Z",
961 "lastUpdatedBy": "sasboot",
962 "lastUpdatedAt": "2023-06-23T20:47:08.753Z",
963 "label": "Auto Generated Sk",
964 "version": 0,
965 "localeCd": "en-US"
966 }
967 ],
968 "name": "auto_generated_sk",
969 "columnName": "auto_generated_sk",
970 "dataType": "STRING",
971 "length": 36,
972 "required": true,
973 "primaryKeyField": true,
974 "unique": false,
975 "autoGenerated": true,
976 "systemReserved": true,
977 "displayIndex": 0,
978 "version": 1,
979 "primaryKeySeqNo": 1,
980 "readOnly": true,
981 "indexedForSearch": false,
982 "showTimeZone": false,
983 "ownerName": "intel_report.witnessed_by",
984 "masked": false
985 },
986 {
987 "id": 101568,
988 "createdBy": "sasboot",
989 "createdAt": "2023-06-23T20:47:08.754Z",
990 "lastUpdatedBy": "sasboot",
991 "lastUpdatedAt": "2023-06-23T20:47:29.363Z",
992 "label": "Person Id",
993 "localizedLabels": [
994 {
995 "id": 103224,
996 "createdBy": "sasboot",
997 "createdAt": "2023-06-23T20:47:08.754Z",
998 "lastUpdatedBy": "sasboot",
999 "lastUpdatedAt": "2023-06-23T20:47:08.754Z",
1000 "label": "Person Id",
1001 "version": 0,
1002 "localeCd": "en-US"
1003 }
1004 ],
1005 "name": "personId",
1006 "columnName": "person_id",
1007 "dataType": "STRING",
1008 "length": 36,
1009 "required": true,
1010 "primaryKeyField": false,
1011 "unique": false,
1012 "autoGenerated": false,
1013 "systemReserved": true,
1014 "displayIndex": 1,
1015 "version": 1,
1016 "readOnly": false,
1017 "indexedForSearch": false,
1018 "showTimeZone": false,
1019 "ownerName": "intel_report.witnessed_by",
1020 "masked": false
1021 },
1022 {
1023 "id": 101565,
1024 "createdBy": "sasboot",
1025 "createdAt": "2023-06-23T20:47:08.753Z",
1026 "lastUpdatedBy": "sasboot",
1027 "lastUpdatedAt": "2023-06-23T20:47:29.363Z",
1028 "label": "Report Id",
1029 "localizedLabels": [
1030 {
1031 "id": 103221,
1032 "createdBy": "sasboot",
1033 "createdAt": "2023-06-23T20:47:08.753Z",
1034 "lastUpdatedBy": "sasboot",
1035 "lastUpdatedAt": "2023-06-23T20:47:08.753Z",
1036 "label": "Report Id",
1037 "version": 0,
1038 "localeCd": "en-US"
1039 }
1040 ],
1041 "name": "intelReportId",
1042 "columnName": "intel_report_id",
1043 "dataType": "STRING",
1044 "length": 36,
1045 "required": true,
1046 "primaryKeyField": false,
1047 "unique": false,
1048 "autoGenerated": false,
1049 "systemReserved": true,
1050 "displayIndex": 1,
1051 "version": 1,
1052 "readOnly": false,
1053 "indexedForSearch": false,
1054 "showTimeZone": false,
1055 "ownerName": "intel_report.witnessed_by",
1056 "masked": false
1057 },
1058 {
1059 "id": 101564,
1060 "createdBy": "sasboot",
1061 "createdAt": "2023-06-23T20:47:08.753Z",
1062 "lastUpdatedBy": "sasboot",
1063 "lastUpdatedAt": "2023-06-23T20:47:29.363Z",
1064 "label": "Description",
1065 "localizedLabels": [
1066 {
1067 "id": 103220,
1068 "createdBy": "sasboot",
1069 "createdAt": "2023-06-23T20:47:08.753Z",
1070 "lastUpdatedBy": "sasboot",
1071 "lastUpdatedAt": "2023-06-23T20:47:08.753Z",
1072 "label": "Description",
1073 "version": 0,
1074 "localeCd": "en-US"
1075 }
1076 ],
1077 "name": "description",
1078 "columnName": "description",
1079 "dataType": "STRING",
1080 "length": 100,
1081 "required": false,
1082 "primaryKeyField": false,
1083 "unique": false,
1084 "autoGenerated": false,
1085 "systemReserved": false,
1086 "displayIndex": 2,
1087 "version": 1,
1088 "readOnly": false,
1089 "indexedForSearch": false,
1090 "showTimeZone": false,
1091 "ownerName": "intel_report.witnessed_by",
1092 "masked": false
1093 },
1094 {
1095 "id": 101569,
1096 "createdBy": "sasboot",
1097 "createdAt": "2023-06-23T20:47:08.754Z",
1098 "lastUpdatedBy": "sasboot",
1099 "lastUpdatedAt": "2023-06-23T20:47:29.364Z",
1100 "label": "Version",
1101 "localizedLabels": [
1102 {
1103 "id": 103225,
1104 "createdBy": "sasboot",
1105 "createdAt": "2023-06-23T20:47:08.754Z",
1106 "lastUpdatedBy": "sasboot",
1107 "lastUpdatedAt": "2023-06-23T20:47:08.754Z",
1108 "label": "Version",
1109 "version": 0,
1110 "localeCd": "en-US"
1111 }
1112 ],
1113 "name": "version",
1114 "columnName": "version",
1115 "dataType": "LONG",
1116 "required": true,
1117 "primaryKeyField": false,
1118 "unique": false,
1119 "autoGenerated": false,
1120 "systemReserved": true,
1121 "displayIndex": 3,
1122 "version": 1,
1123 "readOnly": true,
1124 "indexedForSearch": false,
1125 "showTimeZone": false,
1126 "ownerName": "intel_report.witnessed_by",
1127 "masked": false
1128 },
1129 {
1130 "id": 101563,
1131 "createdBy": "sasboot",
1132 "createdAt": "2023-06-23T20:47:08.753Z",
1133 "lastUpdatedBy": "sasboot",
1134 "lastUpdatedAt": "2023-06-23T20:47:29.364Z",
1135 "label": "Created By User Id",
1136 "localizedLabels": [
1137 {
1138 "id": 103219,
1139 "createdBy": "sasboot",
1140 "createdAt": "2023-06-23T20:47:08.753Z",
1141 "lastUpdatedBy": "sasboot",
1142 "lastUpdatedAt": "2023-06-23T20:47:08.753Z",
1143 "label": "Created By User Id",
1144 "version": 0,
1145 "localeCd": "en-US"
1146 }
1147 ],
1148 "name": "created_by_user_id",
1149 "columnName": "created_by_user_id",
1150 "dataType": "STRING",
1151 "length": 255,
1152 "required": false,
1153 "primaryKeyField": false,
1154 "unique": false,
1155 "autoGenerated": false,
1156 "systemReserved": true,
1157 "displayIndex": 4,
1158 "version": 1,
1159 "readOnly": true,
1160 "indexedForSearch": false,
1161 "showTimeZone": false,
1162 "ownerName": "intel_report.witnessed_by",
1163 "masked": false
1164 },
1165 {
1166 "id": 101562,
1167 "createdBy": "sasboot",
1168 "createdAt": "2023-06-23T20:47:08.753Z",
1169 "lastUpdatedBy": "sasboot",
1170 "lastUpdatedAt": "2023-06-23T20:47:29.364Z",
1171 "label": "Created at Date/Time",
1172 "localizedLabels": [
1173 {
1174 "id": 103218,
1175 "createdBy": "sasboot",
1176 "createdAt": "2023-06-23T20:47:08.753Z",
1177 "lastUpdatedBy": "sasboot",
1178 "lastUpdatedAt": "2023-06-23T20:47:08.753Z",
1179 "label": "Created at Date/Time",
1180 "version": 0,
1181 "localeCd": "en-US"
1182 }
1183 ],
1184 "name": "created_at_dttm",
1185 "columnName": "created_at_dttm",
1186 "dataType": "TIMESTAMP",
1187 "required": false,
1188 "primaryKeyField": false,
1189 "unique": false,
1190 "autoGenerated": false,
1191 "systemReserved": true,
1192 "displayIndex": 5,
1193 "version": 1,
1194 "readOnly": true,
1195 "indexedForSearch": false,
1196 "showTimeZone": false,
1197 "ownerName": "intel_report.witnessed_by",
1198 "masked": false
1199 },
1200 {
1201 "id": 101567,
1202 "createdBy": "sasboot",
1203 "createdAt": "2023-06-23T20:47:08.754Z",
1204 "lastUpdatedBy": "sasboot",
1205 "lastUpdatedAt": "2023-06-23T20:47:29.364Z",
1206 "label": "Last Updated By User Id",
1207 "localizedLabels": [
1208 {
1209 "id": 103223,
1210 "createdBy": "sasboot",
1211 "createdAt": "2023-06-23T20:47:08.754Z",
1212 "lastUpdatedBy": "sasboot",
1213 "lastUpdatedAt": "2023-06-23T20:47:08.754Z",
1214 "label": "Last Updated By User Id",
1215 "version": 0,
1216 "localeCd": "en-US"
1217 }
1218 ],
1219 "name": "last_updated_by_user_id",
1220 "columnName": "last_updated_by_user_id",
1221 "dataType": "STRING",
1222 "length": 255,
1223 "required": false,
1224 "primaryKeyField": false,
1225 "unique": false,
1226 "autoGenerated": false,
1227 "systemReserved": true,
1228 "displayIndex": 6,
1229 "version": 1,
1230 "readOnly": true,
1231 "indexedForSearch": false,
1232 "showTimeZone": false,
1233 "ownerName": "intel_report.witnessed_by",
1234 "masked": false
1235 },
1236 {
1237 "id": 101566,
1238 "createdBy": "sasboot",
1239 "createdAt": "2023-06-23T20:47:08.753Z",
1240 "lastUpdatedBy": "sasboot",
1241 "lastUpdatedAt": "2023-06-23T20:47:29.364Z",
1242 "label": "Last Updated at Date/Time",
1243 "localizedLabels": [
1244 {
1245 "id": 103222,
1246 "createdBy": "sasboot",
1247 "createdAt": "2023-06-23T20:47:08.753Z",
1248 "lastUpdatedBy": "sasboot",
1249 "lastUpdatedAt": "2023-06-23T20:47:08.753Z",
1250 "label": "Last Updated at Date/Time",
1251 "version": 0,
1252 "localeCd": "en-US"
1253 }
1254 ],
1255 "name": "last_updated_at_dttm",
1256 "columnName": "last_updated_at_dttm",
1257 "dataType": "TIMESTAMP",
1258 "required": false,
1259 "primaryKeyField": false,
1260 "unique": false,
1261 "autoGenerated": false,
1262 "systemReserved": true,
1263 "displayIndex": 7,
1264 "version": 1,
1265 "readOnly": true,
1266 "indexedForSearch": false,
1267 "showTimeZone": false,
1268 "ownerName": "intel_report.witnessed_by",
1269 "masked": false
1270 }
1271 ],
1272 "localizedReverseLabels": [
1273 {
1274 "id": 103226,
1275 "createdBy": "sasboot",
1276 "createdAt": "2023-06-23T20:47:08.754Z",
1277 "lastUpdatedBy": "sasboot",
1278 "lastUpdatedAt": "2023-06-23T20:47:08.754Z",
1279 "label": "Witnessed",
1280 "version": 0,
1281 "localeCd": "en-US"
1282 }
1283 ],
1284 "useCustomIndex": false,
1285 "color": "#c3c3c3",
1286 "width": 1,
1287 "dashType": "solid",
1288 "reindexRequired": false,
1289 "readOnly": false,
1290 "qualifiedName": "intel_report__witnessed_by"
1291 },
1292 {
1293 "id": 101321,
1294 "createdBy": "sasboot",
1295 "createdAt": "2023-06-23T20:47:08.039Z",
1296 "lastUpdatedBy": "sasboot",
1297 "lastUpdatedAt": "2023-06-23T20:47:30.024Z",
1298 "label": "Reported by",
1299 "localizedLabels": [
1300 {
1301 "id": 103196,
1302 "createdBy": "sasboot",
1303 "createdAt": "2023-06-23T20:47:08.042Z",
1304 "lastUpdatedBy": "sasboot",
1305 "lastUpdatedAt": "2023-06-23T20:47:08.042Z",
1306 "label": "Reported by",
1307 "version": 0,
1308 "localeCd": "en-US"
1309 }
1310 ],
1311 "name": "reported_by",
1312 "dataStoreName": "DEFAULT_STORE",
1313 "dataStoreDefaultSchemaName": "fdhdata",
1314 "tableName": "reported_by",
1315 "systemReserved": false,
1316 "historyEnabled": false,
1317 "version": 1,
1318 "lastUpdatedAtTimeFieldName": "last_updated_at_dttm",
1319 "createdAtTimeFieldName": "created_at_dttm",
1320 "dataStoreAssignedTimeZone": "Etc/UTC",
1321 "solutionName": "sas_visual_investigator_default",
1322 "solutionLabel": "SAS Visual Investigator",
1323 "historyTableName": "reported_by",
1324 "lastUpdatedByUserIdFieldName": "last_updated_by_user_id",
1325 "versionNumberFieldName": "version",
1326 "createFlagHistoryColumnName": "created_flg",
1327 "deleteFlagHistoryColumnName": "archived_flg",
1328 "updateFlagHistoryColumnName": "updated_flg",
1329 "reverseName": "reported",
1330 "reverseLabel": "Reported",
1331 "fromObjectName": "intel_report",
1332 "fromObjectLabel": "Intelligence Report",
1333 "toObjectName": "person",
1334 "toObjectLabel": "Person",
1335 "required": false,
1336 "cascadeType": "NONE",
1337 "cardinality": "MANY_TO_MANY",
1338 "type": "LINK",
1339 "symmetric": false,
1340 "managed": true,
1341 "joinConditions": [
1342 {
1343 "type": "Conditional",
1344 "leftOperand": {
1345 "type": "FieldRef",
1346 "objectName": "intel_report",
1347 "fieldName": "id"
1348 },
1349 "rightOperands": [
1350 {
1351 "type": "FieldRef",
1352 "objectName": "^RELATION^",
1353 "fieldName": "intelReportId"
1354 }
1355 ],
1356 "operator": "EQ"
1357 },
1358 {
1359 "type": "Conditional",
1360 "leftOperand": {
1361 "type": "FieldRef",
1362 "objectName": "^RELATION^",
1363 "fieldName": "personId"
1364 },
1365 "rightOperands": [
1366 {
1367 "type": "FieldRef",
1368 "objectName": "person",
1369 "fieldName": "id"
1370 }
1371 ],
1372 "operator": "EQ"
1373 }
1374 ],
1375 "fields": [
1376 {
1377 "id": 101545,
1378 "createdBy": "sasboot",
1379 "createdAt": "2023-06-23T20:47:08.042Z",
1380 "lastUpdatedBy": "sasboot",
1381 "lastUpdatedAt": "2023-06-23T20:47:30.024Z",
1382 "label": "Auto Generated Sk",
1383 "localizedLabels": [
1384 {
1385 "id": 103197,
1386 "createdBy": "sasboot",
1387 "createdAt": "2023-06-23T20:47:08.043Z",
1388 "lastUpdatedBy": "sasboot",
1389 "lastUpdatedAt": "2023-06-23T20:47:08.043Z",
1390 "label": "Auto Generated Sk",
1391 "version": 0,
1392 "localeCd": "en-US"
1393 }
1394 ],
1395 "name": "auto_generated_sk",
1396 "columnName": "auto_generated_sk",
1397 "dataType": "STRING",
1398 "length": 36,
1399 "required": true,
1400 "primaryKeyField": true,
1401 "unique": false,
1402 "autoGenerated": true,
1403 "systemReserved": true,
1404 "displayIndex": 0,
1405 "version": 1,
1406 "primaryKeySeqNo": 1,
1407 "readOnly": true,
1408 "indexedForSearch": false,
1409 "showTimeZone": false,
1410 "ownerName": "intel_report.reported_by",
1411 "masked": false
1412 },
1413 {
1414 "id": 101548,
1415 "createdBy": "sasboot",
1416 "createdAt": "2023-06-23T20:47:08.043Z",
1417 "lastUpdatedBy": "sasboot",
1418 "lastUpdatedAt": "2023-06-23T20:47:30.024Z",
1419 "label": "Report Id",
1420 "localizedLabels": [
1421 {
1422 "id": 103200,
1423 "createdBy": "sasboot",
1424 "createdAt": "2023-06-23T20:47:08.043Z",
1425 "lastUpdatedBy": "sasboot",
1426 "lastUpdatedAt": "2023-06-23T20:47:08.043Z",
1427 "label": "Report Id",
1428 "version": 0,
1429 "localeCd": "en-US"
1430 }
1431 ],
1432 "name": "intelReportId",
1433 "columnName": "intel_report_id",
1434 "dataType": "STRING",
1435 "length": 36,
1436 "required": true,
1437 "primaryKeyField": false,
1438 "unique": false,
1439 "autoGenerated": false,
1440 "systemReserved": true,
1441 "displayIndex": 1,
1442 "version": 1,
1443 "readOnly": false,
1444 "indexedForSearch": false,
1445 "showTimeZone": false,
1446 "ownerName": "intel_report.reported_by",
1447 "masked": false
1448 },
1449 {
1450 "id": 101551,
1451 "createdBy": "sasboot",
1452 "createdAt": "2023-06-23T20:47:08.044Z",
1453 "lastUpdatedBy": "sasboot",
1454 "lastUpdatedAt": "2023-06-23T20:47:30.025Z",
1455 "label": "Person Id",
1456 "localizedLabels": [
1457 {
1458 "id": 103203,
1459 "createdBy": "sasboot",
1460 "createdAt": "2023-06-23T20:47:08.044Z",
1461 "lastUpdatedBy": "sasboot",
1462 "lastUpdatedAt": "2023-06-23T20:47:08.044Z",
1463 "label": "Person Id",
1464 "version": 0,
1465 "localeCd": "en-US"
1466 }
1467 ],
1468 "name": "personId",
1469 "columnName": "person_id",
1470 "dataType": "STRING",
1471 "length": 36,
1472 "required": true,
1473 "primaryKeyField": false,
1474 "unique": false,
1475 "autoGenerated": false,
1476 "systemReserved": true,
1477 "displayIndex": 1,
1478 "version": 1,
1479 "readOnly": false,
1480 "indexedForSearch": false,
1481 "showTimeZone": false,
1482 "ownerName": "intel_report.reported_by",
1483 "masked": false
1484 },
1485 {
1486 "id": 101552,
1487 "createdBy": "sasboot",
1488 "createdAt": "2023-06-23T20:47:08.044Z",
1489 "lastUpdatedBy": "sasboot",
1490 "lastUpdatedAt": "2023-06-23T20:47:30.025Z",
1491 "label": "Version",
1492 "localizedLabels": [
1493 {
1494 "id": 103204,
1495 "createdBy": "sasboot",
1496 "createdAt": "2023-06-23T20:47:08.044Z",
1497 "lastUpdatedBy": "sasboot",
1498 "lastUpdatedAt": "2023-06-23T20:47:08.044Z",
1499 "label": "Version",
1500 "version": 0,
1501 "localeCd": "en-US"
1502 }
1503 ],
1504 "name": "version",
1505 "columnName": "version",
1506 "dataType": "LONG",
1507 "required": true,
1508 "primaryKeyField": false,
1509 "unique": false,
1510 "autoGenerated": false,
1511 "systemReserved": true,
1512 "displayIndex": 4,
1513 "version": 1,
1514 "readOnly": true,
1515 "indexedForSearch": false,
1516 "showTimeZone": false,
1517 "ownerName": "intel_report.reported_by",
1518 "masked": false
1519 },
1520 {
1521 "id": 101547,
1522 "createdBy": "sasboot",
1523 "createdAt": "2023-06-23T20:47:08.043Z",
1524 "lastUpdatedBy": "sasboot",
1525 "lastUpdatedAt": "2023-06-23T20:47:30.025Z",
1526 "label": "Created By User Id",
1527 "localizedLabels": [
1528 {
1529 "id": 103199,
1530 "createdBy": "sasboot",
1531 "createdAt": "2023-06-23T20:47:08.043Z",
1532 "lastUpdatedBy": "sasboot",
1533 "lastUpdatedAt": "2023-06-23T20:47:08.043Z",
1534 "label": "Created By User Id",
1535 "version": 0,
1536 "localeCd": "en-US"
1537 }
1538 ],
1539 "name": "created_by_user_id",
1540 "columnName": "created_by_user_id",
1541 "dataType": "STRING",
1542 "length": 255,
1543 "required": false,
1544 "primaryKeyField": false,
1545 "unique": false,
1546 "autoGenerated": false,
1547 "systemReserved": true,
1548 "displayIndex": 5,
1549 "version": 1,
1550 "readOnly": true,
1551 "indexedForSearch": false,
1552 "showTimeZone": false,
1553 "ownerName": "intel_report.reported_by",
1554 "masked": false
1555 },
1556 {
1557 "id": 101546,
1558 "createdBy": "sasboot",
1559 "createdAt": "2023-06-23T20:47:08.043Z",
1560 "lastUpdatedBy": "sasboot",
1561 "lastUpdatedAt": "2023-06-23T20:47:30.025Z",
1562 "label": "Created at Date/Time",
1563 "localizedLabels": [
1564 {
1565 "id": 103198,
1566 "createdBy": "sasboot",
1567 "createdAt": "2023-06-23T20:47:08.043Z",
1568 "lastUpdatedBy": "sasboot",
1569 "lastUpdatedAt": "2023-06-23T20:47:08.043Z",
1570 "label": "Created at Date/Time",
1571 "version": 0,
1572 "localeCd": "en-US"
1573 }
1574 ],
1575 "name": "created_at_dttm",
1576 "columnName": "created_at_dttm",
1577 "dataType": "TIMESTAMP",
1578 "required": false,
1579 "primaryKeyField": false,
1580 "unique": false,
1581 "autoGenerated": false,
1582 "systemReserved": true,
1583 "displayIndex": 6,
1584 "version": 1,
1585 "readOnly": true,
1586 "indexedForSearch": false,
1587 "showTimeZone": false,
1588 "ownerName": "intel_report.reported_by",
1589 "masked": false
1590 },
1591 {
1592 "id": 101550,
1593 "createdBy": "sasboot",
1594 "createdAt": "2023-06-23T20:47:08.044Z",
1595 "lastUpdatedBy": "sasboot",
1596 "lastUpdatedAt": "2023-06-23T20:47:30.025Z",
1597 "label": "Last Updated By User Id",
1598 "localizedLabels": [
1599 {
1600 "id": 103202,
1601 "createdBy": "sasboot",
1602 "createdAt": "2023-06-23T20:47:08.044Z",
1603 "lastUpdatedBy": "sasboot",
1604 "lastUpdatedAt": "2023-06-23T20:47:08.044Z",
1605 "label": "Last Updated By User Id",
1606 "version": 0,
1607 "localeCd": "en-US"
1608 }
1609 ],
1610 "name": "last_updated_by_user_id",
1611 "columnName": "last_updated_by_user_id",
1612 "dataType": "STRING",
1613 "length": 255,
1614 "required": false,
1615 "primaryKeyField": false,
1616 "unique": false,
1617 "autoGenerated": false,
1618 "systemReserved": true,
1619 "displayIndex": 7,
1620 "version": 1,
1621 "readOnly": true,
1622 "indexedForSearch": false,
1623 "showTimeZone": false,
1624 "ownerName": "intel_report.reported_by",
1625 "masked": false
1626 },
1627 {
1628 "id": 101549,
1629 "createdBy": "sasboot",
1630 "createdAt": "2023-06-23T20:47:08.044Z",
1631 "lastUpdatedBy": "sasboot",
1632 "lastUpdatedAt": "2023-06-23T20:47:30.025Z",
1633 "label": "Last Updated at Date/Time",
1634 "localizedLabels": [
1635 {
1636 "id": 103201,
1637 "createdBy": "sasboot",
1638 "createdAt": "2023-06-23T20:47:08.044Z",
1639 "lastUpdatedBy": "sasboot",
1640 "lastUpdatedAt": "2023-06-23T20:47:08.044Z",
1641 "label": "Last Updated at Date/Time",
1642 "version": 0,
1643 "localeCd": "en-US"
1644 }
1645 ],
1646 "name": "last_updated_at_dttm",
1647 "columnName": "last_updated_at_dttm",
1648 "dataType": "TIMESTAMP",
1649 "required": false,
1650 "primaryKeyField": false,
1651 "unique": false,
1652 "autoGenerated": false,
1653 "systemReserved": true,
1654 "displayIndex": 8,
1655 "version": 1,
1656 "readOnly": true,
1657 "indexedForSearch": false,
1658 "showTimeZone": false,
1659 "ownerName": "intel_report.reported_by",
1660 "masked": false
1661 }
1662 ],
1663 "localizedReverseLabels": [
1664 {
1665 "id": 103205,
1666 "createdBy": "sasboot",
1667 "createdAt": "2023-06-23T20:47:08.044Z",
1668 "lastUpdatedBy": "sasboot",
1669 "lastUpdatedAt": "2023-06-23T20:47:08.044Z",
1670 "label": "Reported",
1671 "version": 0,
1672 "localeCd": "en-US"
1673 }
1674 ],
1675 "useCustomIndex": false,
1676 "color": "#c3c3c3",
1677 "width": 1,
1678 "dashType": "solid",
1679 "reindexRequired": false,
1680 "readOnly": false,
1681 "qualifiedName": "intel_report__reported_by"
1682 }
1683 ],
1684 "defaultRegularIcon": {
1685 "id": 1011,
1686 "createdBy": "sas.datahub",
1687 "createdAt": "2016-08-29T20:28:03.829Z",
1688 "lastUpdatedBy": "sas.svi-datahub",
1689 "lastUpdatedAt": "2023-06-23T20:22:49.225Z",
1690 "name": "Individual16Teal",
1691 "imageType": "SVG",
1692 "imageLocation": "/svi-datahub/icons/Individual16Teal/image",
1693 "version": 1,
1694 "solutionName": "sas_visual_investigator_default",
1695 "solutionLabel": "SAS Visual Investigator"
1696 },
1697 "allowElementGroupRootAssignment": false,
1698 "urnType": "UUID",
1699 "requireSearchBeforeCreate": false,
1700 "mobileOfflineEnabled": false,
1701 "enableCasDistributedDataLoad": false,
1702 "publishCode": "OPEN",
1703 "readOnly": false,
1704 "icons": [
1705 {
1706 "id": 1011,
1707 "createdBy": "sas.datahub",
1708 "createdAt": "2016-08-29T20:28:03.829Z",
1709 "lastUpdatedBy": "sas.svi-datahub",
1710 "lastUpdatedAt": "2023-06-23T20:22:49.225Z",
1711 "name": "Individual16Teal",
1712 "imageType": "SVG",
1713 "imageLocation": "/svi-datahub/icons/Individual16Teal/image",
1714 "version": 1,
1715 "solutionName": "sas_visual_investigator_default",
1716 "solutionLabel": "SAS Visual Investigator"
1717 }
1718 ]
1719 }
1720]

Query Parameters

NameTypeRequiredDescription
excludeUnauthorized
boolean
false

Specifies whether to exclude the results that the user is not authorized to view. Only administrative users can set this to true.

Default:
false

Responses

StatusMeaningDescription
200OKThe request succeeded.Schema