CREATE TABLE HRIS_TRAVEL_MASTER_SETUP
  (
    TRAVEL_ID                 NUMBER(7,0) PRIMARY KEY,
    TRAVEL_CODE               VARCHAR2(15 BYTE),
    TRAVEL_ENAME              VARCHAR2(255 BYTE),
    TRAVEL_LNAME              VARCHAR2(255 BYTE),
    SETTLEMENT_FLAG           CHAR(1 BYTE) DEFAULT 'N' NOT NULL CHECK(SETTLEMENT_FLAG           IN ('Y','N')),
    TADA_SETTLEMENT_FLAG      CHAR(1 BYTE) DEFAULT 'N' NOT NULL CHECK(TADA_SETTLEMENT_FLAG      IN ('Y','N')),
    OVERRIDE_RECOMMENDER_FLAG CHAR(1 BYTE) DEFAULT 'N' NOT NULL CHECK(OVERRIDE_RECOMMENDER_FLAG IN ('Y','N')),
    OVERRIDE_APPROVER_FLAG    CHAR(1 BYTE) DEFAULT 'N' NOT NULL CHECK(OVERRIDE_APPROVER_FLAG    IN ('Y','N')),
    ENABLE_SUBSTITUTE         CHAR(1 BYTE) DEFAULT 'N' NOT NULL CHECK(ENABLE_SUBSTITUTE         IN ('Y','N')),
    IS_SUBSTITUTE_MANDATORY   CHAR(1 BYTE) DEFAULT 'N' NOT NULL CHECK(IS_SUBSTITUTE_MANDATORY   IN ('Y','N')),
    FALM_TYPE                 CHAR(1 BYTE) DEFAULT 'F' NOT NULL CHECK(FALM_TYPE                 IN ('F','B'))
  );
--
ALTER TABLE HRIS_EMPLOYEE_TRAVEL_REQUEST ADD TRAVEL_ID NUMBER(7,0);
--
ALTER TABLE HRIS_EMPLOYEE_TRAVEL_REQUEST ADD CONSTRAINT TVL_REQ_TVL_FK FOREIGN KEY(TRAVEL_ID) REFERENCES HRIS_EMPLOYEE_TRAVEL_REQUEST(TRAVEL_ID);
--
ALTER TABLE HRIS_EMPLOYEE_TRAVEL_REQUEST ADD ADVANCE_RECOMMENDED_BY NUMBER(7,0);
--
ALTER TABLE HRIS_EMPLOYEE_TRAVEL_REQUEST ADD ADVANCE_RECOMMENDED_DATE DATE;
--
ALTER TABLE HRIS_EMPLOYEE_TRAVEL_REQUEST ADD ADVANCE_RECOMMENDED_REMARKS VARCHAR2(255 BYTE);
--
ALTER TABLE HRIS_EMPLOYEE_TRAVEL_REQUEST ADD ADVANCE_APPROVED_BY NUMBER(7,0);
--
ALTER TABLE HRIS_EMPLOYEE_TRAVEL_REQUEST ADD ADVANCE_APPROVED_DATE DATE;
--
ALTER TABLE HRIS_EMPLOYEE_TRAVEL_REQUEST ADD ADVANCE_APPROVED_REMARKS VARCHAR2(255 BYTE);
