-- ABS-86031 / ABS-89615
ALTER TABLE CLEANROOMBATCHCUSTOMER ADD (CRBCUSTOMERSTATUS NUMBER DEFAULT 0 NOT NULL 
                                   CONSTRAINT CHK_CRBCUSTOMERSTATUS CHECK (CRBCUSTOMERSTATUS IN (0,1)));

COMMENT ON COLUMN CLEANROOMBATCHCUSTOMER.CRBCUSTOMERSTATUS
  IS '0 = Open / Not applicable
1 = Closed';
