--ABS-153379

--CONTACTCATEGORY TABLE
ALTER TABLE CONTACTCATEGORY ADD (ALLOWCOMPLETEONRA VARCHAR2(1) DEFAULT 'Y' NOT NULL CONSTRAINT CHK_CONTACTCATEGORY_ALLOWCOMPLETEONRA CHECK (ALLOWCOMPLETEONRA IN ('Y', 'N')),
                                 SELECTABLEONRA    VARCHAR2(1) DEFAULT 'Y' NOT NULL CONSTRAINT CHK_CONTACTCATEGORY_SELECTABLEONRA CHECK (SELECTABLEONRA IN ('Y', 'N')));
                                 
COMMENT ON COLUMN CONTACTCATEGORY.ALLOWCOMPLETEONRA IS 'Y/N field to indicate whether the contact can be marked as complete on Route Assistant if it has this category'; 
COMMENT ON COLUMN CONTACTCATEGORY.SELECTABLEONRA IS 'Y/N field to indicate whether the contact category can be used on the Route Assistant';                             
