program_id: KIN03EXP
db_type: SQLite
db_name: kin.db

db_tables:
  - name: LEAVE_RECORDS
    columns:
      - name: APPLICATION_ID
        type: INTEGER
        primary_key: true
      - name: EMP_ID
        type: CHAR(8)
      - name: LEAVE_TYPE
        type: CHAR(2)
      - name: START_DATE
        type: CHAR(8)
      - name: START_TIME
        type: CHAR(4)
      - name: END_DATE
        type: CHAR(8)
      - name: END_TIME
        type: CHAR(4)
      - name: STATUS
        type: CHAR(1)

  - name: HOLIDAY_CALENDAR
    columns:
      - name: HOLIDAY_DATE
        type: CHAR(8)
        primary_key: true
      - name: DESCRIPTION
        type: VARCHAR(50)

subprograms:
  - SUB01DAT
  - SUB02MSG
  - SUB03END

coverage_dates:
  LEAVE_RECORDS:
    - start: "20260701"
      end: "20260701"
      emp: "00000001"
    - start: "20260702"
      end: "20260702"
      emp: "00000001"
    - start: "20260704"
      end: "20260704"
      emp: "00000001"
    - start: "20260705"
      end: "20260705"
      emp: "00000001"
    - start: "20260131"
      end: "20260203"
      emp: "00000002"
    - start: "20260430"
      end: "20260502"
      emp: "00000002"
    - start: "20240228"
      end: "20240302"
      emp: "00000003"
    - start: "20230228"
      end: "20230302"
      emp: "00000003"
    - start: "20240229"
      end: "20240302"
      emp: "00000004"
    - start: "20230227"
      end: "20230302"
      emp: "00000004"
    - start: "20261230"
      end: "20270101"
      emp: "00000099"

runs:
  - id: normal
  - id: empty_cursor
    delete_all_rows: true
    row_overrides:
      LEAVE_RECORDS:
        STATUS: "9"