-- ABS-95122 / ABS-96980
--- VERTEXBATCHCONTROL ---
ALTER TABLE VERTEXBATCHCONTROL DROP CONSTRAINT CHK_VERTEXBATCH_STATUS;

ALTER TABLE VERTEXBATCHCONTROL ADD CONSTRAINT CHK_VERTEXBATCH_STATUS CHECK (BATCHSTATUS IN (0,1,2,3,4,5,6,7));

COMMENT ON COLUMN VERTEXBATCHCONTROL.BATCHSTATUS IS '0 = new (default)
1 = ready for processing
2 = Processing
3 = Complete
4 = Failed
5 = WebService
6 = Cancelled
7 = Finalized';