| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| AUDIT_TIMESTAMP |
date |
7 |
|
|
|
|
|
| AUDIT_TRANSACTION_TYPE |
varchar2 |
1 |
|
|
|
|
|
| AUDIT_USER_NAME |
varchar2 |
100 |
|
|
|
|
|
| AUDIT_TRUE_NULLS |
varchar2 |
250 |
√ |
|
null |
|
|
| AGENCY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| AGENCY_DESC |
varchar2 |
40 |
√ |
|
null |
|
|
| AGENCY_STREET |
varchar2 |
100 |
√ |
|
null |
|
|
| AGENCY_CITY |
varchar2 |
15 |
√ |
|
null |
|
|
| AGENCY_STATE |
varchar2 |
2 |
√ |
|
null |
|
|
| AGENCY_ZIP |
number |
0 |
√ |
|
null |
|
|
| AGENCY_COUNTY |
varchar2 |
100 |
√ |
|
null |
|
|
| AGENCY_FAX |
number |
0 |
√ |
|
null |
|
|
| AGENCY_PHONE |
number |
0 |
√ |
|
null |
|
|
| ORI_NUMBER |
varchar2 |
9 |
√ |
|
null |
|
|
| INTERNAL_OFFENSES |
varchar2 |
1 |
√ |
|
null |
|
|
| DEF_LEA_SEC_LEVEL |
number |
38 |
√ |
|
null |
|
|
| DISPATCH_ENABLED |
varchar2 |
1 |
√ |
|
null |
|
|
| PWD_EXPIRE_DAYS |
number |
3 |
√ |
|
null |
|
|
| LABEL_PRINTER |
varchar2 |
40 |
√ |
|
null |
|
|
| UCR_REQUIRED |
varchar2 |
1 |
√ |
|
null |
|
|
| LEA_CASE_UPDATE |
number |
3 |
√ |
|
null |
|
|
| RECORDS_AGENCY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| OFFICE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| UCR_CLERK |
varchar2 |
1 |
√ |
|
null |
|
|
| CAD_AGENCY_ID |
varchar2 |
30 |
√ |
|
null |
|
|
| JRD_AGENCY_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| LEVEL2_AGENCY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| POC_TITLE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| POC_NAME |
varchar2 |
100 |
√ |
|
null |
|
|
| AGENCY_DISPLAY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| DEFAULT_AGENCY_ONLY_FLG |
varchar2 |
1 |
√ |
|
null |
|
|
| DEFAULT_TIME_ZONE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| AGENCY_IMAGE_LOCATION |
varchar2 |
2000 |
√ |
|
null |
|
|
| JRD_AGENCY_TYPE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| OFFICE_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| POC_TITLE_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| WEBSITE_URL |
varchar2 |
255 |
√ |
|
null |
|
|
| DEFAULT_DSPLY_NOTIFY_ITEMS |
number |
0 |
√ |
|
null |
|
|
| TIME_ZONE_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| REC_ID |
number |
0 |
√ |
|
null |
|
|
| NIBR_CITY_INDICATOR |
varchar2 |
4 |
√ |
|
null |
|
|
| IMAGE_ID |
number |
38 |
√ |
|
null |
|
| IMAGES.IMAGE_ID
|
Implied Constraint R |
|
| JS_ORGANIZATION |
varchar2 |
100 |
√ |
|
null |
|
|
| CASE_GOOD_STANDING_DAYS |
number |
3 |
√ |
|
null |
|
|
| NO_OF_COMMENTS_TO_DISPLAY |
number |
3 |
√ |
|
null |
|
|
| DS_AGENCY_COUNTY |
varchar2 |
100 |
√ |
|
null |
|
|
| LATITUDE |
varchar2 |
30 |
√ |
|
null |
|
|
| LONGITUDE |
varchar2 |
30 |
√ |
|
null |
|
|
| SUPPORT_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| SUPPORT_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| LICENSED_USERS |
number |
0 |
√ |
|
null |
|
|
| SOLR_STATE |
varchar2 |
30 |
√ |
|
null |
|
|
| OPTION_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| OPTION_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| CREATOR_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| CREATOR_DATE |
date |
7 |
√ |
|
null |
|
|
| UPDATOR_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| UPDATOR_DATE |
date |
7 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
