iapro-view-queries.md

View Queries

The queries used to generate the custom views used by the extractor

dbo.OIM_LinkedNumbers

TK

dbo.OIM_Citizens

TK

dbo.OIM_UsesOfForce

TK

dbo.OIM_AssocIncOff

SELECT *
    FROM IA_ADM.OFFICERS
    JOIN IA_ADM.ASSOC_INC_OFF ON IA_ADM.OFFICERS.OFFNUM = IA_ADM.ASSOC_INC_OFF.OFFNUM
    JOIN IA_ADM.INCIDENTS ON IA_ADM.ASSOC_INC_OFF.INCNUM = IA_ADM.INCIDENTS.INCNUM;

dbo.OIM_AssocIncCit

SELECT *
    FROM IA_ADM.CITIZENS
    JOIN IA_ADM.ASSOC_INC_CIT ON IA_ADM.CITIZENS.CITNUM = IA_ADM.ASSOC_INC_CIT.CITNUM
    JOIN IA_ADM.INCIDENTS ON IA_ADM.ASSOC_INC_CIT.INCNUM = IA_ADM.INCIDENTS.INCNUM;

dbo.OIM_IncidentAddresses

SELECT *
    FROM IA_ADM.ADDRESSES
    JOIN IA_ADM.ASSOC_ADDR ON IA_ADM.ADDRESSES.ADDRNUM = IA_ADM.ASSOC_ADDR.ADDRNUM
    JOIN IA_ADM.INCIDENTS ON IA_ADM.ASSOC_ADDR.INCNUM = IA_ADM.INCIDENTS.INCNUM;