Retrieve an entity type object by name
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": false112 },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": false148 },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": false184 },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": false219 },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": false254 },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": false290 },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": false325 },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": false361 },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": false396 },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": false433 },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": false470 }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": false593 },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": false629 },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": false665 },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": false700 },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": false736 },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": false771 },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": false807 },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": false842 }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": false984 },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": false1020 },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": false1056 },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": false1092 },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": false1127 },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": false1163 },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": false1198 },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": false1234 },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": false1269 }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": false1411 },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": false1447 },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": false1483 },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": false1518 },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": false1554 },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": false1589 },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": false1625 },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": false1660 }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}