-- ABS-160801/ ABS-161555
ALTER TABLE ROUTECONTROLEXTRAINFO ADD (WEARERMAINTENANCEREVIEW VARCHAR2(1) DEFAULT 'N' NOT NULL
                                                               CONSTRAINT CHK_RCEXTRAINFO_WEARERMAINTREVIEW CHECK (WEARERMAINTENANCEREVIEW IN ('Y', 'N')),
                                       CONTACTSREVIEW VARCHAR2(1) DEFAULT 'N' NOT NULL
                                                               CONSTRAINT CHK_RCEXTRAINFO_CONTACTSREVIEW CHECK (CONTACTSREVIEW IN ('Y', 'N'))
                                       );

COMMENT ON COLUMN ROUTECONTROLEXTRAINFO.WEARERMAINTENANCEREVIEW
  IS 'Used for module UNFCUSTOM
Set to Y when the wearer maintenance tab is reviewed in WebX route check in';
COMMENT ON COLUMN ROUTECONTROLEXTRAINFO.CONTACTSREVIEW
  IS 'Used for module UNFCUSTOM
Set to Y when the Contacts tab is reviewed in WebX route check in
';