Table slot9.WORLD.TSTA.DS_ICR_DATA_SETS
This parent table stores all Data Sets. Data Sets are unique per Root Agency. If there is no Root Agency then for each Distinct Agency
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
DATASETID number 0
DATASET_HEADER_VW.DATASETID Implied Constraint R
DS_IBR_FIELD_VALUES_FAST_VW.DATASETID Implied Constraint R
DS_IBR_FIELD_VALUES_VW.DATASETID Implied Constraint R
DS_IBR_MODIFY_VALUES_VW.DATASETID Implied Constraint R
DS_ICR_ADDL_PROPERTY_ITEMS_GTT.DATASETID Implied Constraint R
DS_ICR_ARRESTS_GTT.DATASETID Implied Constraint R
DS_ICR_FILE_REFERENCES.DATASETID DSICRFREF_DSICR_FK R
DS_ICR_GROUPB_GTT.DATASETID Implied Constraint R
DS_ICR_HEADERS.DATASETID DSICRHD_DSICR_FK R
DS_ICR_HEADERS_GTT.DATASETID Implied Constraint R
DS_ICR_INCIDENT_ERRORS.DATASETID Implied Constraint R
DS_ICR_OFFENDERS_GTT.DATASETID Implied Constraint R
DS_ICR_OFFENSES_GTT.DATASETID Implied Constraint R
DS_ICR_ORI_GTT.DATASETID Implied Constraint R
DS_ICR_PROPERTY_DRUGS_GTT.DATASETID Implied Constraint R
DS_ICR_PROPERTY_ITEMS_GTT.DATASETID Implied Constraint R
DS_ICR_VICTIM_SUSPECTS_GTT.DATASETID Implied Constraint R
DS_ICR_VICTIMS_GTT.DATASETID Implied Constraint R
DS_ICR_ZERO_GTT.DATASETID Implied Constraint R
DS_NIBR_PIVOT.DATASETID Implied Constraint R
DS_NIBRS_ARRESTS_VW.DATASETID Implied Constraint R
DS_NIBRS_GROUPB_VW.DATASETID Implied Constraint R
DS_NIBRS_HEADERS_VW.DATASETID Implied Constraint R
DS_NIBRS_OFFENDERS_VW.DATASETID Implied Constraint R
DS_NIBRS_OFFENSES_VW.DATASETID Implied Constraint R
DS_NIBRS_PROPERTY_VW.DATASETID Implied Constraint R
DS_NIBRS_VICTIMS_VW.DATASETID Implied Constraint R
INCIDENT_WARNING_NOTIFY_LOG.DATA_SET_ID INCWARNOTLG_DSICR_FK R
JS_DS_NIBRS_ARRESTS_VW.DATASETID Implied Constraint R
JS_DS_NIBRS_GROUPB_VW.DATASETID Implied Constraint R
JS_DS_NIBRS_HEADERS_VW.DATASETID Implied Constraint R
JS_DS_NIBRS_OFFENDERS_VW.DATASETID Implied Constraint R
JS_DS_NIBRS_OFFENSES_VW.DATASETID Implied Constraint R
JS_DS_NIBRS_PROPERTY_VW.DATASETID Implied Constraint R
JS_DS_NIBRS_VICTIMS_VW.DATASETID Implied Constraint R
MICR_INCIDENT_HEADER_VW.DATASETID Implied Constraint R
UCR_O_RANK_GTT.DATASETID Implied Constraint R
Unique identifier for the Data Set
DATATAG number 0  √  null Data Set Tag (Calculated from Date or Name, for Descending Sorting)
DATASET varchar2 255  √  null Data Set Name (Format YYYYMMDD, example: 20090608)
DATEMADE date 7  √  null Date when the Data Set was Created/Written
TIMEMADE date 7  √  null Time when the Date Set was Created/Written
USERMADE varchar2 255  √  null Clerk ID of User who Created the Data Set
DATESENT date 7  √  null Date when the Data Set was Sent/FTPed
TIMESENT date 7  √  null Time when the Data Set was Sent/FTPed
USERSENT varchar2 255  √  null Clerk ID of User who Sent the Data Set
DATERECVED date 7  √  null Data when the Error Reports for the Data Set were Received
TIMERECVED date 7  √  null Time when the Error Reports for the Data Set were Received
USERRECVED varchar2 255  √  null Clerk ID of User who Received the Error Reports
DATEMARKED date 7  √  null Date when the Data Set were Marked as Received
TIMEMARKED date 7  √  null Time when the Data Set were Marked as Received
USERMARKED varchar2 255  √  null Clerk ID of User who Marked the Data Set as Received
RECSSENT number 0  √  null Number of Records Sent
RECSFINLED number 0  √  null Number of Incidents with Final Edit Errors
ERRORRATE number 0  √  null Error Rate (in Percent)
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
REC_ID number 0  √  null
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE Implied Constraint R
OPEN_STATUS varchar2 1
MAX_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AGENCY_CODE" IS NOT NULL DSICR_AGENCY_CD_AGENCY_CODE_NN
"DATASETID" IS NOT NULL DSICR_DATASETID_NN
"OPEN_STATUS" IS NOT NULL DSICR_OPENSTATUS_NN

Indexes:
Column(s) Type Sort Constraint Name
DATASETID Primary key Asc DSICR_PK

Close relationships  within of separation: