

INSERT
INTO HRIS_APPRAISAL_TYPE
  (
    APPRAISAL_TYPE_ID,
    APPRAISAL_TYPE_CODE,
    APPRAISAL_TYPE_EDESC,
    APPRAISAL_TYPE_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    1,
    'AA001',
    'Annual',
    NULL,
    7,2,7,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_TYPE
  (
    APPRAISAL_TYPE_ID,
    APPRAISAL_TYPE_CODE,
    APPRAISAL_TYPE_EDESC,
    APPRAISAL_TYPE_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    3,
    'AT003',
    'Training Period',
    NULL,
    7,2,7,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_TYPE
  (
    APPRAISAL_TYPE_ID,
    APPRAISAL_TYPE_CODE,
    APPRAISAL_TYPE_EDESC,
    APPRAISAL_TYPE_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    7,
    NULL,
    'Monthly',
    'Monthly',
    26,1,1000376,
    to_date('15-JUN-17','DD-MON-RR'),
    1000324,
    to_date('27-JUN-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('15-JUN-17','DD-MON-RR'),
    'N',
    'E',
    'TESTING'
  );
INSERT
INTO HRIS_APPRAISAL_TYPE
  (
    APPRAISAL_TYPE_ID,
    APPRAISAL_TYPE_CODE,
    APPRAISAL_TYPE_EDESC,
    APPRAISAL_TYPE_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    5,
    'AO005',
    'Others',
    NULL,
    7,2,7,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_TYPE
  (
    APPRAISAL_TYPE_ID,
    APPRAISAL_TYPE_CODE,
    APPRAISAL_TYPE_EDESC,
    APPRAISAL_TYPE_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    6,
    'sdf',
    'Fsdfsd',
    'Sdf',
    7,8,7,
    to_date('19-APR-17','DD-MON-RR'),
    7,
    to_date('02-MAY-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('19-APR-17','DD-MON-RR'),
    'N',
    'E',
    'sdfs'
  );
INSERT
INTO HRIS_APPRAISAL_TYPE
  (
    APPRAISAL_TYPE_ID,
    APPRAISAL_TYPE_CODE,
    APPRAISAL_TYPE_EDESC,
    APPRAISAL_TYPE_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    2,
    'AP002',
    'Probationary Period ',
    NULL,
    7,2,7,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_TYPE
  (
    APPRAISAL_TYPE_ID,
    APPRAISAL_TYPE_CODE,
    APPRAISAL_TYPE_EDESC,
    APPRAISAL_TYPE_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    4,
    'AC004',
    'Contract Staff',
    NULL,
    7,2,7,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
REM INSERTING into HRIS_APPRAISAL_STATUS
SET DEFINE OFF;
INSERT
INTO HRIS_APPRAISAL_STATUS
  (
    EMPLOYEE_ID,
    APPRAISAL_ID,
    ANNUAL_RATING_KPI,
    ANNUAL_RATING_COMPETENCY,
    APPRAISER_OVERALL_RATING,
    REVIEWER_AGREE,
    APPRAISEE_AGREE,
    APPRAISED_BY,
    REVIEWED_BY,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    DEFAULT_RATING,
    REVIEW_PERIOD,
    PREVIOUS_REVIEW_PERIOD,
    PREVIOUS_RATING,
    HR_FEEDBACK,
    SUPER_REVIEWER_FEEDBACK,
    SUPER_REVIEWER_AGREE
  )
  VALUES
  (
    1000370,1,
    1.2,
    NULL,
    '1.2',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('16-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STATUS
  (
    EMPLOYEE_ID,
    APPRAISAL_ID,
    ANNUAL_RATING_KPI,
    ANNUAL_RATING_COMPETENCY,
    APPRAISER_OVERALL_RATING,
    REVIEWER_AGREE,
    APPRAISEE_AGREE,
    APPRAISED_BY,
    REVIEWED_BY,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    DEFAULT_RATING,
    REVIEW_PERIOD,
    PREVIOUS_REVIEW_PERIOD,
    PREVIOUS_RATING,
    HR_FEEDBACK,
    SUPER_REVIEWER_FEEDBACK,
    SUPER_REVIEWER_AGREE
  )
  VALUES
  (
    60,2,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('30-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STATUS
  (
    EMPLOYEE_ID,
    APPRAISAL_ID,
    ANNUAL_RATING_KPI,
    ANNUAL_RATING_COMPETENCY,
    APPRAISER_OVERALL_RATING,
    REVIEWER_AGREE,
    APPRAISEE_AGREE,
    APPRAISED_BY,
    REVIEWED_BY,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    DEFAULT_RATING,
    REVIEW_PERIOD,
    PREVIOUS_REVIEW_PERIOD,
    PREVIOUS_RATING,
    HR_FEEDBACK,
    SUPER_REVIEWER_FEEDBACK,
    SUPER_REVIEWER_AGREE
  )
  VALUES
  (
    1000348,1,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('02-JUL-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STATUS
  (
    EMPLOYEE_ID,
    APPRAISAL_ID,
    ANNUAL_RATING_KPI,
    ANNUAL_RATING_COMPETENCY,
    APPRAISER_OVERALL_RATING,
    REVIEWER_AGREE,
    APPRAISEE_AGREE,
    APPRAISED_BY,
    REVIEWED_BY,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    DEFAULT_RATING,
    REVIEW_PERIOD,
    PREVIOUS_REVIEW_PERIOD,
    PREVIOUS_RATING,
    HR_FEEDBACK,
    SUPER_REVIEWER_FEEDBACK,
    SUPER_REVIEWER_AGREE
  )
  VALUES
  (
    1000364,1,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('18-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STATUS
  (
    EMPLOYEE_ID,
    APPRAISAL_ID,
    ANNUAL_RATING_KPI,
    ANNUAL_RATING_COMPETENCY,
    APPRAISER_OVERALL_RATING,
    REVIEWER_AGREE,
    APPRAISEE_AGREE,
    APPRAISED_BY,
    REVIEWED_BY,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    DEFAULT_RATING,
    REVIEW_PERIOD,
    PREVIOUS_REVIEW_PERIOD,
    PREVIOUS_RATING,
    HR_FEEDBACK,
    SUPER_REVIEWER_FEEDBACK,
    SUPER_REVIEWER_AGREE
  )
  VALUES
  (
    122,2,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STATUS
  (
    EMPLOYEE_ID,
    APPRAISAL_ID,
    ANNUAL_RATING_KPI,
    ANNUAL_RATING_COMPETENCY,
    APPRAISER_OVERALL_RATING,
    REVIEWER_AGREE,
    APPRAISEE_AGREE,
    APPRAISED_BY,
    REVIEWED_BY,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    DEFAULT_RATING,
    REVIEW_PERIOD,
    PREVIOUS_REVIEW_PERIOD,
    PREVIOUS_RATING,
    HR_FEEDBACK,
    SUPER_REVIEWER_FEEDBACK,
    SUPER_REVIEWER_AGREE
  )
  VALUES
  (
    1000378,1,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('05-JUL-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STATUS
  (
    EMPLOYEE_ID,
    APPRAISAL_ID,
    ANNUAL_RATING_KPI,
    ANNUAL_RATING_COMPETENCY,
    APPRAISER_OVERALL_RATING,
    REVIEWER_AGREE,
    APPRAISEE_AGREE,
    APPRAISED_BY,
    REVIEWED_BY,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    DEFAULT_RATING,
    REVIEW_PERIOD,
    PREVIOUS_REVIEW_PERIOD,
    PREVIOUS_RATING,
    HR_FEEDBACK,
    SUPER_REVIEWER_FEEDBACK,
    SUPER_REVIEWER_AGREE
  )
  VALUES
  (
    1000316,1,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('21-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STATUS
  (
    EMPLOYEE_ID,
    APPRAISAL_ID,
    ANNUAL_RATING_KPI,
    ANNUAL_RATING_COMPETENCY,
    APPRAISER_OVERALL_RATING,
    REVIEWER_AGREE,
    APPRAISEE_AGREE,
    APPRAISED_BY,
    REVIEWED_BY,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    DEFAULT_RATING,
    REVIEW_PERIOD,
    PREVIOUS_REVIEW_PERIOD,
    PREVIOUS_RATING,
    HR_FEEDBACK,
    SUPER_REVIEWER_FEEDBACK,
    SUPER_REVIEWER_AGREE
  )
  VALUES
  (
    1000276,1,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('05-JUL-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STATUS
  (
    EMPLOYEE_ID,
    APPRAISAL_ID,
    ANNUAL_RATING_KPI,
    ANNUAL_RATING_COMPETENCY,
    APPRAISER_OVERALL_RATING,
    REVIEWER_AGREE,
    APPRAISEE_AGREE,
    APPRAISED_BY,
    REVIEWED_BY,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    DEFAULT_RATING,
    REVIEW_PERIOD,
    PREVIOUS_REVIEW_PERIOD,
    PREVIOUS_RATING,
    HR_FEEDBACK,
    SUPER_REVIEWER_FEEDBACK,
    SUPER_REVIEWER_AGREE
  )
  VALUES
  (
    1000364,2,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('11-JUL-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STATUS
  (
    EMPLOYEE_ID,
    APPRAISAL_ID,
    ANNUAL_RATING_KPI,
    ANNUAL_RATING_COMPETENCY,
    APPRAISER_OVERALL_RATING,
    REVIEWER_AGREE,
    APPRAISEE_AGREE,
    APPRAISED_BY,
    REVIEWED_BY,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    DEFAULT_RATING,
    REVIEW_PERIOD,
    PREVIOUS_REVIEW_PERIOD,
    PREVIOUS_RATING,
    HR_FEEDBACK,
    SUPER_REVIEWER_FEEDBACK,
    SUPER_REVIEWER_AGREE
  )
  VALUES
  (
    60,1,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('20-JUL-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
  );
REM INSERTING into HRIS_APPRAISAL_STAGE_QUESTIONS
SET DEFINE OFF;
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    51,5,
    'E',
    to_date('14-JUN-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    53,1,
    'D',
    to_date('29-JUN-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    54,1,
    'D',
    to_date('29-JUN-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    55,1,
    'D',
    to_date('29-JUN-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    56,1,
    'D',
    to_date('29-JUN-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    49,1,
    'D',
    to_date('23-MAY-17','DD-MON-RR'),
    to_date('13-JUN-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    57,1,
    'D',
    to_date('29-JUN-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    58,1,
    'D',
    to_date('29-JUN-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    59,1,
    'D',
    to_date('29-JUN-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    60,1,
    'D',
    to_date('29-JUN-17','DD-MON-RR'),
    to_date('29-JUN-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    61,1,
    'D',
    to_date('29-JUN-17','DD-MON-RR'),
    to_date('29-JUN-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    62,1,
    'D',
    to_date('29-JUN-17','DD-MON-RR'),
    to_date('29-JUN-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    63,1,
    'D',
    to_date('29-JUN-17','DD-MON-RR'),
    to_date('29-JUN-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    64,1,
    'D',
    to_date('29-JUN-17','DD-MON-RR'),
    to_date('29-JUN-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    65,3,
    'E',
    to_date('29-JUN-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    1,1,
    'D',
    to_date('16-MAR-17','DD-MON-RR'),
    to_date('13-JUN-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    2,1,
    'D',
    to_date('16-MAR-17','DD-MON-RR'),
    to_date('13-JUN-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    5,1,
    'D',
    to_date('17-MAR-17','DD-MON-RR'),
    to_date('25-MAY-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    6,1,
    'D',
    to_date('17-MAR-17','DD-MON-RR'),
    to_date('25-MAY-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    7,1,
    'D',
    to_date('17-MAR-17','DD-MON-RR'),
    to_date('25-MAY-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    8,1,
    'D',
    to_date('17-MAR-17','DD-MON-RR'),
    to_date('25-MAY-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    9,1,
    'D',
    to_date('17-MAR-17','DD-MON-RR'),
    to_date('25-MAY-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    53,1,
    'D',
    to_date('11-JUL-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    54,1,
    'D',
    to_date('11-JUL-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    55,1,
    'D',
    to_date('11-JUL-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    56,1,
    'D',
    to_date('11-JUL-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    57,1,
    'D',
    to_date('11-JUL-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    58,1,
    'D',
    to_date('11-JUL-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    59,1,
    'D',
    to_date('11-JUL-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    10,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    11,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    12,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    13,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    14,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    15,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    16,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    17,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    18,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    19,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    20,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    21,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    22,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    23,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    24,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    25,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    26,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    27,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    28,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    29,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    30,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    31,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    32,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    33,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    34,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    35,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    36,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    37,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    38,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    39,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    40,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    41,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    42,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    43,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    44,5,
    'D',
    to_date('25-MAY-17','DD-MON-RR'),
    to_date('25-MAY-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    53,5,
    'E',
    to_date('11-JUL-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    54,5,
    'E',
    to_date('11-JUL-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    55,5,
    'E',
    to_date('11-JUL-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    56,5,
    'E',
    to_date('11-JUL-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    57,5,
    'E',
    to_date('11-JUL-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    58,5,
    'E',
    to_date('11-JUL-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    59,5,
    'E',
    to_date('11-JUL-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    1,1,
    'D',
    to_date('13-JUN-17','DD-MON-RR'),
    to_date('13-JUN-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    2,1,
    'D',
    to_date('13-JUN-17','DD-MON-RR'),
    to_date('13-JUN-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    47,1,
    'D',
    to_date('13-JUN-17','DD-MON-RR'),
    to_date('13-JUN-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    48,1,
    'D',
    to_date('13-JUN-17','DD-MON-RR'),
    to_date('13-JUN-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    49,1,
    'D',
    to_date('13-JUN-17','DD-MON-RR'),
    to_date('13-JUN-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    50,1,
    'D',
    to_date('13-JUN-17','DD-MON-RR'),
    to_date('13-JUN-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    50,1,
    'D',
    to_date('23-MAY-17','DD-MON-RR'),
    to_date('13-JUN-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    47,1,
    'D',
    to_date('23-MAY-17','DD-MON-RR'),
    to_date('13-JUN-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    3,1,
    'D',
    to_date('16-MAR-17','DD-MON-RR'),
    to_date('13-JUN-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    4,1,
    'D',
    to_date('16-MAR-17','DD-MON-RR'),
    to_date('13-JUN-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    48,1,
    'D',
    to_date('23-MAY-17','DD-MON-RR'),
    to_date('13-JUN-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    5,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    6,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    7,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    8,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    9,5,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    45,5,
    'D',
    to_date('25-MAY-17','DD-MON-RR'),
    to_date('25-MAY-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    45,6,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    44,6,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    46,3,
    'E',
    to_date('25-MAY-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    66,6,
    'E',
    to_date('29-JUN-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    53,5,
    'D',
    to_date('29-JUN-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    54,5,
    'D',
    to_date('29-JUN-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    55,5,
    'D',
    to_date('29-JUN-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    56,5,
    'D',
    to_date('29-JUN-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    57,5,
    'D',
    to_date('29-JUN-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    58,5,
    'D',
    to_date('29-JUN-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    59,5,
    'D',
    to_date('29-JUN-17','DD-MON-RR'),
    to_date('11-JUL-17','DD-MON-RR')
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    60,5,
    'E',
    to_date('29-JUN-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    61,5,
    'E',
    to_date('29-JUN-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    62,5,
    'E',
    to_date('29-JUN-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    63,5,
    'E',
    to_date('29-JUN-17','DD-MON-RR'),
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE_QUESTIONS
  (
    QUESTION_ID,
    STAGE_ID,
    STATUS,
    CREATED_DATE,
    MODIFIED_DATE
  )
  VALUES
  (
    64,5,
    'E',
    to_date('29-JUN-17','DD-MON-RR'),
    NULL
  );
REM INSERTING into HRIS_APPRAISAL_STAGE
SET DEFINE OFF;
INSERT
INTO HRIS_APPRAISAL_STAGE
  (
    STAGE_ID,
    STAGE_CODE,
    STAGE_EDESC,
    STAGE_NDESC,
    START_DATE,
    END_DATE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    5,
    '366',
    'Appraiser Evaluation',
    NULL,
    to_date('17-MAY-17','DD-MON-RR'),
    to_date('25-MAY-17','DD-MON-RR'),
    2,7,2,7,
    to_date('07-APR-17','DD-MON-RR'),
    1,
    to_date('25-MAY-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('07-APR-17','DD-MON-RR'),
    'N',
    'E',
    'asdasd'
  );
INSERT
INTO HRIS_APPRAISAL_STAGE
  (
    STAGE_ID,
    STAGE_CODE,
    STAGE_EDESC,
    STAGE_NDESC,
    START_DATE,
    END_DATE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    3,
    'SC003',
    'Reviewer Comment',
    NULL,
    to_date('31-MAR-17','DD-MON-RR'),
    to_date('31-MAR-17','DD-MON-RR'),
    3,7,2,7,
    to_date('16-MAR-17','DD-MON-RR'),
    1,
    to_date('25-MAY-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE
  (
    STAGE_ID,
    STAGE_CODE,
    STAGE_EDESC,
    STAGE_NDESC,
    START_DATE,
    END_DATE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    6,
    'dsf',
    'Appraisee View',
    NULL,
    to_date('27-APR-17','DD-MON-RR'),
    to_date('29-APR-17','DD-MON-RR'),
    5,7,8,7,
    to_date('19-APR-17','DD-MON-RR'),
    1,
    to_date('25-MAY-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('19-APR-17','DD-MON-RR'),
    'N',
    'E',
    'sdf'
  );
INSERT
INTO HRIS_APPRAISAL_STAGE
  (
    STAGE_ID,
    STAGE_CODE,
    STAGE_EDESC,
    STAGE_NDESC,
    START_DATE,
    END_DATE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    4,
    'SL004',
    'Locked',
    NULL,
    NULL,
    NULL,
    7,7,2,7,
    to_date('16-MAR-17','DD-MON-RR'),
    1,
    to_date('25-MAY-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE
  (
    STAGE_ID,
    STAGE_CODE,
    STAGE_EDESC,
    STAGE_NDESC,
    START_DATE,
    END_DATE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    7,
    NULL,
    'Key Achievement',
    NULL,
    to_date('01-JUN-17','DD-MON-RR'),
    to_date('30-JUN-17','DD-MON-RR'),
    1,26,1,1000376,
    to_date('13-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('13-JUN-17','DD-MON-RR'),
    'N',
    'E',
    'test'
  );
INSERT
INTO HRIS_APPRAISAL_STAGE
  (
    STAGE_ID,
    STAGE_CODE,
    STAGE_EDESC,
    STAGE_NDESC,
    START_DATE,
    END_DATE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    9,
    'SK009',
    'HR Comment',
    NULL,
    NULL,
    NULL,
    8,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    'N',
    NULL,
    NULL,
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE
  (
    STAGE_ID,
    STAGE_CODE,
    STAGE_EDESC,
    STAGE_NDESC,
    START_DATE,
    END_DATE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    1,
    'SB001',
    'Beginning',
    NULL,
    to_date('01-APR-17','DD-MON-RR'),
    to_date('15-APR-17','DD-MON-RR'),
    1,7,2,7,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE
  (
    STAGE_ID,
    STAGE_CODE,
    STAGE_EDESC,
    STAGE_NDESC,
    START_DATE,
    END_DATE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    2,
    'SK002',
    'Completed',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    to_date('31-MAR-17','DD-MON-RR'),
    6,7,2,7,
    to_date('16-MAR-17','DD-MON-RR'),
    1,
    to_date('25-MAY-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_STAGE
  (
    STAGE_ID,
    STAGE_CODE,
    STAGE_EDESC,
    STAGE_NDESC,
    START_DATE,
    END_DATE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    8,
    'SK008',
    'Super Reviewer Comment',
    NULL,
    NULL,
    NULL,
    4,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    'N',
    NULL,
    NULL,
    'N',
    'E',
    NULL
  );
REM INSERTING into HRIS_APPRAISAL_SETUP
SET DEFINE OFF;
INSERT
INTO HRIS_APPRAISAL_SETUP
  (
    APPRAISAL_ID,
    APPRAISAL_CODE,
    APPRAISAL_EDESC,
    APPRAISAL_NDESC,
    APPRAISAL_TYPE_ID,
    START_DATE,
    END_DATE,
    CURRENT_STAGE_ID,
    REMARKS,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    KPI_SETTING,
    COMPETENCIES_SETTING,
    HR_FEEDBACK_ENABLE
  )
  VALUES
  (
    3,
    'wer',
    'wer',
    'wer',
    1,
    to_date('26-APR-17','DD-MON-RR'),
    to_date('28-APR-17','DD-MON-RR'),
    1,
    NULL,
    7,8,7,
    to_date('19-APR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('19-APR-17','DD-MON-RR'),
    'N',
    'E',
    'N',
    'N',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_SETUP
  (
    APPRAISAL_ID,
    APPRAISAL_CODE,
    APPRAISAL_EDESC,
    APPRAISAL_NDESC,
    APPRAISAL_TYPE_ID,
    START_DATE,
    END_DATE,
    CURRENT_STAGE_ID,
    REMARKS,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    KPI_SETTING,
    COMPETENCIES_SETTING,
    HR_FEEDBACK_ENABLE
  )
  VALUES
  (
    1,
    'AC001',
    'Annual Appraisal 2017 ',
    NULL,
    1,
    to_date('01-MAR-17','DD-MON-RR'),
    to_date('31-MAR-17','DD-MON-RR'),
    7,
    NULL,
    7,2,7,
    to_date('16-MAR-17','DD-MON-RR'),
    1000370,
    to_date('23-JUL-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    'Y',
    'Y',
    'Y'
  );
INSERT
INTO HRIS_APPRAISAL_SETUP
  (
    APPRAISAL_ID,
    APPRAISAL_CODE,
    APPRAISAL_EDESC,
    APPRAISAL_NDESC,
    APPRAISAL_TYPE_ID,
    START_DATE,
    END_DATE,
    CURRENT_STAGE_ID,
    REMARKS,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    KPI_SETTING,
    COMPETENCIES_SETTING,
    HR_FEEDBACK_ENABLE
  )
  VALUES
  (
    2,
    'sad',
    'Monthly Appraisal June',
    NULL,
    7,
    to_date('01-JUN-17','DD-MON-RR'),
    to_date('30-JUN-17','DD-MON-RR'),
    5,
    NULL,
    7,2,7,
    to_date('07-APR-17','DD-MON-RR'),
    1000370,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('07-APR-17','DD-MON-RR'),
    'N',
    'E',
    'N',
    'N',
    'Y'
  );
REM INSERTING into HRIS_APPRAISAL_QUESTION_OPTS
SET DEFINE OFF;
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    18,
    '18',
    55,
    'Unsatisfactory',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    6,
    '6',
    49,
    'Gulmi',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('23-MAY-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('23-MAY-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    7,
    '7',
    49,
    'Baglung',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('23-MAY-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('23-MAY-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    19,
    '19',
    55,
    'Improvement Needed',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    20,
    '20',
    55,
    'Meets Expectations',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    21,
    '21',
    55,
    'Good',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    22,
    '22',
    55,
    'Excellent',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    28,
    '28',
    57,
    'Unsatisfactory',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    29,
    '29',
    57,
    'Improvement Needed',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    30,
    '30',
    57,
    'Meets Expectations',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    31,
    '31',
    57,
    'Good',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    32,
    '32',
    57,
    'Excellent',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    3,
    '3',
    48,
    'Playing',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('23-MAY-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('23-MAY-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    4,
    '4',
    48,
    'Singing',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('23-MAY-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('23-MAY-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    5,
    '5',
    48,
    'Dancing',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('23-MAY-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('23-MAY-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    13,
    '13',
    54,
    'Unsatisfactory',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    14,
    '14',
    54,
    'Improvement Needed',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    15,
    '15',
    54,
    'Meets Expectations',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    16,
    '16',
    54,
    'Good',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    17,
    '17',
    54,
    'Excellent',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    23,
    '23',
    56,
    'Unsatisfactory',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    24,
    '24',
    56,
    'Improvement Needed',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    25,
    '25',
    56,
    'Meets Expectations',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    26,
    '26',
    56,
    'Good',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    27,
    '27',
    56,
    'Excellent',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    33,
    '33',
    58,
    'Unsatisfactory',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    34,
    '34',
    58,
    'Improvement Needed',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    35,
    '35',
    58,
    'Meets Expectations',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    36,
    '36',
    58,
    'Good',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    37,
    '37',
    58,
    'Excellent',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    43,
    '43',
    60,
    'Unsatisfactory',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    44,
    '44',
    60,
    'Improvement Needed',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    45,
    '45',
    60,
    'Meets Expectations',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    46,
    '46',
    60,
    'Good',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    47,
    '47',
    60,
    'Excellent',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    38,
    '38',
    59,
    'Unsatisfactory',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    39,
    '39',
    59,
    'Improvement Needed',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    40,
    '40',
    59,
    'Meets Expectations',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    1,
    '1',
    50,
    'Yes',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('20-APR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('20-APR-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    2,
    '2',
    50,
    'No',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('20-APR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('20-APR-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    41,
    '41',
    59,
    'Good',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    42,
    '42',
    59,
    'Excellent',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    10,
    '10',
    53,
    'Meets Expectations',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    11,
    '11',
    53,
    'Good',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    12,
    '12',
    53,
    'Excellent',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    8,
    '8',
    53,
    'Unsatisfactory',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION_OPTS
  (
    OPTION_ID,
    OPTION_CODE,
    QUESTION_ID,
    OPTION_EDESC,
    OPTION_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    9,
    '9',
    53,
    'Improvement Needed',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E'
  );
REM INSERTING into HRIS_APPRAISAL_QUESTION
SET DEFINE OFF;
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    2,
    'QA002',
    1,
    '(B) ACHIEVEMENT ON 1 (A):',
    NULL,
    'Y',
    'N',
    'N',
    'N',
    'N',
    'N',
    NULL,
    NULL,
    2,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXTAREA',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    1,
    'QJ001',
    1,
    '1. (A) Job Requirement:',
    NULL,
    'Y',
    'N',
    'N',
    'Y',
    'Y',
    'Y',
    20,0,1,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    to_date('07-JUN-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXTAREA',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    6,
    'QJTA07',
    3,
    'Job Target Achieved',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,2,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    7,
    'QQ008',
    3,
    'Quality of Job Performed',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,3,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    22,
    'QDACS',
    5,
    'Diagnostic and conceptual Skills',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,7,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    28,
    'QCPS',
    6,
    'Presentation Skills',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,2,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    30,
    'QLS',
    6,
    'listening Skills',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,4,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    47,
    'dsf',
    1,
    'Your Name',
    'Your Name',
    'Y',
    'N',
    'N',
    'N',
    'N',
    'N',
    0,0,6,
    NULL,
    NULL,
    NULL,
    to_date('19-APR-17','DD-MON-RR'),
    NULL,
    to_date('23-MAY-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('19-APR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'PERCENTAGE',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    62,
    'APP00010',
    21,
    'Identified Weakness:',
    NULL,
    'N',
    'Y',
    'N',
    'N',
    'N',
    'N',
    NULL,
    NULL,
    2,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXTAREA',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    64,
    'AP0012',
    22,
    'Comments:',
    NULL,
    'N',
    'Y',
    'N',
    'N',
    'N',
    'N',
    NULL,
    NULL,
    1,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXTAREA',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    55,
    'AP003',
    19,
    'Attitude towards his/her work',
    NULL,
    'N',
    'Y',
    'N',
    'N',
    'N',
    'N',
    NULL,
    NULL,
    3,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'RADIO',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    57,
    'AP005',
    19,
    'Contribution towards the completion of team achievements',
    NULL,
    'N',
    'Y',
    'N',
    'N',
    'N',
    'N',
    NULL,
    NULL,
    5,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'RADIO',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    8,
    'QC009',
    3,
    'Creativity in Achieving Target',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,4,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    9,
    'QT010',
    3,
    'Teamwork in Achieving Target',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,5,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    10,
    'QA0012',
    4,
    'Attitude to Company Values',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,1,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    11,
    'QCCC01',
    4,
    'Code of Conduct Values',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,2,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    12,
    'QAWS03',
    4,
    'Attitude with Subordinates',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,3,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    24,
    'QPS',
    5,
    'Prioritizing Skills',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,9,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    17,
    'QTM',
    5,
    'Time Management',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,2,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    21,
    'QPAOS',
    5,
    'Planning and organizing skills',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,6,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    32,
    'QIH',
    7,
    'Integrity/Honesty',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,1,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    34,
    'QI',
    7,
    'Initative',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,3,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    37,
    'QPU',
    7,
    'Punctuality',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    9,1,6,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    40,
    'QW001',
    9,
    'Weakness',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    NULL,
    NULL,
    1,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXTAREA',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    44,
    'QC001',
    13,
    'Comment Towards Appraisal',
    NULL,
    'Y',
    'N',
    'N',
    'N',
    'N',
    'N',
    20,0,1,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    to_date('06-JUN-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXTAREA',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    54,
    'APP002',
    19,
    'Quality of work(maintain standards,accuracy,and quality consciousness)',
    NULL,
    'N',
    'Y',
    'N',
    'N',
    'N',
    'N',
    NULL,
    NULL,
    2,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'RADIO',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    56,
    'APP004',
    19,
    'Attitude towards colleagues',
    NULL,
    'N',
    'Y',
    'N',
    'N',
    'N',
    'N',
    NULL,
    NULL,
    4,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'RADIO',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    58,
    'APP006',
    19,
    'Ability to communicate in English(Verbal & written)',
    NULL,
    'N',
    'Y',
    'N',
    'N',
    'N',
    'N',
    NULL,
    NULL,
    6,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'RADIO',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    60,
    'APP008',
    20,
    'Overall Rating(Please Tick The Most Appropriate Box)',
    NULL,
    'N',
    'Y',
    'N',
    'N',
    'N',
    'N',
    0,0,1,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'RADIO',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    3,
    'AW003',
    2,
    '2. (A) WEAKNESS POINTED OUT IN THE PREVIOUS APPRAISAL',
    NULL,
    'Y',
    'N',
    'N',
    'N',
    'N',
    'N',
    NULL,
    NULL,
    1,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXTAREA',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    4,
    'QI004',
    2,
    '(B) Improvement On 2 (A)',
    NULL,
    'Y',
    'N',
    'N',
    'Y',
    'N',
    'N',
    15,0,2,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    to_date('28-MAY-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXTAREA',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    5,
    'QJK05',
    3,
    'Job Knowledge',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,1,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    to_date('07-JUN-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    18,
    'QCM',
    5,
    'Change Management',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,3,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    19,
    'QSD',
    5,
    'Staff Development',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,4,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    20,
    'QMACS',
    5,
    'Monitoring and controlling Skills',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,5,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    35,
    '@DAD',
    7,
    'Drive and Determination',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,4,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    42,
    'QTR001',
    11,
    'Training Required',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    NULL,
    NULL,
    1,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXTAREA',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    43,
    'QJAR',
    12,
    'List 3 jobs with reasons',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    NULL,
    NULL,
    1,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXTAREA',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    48,
    'QI004sad',
    1,
    'Your Hobbie',
    'Your Hobbie',
    'Y',
    'N',
    'N',
    'N',
    'N',
    'N',
    0,0,6,
    NULL,
    NULL,
    NULL,
    to_date('19-APR-17','DD-MON-RR'),
    NULL,
    to_date('23-MAY-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('19-APR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'CHECKBOX',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    49,
    'sdf',
    1,
    'Birth Place',
    'Birth Place',
    'Y',
    'N',
    'N',
    'N',
    'N',
    'N',
    0,0,4,
    NULL,
    NULL,
    NULL,
    to_date('19-APR-17','DD-MON-RR'),
    NULL,
    to_date('23-MAY-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('19-APR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'SELECT',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    50,
    'DFG',
    1,
    'Do You Have Any Comment ?',
    'Dfg',
    'Y',
    'N',
    'N',
    'N',
    'N',
    'N',
    0,0,9,
    NULL,
    NULL,
    NULL,
    to_date('20-APR-17','DD-MON-RR'),
    NULL,
    to_date('23-MAY-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('20-APR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'RADIO',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    65,
    'AP0013',
    23,
    'Comments:',
    NULL,
    'N',
    'N',
    'Y',
    'N',
    'N',
    'N',
    0,0,1,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXTAREA',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    59,
    'APP007',
    19,
    'Eagerness to take initiative',
    NULL,
    'N',
    'Y',
    'N',
    'N',
    'N',
    'N',
    NULL,
    NULL,
    7,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'RADIO',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    63,
    'AP00011',
    21,
    'Identified Training & Development Needs(If any):',
    NULL,
    'N',
    'Y',
    'N',
    'N',
    'N',
    'N',
    NULL,
    NULL,
    3,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXTAREA',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    29,
    'QWS',
    6,
    'written Skills',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,3,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    31,
    'QATC',
    6,
    'Ability To comprehend',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,5,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    23,
    'QBS',
    5,
    'Budgeting Skills',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,8,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    27,
    'QIS',
    6,
    'Interpersonal Skills',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,1,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    36,
    'QPER',
    7,
    'Personality',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,5,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    38,
    'QVIS',
    7,
    'Innovative Skills',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,7,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    41,
    'QI001',
    10,
    'Improvements',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    NULL,
    NULL,
    1,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXTAREA',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    45,
    'QC002',
    14,
    'Comment Towards Supervisor',
    NULL,
    'Y',
    'N',
    'N',
    'N',
    'N',
    'N',
    50,0,1,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    to_date('06-JUN-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXTAREA',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    51,
    'AP004',
    18,
    'Appraiser''s Comment:',
    NULL,
    'N',
    'Y',
    'N',
    'N',
    'N',
    'N',
    100,1,1,
    NULL,
    NULL,
    NULL,
    to_date('14-JUN-17','DD-MON-RR'),
    1,
    to_date('06-JUL-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('14-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXTAREA',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    52,
    'd',
    1,
    'sdf',
    NULL,
    'Y',
    'Y',
    'Y',
    'Y',
    'Y',
    'Y',
    NULL,
    NULL,
    5,
    NULL,
    NULL,
    NULL,
    to_date('21-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('21-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXT',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    14,
    'QAWC',
    4,
    'Attitude with Customers',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,5,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    13,
    'QAWP',
    4,
    'Attitude with Peers',
    'Attitude with Peers',
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,4,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    15,
    'QAWS',
    4,
    'Attitude with Superiors',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,6,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    16,
    'QLQ',
    5,
    'Leadership Qualities',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,1,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    25,
    'QTS',
    5,
    'Technical Skills',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,10,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    26,
    'QCS',
    5,
    'Crisis Management',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,11,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    33,
    'QD',
    7,
    'Dependability',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    10,1,2,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'NUMBER',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    39,
    'QS001',
    8,
    'Strength',
    NULL,
    'N',
    'N',
    'N',
    'N',
    'N',
    'N',
    NULL,
    NULL,
    1,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXTAREA',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    46,
    'QC003',
    15,
    'Comment By Supervisor',
    NULL,
    'N',
    'N',
    'Y',
    'N',
    'N',
    'N',
    50,0,1,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    to_date('06-JUN-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXTAREA',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    66,
    'APP0064',
    24,
    'Comments',
    NULL,
    'Y',
    'N',
    'N',
    'N',
    'N',
    'N',
    NULL,
    NULL,
    1,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXTAREA',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    53,
    'APP001',
    19,
    'Knowledge of the job',
    NULL,
    'N',
    'Y',
    'N',
    'N',
    'N',
    'N',
    NULL,
    NULL,
    1,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'RADIO',
    'N',
    'N'
  );
INSERT
INTO HRIS_APPRAISAL_QUESTION
  (
    QUESTION_ID,
    QUESTION_CODE,
    HEADING_ID,
    QUESTION_EDESC,
    QUESTION_NDESC,
    APPRAISEE_FLAG,
    APPRAISER_FLAG,
    REVIEWER_FLAG,
    APPRAISEE_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    MAX_VALUE,
    MIN_VALUE,
    ORDER_NO,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS,
    ANSWER_TYPE,
    HR_FLAG,
    HR_RATING
  )
  VALUES
  (
    61,
    'APP009',
    21,
    'Identified Strength:',
    NULL,
    'N',
    'Y',
    'N',
    'N',
    'N',
    'N',
    NULL,
    NULL,
    1,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL,
    'TEXTAREA',
    'N',
    'N'
  );
REM INSERTING into HRIS_APPRAISAL_KPI
SET DEFINE OFF;
INSERT
INTO HRIS_APPRAISAL_KPI
  (
    SNO,
    APPRAISAL_ID,
    EMPLOYEE_ID,
    TITLE,
    SUCCESS_CRITERIA,
    WEIGHT,
    KEY_ACHIEVEMENT,
    SELF_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    1,1,1000370,
    'kpi1',
    'criteria1',
    40,
    'sdf',
    1.2,
    1.2,
    NULL,
    26,1,1000370,
    to_date('23-JUL-17','DD-MON-RR'),
    1000324,
    to_date('01-AUG-17','DD-MON-RR'),
    'N',
    1000324,
    to_date('01-AUG-17','DD-MON-RR'),
    'N',
    'E'
  );
INSERT
INTO HRIS_APPRAISAL_KPI
  (
    SNO,
    APPRAISAL_ID,
    EMPLOYEE_ID,
    TITLE,
    SUCCESS_CRITERIA,
    WEIGHT,
    KEY_ACHIEVEMENT,
    SELF_RATING,
    APPRAISER_RATING,
    REVIEWER_RATING,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    2,1,1000370,
    'kpi2',
    'criteria2',
    60,
    'sdf',
    1.2,
    1.2,
    NULL,
    26,1,1000370,
    to_date('23-JUL-17','DD-MON-RR'),
    1000324,
    to_date('01-AUG-17','DD-MON-RR'),
    'N',
    1000324,
    to_date('01-AUG-17','DD-MON-RR'),
    'N',
    'E'
  );
REM INSERTING into HRIS_APPRAISAL_HEADING
SET DEFINE OFF;
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    8,
    'HW08',
    1,0,
    'What are the appraisee''s Strengths?',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    5,
    'HM05',
    1,25,
    'Management',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    7,
    'HV007',
    1,5,
    'Values',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    13,
    'HC012',
    1,0,
    'Comments of appraisee towards the appraisal',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    15,
    'HC014',
    1,0,
    'Comments of appraisers immediate supervisor',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    9,
    'HW009',
    1,0,
    'What are the appraisee''s Weaknesses?',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    23,
    NULL,
    7,0,
    'Comments by Line Manager',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    11,
    'HW011',
    1,0,
    'What are the areas that require training?',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    16,
    'test',
    6,22,
    'Test2',
    '22',
    NULL,
    NULL,
    NULL,
    to_date('07-APR-17','DD-MON-RR'),
    NULL,
    to_date('02-MAY-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('07-APR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    1,
    'HJ001',
    1,50,
    'Job Detail',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    2,
    'HW002',
    2,50,
    'Weakness',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    to_date('15-JUN-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    17,
    'dsf',
    4,45,
    'dsf',
    'dsf',
    NULL,
    NULL,
    NULL,
    to_date('19-APR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('19-APR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    19,
    NULL,
    7,0,
    'Performance Evaluation',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    20,
    NULL,
    7,0,
    'Overall Rating',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    21,
    NULL,
    7,0,
    'Performance Explaination',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    6,
    'HC06',
    1,15,
    'Communication',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    12,
    'HW013',
    1,0,
    'List at least 3 jobs where the appraisee would be suitable, with specific reasons as to why?',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    3,
    'HJT03',
    1,40,
    'Job Target',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    4,
    'HA04',
    1,15,
    'Attitude',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    10,
    'HW010',
    1,0,
    'What are the areas that need improvement?',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    14,
    'HC013',
    1,0,
    'Comments of appraisee towards the supervisor''s role in appraisee''s overall development',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    NULL,
    to_date('07-APR-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('16-MAR-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    18,
    NULL,
    1,0,
    'APPRASER''S REVIEW AND OVERALL RATING',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('14-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('14-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    22,
    NULL,
    7,0,
    'Comments by Appraisers immediate Line Manager',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_HEADING
  (
    HEADING_ID,
    HEADING_CODE,
    APPRAISAL_TYPE_ID,
    PERCENTAGE,
    HEADING_EDESC,
    HEADING_NDESC,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    REMARKS
  )
  VALUES
  (
    24,
    NULL,
    7,0,
    ' Appraisee''s Comments On The Overall Appraisal',
    NULL,
    NULL,
    NULL,
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    NULL
  );
REM INSERTING into HRIS_APPRAISAL_DEFAULT
SET DEFINE OFF;
INSERT
INTO HRIS_APPRAISAL_DEFAULT
  (
    ID,
    MIN_VALUE,
    MAX_VALUE,
    APPRAISAL_TYPE_ID,
    DESIGNATION_IDS,
    POSITION_IDS,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    DEFAULT_VALUE
  )
  VALUES
  (
    1,
    1.8,
    2.2,
    1,
    '["3","4"]',
    'null',
    26,1,1000370,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    2
  );
REM INSERTING into HRIS_APPRAISAL_ASSIGN
SET DEFINE OFF;
INSERT
INTO HRIS_APPRAISAL_ASSIGN
  (
    APPRAISAL_ID,
    EMPLOYEE_ID,
    APPRAISER_ID,
    REVIEWER_ID,
    REMARKS,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    CURRENT_STAGE_ID,
    ALT_APPRAISER_ID,
    ALT_REVIEWER_ID,
    SUPER_REVIEWER_ID
  )
  VALUES
  (
    1,1000370,1000376,1000324,
    NULL,
    26,1,1000370,
    to_date('16-JUN-17','DD-MON-RR'),
    1000370,
    to_date('01-AUG-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('16-JUN-17','DD-MON-RR'),
    'N',
    'E',
    1,
    NULL,
    NULL,
    1000385
  );
INSERT
INTO HRIS_APPRAISAL_ASSIGN
  (
    APPRAISAL_ID,
    EMPLOYEE_ID,
    APPRAISER_ID,
    REVIEWER_ID,
    REMARKS,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    CURRENT_STAGE_ID,
    ALT_APPRAISER_ID,
    ALT_REVIEWER_ID,
    SUPER_REVIEWER_ID
  )
  VALUES
  (
    2,60,1000376,1000324,
    NULL,
    26,1,1000370,
    to_date('30-JUN-17','DD-MON-RR'),
    1,
    to_date('05-JUL-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('30-JUN-17','DD-MON-RR'),
    'N',
    'E',
    2,
    NULL,
    NULL,
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_ASSIGN
  (
    APPRAISAL_ID,
    EMPLOYEE_ID,
    APPRAISER_ID,
    REVIEWER_ID,
    REMARKS,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    CURRENT_STAGE_ID,
    ALT_APPRAISER_ID,
    ALT_REVIEWER_ID,
    SUPER_REVIEWER_ID
  )
  VALUES
  (
    1,1000348,1000376,1000324,
    NULL,
    26,
    NULL,
    1,
    to_date('02-JUL-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('02-JUL-17','DD-MON-RR'),
    'N',
    'E',
    7,
    NULL,
    NULL,
    1000385
  );
INSERT
INTO HRIS_APPRAISAL_ASSIGN
  (
    APPRAISAL_ID,
    EMPLOYEE_ID,
    APPRAISER_ID,
    REVIEWER_ID,
    REMARKS,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    CURRENT_STAGE_ID,
    ALT_APPRAISER_ID,
    ALT_REVIEWER_ID,
    SUPER_REVIEWER_ID
  )
  VALUES
  (
    2,122,1000376,1000324,
    NULL,
    26,1,1000376,
    to_date('29-JUN-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('29-JUN-17','DD-MON-RR'),
    'N',
    'E',
    2,
    NULL,
    NULL,
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_ASSIGN
  (
    APPRAISAL_ID,
    EMPLOYEE_ID,
    APPRAISER_ID,
    REVIEWER_ID,
    REMARKS,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    CURRENT_STAGE_ID,
    ALT_APPRAISER_ID,
    ALT_REVIEWER_ID,
    SUPER_REVIEWER_ID
  )
  VALUES
  (
    1,1000378,123,1000325,
    NULL,
    26,
    NULL,
    1,
    to_date('05-JUL-17','DD-MON-RR'),
    1,
    to_date('05-JUL-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('05-JUL-17','DD-MON-RR'),
    'N',
    'E',
    7,
    NULL,
    NULL,
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_ASSIGN
  (
    APPRAISAL_ID,
    EMPLOYEE_ID,
    APPRAISER_ID,
    REVIEWER_ID,
    REMARKS,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    CURRENT_STAGE_ID,
    ALT_APPRAISER_ID,
    ALT_REVIEWER_ID,
    SUPER_REVIEWER_ID
  )
  VALUES
  (
    1,1000364,1000363,1000366,
    NULL,
    26,1,1000370,
    to_date('18-JUN-17','DD-MON-RR'),
    1000324,
    to_date('18-JUN-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('18-JUN-17','DD-MON-RR'),
    'N',
    'E',
    7,
    NULL,
    NULL,
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_ASSIGN
  (
    APPRAISAL_ID,
    EMPLOYEE_ID,
    APPRAISER_ID,
    REVIEWER_ID,
    REMARKS,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    CURRENT_STAGE_ID,
    ALT_APPRAISER_ID,
    ALT_REVIEWER_ID,
    SUPER_REVIEWER_ID
  )
  VALUES
  (
    1,1000316,1000376,1000324,
    NULL,
    26,1,1000376,
    to_date('21-JUN-17','DD-MON-RR'),
    1,
    to_date('05-JUL-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('21-JUN-17','DD-MON-RR'),
    'N',
    'E',
    7,
    NULL,
    NULL,
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_ASSIGN
  (
    APPRAISAL_ID,
    EMPLOYEE_ID,
    APPRAISER_ID,
    REVIEWER_ID,
    REMARKS,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    CURRENT_STAGE_ID,
    ALT_APPRAISER_ID,
    ALT_REVIEWER_ID,
    SUPER_REVIEWER_ID
  )
  VALUES
  (
    1,1000276,1000338,175,
    NULL,
    26,
    NULL,
    1,
    to_date('05-JUL-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('05-JUL-17','DD-MON-RR'),
    'N',
    'E',
    7,
    NULL,
    NULL,
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_ASSIGN
  (
    APPRAISAL_ID,
    EMPLOYEE_ID,
    APPRAISER_ID,
    REVIEWER_ID,
    REMARKS,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    CURRENT_STAGE_ID,
    ALT_APPRAISER_ID,
    ALT_REVIEWER_ID,
    SUPER_REVIEWER_ID
  )
  VALUES
  (
    2,1000364,
    NULL,
    1000316,
    NULL,
    26,1,1000370,
    to_date('11-JUL-17','DD-MON-RR'),
    1000370,
    to_date('11-JUL-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('11-JUL-17','DD-MON-RR'),
    'N',
    'E',
    7,
    NULL,
    NULL,
    NULL
  );
INSERT
INTO HRIS_APPRAISAL_ASSIGN
  (
    APPRAISAL_ID,
    EMPLOYEE_ID,
    APPRAISER_ID,
    REVIEWER_ID,
    REMARKS,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS,
    CURRENT_STAGE_ID,
    ALT_APPRAISER_ID,
    ALT_REVIEWER_ID,
    SUPER_REVIEWER_ID
  )
  VALUES
  (
    1,60,122,
    NULL,
    NULL,
    26,1,1000370,
    to_date('20-JUL-17','DD-MON-RR'),
    1000370,
    to_date('23-JUL-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('20-JUL-17','DD-MON-RR'),
    'N',
    'E',
    1,
    NULL,
    NULL,
    NULL
  );
REM INSERTING into HRIS_APPRAISAL_COMPETENCY
SET DEFINE OFF;
INSERT
INTO HRIS_APPRAISAL_COMPETENCY
  (
    APPRAISAL_ID,
    EMPLOYEE_ID,
    SNO,
    TITLE,
    RATING,
    COMMENTS,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    1,1000370,2,
    'sdfsdf',
    NULL,
    NULL,
    26,1,1000324,
    to_date('01-AUG-17','DD-MON-RR'),
    NULL,
    NULL,
    'N',
    NULL,
    to_date('01-AUG-17','DD-MON-RR'),
    'N',
    'E'
  );

INSERT
INTO HRIS_APPRAISAL_COMPETENCY
  (
    APPRAISAL_ID,
    EMPLOYEE_ID,
    SNO,
    TITLE,
    RATING,
    COMMENTS,
    COMPANY_ID,
    BRANCH_ID,
    CREATED_BY,
    CREATED_DATE,
    MODIFIED_BY,
    MODIFIED_DATE,
    CHECKED,
    APPROVED_BY,
    APPROVED_DATE,
    APPROVED,
    STATUS
  )
  VALUES
  (
    1,1000370,1,
    'compe',
    NULL,
    NULL,
    26,1,1000370,
    to_date('23-JUL-17','DD-MON-RR'),
    1000324,
    to_date('01-AUG-17','DD-MON-RR'),
    'N',
    NULL,
    to_date('23-JUL-17','DD-MON-RR'),
    'N',
    'E'
  );

