-- ABS-62306 / ABS-78116
--- ROUTECONTROL ---
ALTER TABLE ROUTECONTROL ADD (RETURNSTATUS NUMBER DEFAULT 1 NOT NULL
				CONSTRAINT RETURNSTATUS_VALID1 CHECK (RETURNSTATUS IN (1,2,3)));

COMMENT ON COLUMN ROUTECONTROL.RETURNSTATUS IS '1 = Not started
2 = In progress
3 = Completed';