-- ABS-92087/ ABS-113717

-------- DEPARTMENT table -------------
ALTER TABLE DEPARTMENT ADD (WORKORDERSUPAPPROVALREQ NUMBER DEFAULT 0 NOT NULL
                                                 CONSTRAINT CHK_DEP_WOSUPAPP CHECK (WORKORDERSUPAPPROVALREQ IN (0, 1, 2)));
 
COMMENT ON COLUMN DEPARTMENT.WORKORDERSUPAPPROVALREQ
  IS '0 = Not applicable or inherit from customer
1 = Department specific work orders created via the web portal must be approved by supervisor first.
2 = Department specific work orders created by the web portal are not approved by supervisor.
This attribute is only used for the module WEBORDERSUPERVISORAPPROVAL, set to 0 if not used.
';
