program_id: ZAN06UPD
db_type: SQLite

db_tables:
  - name: ZANTBL01
    sql_name: OVT_APPLICATIONS
    columns:
      - name: APPL_ID
        type: CHAR(8)
        primary_key: true
      - name: EMP_ID
        type: CHAR(8)
      - name: APPL_DATE
        type: CHAR(8)
      - name: OVT_TYPE
        type: CHAR(1)
      - name: START_TIME
        type: CHAR(4)
      - name: END_TIME
        type: CHAR(4)
      - name: OVT_HOURS
        type: NUMERIC(4,1)
      - name: STATUS
        type: CHAR(1)
      - name: UPDATED_AT
        type: TIMESTAMP

  - name: ZANTBL02
    sql_name: OVT_MONTHLY
    columns:
      - name: EMP_ID
        type: CHAR(8)
        primary_key: true
      - name: YEAR_MONTH
        type: CHAR(6)
        primary_key: true
      - name: OVT_TYPE
        type: CHAR(1)
        primary_key: true
      - name: OVT_HOURS
        type: NUMERIC(8,1)
      - name: OVT_COUNT
        type: NUMERIC(9)
      - name: UPDATED_AT
        type: TIMESTAMP

subprograms:
  - SUB01DAT
  - SUB02MSG
  - SUB03END
  - SUB04CHK
  - SUB05TIM

runs:
  - id: normal
    sysin:
      period: "202607"
      modes: ["NORMAL"]
  - id: collision
    sysin:
      period: "202607"
      modes: ["NORMAL"]
    inject_duplicate_pk: true
  - id: abnormal
    sysin:
      period: "202607"
      modes: ["NORMAL"]