Trigger entity type metadata reconstruction

post/admin/storedObjects/{entityTypeId}/reconstruct
Internal-Use Only

Synchronizes an entity type's field metadata with the schema for the database table that contains the entity type's records. This can be used to repair the entity type's metadata if the table that backs the entity type changes. Care should be taken when using this operation as it does not automatically update other services in SAS Visual Investigator to reflect the metadata changes. Users who do not understand how their metadata is used in SAS Visual Investigator or are not prepared to repair inconsistencies downstream from Data Hub are not advised to use this endpoint. The request body should be empty.

Request Samples

1

Response Samples

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

Path Parameters

NameTypeRequiredDescription
entityTypeId
string
true

The id of the entity type object.

Request Body

The request body should be empty.

No schema defined

Responses

StatusMeaningDescription
200OKThe request succeeded.Schema
400Bad RequestThe request was invalid.Schema
404Not FoundThe request did not find an entity type with a matching ID or the entity type was found but the table backing it was not found. Schema