Table slot9.WORLD.TSTA.DS_ICR_PROPERTY_ITEMS
This table stores Property Items Segment based on a given EXTERNAL_SYSTEM_CODES.CODE populated from DS_ICR Package when Incident is Approved in the application
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
HEADERID number 0
DS_ICR_HEADERS.HEADERID DSICRPROP_DSICRHD_FK R
PROPNO number 0 Property Item Number [Part of Foreign Key: Property]
PITEMNO varchar2 255 Data Element 52 (Item Number [Part of Primary Key])
PLOSSTYPE varchar2 255 Data Element 53 (Property Loss Type)
PCLASS varchar2 255  √  null Data Element 54 (Property Class)
PVALUE varchar2 255  √  null Data Element 55 (Property Value)
PDATEREC date 7  √  null Data Element 56 (Date Recovered)
PNOVEH varchar2 255  √  null Data Element 57 (Number of Stolen/Recovered)
PDRUGTYPE varchar2 255  √  null Data Element 58 (Suspected Drug Type)
PDRUGQTY varchar2 255  √  null Data Element 59 (Estimated Drug Quantity)
PDRUGMSR varchar2 255  √  null Data Element 60 (Drug Measurement Type)
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
PNOVEHREC varchar2 255  √  null NIBR 19 Data Element (Number of Recovered)
PLOSSORIG varchar2 255  √  null NIBR Original property/loss status
ORECNO number 0  √  null Link to DS_ICR_OFFENSES
NIBRSOFFCD varchar2 255  √  null Link to DS_ICR_OFFENSES to determine NIBRS Offense Code.
PROPERTY_TYPE varchar2 255  √  null Property Type
NIBRSOFFCD2 varchar2 255  √  null
NIBRSOFFCD3 varchar2 255  √  null
NIBRSOFFCD4 varchar2 255  √  null
NIBRSOFFCD5 varchar2 255  √  null
NIBRSOFFCD6 varchar2 255  √  null
NIBRSOFFCD7 varchar2 255  √  null
NIBRSOFFCD8 varchar2 255  √  null
NIBRSOFFCD9 varchar2 255  √  null
NIBRSOFFCD10 varchar2 255  √  null
PDESCR varchar2 255  √  null
PMODEL varchar2 255  √  null
PCOLOR varchar2 255  √  null
PCALIBER varchar2 255  √  null
PSERIALNUM varchar2 255  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"HEADERID" IS NOT NULL DSICRPROP_HEADERID_NN
"PITEMNO" IS NOT NULL DSICRPROP_PITEMNO_NN
"PLOSSTYPE" IS NOT NULL DSICRPROP_PLOSSTYPE_NN
"PROPNO" IS NOT NULL DSICRPROP_PROPNO_NN

Indexes:
Column(s) Type Sort Constraint Name
HEADERID + PROPNO + PITEMNO + PLOSSTYPE Primary key Asc/Asc/Asc/Asc DSICRPROP_PK
HEADERID Performance Asc DSICRPROP_DSICRHD_FK_I

Close relationships  within of separation: