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