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;