Table slot9.WORLD.TSTA.AGENCY_CODES
This table stores the agency information
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
AGENCY_CODE varchar2 30
ACCESS_LOGS.AGENCY_CODE ACLOGS_AGNCY_CD_FK R
ACTIVITY_CATEGORY_CODES.AGENCY_CODE ACTCC_AGNCY_CD_FK R
ACTIVITY_CODE_AGENCIES.AGENCY_CODE ACATCA_AGNCY_CD_FK R
ACTIVITY_RESULT_CODES.AGENCY_CODE ACT_RES_CODE_AGNCY_CD_FK R
ACTIVITY_TEMP_CODE_AGENCIES.AGENCY_CODE ACTTCA_AGNCY_CD_FK R
ACTIVITY_TEMPLATE_RESULTS.AGENCY_CODE Implied Constraint R
AGENCY_ADMINISTRATORS.AGENCY_CODE AGENCY_ADMIN_AGNCY_CD_FK R
AGENCY_API_KEYS.AGENCY_CODE AGAPIK_AGNCY_CD_FK C
AGENCY_ATTACHMENT_INTERFACES.AGENCY_CODE AGATTINT_AGNCY_CD_FK R
AGENCY_CASE_SUPERVISORS.AGENCY_CODE AGCASU_AGNCY_CD_FK C
AGENCY_CODES.LEVEL2_AGENCY_CODE AGNCY_CD_LEVEL2_AGENCY_FK R
AGENCY_CODES.RECORDS_AGENCY_CODE RECORDS_AGNCY_CD_FK R
AGENCY_CODES_EXT_AUTH.AGENCY_CODE AC_EXT_AUTH_AGNCY_CD_FK C
AGENCY_CODES_TEMP.AGENCY_CODE Implied Constraint R
AGENCY_CREDENTIALS.AGENCY_CODE AGCR_AGNCY_CD_FK R
AGENCY_EXT_SERVER_RELATIONS.AGENCY_CODE AGEXTSRVRL_AGNCY_CD_FK R
AGENCY_FEATURES.AGENCY_CODE AF_AGNCY_CD_FK R
AGENCY_NIBR_CITIES.AGENCY_CODE AGNIBR_AGNCY_CD_FK R
AGENCY_NUM_GENERATIONS.AGENCY_CODE ANGT_AGNCY_CD_FK R
AGENCY_OFFENSES.AGENCY_CODE AGNCY_OFFNS_AGNCY_CD_FK R
AGENCY_PARENT_VW.AGENCY_CODE Implied Constraint R
AGENCY_ROLE_JS_USERS.AGENCY_CODE AR_JS_AGNCY_CD_FK R
AGENCY_ROUTING.SOURCE_AGENCY_CODE AR_AGNCY_CD_SRC_FK R
AGENCY_ROUTING.TARGET_AGENCY_CODE AR_AGNCY_CD_TRG_FK R
AGENCY_SEARCH_INT_COUNTS.AGENCY_CODE ASIC_AGNCY_CD_FK R
AGENCY_SEARCH_INTERFACES.AGENCY_CODE AGSRCHINT_AGNCY_CD_FK R
AGENCY_SEARCH_OPTIONS.AGENCY_CODE ASO_AGENCY_CD_FK R
AGENCY_SUB_MAINT.AGENCY_CODE AGMNT_AGNCY_CD_FK R
AGENCY_SUBSCRIPTIONS_VW.AGENCY_CODE Implied Constraint R
AGENCY_USER_TYPE_COUNTS.AGENCY_CODE AUTC_AGNCY_CD_FK R
AGENCY_WORKGROUPS.AGENCY_CODE AGNCY_CD_AGNCY_WRKGRPS_FK1 C
ARREST_DELETE.AGENCY_CODE ARRDEL_AGNCY_CD_FK R
ARRESTS.AGENCY_CODE ARR_AGNCY_CD_FK R
ARRESTS.LOC_AGENCY_CODE ARR_LOC_AGNCY_CD_FK R
ASSIGNMENT_CODE_AGENCIES.AGENCY_CODE ACA_AGNCY_CD_FK R
ASSIGNMENT_HOME_VW.AGENCY_CODE Implied Constraint R
ASSIGNMENT_ORGS.AGENCY_CODE ORGSTRAO_AGNCY_CD_FK R
ASSIGNMENT_ORGS.OLD_AGENCY_CODE ORGSTRAO_OLD_AGNCY_CD_FK R
ASSIGNMENT_SHIFT_CODE_AGENCIES.AGENCY_CODE ASHCA_AGNCY_CD_FK R
ASSIGNMENTS.AGENCY_CODE ASSIG_AGNCY_CD_FK R
ASSOCIATE_DETAILS_VW.AGENCY_CODE Implied Constraint R
ATC_AGENCIES.AGENCY_CODE ATCAG_AGNCY_CD_FK R
BI_AGENCY_INFORMATION_VW.AGENCY_CODE Implied Constraint R
BI_CITATIONS_VW.AGENCY_CODE Implied Constraint R
BI_RECORD_COUNTS_VW.AGENCY_CODE Implied Constraint R
BI_USER_INFORMATION_VW.AGENCY_CODE Implied Constraint R
BI_USER_STORAGE_VW.AGENCY_CODE Implied Constraint R
CALL_DISPOSITION_CODES.AGENCY_CODE CALLDISPCD_AGNCY_CD_FK R
CALL_RECEIVED_CODES.AGENCY_CODE CALLRC_AGNCY_CD_FK R
CALL_TYPE_CODES.AGENCY_CODE CALLTYPECD_AGNCY_CD_FK R
CASE_ASSIGNMENT_HISTORIES.AGENCY_CODE Implied Constraint R
CASE_OFFICER_GROUPS.AGENCY_CODE CASE_OFF_GRP_AGENCY_CD_FK R
CASE_SEARCH_ADDRESS_VW.AGENCY_CODE Implied Constraint R
CASE_SEARCH_FIELD_CONTACT_VW.AGENCY_CODE Implied Constraint R
CASE_SEARCH_INCIDENTS_VW.AGENCY_CODE Implied Constraint R
CASE_SEARCH_NAMES_VW.AGENCY_CODE Implied Constraint R
CASE_SEARCH_OFFENSES_VW.AGENCY_CODE Implied Constraint R
CASE_SEARCH_OFFICERS_VW.AGENCY_CODE Implied Constraint R
CERTIFICATIONS.AGENCY_CODE CERT_AGNCY_CD_FK R
CITATION_ADDRESS_VW.AGENCY_CODE Implied Constraint R
CITATION_BUSINESS_VW.AGENCY_CODE Implied Constraint R
CITATION_DELETE.AGENCY_CODE Implied Constraint R
CITATION_EMPLOYEE_VW.AGENCY_CODE Implied Constraint R
CITATION_PERSON_VW.AGENCY_CODE Implied Constraint R
CITATION_RACIAL_PROFILE_VW.AGENCY_CODE Implied Constraint R
CITATION_VEHICLE_VW.AGENCY_CODE Implied Constraint R
CITATION_VW.AGENCY_CODE Implied Constraint R
CITATIONS.AGENCY_CODE CITATION_AGNCY_CD_FK R
CITATIONS.USER_AGENCY CITATION_USER_AGNCY_FK R
COMMON_PLACE_NAMES.AGENCY_CODE CPN_AGNCY_CD_FK R
COURSE.AGENCY_CODE CRS_AGNCY_CD_FK R
COURSE_INSTANCE.AGENCY_CODE CRSINST_AGNCY_CD_FK R
COURT_APPEARANCE_SEARCH_VW.AGENCY_CODE Implied Constraint R
COURT_APPEARANCES.AGENCY_CODE CRTAPP_AGNCY_CD_FK R
COURT_CASE_APP_SEARCH_VW.AGENCY_CODE Implied Constraint R
COURT_CASE_DELETE.AGENCY_CODE Implied Constraint R
COURT_CASE_SEARCH_VW.AGENCY_CODE Implied Constraint R
COURT_CASES.AGENCY_CODE CRTCASE_AGNCY_CD_FK R
COURT_LOCATION_CODES.AGENCY_CODE CRTLOC_AGNCY_CD_FK R
COURT_PAPERS.AGENCY_CODE CPAP_AGNCY_CD_FK R
CP_DEL_LOG.AGENCY_CODE CPDEL_AGNCY_CD_FK C
CRIMINAL_COMPLAINT_SEARCH_VW.AGENCY_CODE Implied Constraint R
CRIMINAL_COMPLAINTS.COMPLAINTANT_AGENCY_CODE CRMCMP_AGNCY_CD_FK R
DATASET_HEADER_VW.AGENCY_CODE Implied Constraint R
DEPARTMENT_EQUIPMENT.AGENCY_CODE DE_AC_FK R
DEPARTMENT_VEHICLES.AGENCY_CODE DV_AC_FK R
DS_IBR_FIELD_VALUES_FAST_VW.AGENCY_CODE Implied Constraint R
DS_IBR_FIELD_VALUES_VW.AGENCY_CODE Implied Constraint R
DS_ICR_DATA_SETS.AGENCY_CODE Implied Constraint R
DV_CRASH_DELETE_LOG.AGENCY_CODE CDEL_AGNCY_CD_FK R
DV_CRASH_INSURANCE_VW.AGENCY_CODE Implied Constraint R
DV_CRASH_REFERENCES_VW.AGENCY_CODE Implied Constraint R
DV_CRASH_SERVICE_RECORDS_VW.AGENCY_CODE Implied Constraint R
DV_CRASH_SERVICE_REPAIRS_VW.AGENCY_CODE Implied Constraint R
DV_CRASH_TOWS_VW.AGENCY_CODE Implied Constraint R
DV_CRASHES.AGENCY_CODE CRASH_AGENCY_CD_FK R
DV_CRASHES_VW.AGENCY_CODE Implied Constraint R
E_WARRANTS.AGENCY_CODE EWAR_AGNCY_CD_FK R
E_WARRANTS.CHARGING_AGENCY_CODE EWAR_AGNCY_CD_CHRG_FK R
E_WARRANTS.ISSUING_AGENCY EWAR_ISSUING_AGNCY_CD_FK R
E_WARRANTS_AUDIT.AGENCY_CODE Implied Constraint R
EJS_CODES_AGENCIES.AGENCY_CODE ECA_AGNCY_CD_FK R
EJS_CODES_RELATIONS_AGENCIES.AGENCY_CODE EJSCDRELA_AGNCY_CD_FK R
EJS_MODULE_TEXT.AGENCY_CODE EMT_AGNCY_CD_FK R
EJS_REPORTS.AGENCY_CODE ER_AGNCY_CD_FK R
EJS_WEB_SERVICE_AGENCIES.AGENCY_CODE EWSA_AGNCY_CD_FK R
EJS_XML_DOC_KEYS_VW.AGENCY_CODE Implied Constraint R
EJSXML_DOCS.AGENCY_CODE EJSDOCS_AGNCY_CD_FK R
EJSXML_DOCS_VW.AGENCY_CODE Implied Constraint R
EMP_LANGUAGE_VW.AGENCY_CODE Implied Constraint R
EMP_SENIORITY_VW.AGENCY_CODE Implied Constraint R
EMP_SERVICE_HISTORY_VW.AGENCY_CODE Implied Constraint R
EMP_VW.AGENCY_CODE Implied Constraint R
EMPLOYEE_MEDICAL.AGENCY_CODE EMED_AGNCY_FK R
EMPLOYEE_SALARY_VW.AGENCY_CODE Implied Constraint R
EMPLOYEES.AGENCY_CODE EMP1_AGNCY_CD_FK R
ENROLLMENTS.AGENCY_CODE ENR_1_AGNCY_CD_FK R
EVIDENCE_AUDIT_REPORTS.AGENCY_CODE EVID_AR_AGNCY_CD_FK R
EVIDENCE_DELETE.AGENCY_CODE Implied Constraint R
EVIDENCE_DESTINATION_CODES.AGENCY_CODE EDC1_AGNCY_CD_FK R
EVIDENCE_LABELS.AGENCY_CODE EVIDLBL_AGNCY_CD_FK C
EVIDENCE_LOCATION_CODES.AGNCY_CD_AGENCY_CODE ELC_AGNCY_CD_FK R
EXPORT_DESTINATIONS.AGENCY_CODE EXP_DEST_AGNCY_CD_FK R
EXTERNAL_SYSTEM_AGENCIES.AGNCY_CD_AGENCY_CODE AGNCY_CD_EXSA_FK R
EXTERNAL_SYSTEM_DELETES.AGENCY_CODE ESD_AGNCY_CD_FK R
FIELD_INT_SEARCH_GANG_VW.AGENCY_CODE Implied Constraint R
FIELD_INT_SEARCH_LOCATION_VW.AGENCY_CODE Implied Constraint R
FIELD_INT_SEARCH_MIN_VW.AGENCY_CODE Implied Constraint R
FIELD_INT_SEARCH_OFFICER_VW.AGENCY_CODE Implied Constraint R
FIELD_INT_SEARCH_ORG_VW.AGENCY_CODE Implied Constraint R
FIELD_INT_SEARCH_PERSON_VW.AGENCY_CODE Implied Constraint R
FIELD_INT_SEARCH_VEHICLE_VW.AGENCY_CODE Implied Constraint R
FIELD_INTERVIEWS.AGENCY_CODE FLDINT_AGNCY_CD_FK R
FLDINT_ADD_VW.AGENCY_CODE Implied Constraint R
FLDINT_DELETE.AGENCY_CODE Implied Constraint R
FLDINT_GANG_VW.AGENCY_CODE Implied Constraint R
FLDINT_INTELL_VW.AGENCY_CODE Implied Constraint R
FLDINT_NARRATIVES_VW.AGENCY_CODE Implied Constraint R
FLDINT_OFF_VW.AGENCY_CODE Implied Constraint R
FLDINT_VEH_VW.AGENCY_CODE Implied Constraint R
FLEET_MAINTENANCE_LOG.AGENCY_CODE FM_AGNCY_CD_FK R
FLEET_MILEAGE_LOG.AGENCY_CODE FML_AGNCY_CD_FK R
GUEST_LOG_ENTRIES.AGNCY_CD_AGENCY_CODE GLE_AGNCY_CD_FK R
HOME_AGENCY_AUDIT.AGENCY_CODE HAGA_AGENCY_CD_FK R
HOME_AGENCY_AUDIT.OLD_AGENCY_CODE HAGA_OLD_AGENCY_CD_FK R
IJIS_USER_PROFILES.AGNCY_CD_AGENCY_CODE IUP_AGNCY_CD_FK R
IMP_LOC_CODES.AGENCY_CODE IMPLC_AGNCY_CD_FK R
IMP_VEH_OFFICERS_VW.AGENCY_CODE Implied Constraint R
IMPOUND.GEO_CODE IMPD_GEO_AGNCY_CD_FK R
IMPOUND.IMPOUNDING_AGENCY IMPD_AGNCY_CD_IMPOUNDING_FK R
IMPOUND.REPORTING_AGENCY IMPD_AGNCY_CD_FK R
IMPOUND_DELETE_LOG.IMPOUNDING_AGENCY IMPDEL_AGNCY_CD_FK R
INC_CASE_ROUTING.INC_CASE_AGENCY ICR_AGNCY_CD_REC_FK R
INC_CASE_ROUTING.INCIDENT_AGENCY ICR_AGNCY_CD_FK R
INC_REVIEW_ROUTE_AGENCIES.AGENCY_CODE INCRVWRTAG_AGNCY_CD_FK R
INC_REVIEW_ROUTE_INSTANCES.AGENCY_CODE INCRVWRTINST_AGNCY_CD_FK R
INC_VAL_COND_AGNC_CDE.AGENCY_CODE IVCAC_AGNCY_CD_FK R
INCIDENT_ADDRESSES.LOC_AGENCY_CODE INC_INC_ADDR_FK R
INCIDENT_BAIR_EXTRACT_VW.AGENCY_CODE Implied Constraint R
INCIDENT_CASE_OFFICERS_VW.AGENCY_CODE Implied Constraint R
INCIDENT_CASE_RWSCH_VW.AGENCY_CODE Implied Constraint R
INCIDENT_CASE_SEARCH_MIN_VW.AGENCY_CODE Implied Constraint R
INCIDENT_CASE_SEARCH_VW.AGENCY_CODE Implied Constraint R
INCIDENT_CASES.AGENCY_CODE IC_AGNCY_CD_FK R
INCIDENT_CITATION_VW.AGENCY_CODE Implied Constraint R
INCIDENT_DELETE.AGENCY_CODE Implied Constraint R
INCIDENT_DELETE_SEARCH_VW.AGENCY_CODE Implied Constraint R
INCIDENT_DELETE_VW.AGENCY_CODE Implied Constraint R
INCIDENT_GIS_VW.AGENCY_CODE Implied Constraint R
INCIDENT_NOTIFY_HISTORY.DEST_AGENCY_CODE INH_AGNCY_CD_DEST_FK R
INCIDENT_NOTIFY_HISTORY.SRC_AGENCY_CODE INH_AGNCY_CD_SRC_FK R
INCIDENT_ROUTE_DEF_AGNCY.AGENCY_CODE IRDA_AGNCY_CD_FK R
INCIDENT_ROUTE_ORIG_AGENCIES.AGENCY_CODE INCRTEOA_AGNCY_CD_FK R
INCIDENT_ROUTES.DEST_AGENCY_CODE INCRTE_AGNCY_CD_FK R
INCIDENT_SUPPLEMENTS.APPROVING_AGENCY_CODE INCSUP_AGNCY_CD_APPR_FK R
INCIDENT_SUPPLEMENTS.RESPONSIBLE_AGENCY_CODE INCSUP_RSP_AGNCY_CD_FK R
INCIDENT_SUPPLEMENTS.SUPP_AGENCY_CODE INCSUP_AGNCY_CD_FK R
INCIDENTS.AGNCY_CD_AGENCY_CODE INC_AGNCY_CD_FK R
ITEM_CATEGORY_CODES.AGENCY_CODE ICC_AGNCY_CD_FK R
ITEM_CUSTODIES.AGENCY_CODE ITCU_AGNCY_CD_FK R
ITEM_CUSTODY_EVENTS.AGENCY_CODE ICE_AGNCY_CD_FK R
ITEM_DESCRIPTORS.AGENCY_CODE ITDS_AGNCY_CD_FK R
ITEM_DESCRIPTORS_VW.AGENCY_CODE Implied Constraint R
ITEM_ENTRIES.AGENCY_CODE ITENT_AGNCY_CD_FK R
ITEM_GUN_DESCRIPTORS_VW.AGENCY_CODE Implied Constraint R
ITEM_INSP_SEARCH_VW.AGENCY_CODE Implied Constraint R
ITEM_INSP_VW.AGENCY_CODE Implied Constraint R
ITEM_INSPECTIONS.AGENCY_CODE ITINSP_AGNCY_CD_FK R
ITEM_INST_CUSTODY_DESC_VW.AGENCY_CODE Implied Constraint R
ITEM_INST_CUSTODY_VW.AGENCY_CODE Implied Constraint R
ITEM_INSTANCES.AGENCY_CODE ITII_AGNCY_CD_FK R
ITEM_INSTANCES.CUSTODY_AGENCY_CODE ITII_AGNCY_CD_CUST_FK R
ITEM_LINE_CODES.AGENCY_CODE ITLN_AGNCY_CD_FK R
ITEM_LOCATIONS.AGENCY_CODE ITLC_AGNCY_CD_FK R
ITEM_LOG_ENTRIES.AGENCY_CODE ILE_AGNCY_CD_FK R
ITEM_LOG_VW.AGENCY_CODE Implied Constraint R
ITEM_MAKE_CODES.AGENCY_CODE ITMK_AGNCY_CD_FK R
ITEM_MODEL_CODES.AGENCY_CODE ITMO_AGNCY_CD_FK R
ITEM_ORDERS.AGENCY_CODE ITORD_AGNCY_CD_FK R
ITEM_ORGANIZATIONS.AGENCY_CODE ITOR_AGNCY_CD_FK R
ITEM_QUANTITY_CODES.AGENCY_CODE IQC_AGNCY_CD_FK R
ITEM_SIZE_CODES.AGENCY_CODE ITSZ_AGNCY_CD_FK R
ITEM_STYLE_CODES.AGENCY_CODE ITSTY_AGNCY_CD_FK R
ITEM_SUB_TYPE_CODES.AGENCY_CODE ITST_AGNCY_CD_FK R
ITEM_VEHICLE_DESCRIPTORS_VW.AGENCY_CODE Implied Constraint R
ITEM_VENDORS.AGENCY_CODE ITVD_AGNCY_CD_FK R
JS_BAIR_MO_FIELDS_VW.AGENCY_CODE Implied Constraint R
JS_BAIR_PERSON_VW.AGENCY_CODE Implied Constraint R
JS_CITATION_VW.AGENCY_CODE Implied Constraint R
JS_CIVIL_PROCESS_LOG_VW.AGENCY_CODE Implied Constraint R
JS_CIVIL_PROCESS_PARTY_VW.AGENCY_CODE Implied Constraint R
JS_CIVIL_PROCESS_VW.AGENCY_CODE Implied Constraint R
JS_FIELD_CONTACT_ADDRESS_VW.AGENCY_CODE Implied Constraint R
JS_FIELD_CONTACT_GANG_VW.AGENCY_CODE Implied Constraint R
JS_FIELD_CONTACT_OFFICERS_VW.AGENCY_CODE Implied Constraint R
JS_FIELD_CONTACT_VW.AGENCY_CODE Implied Constraint R
JS_FLEET_VEHICLES_VW.AGENCY_CODE Implied Constraint R
JS_INCIDENT_ADDRESS_VW.AGENCY_CODE Implied Constraint R
JS_INCIDENT_CASE_SUMMARY_VW.AGENCY_CODE Implied Constraint R
JS_INCIDENT_CASE_VW.AGENCY_CODE Implied Constraint R
JS_INCIDENT_OFFENSE_VW.AGENCY_CODE Implied Constraint R
JS_INCIDENT_OFFNDR_EVIDENCE_VW.AGENCY_CODE Implied Constraint R
JS_OFFICER_DAILY_ACTIVITY_VW.AGENCY_CODE Implied Constraint R
JS_OFFICER_DAILY_EQUIPMENT_VW.AGENCY_CODE Implied Constraint R
JS_OFFICER_DAILY_VEHICLE_VW.AGENCY_CODE Implied Constraint R
JS_OFFICER_DAILY_VW.AGENCY_CODE Implied Constraint R
JS_PERMIT_BUSINESS_VW.AGENCY_CODE Implied Constraint R
JS_PERMIT_PEOPLE_VW.AGENCY_CODE Implied Constraint R
JS_PERMIT_PROPERTY_VW.AGENCY_CODE Implied Constraint R
JS_PERMIT_VEHICLE_VW.AGENCY_CODE Implied Constraint R
JS_PERMITS_VW.AGENCY_CODE Implied Constraint R
JS_USER_ASSIGNMENT_VW.AGENCY_CODE Implied Constraint R
JS_WARRANT_OFFENSE_CHARGE_VW.AGENCY_CODE Implied Constraint R
JS_WARRANT_VW.AGENCY_CODE Implied Constraint R
JT_JAIL_FACILITIES.AGENCY_CODE JT_JF_AGNCY_CD_FK R
JT_WEB_SERVICES.AGENCY_CODE JT_WS_AGNCY_CD_FK R
K9_ACTIVITY.AGENCY_CODE K9ACT_AGNCY_CD_FK R
K9_DEPLOYMENT.AGENCY_CODE K9DEP_AGNCY_CD_FK R
K9_DOGS.AGENCY_CODE K9DOG_AGNCY_CD_FK R
K9_DOGS_VW.AGENCY_CODE Implied Constraint R
K9_TRAINING.AGENCY_CODE K9TRN_AGNCY_CD_FK R
LEGAL_SEARCH_INDEX.AGENCY_CODE LSI_AGNCY_CD_FK R
LSI_ADDRESSES_VW.AGENCY_CODE Implied Constraint R
LSI_PEOPLE_VW.AGENCY_CODE Implied Constraint R
LSI_VW.AGENCY_CODE Implied Constraint R
MAP_SHAPES.AGENCY_CODE MS_AGNCY_CD_FK R
MASTER_REPORT_REFERENCES.AGENCY_CODE MRREF_AGNCY_CD_FK R
NARRATIVE_TEMPLATES.AGENCY_CODE NARTEM_AGNCY_CD_FK R
NEW_NOTIFICATIONS_VW.AGENCY_CODE Implied Constraint R
NOTIFICATION_AUDITS.AGENCY_CODE NOTIFAUD_AGNCY_CD_FK R
NOTIFICATION_DETAILS.AGENCY_CODE Implied Constraint R
OFFENSE_GROUPS.AGENCY_CODE OFFNSEGRP_AGNCY_CD_FK R
OFFICER_EMPLOYEE_VW.AGENCY_CODE Implied Constraint R
OFFICERS.AGNCY_CD_AGENCY_CODE OFF1_AGNCY_CD_FK R
PERMIT_BUSINESSES_VW.AGENCY_CODE Implied Constraint R
PERMIT_PEOPLE_VW.AGENCY_CODE Implied Constraint R
PERMIT_PROPERTIES_VW.AGENCY_CODE Implied Constraint R
PERMIT_VEHICLES_VW.AGENCY_CODE Implied Constraint R
PERMITS.AGENCY_CODE PRMT_AGNCY_CD_FK R
PERSON_GEO_VW.AGENCY_CODE Implied Constraint R
PERSONNEL_CERT_SEARCH_VIEW.AGENCY_CODE Implied Constraint R
PERSONNEL_COURSE_SEARCH_VIEW.AGENCY_CODE Implied Constraint R
PERSONNEL_SEARCH_VIEW.AGENCY_CODE Implied Constraint R
PHOTO_LINEUP.AGENCY_CODE PHTOLNUP_AGNCY_CD_FK R
PHOTO_LINEUP_DELETE.AGENCY_CODE PHTOLNUPD_AGNCY_CD_FK R
PRINT_TEMPLATES.AGENCY_CODE PRTE_AGNCY_CD_FK R
PROPERTY_HOLD_LOCATIONS.AGENCY_CODE PROPHOLOC_AGNCY_CD_FK R
PROPERTY_HOLD_SEARCH_VW.AGENCY_CODE Implied Constraint R
PROPERTY_HOLDS.AGENCY_CODE PROPHO_AGNCY_CD_FK R
PSEUDO_ORG_DESCRIPTORS.AGENCY_CODE ORGSTRPOD_AGNCY_CD_FK R
QUESTION_TYPES.AGENCY_CODE QUTY_AGNCY_CD_FK R
QUESTION_TYPES_VW.AGENCY_CODE Implied Constraint R
QUICK_LINKS.AGENCY_CODE AGNQL_AGNCY_CD_FK R
REPORT_AGENCIES.AGENCY_CODE REPAG_AGNCY_CD_FK R
ROLE_SECURITIES.AGENCY_CODE RS_AGNCY_CD_FK R
ROUTE_ACTION_AGENCIES.AGENCY_CODE RTEAA_AGNCY_CD_FK R
ROUTE_ACTION_INST_AGENCIES.AGENCY_CODE RTACTINSTAG_AGNCY_CD_FK R
ROUTE_ACTION_INST_USERS.AGENCY_CODE RTEACTINUS_AGNCY_CD_FK R
ROUTE_INSTANCE_AGENCIES.AGENCY_CODE RTINSTAG_AGNCY_CD_FK R
RV_AGENCY_CONDITIONS.AGENCY_CODE RVAC_AGNCY_CD_FK C
RV_AGENCY_OVERRIDES.AGENCY_CODE RVCAO_AGNCY_CD_FK R
RV_CONDITIONS.AGENCY_CODE RVC_AGNCY_CD_FK R
SALARY.AGENCY_CODE SALY_AGNCY_FK R
SEARCH_INT_FORM_TYPES.OVERRIDE_AGENCY_CODE SRCHINTFT_AGNCY_CD_FK R
SEARCH_INTERFACE_RESULTS.QUERY_AGENCY SI_RESULT_AGNCY_CD_FK R
SEARCH_INTERFACE_VALIDATORS.OVERRIDE_AGENCY_CODE SRCHINTV_AGNCY_CD_FK R
SUB_AGENCIES.AGENCY_CODE SA1_AGNCY_CD_FK C
SUB_AGENCIES.SUB_AGENCY_CODE SA1_AGNCY_CD_SUB_FK R
SUB_BEAT_CODES.AGENCY_CODE SBC_AGNCY_CD_FK R
TAGS.AGENCY_CODE TAGS_AGNCY_CD_FK R
TRAINING_EXPIRED_CERT_VW.AGENCY_CODE Implied Constraint R
TRAINING_EXPIRED_COURSES_VW.AGENCY_CODE Implied Constraint R
TRAINING_UPCOMING_COURSES_VW.AGENCY_CODE Implied Constraint R
USER_AGENCIES.AGENCY_CODE UPJ_AGNCY_CD_FK R
USER_AGENCY_ACCESS_VW.AGENCY_CODE Implied Constraint R
USER_ASSIGNMENT_AGENCIES.AGENCY_CODE UAA_AGENCY_CODE_FK R
USER_FIELD_OFF_VALUES.AGENCY_CODE USRSCRN_UFOV_AGNCY_CD_FK R
USER_GROUPS.AGENCY_CODE USRGRP_AGNCY_CD_FK R
USER_SCREEN_AGENCIES.AGENCY_CODE USRSCA_AGNCY_CD_FK R
USER_SCREEN_AUDIT_LOG.AGENCY_CODE USAL_AGNCY_CD_FK R
USER_SCREEN_COMMENTS.AGENCY_CODE USRSCRN_COM_AGNCY_CD_FK R
USER_SCREEN_HEADERS.AGENCY_CODE USH_AGNCY_CD_FK R
USER_SCREEN_INSTANCES.AGENCY_CODE USRSCRN_INST_AGNCY_CD_FK R
USER_SCREEN_MISC_NOTES.AGENCY_CODE USR_SCRNMN_AGNCY_CD_FK R
USER_SCREENS.AGENCY_CODE USRSCRN_AGNCY_CD_FK R
USI_SEARCH_VW.AGENCY_CODE Implied Constraint R
VS_OFFENSE_COUNT_VW.AGENCY_CODE Implied Constraint R
VS_TIME_CATEGORY_VW.AGENCY_CODE Implied Constraint R
WARRANT_OFFENSE_CHARGE_VW.AGENCY_CODE Implied Constraint R
WARRANT_OFFICER_VW.AGENCY_CODE Implied Constraint R
WARRANT_PERSON_ADDR_VW.AGENCY_CODE Implied Constraint R
WARRANTS_VW.AGENCY_CODE Implied Constraint R
XML_DOCUMENT_OPTIONS.AGENCY_CODE XMLDOP_AGNCY_CD_FK R
ZZ_AGENCY_CODES.AGENCY_CODE Implied Constraint R
ZZC1_AGENCY_CODES.AGENCY_CODE Implied Constraint R
ZZV1_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
DEF_LEA_SEC_LEVEL number 38  √  null
INCIDENT_SECURITY_LEVEL_CODES.INC_SEC_LEVEL_CODE AGNCY_CD_INC_SEC_LVL_FK R
DISPATCH_ENABLED varchar2 1
PWD_EXPIRE_DAYS number 3  √  null
LABEL_PRINTER varchar2 40  √  null
UCR_REQUIRED varchar2 1
LEA_CASE_UPDATE number 3  √  null
RECORDS_AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE RECORDS_AGNCY_CD_FK R
OFFICE_CODE varchar2 30  √  null
EJS_CODES.CODE AGNCY_CD_OFFICE_CO_EJS_CODE_FK R
Office code this agency is associated with.
UCR_CLERK varchar2 1 'N'
CAD_AGENCY_ID varchar2 30  √  null
JRD_AGENCY_TYPE varchar2 30  √  null
EJS_CODES.CODE AGNCY_CD_JRD_AGENC_EJS_CODE_FK R
The code to identify an jurisdiction agency type.
LEVEL2_AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE AGNCY_CD_LEVEL2_AGENCY_FK R
2nd Level Approving Agency Code
POC_TITLE_CODE varchar2 30  √  null
EJS_CODES.CODE AGNCY_CD_POC_TITLE_EJS_CODE_FK R
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
EJS_CODES.CODE AGNCY_CD_TZONE_EJS_CODES_FK R
AGENCY_IMAGE_LOCATION varchar2 2000  √  null
JRD_AGENCY_TYPE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE AGNCY_CD_JRD_AGENC_EJS_CODE_FK R
OFFICE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE AGNCY_CD_OFFICE_CO_EJS_CODE_FK R
POC_TITLE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE AGNCY_CD_POC_TITLE_EJS_CODE_FK R
WEBSITE_URL varchar2 255  √  null
DEFAULT_DSPLY_NOTIFY_ITEMS number 0  √  null
TIME_ZONE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE AGNCY_CD_TZONE_EJS_CODES_FK R
REC_ID number 0  √  null
NIBR_CITY_INDICATOR varchar2 4  √  null
IMAGE_ID number 38  √  null
IMAGES.IMAGE_ID AGNCY_CD_IMA_FK 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 This is the County number that will display as a Data Element in the State Submission file.
LATITUDE varchar2 30  √  null
LONGITUDE varchar2 30  √  null
SUPPORT_CODE varchar2 30  √  null
EJS_CODES.CODE AGNCY_CD_SUP_CODE_FK R
SUPPORT_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE AGNCY_CD_SUP_CODE_FK R
LICENSED_USERS number 0  √  null
SOLR_STATE varchar2 30  √  null
OPTION_CODE_TYPE varchar2 30
EJS_CODES.CODE_TYPE AGNCY_CD_OPT_CODE_FK R
Can be used to store any option codes that may be relevant to the agency, nulls are Ok, indicating that there are no options stored for the agency
OPTION_CODE varchar2 30
EJS_CODES.CODE AGNCY_CD_OPT_CODE_FK R
Option Code in effect for the Agency, initially NIBRS Option Codes are there, but the field can be null, indicating that there are not opetion codes in effect
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
ORI_POLICY_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE AGNCY_CD_ORI_POL_CD_FK R
identifies the EJS CODE_TYPE associated with the value in ORI_POLICY_CODE.
ORI_POLICY_CODE varchar2 30  √  null
EJS_CODES.CODE AGNCY_CD_ORI_POL_CD_FK R
When the OPTION_CODE is set to ORGANIZATION_ROLL_UP this tells the app which ORI to use when writing the output ICR data for state submissions.
INTERDEX_ID varchar2 100  √  null Agency identifier that is provided to IX InfoExchange queries. Configured on the IX side to restrict or allow some data sources based on an Agency Name
SUPPORT_AGENCY_NAME varchar2 500  √  null
CASE_ACT_NEXT_UPDATE_DATE_DAYS number 0  √  null Number of days to increment case activity review date
CASE_ACT_GOOD_STANDING_DAYS number 0  √  null Number of days for case review indicators
RICH_MEDIA_STORAGE_GB number 0  √  null Total gigibytes of rich media storage purchased

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AGENCY_CODE" IS NOT NULL AGNCY_CD_AGENCY_CODE_NN
"DISPATCH_ENABLED" IS NOT NULL AGNCY_CD_DISPATCH_ENABLED_NN
"INTERNAL_OFFENSES" IS NOT NULL AGNCY_CD_INTERNAL_OFFENSES_NN
"OPTION_CODE" IS NOT NULL AGNCY_CD_OPT_CD_NN
"OPTION_CODE_TYPE" IS NOT NULL AGNCY_CD_OPT_CD_TYP_NN
"UCR_CLERK" IS NOT NULL AGNCY_CD_UCR_CLERK_NN
"UCR_REQUIRED" IS NOT NULL AGNCY_CD_UCR_REQUIRED_NN

Indexes:
Column(s) Type Sort Constraint Name
AGENCY_CODE Primary key Asc AGNCY_CD_PK
IMAGE_ID Performance Asc AGNCY_CD_IMA_FK_I
DEF_LEA_SEC_LEVEL Performance Asc AGNCY_CD_INC_SEC_LVL_FK_I
JRD_AGENCY_TYPE Performance Asc AGNCY_CD_JATC_FK_I
JRD_AGENCY_TYPE_TYPE + JRD_AGENCY_TYPE Performance Asc/Asc AGNCY_CD_JRD_AGENC_EJS_CODE_I
LEVEL2_AGENCY_CODE Performance Asc AGNCY_CD_LEVEL2_AGENCY_FK_I
OFFICE_CODE Performance Asc AGNCY_CD_OC2_FK_I
OFFICE_CODE_TYPE + OFFICE_CODE Performance Asc/Asc AGNCY_CD_OFFICE_CO_EJS_CODE_I
OPTION_CODE_TYPE + OPTION_CODE Performance Asc/Asc AGNCY_CD_OPT_CODE_FK_I
ORI_POLICY_CODE_TYPE + ORI_POLICY_CODE Performance Asc/Asc AGNCY_CD_ORI_POL_CD_FK_I
POC_TITLE_CODE_TYPE + POC_TITLE_CODE Performance Asc/Asc AGNCY_CD_POC_TITLE_EJS_CODE_I
SUPPORT_CODE_TYPE + SUPPORT_CODE Performance Asc/Asc AGNCY_CD_SUP_CODE_FK_I
POC_TITLE_CODE Performance Asc AGNCY_CD_TC_FK_I
TIME_ZONE_CODE_TYPE + DEFAULT_TIME_ZONE_CODE Performance Asc/Asc AGNCY_CD_TZONE_EJS_CODES_FK_I
Performance AGNCY_CD_UPPER_FNCBAS_I
RECORDS_AGENCY_CODE Performance Asc RECORDS_AGNCY_CD_FK_I

Close relationships  within of separation: