Table slot9.WORLD.TSTA.DS_ICR_ADDL_PROPERTY_ITEMS_GTT
This table stores additional Property Items for Additional for Staging transformation from DS_ICR_ADDL_PROPERTY_ITEMS into its Final (or close to) NIBRS (or given EXTERNAL_SYSTEM_CODES.CODE) Format
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
DS_ICR_DATA_SETS.DATASETID Implied Constraint R
Unique Data Set ID from DS_ICR_DATA_SETS
HEADERID number 0
DS_ICR_HEADERS.HEADERID Implied Constraint R
Unique Header ID from DS_ICR_HEADERS
UNIQUE_KEY varchar2 255 Unique Key
REC_NUM varchar2 255 Rec Num
SEGMENT_LENGTH varchar2 2000  √  null Segment Length
SEGMENT_LEVEL varchar2 2000  √  null Segment Level
ACTION varchar2 2000  √  null Action
MONTH date 7  √  null Month
ORIGYEAR date 7  √  null Orig Year
CITYINDICATOR varchar2 2000  √  null City Indicator
ORIGORI varchar2 2000  √  null Orig ORI
INCIDENTNO varchar2 2000  √  null Incident Report Number
INCDATE date 7  √  null Incident Date
PLOSSTYPE varchar2 2000  √  null Property Loss Type
FAMILYVIOLENCEINDICATOR varchar2 2000  √  null Family Violence Indicator
UTILITYFIELD varchar2 2000  √  null Utility Field
PDRUGTYPE4 varchar2 2000  √  null Drug Type 4
PDRUGQTY4 varchar2 2000  √  null Drug Quantity 4
PDRUGMSR4 varchar2 2000  √  null Drug Measurement 4
PDRUGTYPE5 varchar2 2000  √  null Drug Type 5
PDRUGQTY5 varchar2 2000  √  null Drug Quantity 5
PDRUGMSR5 varchar2 2000  √  null Drug Measurement 5
PDRUGTYPE6 varchar2 2000  √  null Drug Type 6
PDRUGQTY6 varchar2 2000  √  null Drug Quantity 6
PDRUGMSR6 varchar2 2000  √  null Drug Measurement 6
PDRUGTYPE7 varchar2 2000  √  null Drug Type 7
PDRUGQTY7 varchar2 2000  √  null Drug Quantity 7
PDRUGMSR7 varchar2 2000  √  null Drug Measurement 7
PDRUGTYPE8 varchar2 2000  √  null Drug Type 8
PDRUGQTY8 varchar2 2000  √  null Drug Quantity 8
PDRUGMSR8 varchar2 2000  √  null Drug Measurement 8
TYPEMARIJUANAFIELDGARDEN varchar2 2000  √  null Type Marijuana Fields and Gardens
NUMBERMARIJUANAFIELDGARDEN varchar2 2000  √  null Number Marijuana Fields and Gardens
NUMBERCLANDESTINELABSSEIZED varchar2 2000  √  null Number of Clandestine Labs Seized
TYPEOFDRUGMANUFACTURED1 varchar2 2000  √  null Type of Drug Manufactured 1
TYPEOFDRUGMANUFACTURED2 varchar2 2000  √  null Type of Drug Manufactured 2
QUANTITYPRECURSORCHEMICAL1 varchar2 2000  √  null Quantity Precursor Chemical 1
QUANTITYPRECURSORCHEMICAL2 varchar2 2000  √  null Quantity Precursor Chemical 2
QUANTITYPRECURSORCHEMICAL3 varchar2 2000  √  null Quantity Precursor Chemical 3
QUANTITYPRECURSORCHEMICAL4 varchar2 2000  √  null Quantity Precursor Chemical 4
QUANTITYPRECURSORCHEMICAL5 varchar2 2000  √  null Quantity Precursor Chemical 5
QUANTITYPRECURSORCHEMICAL6 varchar2 2000  √  null Quantity Precursor Chemical 6
TYPEMEASUREPRECURSORCHEMICAL1 varchar2 2000  √  null Type Measure Precursor Chemical 1
TYPEMEASUREPRECURSORCHEMICAL2 varchar2 2000  √  null Type Measure Precursor Chemical 2
TYPEMEASUREPRECURSORCHEMICAL3 varchar2 2000  √  null Type Measure Precursor Chemical 3
TYPEMEASUREPRECURSORCHEMICAL4 varchar2 2000  √  null Type Measure Precursor Chemical 4
TYPEMEASUREPRECURSORCHEMICAL5 varchar2 2000  √  null Type Measure Precursor Chemical 5
TYPEMEASUREPRECURSORCHEMICAL6 varchar2 2000  √  null Type Measure Precursor Chemical 6
ADMINISTRATIVEAREA varchar2 2000  √  null Administrative Area

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DATASETID" IS NOT NULL DSICRAPROPGTT_DATESETID_NN
"HEADERID" IS NOT NULL DSICRAPROPGTT_HEADERID_NN
"REC_NUM" IS NOT NULL DSICRAPROPGTT_RECNUM_NN
"UNIQUE_KEY" IS NOT NULL DSICRAPROPGTT_UNIQUEKEY_NN


Close relationships: