View slot9.WORLD.TSTA.ZZV1_AGENCY_CODES
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
AUDIT_TIMESTAMP date 7  √  null
AUDIT_TRANSACTION_TYPE varchar2 1  √  null
AUDIT_USER_NAME varchar2 100  √  null
AUDIT_TRUE_NULLS varchar2 250  √  null
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE Implied Constraint R
AGENCY_DESC varchar2 40  √  null
AGENCY_STREET varchar2 100  √  null
AGENCY_CITY varchar2 40  √  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

View Definition:
SELECT ZZ1.AUDIT_TIMESTAMP AUDIT_TIMESTAMP, ZZ1.AUDIT_TRANSACTION_TYPE AUDIT_TRANSACTION_TYPE, ZZ1.AUDIT_USER_NAME AUDIT_USER_NAME, ZZ1.AUDIT_TRUE_NULLS AUDIT_TRUE_NULLS, ZZ1.AGENCY_CODE AGENCY_CODE, ZZ1.AGENCY_DESC AGENCY_DESC, ZZ1.AGENCY_STREET AGENCY_STREET, ZZ1.AGENCY_CITY AGENCY_CITY, ZZ1.AGENCY_STATE AGENCY_STATE, ZZ1.AGENCY_ZIP AGENCY_ZIP, ZZ1.AGENCY_COUNTY AGENCY_COUNTY, ZZ1.AGENCY_FAX AGENCY_FAX, ZZ1.AGENCY_PHONE AGENCY_PHONE, ZZ1.ORI_NUMBER ORI_NUMBER, ZZ1.INTERNAL_OFFENSES INTERNAL_OFFENSES, ZZ1.DEF_LEA_SEC_LEVEL DEF_LEA_SEC_LEVEL, ZZ1.DISPATCH_ENABLED DISPATCH_ENABLED, ZZ1.PWD_EXPIRE_DAYS PWD_EXPIRE_DAYS, ZZ1.LABEL_PRINTER LABEL_PRINTER, ZZ1.UCR_REQUIRED UCR_REQUIRED, ZZ1.LEA_CASE_UPDATE LEA_CASE_UPDATE, ZZ1.RECORDS_AGENCY_CODE RECORDS_AGENCY_CODE, ZZ1.OFFICE_CODE OFFICE_CODE, ZZ1.UCR_CLERK UCR_CLERK, ZZ1.CAD_AGENCY_ID CAD_AGENCY_ID, ZZ1.JRD_AGENCY_TYPE JRD_AGENCY_TYPE, ZZ1.LEVEL2_AGENCY_CODE LEVEL2_AGENCY_CODE, ZZ1.POC_TITLE_CODE POC_TITLE_CODE, ZZ1.POC_NAME POC_NAME, ZZ1.AGENCY_DISPLAY_CODE AGENCY_DISPLAY_CODE, ZZ1.DEFAULT_AGENCY_ONLY_FLG DEFAULT_AGENCY_ONLY_FLG, ZZ1.DEFAULT_TIME_ZONE_CODE DEFAULT_TIME_ZONE_CODE, ZZ1.AGENCY_IMAGE_LOCATION AGENCY_IMAGE_LOCATION, ZZ1.JRD_AGENCY_TYPE_TYPE JRD_AGENCY_TYPE_TYPE, ZZ1.OFFICE_CODE_TYPE OFFICE_CODE_TYPE, ZZ1.POC_TITLE_CODE_TYPE POC_TITLE_CODE_TYPE, ZZ1.WEBSITE_URL WEBSITE_URL, ZZ1.DEFAULT_DSPLY_NOTIFY_ITEMS DEFAULT_DSPLY_NOTIFY_ITEMS, ZZ1.TIME_ZONE_CODE_TYPE TIME_ZONE_CODE_TYPE, ZZ1.REC_ID REC_ID, ZZ1.NIBR_CITY_INDICATOR NIBR_CITY_INDICATOR, ZZ1.IMAGE_ID IMAGE_ID, ZZ1.JS_ORGANIZATION JS_ORGANIZATION, ZZ1.CASE_GOOD_STANDING_DAYS CASE_GOOD_STANDING_DAYS, ZZ1.NO_OF_COMMENTS_TO_DISPLAY NO_OF_COMMENTS_TO_DISPLAY, ZZ1.DS_AGENCY_COUNTY DS_AGENCY_COUNTY, ZZ1.LATITUDE LATITUDE, ZZ1.LONGITUDE LONGITUDE, ZZ1.SUPPORT_CODE SUPPORT_CODE, ZZ1.SUPPORT_CODE_TYPE SUPPORT_CODE_TYPE, ZZ1.LICENSED_USERS LICENSED_USERS, ZZ1.SOLR_STATE SOLR_STATE, ZZ1.OPTION_CODE_TYPE OPTION_CODE_TYPE, ZZ1.OPTION_CODE OPTION_CODE, ZZ1.CREATOR_ID CREATOR_ID, ZZ1.CREATOR_DATE CREATOR_DATE, ZZ1.UPDATOR_ID UPDATOR_ID, ZZ1.UPDATOR_DATE UPDATOR_DATE FROM ZZ_AGENCY_CODES ZZ1 union all select sysdate, 'C', null, null, ZZ2.AGENCY_CODE, ZZ2.AGENCY_DESC, ZZ2.AGENCY_STREET, ZZ2.AGENCY_CITY, ZZ2.AGENCY_STATE, ZZ2.AGENCY_ZIP, ZZ2.AGENCY_COUNTY, ZZ2.AGENCY_FAX, ZZ2.AGENCY_PHONE, ZZ2.ORI_NUMBER, ZZ2.INTERNAL_OFFENSES, ZZ2.DEF_LEA_SEC_LEVEL, ZZ2.DISPATCH_ENABLED, ZZ2.PWD_EXPIRE_DAYS, ZZ2.LABEL_PRINTER, ZZ2.UCR_REQUIRED, ZZ2.LEA_CASE_UPDATE, ZZ2.RECORDS_AGENCY_CODE, ZZ2.OFFICE_CODE, ZZ2.UCR_CLERK, ZZ2.CAD_AGENCY_ID, ZZ2.JRD_AGENCY_TYPE, ZZ2.LEVEL2_AGENCY_CODE, ZZ2.POC_TITLE_CODE, ZZ2.POC_NAME, ZZ2.AGENCY_DISPLAY_CODE, ZZ2.DEFAULT_AGENCY_ONLY_FLG, ZZ2.DEFAULT_TIME_ZONE_CODE, ZZ2.AGENCY_IMAGE_LOCATION, ZZ2.JRD_AGENCY_TYPE_TYPE, ZZ2.OFFICE_CODE_TYPE, ZZ2.POC_TITLE_CODE_TYPE, ZZ2.WEBSITE_URL, ZZ2.DEFAULT_DSPLY_NOTIFY_ITEMS, ZZ2.TIME_ZONE_CODE_TYPE, ZZ2.REC_ID, ZZ2.NIBR_CITY_INDICATOR, ZZ2.IMAGE_ID, ZZ2.JS_ORGANIZATION, ZZ2.CASE_GOOD_STANDING_DAYS, ZZ2.NO_OF_COMMENTS_TO_DISPLAY, ZZ2.DS_AGENCY_COUNTY, ZZ2.LATITUDE, ZZ2.LONGITUDE, ZZ2.SUPPORT_CODE, ZZ2.SUPPORT_CODE_TYPE, ZZ2.LICENSED_USERS, ZZ2.SOLR_STATE, ZZ2.OPTION_CODE_TYPE, ZZ2.OPTION_CODE, ZZ2.CREATOR_ID, ZZ2.CREATOR_DATE, ZZ2.UPDATOR_ID, ZZ2.UPDATOR_DATE FROM AGENCY_CODES ZZ2 where exists ( select * from ZZ_AGENCY_CODES where AGENCY_CODE= ZZ2.AGENCY_CODE )
 
Possibly Referenced Tables/Views:
AGENCY_CODES ZZ_AGENCY_CODES 


Close relationships: