--ABS-53261/ ABS-57050

ALTER TABLE DELIVERYSCAN ADD (SCANLEVEL NUMBER DEFAULT 0 NOT NULL
                              CONSTRAINT SCANLEVEL_VALID1_1 CHECK (SCANLEVEL IN (0, 1, 2)));

COMMENT ON COLUMN DELIVERYSCAN.SCANLEVEL
  IS '0 = Not Applicable
1 = Scan made on Parent level
2 = Scan made on Child level
';