--ABS-83768 /ABS-116283

ALTER TABLE RESIDENTIALITEMSCAN ADD (RAGREASON_ID NUMBER NULL);

CREATE INDEX XIF13RESIDENTIALITEMSCAN ON RESIDENTIALITEMSCAN (RAGREASON_ID ASC);

ALTER TABLE RESIDENTIALITEMSCAN
  ADD CONSTRAINT FK_RESIDITSCAN_RAGR FOREIGN KEY (RAGREASON_ID)
  REFERENCES RAGREASON (RAGREASON_ID) ON DELETE SET NULL;