/*SQL Export File gegenereerd door Magister op 20/11/2018.*/
/*SchoolMaster, Postbus 1277, 8900 CG Leeuwarden*/

/*Exportbestand: \\tsclient\C\TEMP\Controlelijst Leerling-vak-groep-docent_code_FBS.rpt*/
/*Tabel: ReportsUsr*/
/*Include DELETE: False*/
/*Modify function: INSERT*/
/*Database: MSSQL*/

INSERT INTO ReportsUsr (IDReports,omschr,titel,onderdeel,type,idReports_parent,eigenaarid,version,idReports_tmpl,font,checkstyle,kleur,SQL_COMM,REPORT_DEF,Volgnr,RapportGroep,bZichtbaarInternet,idHrnreportscategorie,Onderwijssoort,bGeenkolomkiezer) VALUES (NULL,'Controlelijst Leerling-vak-groep-docent_code_FBS','Controlelijst Leerling-vak-groep-docent','Leerlingen','Vakkenpakketten',0,70,'5.7.21.1',0,NULL,NULL,NULL,NULL,'object _1: TppReport
  AutoStop = False
  DataPipeline = daADSQueryDataView1.Aanmelding
  NoDataBehaviors = [ndMessageOnPage, ndBlankReport]
  OnNoData = ReportNoData
  PassSetting = psTwoPass
  PrinterSetup.BinName = ''Default''
  PrinterSetup.DocumentName = ''Report''
  PrinterSetup.Orientation = poLandscape
  PrinterSetup.PaperName = ''A4''
  PrinterSetup.PrinterName = ''Default''
  PrinterSetup.SaveDeviceSettings = False
  PrinterSetup.mmMarginBottom = 6350
  PrinterSetup.mmMarginLeft = 4000
  PrinterSetup.mmMarginRight = 4000
  PrinterSetup.mmMarginTop = 6350
  PrinterSetup.mmPaperHeight = 210000
  PrinterSetup.mmPaperWidth = 297000
  PrinterSetup.PaperSize = 9
  Template.Format = ftASCII
  Units = utMillimeters
  ArchiveFileName = ''($MyDocuments)\ReportArchive.raf''
  BeforePrint = pprDefaultReportBeforePrint
  DeviceType = ''Screen''
  DefaultFileDeviceType = ''PDF''
  EmailSettings.ReportFormat = ''PDF''
  LanguageID = ''Default''
  OpenFile = False
  OutlineSettings.CreateNode = True
  OutlineSettings.CreatePageNodes = True
  OutlineSettings.Enabled = True
  OutlineSettings.Visible = False
  ThumbnailSettings.Enabled = True
  ThumbnailSettings.Visible = True
  ThumbnailSettings.DeadSpace = 30
  PDFSettings.EmbedFontOptions = []
  PDFSettings.EncryptSettings.AllowCopy = True
  PDFSettings.EncryptSettings.AllowInteract = True
  PDFSettings.EncryptSettings.AllowModify = True
  PDFSettings.EncryptSettings.AllowPrint = True
  PDFSettings.EncryptSettings.Enabled = False
  PDFSettings.EncryptSettings.KeyLength = kl40Bit
  PDFSettings.FontEncoding = feAnsi
  PDFSettings.ImageCompressionLevel = 25
  PreviewFormSettings.WindowState = wsMaximized
  PreviewFormSettings.ZoomSetting = zsPercentage
  RTFSettings.DefaultFont.Charset = DEFAULT_CHARSET
  RTFSettings.DefaultFont.Color = clWindowText
  RTFSettings.DefaultFont.Height = -13
  RTFSettings.DefaultFont.Name = ''Arial''
  RTFSettings.DefaultFont.Style = []
  TextFileName = ''($MyDocuments)\Report.pdf''
  TextSearchSettings.DefaultString = ''<Vind Tekst>''
  TextSearchSettings.Enabled = False
  XLSSettings.AppName = ''ReportBuilder''
  XLSSettings.Author = ''ReportBuilder''
  XLSSettings.Subject = ''Report''
  XLSSettings.Title = ''Report''
  Left = 312
  Top = 8
  Version = ''16.02''
  mmColumnWidth = 284300
  DataPipelineName = ''Aanmelding''
  object ppHeaderBand1: TppHeaderBand
    Save = True
    Background.Brush.Style = bsClear
    mmBottomOffset = 0
    mmHeight = 4233
    mmPrintPosition = 0
    object ppLabel7: TppLabel
      DesignLayer = ppDesignLayer1
      UserName = ''Label7''
      SaveOrder = 0
      Save = True
      Border.Weight = 1.000000000000000000
      Caption = ''Vak''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Verdana''
      Font.Size = 9
      Font.Style = [fsBold]
      FormField = False
      Transparent = True
      mmHeight = 4233
      mmLeft = 152665
      mmTop = 0
      mmWidth = 6615
      BandType = 0
      LayerName = Foreground
    end
    object ppLabel8: TppLabel
      DesignLayer = ppDesignLayer1
      UserName = ''Label8''
      SaveOrder = 1
      Save = True
      Border.Weight = 1.000000000000000000
      Caption = ''StamnrLL''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Verdana''
      Font.Size = 9
      Font.Style = [fsBold]
      FormField = False
      Transparent = True
      mmHeight = 4233
      mmLeft = 14288
      mmTop = 0
      mmWidth = 17018
      BandType = 0
      LayerName = Foreground
    end
    object ppLabel15: TppLabel
      DesignLayer = ppDesignLayer1
      UserName = ''Label15''
      SaveOrder = 2
      Save = True
      Border.Weight = 1.000000000000000000
      Caption = ''Klas/Lesgrp''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Verdana''
      Font.Size = 9
      Font.Style = [fsBold]
      FormField = False
      TextAlignment = taCentered
      Transparent = True
      mmHeight = 4233
      mmLeft = 117740
      mmTop = 0
      mmWidth = 31485
      BandType = 0
      LayerName = Foreground
    end
    object ppLabel1: TppLabel
      DesignLayer = ppDesignLayer1
      UserName = ''Label1''
      OnGetText = ppLabelGetText
      SaveOrder = 3
      Save = True
      Caption = ''Brin''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Verdana''
      Font.Size = 9
      Font.Style = [fsBold]
      FormField = False
      Transparent = True
      mmHeight = 4233
      mmLeft = 2117
      mmTop = 0
      mmWidth = 7324
      BandType = 0
      LayerName = Foreground
    end
    object ppLabel2: TppLabel
      DesignLayer = ppDesignLayer1
      UserName = ''Label2''
      OnGetText = ppLabelGetText
      SaveOrder = 4
      Save = True
      Caption = ''Roepnaam''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Verdana''
      Font.Size = 9
      Font.Style = [fsBold]
      FormField = False
      Transparent = True
      mmHeight = 4233
      mmLeft = 34660
      mmTop = 0
      mmWidth = 18796
      BandType = 0
      LayerName = Foreground
    end
    object ppLabel3: TppLabel
      DesignLayer = ppDesignLayer1
      UserName = ''Label3''
      OnGetText = ppLabelGetText
      SaveOrder = 5
      Save = True
      Caption = ''Achtern''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Verdana''
      Font.Size = 9
      Font.Style = [fsBold]
      FormField = False
      Transparent = True
      mmHeight = 4233
      mmLeft = 73290
      mmTop = 0
      mmWidth = 14023
      BandType = 0
      LayerName = Foreground
    end
    object ppLabel4: TppLabel
      DesignLayer = ppDesignLayer1
      UserName = ''Label4''
      OnGetText = ppLabelGetText
      SaveOrder = 6
      Save = True
      Caption = ''tv''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Verdana''
      Font.Size = 9
      Font.Style = [fsBold]
      FormField = False
      Transparent = True
      mmHeight = 4233
      mmLeft = 60590
      mmTop = 0
      mmWidth = 3514
      BandType = 0
      LayerName = Foreground
    end
    object ppLabel5: TppLabel
      DesignLayer = ppDesignLayer1
      UserName = ''Label5''
      OnGetText = ppLabelGetText
      SaveOrder = 7
      Save = True
      Caption = ''Leerjaar''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Verdana''
      Font.Size = 10
      Font.Style = [fsBold]
      FormField = False
      Transparent = True
      mmHeight = 4233
      mmLeft = 100013
      mmTop = 0
      mmWidth = 16404
      BandType = 0
      LayerName = Foreground
    end
    object ppLabel6: TppLabel
      DesignLayer = ppDesignLayer1
      UserName = ''Label6''
      OnGetText = ppLabelGetText
      SaveOrder = 8
      Save = True
      Caption = ''dccode1''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Verdana''
      Font.Size = 10
      Font.Style = [fsBold]
      FormField = False
      Transparent = True
      mmHeight = 4233
      mmLeft = 161661
      mmTop = 0
      mmWidth = 16140
      BandType = 0
      LayerName = Foreground
    end
    object ppLabel12: TppLabel
      DesignLayer = ppDesignLayer1
      UserName = ''Label12''
      OnGetText = ppLabelGetText
      SaveOrder = 9
      Save = True
      Caption = ''dccode2''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Verdana''
      Font.Size = 10
      Font.Style = [fsBold]
      FormField = False
      Transparent = True
      mmHeight = 4233
      mmLeft = 179917
      mmTop = 0
      mmWidth = 16140
      BandType = 0
      LayerName = Foreground
    end
    object ppLabel9: TppLabel
      DesignLayer = ppDesignLayer1
      UserName = ''Label9''
      OnGetText = ppLabelGetText
      SaveOrder = 10
      Save = True
      AutoSize = False
      Caption = ''studie richting.studie''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Verdana''
      Font.Size = 10
      Font.Style = [fsBold]
      FormField = False
      Transparent = True
      mmHeight = 4763
      mmLeft = 204523
      mmTop = 0
      mmWidth = 38629
      BandType = 0
      LayerName = Foreground
    end
    object ppLabel10: TppLabel
      DesignLayer = ppDesignLayer1
      UserName = ''Label10''
      OnGetText = ppLabelGetText
      SaveOrder = 11
      Save = True
      AutoSize = False
      Caption = ''Ex. Nr.''
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Verdana''
      Font.Size = 9
      Font.Style = [fsBold]
      FormField = False
      Transparent = True
      mmHeight = 4763
      mmLeft = 251090
      mmTop = 0
      mmWidth = 14552
      BandType = 0
      LayerName = Foreground
    end
  end
  object ppDetailBand1: TppDetailBand
    Save = True
    Background1.Brush.Style = bsClear
    Background2.Brush.Style = bsClear
    PrintHeight = phDynamic
    mmBottomOffset = 0
    mmHeight = 5027
    mmPrintPosition = 0
    object ppDBText6: TppDBText
      DesignLayer = ppDesignLayer1
      UserName = ''DBText6''
      OnGetText = ppDBTextGetText
      SaveOrder = 0
      Save = True
      Border.Weight = 1.000000000000000000
      DataField = ''c_vak''
      DataPipeline = daADSQueryDataView1.Aanmelding
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Verdana''
      Font.Size = 9
      Font.Style = []
      Transparent = True
      UTF8 = False
      DataPipelineName = ''Aanmelding''
      mmHeight = 4233
      mmLeft = 152665
      mmTop = 265
      mmWidth = 11642
      BandType = 4
      LayerName = Foreground
    end
    object ppDBText13: TppDBText
      DesignLayer = ppDesignLayer1
      UserName = ''DBText13''
      OnGetText = ppDBTextGetText
      SaveOrder = 1
      Save = True
      Border.Weight = 1.000000000000000000
      DataField = ''CASE_WHEN_sis_lvak_idBgrp''
      DataPipeline = daADSQueryDataView1.Aanmelding
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Verdana''
      Font.Size = 9
      Font.Style = []
      Transparent = True
      UTF8 = False
      DataPipelineName = ''Aanmelding''
      mmHeight = 4233
      mmLeft = 118798
      mmTop = 265
      mmWidth = 30427
      BandType = 4
      LayerName = Foreground
    end
    object ppDBText8: TppDBText
      DesignLayer = ppDesignLayer1
      UserName = ''DBText8''
      OnGetText = ppDBTextGetText
      SaveOrder = 2
      Save = True
      Border.Weight = 1.000000000000000000
      DataField = ''STAMNR''
      DataPipeline = daADSQueryDataView1.Aanmelding
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Verdana''
      Font.Size = 9
      Font.Style = []
      Transparent = True
      UTF8 = False
      DataPipelineName = ''Aanmelding''
      mmHeight = 4233
      mmLeft = 14288
      mmTop = 265
      mmWidth = 21431
      BandType = 4
      LayerName = Foreground
    end
    object ppDBText2: TppDBText
      DesignLayer = ppDesignLayer1
      UserName = ''DBText2''
      OnGetText = ppDBTextGetText
      SaveOrder = 3
      Save = True
      DataField = ''brin_nr''
      DataPipeline = daADSQueryDataView1.Aanmelding
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Verdana''
      Font.Size = 9
      Font.Style = []
      Transparent = True
      UTF8 = False
      DataPipelineName = ''Aanmelding''
      mmHeight = 4233
      mmLeft = 1852
      mmTop = 265
      mmWidth = 17198
      BandType = 4
      LayerName = Foreground
    end
    object ppDBText3: TppDBText
      DesignLayer = ppDesignLayer1
      UserName = ''DBText3''
      OnGetText = ppDBTextGetText
      SaveOrder = 4
      Save = True
      DataField = ''roepnaam''
      DataPipeline = daADSQueryDataView1.Aanmelding
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Verdana''
      Font.Size = 9
      Font.Style = []
      Transparent = True
      UTF8 = True
      DataPipelineName = ''Aanmelding''
      mmHeight = 4233
      mmLeft = 34660
      mmTop = 265
      mmWidth = 17198
      BandType = 4
      LayerName = Foreground
    end
    object ppDBText4: TppDBText
      DesignLayer = ppDesignLayer1
      UserName = ''DBText4''
      OnGetText = ppDBTextGetText
      SaveOrder = 5
      Save = True
      DataField = ''tussenvoeg''
      DataPipeline = daADSQueryDataView1.Aanmelding
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Verdana''
      Font.Size = 9
      Font.Style = []
      Transparent = True
      UTF8 = True
      DataPipelineName = ''Aanmelding''
      mmHeight = 4233
      mmLeft = 57944
      mmTop = 265
      mmWidth = 17198
      BandType = 4
      LayerName = Foreground
    end
    object ppDBText5: TppDBText
      DesignLayer = ppDesignLayer1
      UserName = ''DBText5''
      OnGetText = ppDBTextGetText
      SaveOrder = 6
      Save = True
      DataField = ''achternaam''
      DataPipeline = daADSQueryDataView1.Aanmelding
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = ''Verdana''
      Font.Size = 9
      Font.Style = []
      Transparent = True
      UTF8 = True
      DataPipelineName = ''Aanmelding''
      mmHeight = 4233
      mmLeft = 76200
      mmTop = 265
      mmWidth = 25400
      BandType = 4
      LayerName = Foreground
    end
    object ppDBText11: TppDBText
      DesignLayer = ppDesignLayer1
      UserName = ''DBText11''
      OnGetText = ppDBTextGetText
      SaveOrder = 7
      Save = True
      DataField = ''leerjaar''
      DataPipeline = daADSQueryDataView1.Aanmelding
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Verdana''
      Font.Size = 9
      Font.Style = []
      Transparent = True
      UTF8 = False
      DataPipelineName = ''Aanmelding''
      mmHeight = 4233
      mmLeft = 105569
      mmTop = 265
      mmWidth = 9260
      BandType = 4
      LayerName = Foreground
    end
    object ppDBText1: TppDBText
      DesignLayer = ppDesignLayer1
      UserName = ''DBText1''
      OnGetText = ppDBTextGetText
      SaveOrder = 8
      Save = True
      DataField = ''doc_code''
      DataPipeline = daADSQueryDataView1.Aanmelding
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Verdana''
      Font.Size = 9
      Font.Style = []
      Transparent = True
      UTF8 = False
      DataPipelineName = ''Aanmelding''
      mmHeight = 4763
      mmLeft = 166952
      mmTop = 264
      mmWidth = 9525
      BandType = 4
      LayerName = Foreground
    end
    object ppDBText12: TppDBText
      DesignLayer = ppDesignLayer1
      UserName = ''DBText12''
      OnGetText = ppDBTextGetText
      SaveOrder = 9
      Save = True
      DataField = ''doc_code_2''
      DataPipeline = daADSQueryDataView1.Aanmelding
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Verdana''
      Font.Size = 9
      Font.Style = []
      Transparent = True
      UTF8 = False
      DataPipelineName = ''Aanmelding''
      mmHeight = 4763
      mmLeft = 179917
      mmTop = 264
      mmWidth = 10848
      BandType = 4
      LayerName = Foreground
    end
    object ppDBText7: TppDBText
      DesignLayer = ppDesignLayer1
      UserName = ''DBText7''
      OnGetText = ppDBTextGetText
      SaveOrder = 10
      Save = True
      DataField = ''STUDIE''
      DataPipeline = daADSQueryDataView1.Aanmelding
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Verdana''
      Font.Size = 10
      Font.Style = []
      Transparent = True
      UTF8 = False
      DataPipelineName = ''Aanmelding''
      mmHeight = 4763
      mmLeft = 204523
      mmTop = 264
      mmWidth = 32808
      BandType = 4
      LayerName = Foreground
    end
    object ppDBText9: TppDBText
      DesignLayer = ppDesignLayer1
      UserName = ''DBText9''
      OnGetText = ppDBTextGetText
      SaveOrder = 11
      Save = True
      DataField = ''exam_nr''
      DataPipeline = daADSQueryDataView1.Aanmelding
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Verdana''
      Font.Size = 9
      Font.Style = []
      Transparent = True
      UTF8 = False
      DataPipelineName = ''Aanmelding''
      mmHeight = 4763
      mmLeft = 251090
      mmTop = 264
      mmWidth = 12700
      BandType = 4
      LayerName = Foreground
    end
  end
  object ppFooterBand1: TppFooterBand
    Save = True
    Background.Brush.Style = bsClear
    mmBottomOffset = 0
    mmHeight = 0
    mmPrintPosition = 0
  end
  object ppSummaryBand1: TppSummaryBand
    Save = True
    Background.Brush.Style = bsClear
    PrintHeight = phDynamic
    mmBottomOffset = 0
    mmHeight = 0
    mmPrintPosition = 0
  end
  object ppGroup1: TppGroup
    BreakName = ''STAMNR''
    DataPipeline = daADSQueryDataView1.Aanmelding
    GroupFileSettings.NewFile = False
    GroupFileSettings.EmailFile = False
    OutlineSettings.CreateNode = True
    ReprintOnSubsequentPage = False
    StartOnOddPage = False
    UserName = ''Group1''
    mmNewColumnThreshold = 0
    mmNewPageThreshold = 0
    DataPipelineName = ''Aanmelding''
    NewFile = False
    object ppGroupHeaderBand1: TppGroupHeaderBand
      Save = True
      Background.Brush.Style = bsClear
      mmBottomOffset = 0
      mmHeight = 0
      mmPrintPosition = 0
    end
    object ppGroupFooterBand1: TppGroupFooterBand
      Save = True
      Background.Brush.Style = bsClear
      HideWhenOneDetail = False
      mmBottomOffset = 0
      mmHeight = 0
      mmPrintPosition = 0
    end
  end
  object daDataModule2: TdaDataModule
    object daADSQueryDataView1: TdaSDACQueryDataView
      UserName = ''Query_Aanmelding''
      Height = 452
      Left = 76
      NameColumnWidth = 323
      SizeColumnWidth = 35
      SortMode = 0
      Top = 57
      TypeColumnWidth = 52
      Width = 958
      AutoSearchTabOrder = 0
      object Aanmelding: TppChildDBPipeline
        AutoCreateFields = False
        RangeEnd = reCount
        RangeEndCount = 100
        UserName = ''Aanmelding''
        object ppField1: TppField
          FieldAlias = ''aanmelding.idBgrp''
          FieldName = ''idBgrp''
          FieldLength = 10
          DataType = dtDouble
          DisplayWidth = 0
          Position = 0
          TableName = ''sis_aanm''
        end
        object ppField2: TppField
          FieldAlias = ''aanmelding.idStud''
          FieldName = ''idStud''
          FieldLength = 10
          DataType = dtDouble
          DisplayWidth = 0
          Position = 1
          TableName = ''sis_aanm''
        end
        object ppField3: TppField
          FieldAlias = ''aanmelding.stamnr''
          FieldName = ''STAMNR_2''
          FieldLength = 10
          DataType = dtInteger
          DisplayWidth = 0
          Position = 2
          TableName = ''sis_aanm''
        end
        object ppField4: TppField
          FieldAlias = ''Leerling.Stamnummer''
          FieldName = ''STAMNR''
          FieldLength = 10
          IsDetail = True
          DataType = dtInteger
          DisplayWidth = 0
          Position = 3
          TableName = ''sis_leer''
        end
        object ppField5: TppField
          FieldAlias = ''vak leerling.c_vak''
          FieldName = ''C_VAK''
          FieldLength = 10
          IsDetail = True
          DisplayWidth = 6
          Position = 4
          TableName = ''sis_lvak''
        end
        object ppField6: TppField
          FieldAlias = ''vak.omschr''
          FieldName = ''OMSCHR_2''
          FieldLength = 10
          IsDetail = True
          DisplayWidth = 30
          Position = 5
          TableName = ''sis_bvak''
        end
        object ppField7: TppField
          FieldAlias = ''vak leerling.bVrij''
          FieldName = ''bVrij''
          FieldLength = 10
          IsDetail = True
          DataType = dtBoolean
          DisplayWidth = 0
          Position = 6
          TableName = ''sis_lvak''
        end
        object ppField8: TppField
          FieldAlias = ''vak leerling.bExtra''
          FieldName = ''bExtra''
          FieldLength = 10
          IsDetail = True
          DataType = dtBoolean
          DisplayWidth = 0
          Position = 7
          TableName = ''sis_lvak''
        end
        object ppField9: TppField
          FieldAlias = ''personeel.naam_vol''
          FieldName = ''NAAM_VOL_2''
          FieldLength = 10
          IsDetail = True
          DisplayWidth = 90
          Position = 8
          TableName = ''sis_pers_3''
        end
        object ppField10: TppField
          FieldAlias = ''personeel.naam_vol (2)''
          FieldName = ''NAAM_VOL_3''
          FieldLength = 10
          IsDetail = True
          DisplayWidth = 90
          Position = 9
          TableName = ''sis_pers_4''
        end
        object ppField11: TppField
          FieldAlias = ''studie richting.studie''
          FieldName = ''STUDIE''
          FieldLength = 10
          IsDetail = True
          DisplayWidth = 10
          Position = 10
          TableName = ''sis_stud''
        end
        object ppField12: TppField
          FieldAlias = ''klas groep.groep''
          FieldName = ''GROEP''
          FieldLength = 10
          IsDetail = True
          DisplayWidth = 10
          Position = 11
          TableName = ''sis_bgrp''
        end
        object ppField13: TppField
          FieldAlias = ''klas groep.omschr''
          FieldName = ''OMSCHR''
          FieldLength = 10
          IsDetail = True
          DisplayWidth = 30
          Position = 12
          TableName = ''sis_bgrp''
        end
        object ppField14: TppField
          FieldAlias = ''Leerling.Tussenv.''
          FieldName = ''tussenvoeg''
          FieldLength = 10
          IsDetail = True
          DisplayWidth = 10
          Position = 13
          TableName = ''sis_leer''
        end
        object ppField15: TppField
          FieldAlias = ''Leerling.Achternaam''
          FieldName = ''achternaam''
          FieldLength = 10
          IsDetail = True
          DisplayWidth = 40
          Position = 14
          TableName = ''sis_leer''
        end
        object ppField16: TppField
          FieldAlias = ''Leerling.Roepnaam''
          FieldName = ''roepnaam''
          FieldLength = 10
          IsDetail = True
          DisplayWidth = 20
          Position = 15
          TableName = ''sis_leer''
        end
        object ppField17: TppField
          FieldAlias = ''Vakken_per_studie.Volgnr''
          FieldName = ''volgnr''
          FieldLength = 10
          IsDetail = True
          DataType = dtInteger
          DisplayWidth = 0
          Position = 16
          TableName = ''sis_svak''
        end
        object ppField18: TppField
          FieldAlias = ''groep''
          FieldName = ''groep_2''
          FieldLength = 10
          DisplayWidth = 10
          Position = 17
          TableName = ''sis_bgrp_2''
        end
        object ppField19: TppField
          FieldAlias = ''Docent stamnr''
          FieldName = ''stamnr_3''
          FieldLength = 10
          IsDetail = True
          DataType = dtInteger
          DisplayWidth = 10
          Position = 18
          TableName = ''sis_pers''
        end
        object ppField20: TppField
          FieldAlias = ''Docent 2 stamnr''
          FieldName = ''stamnr_4''
          FieldLength = 10
          IsDetail = True
          DataType = dtInteger
          DisplayWidth = 10
          Position = 19
          TableName = ''sis_pers_2''
        end
        object ppField21: TppField
          FieldAlias = ''Brin''
          FieldName = ''brin_nr''
          FieldLength = 10
          IsDetail = True
          DisplayWidth = 10
          Position = 20
          TableName = ''sis_blok''
        end
        object ppField22: TppField
          FieldAlias = ''Leerjaar''
          FieldName = ''leerjaar''
          FieldLength = 10
          IsDetail = True
          DataType = dtInteger
          DisplayWidth = 10
          Position = 21
          TableName = ''sis_blfa''
        end
        object ppField23: TppField
          FieldAlias = ''doc_code''
          FieldName = ''doc_code''
          FieldLength = 10
          IsDetail = True
          DisplayWidth = 10
          Position = 22
          TableName = ''sis_pers''
        end
        object ppField24: TppField
          FieldAlias = ''doc_code (2)''
          FieldName = ''doc_code_2''
          FieldLength = 10
          IsDetail = True
          DisplayWidth = 10
          Position = 23
          TableName = ''sis_pers_2''
        end
        object ppField25: TppField
          FieldAlias = ''doc_code (3)''
          FieldName = ''doc_code_3''
          FieldLength = 10
          IsDetail = True
          DisplayWidth = 10
          Position = 24
          TableName = ''sis_pers_3''
        end
        object ppField26: TppField
          FieldAlias = ''doc_code (4)''
          FieldName = ''doc_code_4''
          FieldLength = 10
          IsDetail = True
          DisplayWidth = 10
          Position = 25
          TableName = ''sis_pers_4''
        end
        object ppField27: TppField
          FieldAlias = ''Aanmelding.Examennummer''
          FieldName = ''exam_nr''
          FieldLength = 10
          DataType = dtInteger
          DisplayWidth = 10
          Position = 26
          TableName = ''sis_aanm''
        end
        object ppField28: TppField
          FieldAlias = ''KlasLesgrp''
          FieldName = ''CASE_WHEN_sis_lvak_idBgrp''
          FieldLength = 10
          DisplayWidth = 10
          Position = 27
          TableName = ''sis_bgrp''
        end
        object ppField29: TppField
          FieldAlias = ''Doc achtern''
          FieldName = ''CASE_WHEN_sis_lvak_idBg_2''
          FieldLength = 10
          DisplayWidth = 10
          Position = 28
          TableName = ''sis_pers''
        end
        object ppField30: TppField
          FieldAlias = ''SoortVak''
          FieldName = ''CASE_WHEN_sis_lvak_bGem_1''
          FieldLength = 10
          DisplayWidth = 10
          Position = 29
          TableName = ''sis_pers''
        end
        object ppField31: TppField
          FieldAlias = ''sis_lvak_dEinde''
          FieldName = ''sis_lvak_dEinde''
          FieldLength = 10
          DataType = dtDate
          DisplayWidth = 10
          Position = 30
          TableName = ''sis_lvak''
        end
        object ppField32: TppField
          FieldAlias = ''Vaksortering''
          FieldName = ''CASE_WHEN_sis_lvak_bGem_2''
          FieldLength = 10
          DataType = dtInteger
          DisplayWidth = 10
          Position = 31
          TableName = ''sis_aanm''
        end
        object ppField33: TppField
          FieldAlias = ''Docstamnr''
          FieldName = ''CASE_WHEN_sis_lvak_idBg_3''
          FieldLength = 10
          DataType = dtInteger
          DisplayWidth = 10
          Position = 32
          TableName = ''sis_aanm''
        end
        object ppField34: TppField
          FieldAlias = ''Doc roepnaam''
          FieldName = ''CASE_WHEN_sis_lvak_idBg_4''
          FieldLength = 10
          DisplayWidth = 10
          Position = 33
          TableName = ''sis_aanm''
        end
        object ppField35: TppField
          FieldAlias = ''Doc tvg''
          FieldName = ''CASE_WHEN_sis_lvak_idBg_5''
          FieldLength = 10
          DisplayWidth = 10
          Position = 34
          TableName = ''sis_aanm''
        end
      end
      object daSQL1: TdaSQL
        GuidCollationType = gcMSSQLServer
        DatabaseName = ''MSSQLConnectie''
        DatabaseType = dtMSSQLServer
        DataPipelineName = ''Aanmelding''
        Distinct = True
        LinkColor = clMaroon
        LinkType = ltMagicSQL
        MaxSQLFieldAliasLength = 25
        SQLText.Strings = (
          ''SELECT DISTINCT sis_aanm.idBgrp, sis_aanm.idStud, ''
          ''                sis_aanm.STAMNR STAMNR_2, ''
          ''                sis_leer.STAMNR, sis_lvak.C_VAK, ''
          ''                sis_bvak.OMSCHR OMSCHR_2, ''
          ''                sis_lvak.bVrij, sis_lvak.bExtra, ''
          ''                sis_pers_3.NAAM_VOL NAAM_VOL_2, ''
          ''                sis_pers_4.NAAM_VOL NAAM_VOL_3, ''
          ''                sis_stud.STUDIE, sis_bgrp.GROEP, ''
          ''                sis_bgrp.OMSCHR, ''
          ''                persoonxxx.tussenvoegsel as tussenvoeg, ''
          ''                persoonxxx.achternaam as achternaam, ''
          ''                persoonxxx.roepnaam as roepnaam, ''
          ''                sis_svak.volgnr, ''
          ''                sis_bgrp_2.groep groep_2, ''
          ''                sis_pers.stamnr stamnr_3, ''
          ''                sis_pers_2.stamnr stamnr_4, ''
          ''                sis_blok.brin_nr, ''
          ''                sis_blfa.leerjaar, ''
          ''                sis_pers.doc_code, ''
          ''                sis_pers_2.doc_code doc_code_2, ''
          ''                sis_pers_3.doc_code doc_code_3, ''
          ''                sis_pers_4.doc_code doc_code_4, ''
          ''                sis_aanm.exam_nr, ''
          
            ''                CASE WHEN sis_lvak.idBgrp Is Null THEN sis_bgrp.'' +
            ''groep ELSE sis_bgrp_2.groep END CASE_WHEN_sis_lvak_idBgrp, ''
          
            ''                CASE WHEN sis_lvak.idBgrp Is Null THEN sis_pers.'' +
            ''achternaam ELSE sis_pers_2.achternaam END CASE_WHEN_sis_lvak_idB'' +
            ''g_2, ''
          
            ''                CASE WHEN sis_lvak.bGem=1 THEN ''#39''Gemeenschappelij'' +
            ''k''#39'' ELSE CASE WHEN sis_lvak.bPvak=1 THEN ''#39''Profielvak''#39'' ELSE ''#39''Vrij '' +
            ''vak''#39''END END CASE_WHEN_sis_lvak_bGem_1, ''
          ''                sis_lvak.dEinde sis_lvak_dEinde, ''
          
            ''                CASE WHEN (sis_lvak.bGem=1 OR sis_lvak.bGem2=1) '' +
            ''THEN 2 ELSE 0 END + CASE WHEN (sis_lvak.bPvak=1 OR sis_lvak.bPva'' +
            ''k2=1) THEN 1 ELSE 0 END CASE_WHEN_sis_lvak_bGem_2, ''
          
            ''                CASE WHEN sis_lvak.idBgrp Is Null THEN sis_pers.'' +
            ''stamnr ELSE sis_pers_2.stamnr END CASE_WHEN_sis_lvak_idBg_3, ''
          
            ''                CASE WHEN sis_lvak.idBgrp Is Null THEN sis_pers.'' +
            ''roepnaam ELSE sis_pers_2.roepnaam END CASE_WHEN_sis_lvak_idBg_4,'' +
            '' ''
          
            ''                CASE WHEN sis_lvak.idBgrp Is Null THEN sis_pers.'' +
            ''tussenvoeg ELSE sis_pers_2.tussenvoeg END CASE_WHEN_sis_lvak_idB'' +
            ''g_5''
          ''FROM sis_aanm sis_aanm''
          ''      INNER JOIN sis_leer sis_leer ON ''
          ''     (sis_leer.STAMNR = sis_aanm.STAMNR)''
          ''      LEFT OUTER JOIN sis_lvak sis_lvak ON ''
          ''     (sis_lvak.STAMNR = sis_aanm.STAMNR)''
          ''      AND (sis_lvak.idStud = sis_aanm.idStud)''
          ''      LEFT OUTER JOIN sis_bgrp sis_bgrp ON ''
          ''     (sis_bgrp.idBgrp = sis_aanm.idBgrp)''
          ''      LEFT OUTER JOIN sis_pgvk sis_pgvk ON ''
          ''     (sis_pgvk.idBgrp = sis_bgrp.idBgrp)''
          ''      AND (sis_pgvk.C_VAK = sis_lvak.C_VAK)''
          ''      LEFT OUTER JOIN sis_pers sis_pers ON ''
          ''     (sis_pers.idPers = sis_pgvk.idPers)''
          ''      LEFT OUTER JOIN sis_bgrp sis_bgrp_2 ON ''
          ''     (sis_bgrp_2.idBgrp = sis_lvak.idBgrp)''
          ''      LEFT OUTER JOIN sis_pgvk sis_pgvk_2 ON ''
          ''     (sis_pgvk_2.idBgrp = sis_lvak.idBgrp)''
          ''      AND (sis_pgvk_2.C_VAK = sis_lvak.C_VAK)''
          ''      LEFT OUTER JOIN sis_pers sis_pers_2 ON ''
          ''     (sis_pers_2.idPers = sis_pgvk_2.idPers)''
          ''      LEFT OUTER JOIN sis_bvak sis_bvak ON ''
          ''     (sis_bvak.C_VAK = sis_lvak.C_VAK)''
          ''      LEFT OUTER JOIN sis_pers sis_pers_3 ON ''
          ''     (sis_pers_3.idPers = sis_bgrp.idPers_mentor1)''
          ''      LEFT OUTER JOIN sis_pers sis_pers_4 ON ''
          ''     (sis_pers_4.idPers = sis_bgrp.idPers_mentor2)''
          ''      LEFT OUTER JOIN sis_stud sis_stud ON ''
          ''     (sis_stud.idStud = sis_aanm.idStud)''
          ''      LEFT OUTER JOIN sis_svak sis_svak ON ''
          ''     (sis_svak.idStud = sis_lvak.idStud)''
          ''      AND (sis_svak.C_VAK = sis_lvak.C_VAK)''
          ''      LEFT OUTER JOIN sis_blok sis_blok ON ''
          ''     (sis_blok.c_lokatie = sis_bgrp.c_lokatie)''
          ''      LEFT OUTER JOIN sis_blfa sis_blfa ON ''
          ''     (sis_blfa.idBlfa = sis_stud.idBlfa)''
          
            ''     LEFT JOIN persoon persoonxxx ON (persoonxxx.id = sis_leer.i'' +
            ''dpersoon)''
          ''WHERE ''
          
            ''      ( CASE WHEN sis_pgvk.idPers Is Null THEN 1 ELSE sis_pgvk.a'' +
            ''ctief END = 1 )''
          
            ''       AND ( CASE WHEN sis_pgvk_2.idPers Is Null THEN 1 ELSE sis'' +
            ''_pgvk_2.actief END = ''#39''1''#39'' )''
          ''ORDER BY sis_aanm.STAMNR, 30, sis_svak.volgnr'')
        SQLType = sqSQL2
        object daCalculation1: TdaCalculation
          ChildType = 8
          Alias = ''KlasLesgrp''
          DisplayWidth = 10
          FieldAlias = ''groep''
          FieldLength = 10
          FieldName = ''groep''
          SQLFieldName = ''CASE_WHEN_sis_lvak_idBgrp''
          TableAlias = ''Klas Groep''
          TableName = ''sis_bgrp''
          TableSQLAlias = ''sis_bgrp''
          CalcType = dacaExpression
          Expression = 
            ''CASE WHEN sis_lvak.idBgrp Is Null THEN sis_bgrp.groep ELSE sis_b'' +
            ''grp_2.groep END''
        end
        object daCalculation2: TdaCalculation
          ChildType = 8
          Alias = ''Doc achtern''
          DisplayWidth = 10
          FieldAlias = ''naam_vol''
          FieldLength = 10
          FieldName = ''naam_vol''
          SQLFieldName = ''CASE_WHEN_sis_lvak_idBg_2''
          TableAlias = ''Personeel''
          TableName = ''sis_pers''
          TableSQLAlias = ''sis_pers''
          CalcType = dacaExpression
          Expression = 
            ''CASE WHEN sis_lvak.idBgrp Is Null THEN sis_pers.achternaam ELSE '' +
            ''sis_pers_2.achternaam END''
        end
        object daCalculation3: TdaCalculation
          ChildType = 8
          Alias = ''SoortVak''
          DisplayWidth = 10
          FieldAlias = ''voornamen''
          FieldLength = 10
          FieldName = ''voornamen''
          SQLFieldName = ''CASE_WHEN_sis_lvak_bGem_1''
          TableAlias = ''Personeel''
          TableName = ''sis_pers''
          TableSQLAlias = ''sis_pers''
          CalcType = dacaExpression
          Expression = 
            ''CASE WHEN sis_lvak.bGem=1 THEN ''#39''Gemeenschappelijk''#39'' ELSE CASE WHE'' +
            ''N sis_lvak.bPvak=1 THEN ''#39''Profielvak''#39'' ELSE ''#39''Vrij vak''#39''END END''
        end
        object daCalculation4: TdaCalculation
          ChildType = 8
          Alias = ''sis_lvak_dEinde''
          DataType = dtDate
          DisplayWidth = 10
          FieldAlias = ''stamnr''
          FieldLength = 10
          FieldName = ''stamnr''
          SQLFieldName = ''sis_lvak_dEinde''
          TableAlias = ''Vak leerling''
          TableName = ''sis_lvak''
          TableSQLAlias = ''sis_lvak''
          CalcType = dacaExpression
          Expression = ''sis_lvak.dEinde''
        end
        object daCalculation5: TdaCalculation
          ChildType = 8
          Alias = ''Vaksortering''
          DataType = dtInteger
          DisplayWidth = 10
          FieldAlias = ''idAanm''
          FieldLength = 10
          FieldName = ''idAanm''
          SQLFieldName = ''CASE_WHEN_sis_lvak_bGem_2''
          TableAlias = ''Aanmelding''
          TableName = ''sis_aanm''
          TableSQLAlias = ''sis_aanm''
          CalcType = dacaExpression
          Expression = 
            ''CASE WHEN (sis_lvak.bGem=1 OR sis_lvak.bGem2=1) THEN 2 ELSE 0 EN'' +
            ''D + CASE WHEN (sis_lvak.bPvak=1 OR sis_lvak.bPvak2=1) THEN 1 ELS'' +
            ''E 0 END''
        end
        object daCalculation6: TdaCalculation
          ChildType = 8
          Alias = ''Docstamnr''
          DataType = dtInteger
          DisplayWidth = 10
          FieldAlias = ''idBvrt''
          FieldLength = 10
          FieldName = ''idBvrt''
          SQLFieldName = ''CASE_WHEN_sis_lvak_idBg_3''
          TableAlias = ''Aanmelding''
          TableName = ''sis_aanm''
          TableSQLAlias = ''sis_aanm''
          CalcType = dacaExpression
          Expression = 
            ''CASE WHEN sis_lvak.idBgrp Is Null THEN sis_pers.stamnr ELSE sis_'' +
            ''pers_2.stamnr END''
        end
        object daCalculation7: TdaCalculation
          ChildType = 8
          Alias = ''Doc roepnaam''
          DisplayWidth = 10
          FieldAlias = ''Aanmelding.Vorige opleiding''
          FieldLength = 10
          FieldName = ''idBins_v_opl''
          SQLFieldName = ''CASE_WHEN_sis_lvak_idBg_4''
          TableAlias = ''Aanmelding''
          TableName = ''sis_aanm''
          TableSQLAlias = ''sis_aanm''
          CalcType = dacaExpression
          Expression = 
            ''CASE WHEN sis_lvak.idBgrp Is Null THEN sis_pers.roepnaam ELSE si'' +
            ''s_pers_2.roepnaam END''
        end
        object daCalculation8: TdaCalculation
          ChildType = 8
          Alias = ''Doc tvg''
          DisplayWidth = 10
          FieldAlias = ''Aanmelding.Vorige opleiding''
          FieldLength = 10
          FieldName = ''idBins_v_opl''
          SQLFieldName = ''CASE_WHEN_sis_lvak_idBg_5''
          TableAlias = ''Aanmelding''
          TableName = ''sis_aanm''
          TableSQLAlias = ''sis_aanm''
          CalcType = dacaExpression
          Expression = 
            ''CASE WHEN sis_lvak.idBgrp Is Null THEN sis_pers.tussenvoeg ELSE '' +
            ''sis_pers_2.tussenvoeg END''
        end
        object daCriteria1: TdaCriteria
          ChildType = 7
          Level = 0
          Operator = dacoInList
          object TdaField
            Alias = ''Aanmelding.Key''
            AutoSearch = True
            DataType = dtDouble
            DisplayWidth = 0
            FieldAlias = ''Aanmelding.Key''
            FieldLength = 0
            FieldName = ''idAanm''
            SQLFieldName = ''idAanm''
            TableAlias = ''Aanmelding''
            TableName = ''sis_aanm''
            TableSQLAlias = ''sis_aanm''
          end
        end
        object daCriteria2: TdaCriteria
          ChildType = 7
          Level = 0
          Operator = dacoGreaterThanOrEqualTo
          object TdaField
            Alias = ''dEinde''
            AutoSearch = True
            DataType = dtDate
            DisplayWidth = 10
            FieldAlias = ''dEinde''
            FieldLength = 0
            FieldName = ''dEinde''
            SQLFieldName = ''dEinde''
            TableAlias = ''Vak leerling''
            TableName = ''sis_lvak''
            TableSQLAlias = ''sis_lvak''
          end
        end
        object daCriteria3: TdaCriteria
          ChildType = 7
          Level = 0
          Operator = dacoLessThanOrEqualTo
          object TdaField
            Alias = ''Vak.Begindatum''
            AutoSearch = True
            DataType = dtDateTime
            DisplayWidth = 0
            FieldAlias = ''Vak.Begindatum''
            FieldLength = 0
            FieldName = ''dBegin''
            SQLFieldName = ''dBegin''
            TableAlias = ''Vak leerling''
            TableName = ''sis_lvak''
            TableSQLAlias = ''sis_lvak''
          end
        end
        object daCriteria4: TdaCriteria
          ChildType = 7
          Expression = 
            ''CASE WHEN sis_pgvk.idPers Is Null THEN 1 ELSE sis_pgvk.actief EN'' +
            ''D''
          Level = 0
          Value = ''1''
          object TdaField
            Alias = ''Aanmelding.Zittenblijver''
            DataType = dtBoolean
            DisplayWidth = 0
            FieldAlias = ''Aanmelding.Zittenblijver''
            FieldLength = 0
            FieldName = ''zittenbl''
            SQLFieldName = ''zittenbl''
            TableAlias = ''Aanmelding''
            TableName = ''sis_aanm''
            TableSQLAlias = ''sis_aanm''
          end
        end
        object daCriteria5: TdaCriteria
          ChildType = 7
          Expression = 
            ''CASE WHEN sis_pgvk_2.idPers Is Null THEN 1 ELSE sis_pgvk_2.actie'' +
            ''f END''
          Level = 0
          Value = ''1''
          object TdaField
            Alias = ''lesperiode''
            DisplayWidth = 4
            FieldAlias = ''lesperiode''
            FieldLength = 4
            FieldName = ''lesperiode''
            SQLFieldName = ''lesperiode''
            TableAlias = ''Aanmelding''
            TableName = ''sis_aanm''
            TableSQLAlias = ''sis_aanm''
          end
        end
        object daCriteria6: TdaCriteria
          ChildType = 7
          Level = 0
          object TdaField
            Alias = ''Vak.Roostertechnisch''
            AutoSearch = True
            DataType = dtBoolean
            DisplayWidth = 0
            FieldAlias = ''Vak.Roostertechnisch''
            FieldLength = 0
            FieldName = ''brosttechnisch''
            SQLFieldName = ''brosttechnisch''
            TableAlias = ''Vak leerling''
            TableName = ''sis_lvak''
            TableSQLAlias = ''sis_lvak''
          end
        end
        object daField1: TdaField
          Alias = ''aanmelding.idBgrp''
          DataType = dtDouble
          DisplayWidth = 0
          FieldAlias = ''aanmelding.idBgrp''
          FieldLength = 10
          FieldName = ''idBgrp''
          SQLFieldName = ''idBgrp''
          TableAlias = ''Aanmelding''
          TableName = ''sis_aanm''
          TableSQLAlias = ''sis_aanm''
        end
        object daField2: TdaField
          Alias = ''aanmelding.idStud''
          DataType = dtDouble
          DisplayWidth = 0
          FieldAlias = ''aanmelding.idStud''
          FieldLength = 10
          FieldName = ''idStud''
          SQLFieldName = ''idStud''
          TableAlias = ''Aanmelding''
          TableName = ''sis_aanm''
          TableSQLAlias = ''sis_aanm''
        end
        object daField3: TdaField
          Alias = ''aanmelding.stamnr''
          DataType = dtInteger
          DisplayWidth = 0
          FieldAlias = ''aanmelding.stamnr''
          FieldLength = 10
          FieldName = ''STAMNR''
          SQLFieldName = ''STAMNR_2''
          TableAlias = ''Aanmelding''
          TableName = ''sis_aanm''
          TableSQLAlias = ''sis_aanm''
        end
        object daField4: TdaField
          Alias = ''Leerling.Stamnummer''
          DataType = dtInteger
          DisplayWidth = 0
          FieldAlias = ''Leerling.Stamnummer''
          FieldLength = 10
          FieldName = ''STAMNR''
          IsDetail = True
          SQLFieldName = ''STAMNR''
          TableAlias = ''Leerling''
          TableName = ''sis_leer''
          TableSQLAlias = ''sis_leer''
        end
        object daField5: TdaField
          Alias = ''vak leerling.c_vak''
          DisplayWidth = 6
          FieldAlias = ''vak leerling.c_vak''
          FieldLength = 10
          FieldName = ''C_VAK''
          IsDetail = True
          SQLFieldName = ''C_VAK''
          TableAlias = ''Vak leerling''
          TableName = ''sis_lvak''
          TableSQLAlias = ''sis_lvak''
        end
        object daField6: TdaField
          Alias = ''vak.omschr''
          DisplayWidth = 30
          FieldAlias = ''vak.omschr''
          FieldLength = 10
          FieldName = ''OMSCHR''
          IsDetail = True
          SQLFieldName = ''OMSCHR_2''
          TableAlias = ''Vak''
          TableName = ''sis_bvak''
          TableSQLAlias = ''sis_bvak''
        end
        object daField7: TdaField
          Alias = ''vak leerling.bVrij''
          DataType = dtBoolean
          DisplayWidth = 0
          FieldAlias = ''vak leerling.bVrij''
          FieldLength = 10
          FieldName = ''bVrij''
          IsDetail = True
          SQLFieldName = ''bVrij''
          TableAlias = ''Vak leerling''
          TableName = ''sis_lvak''
          TableSQLAlias = ''sis_lvak''
        end
        object daField8: TdaField
          Alias = ''vak leerling.bExtra''
          DataType = dtBoolean
          DisplayWidth = 0
          FieldAlias = ''vak leerling.bExtra''
          FieldLength = 10
          FieldName = ''bExtra''
          IsDetail = True
          SQLFieldName = ''bExtra''
          TableAlias = ''Vak leerling''
          TableName = ''sis_lvak''
          TableSQLAlias = ''sis_lvak''
        end
        object daField9: TdaField
          Alias = ''personeel.naam_vol''
          DisplayWidth = 90
          FieldAlias = ''personeel.naam_vol''
          FieldLength = 10
          FieldName = ''NAAM_VOL''
          IsDetail = True
          SQLFieldName = ''NAAM_VOL_2''
          TableAlias = ''Personeel''
          TableName = ''sis_pers''
          TableSQLAlias = ''sis_pers_3''
        end
        object daField10: TdaField
          Alias = ''personeel.naam_vol (2)''
          DisplayWidth = 90
          FieldAlias = ''personeel.naam_vol''
          FieldLength = 10
          FieldName = ''NAAM_VOL''
          IsDetail = True
          SQLFieldName = ''NAAM_VOL_3''
          TableAlias = ''Personeel''
          TableName = ''sis_pers''
          TableSQLAlias = ''sis_pers_4''
        end
        object daField11: TdaField
          Alias = ''studie richting.studie''
          DisplayWidth = 10
          FieldAlias = ''studie richting.studie''
          FieldLength = 10
          FieldName = ''STUDIE''
          IsDetail = True
          SQLFieldName = ''STUDIE''
          TableAlias = ''Studie richting''
          TableName = ''sis_stud''
          TableSQLAlias = ''sis_stud''
        end
        object daField12: TdaField
          Alias = ''klas groep.groep''
          DisplayWidth = 10
          FieldAlias = ''klas groep.groep''
          FieldLength = 10
          FieldName = ''GROEP''
          IsDetail = True
          SQLFieldName = ''GROEP''
          TableAlias = ''Klas Groep''
          TableName = ''sis_bgrp''
          TableSQLAlias = ''sis_bgrp''
        end
        object daField13: TdaField
          Alias = ''klas groep.omschr''
          DisplayWidth = 30
          FieldAlias = ''klas groep.omschr''
          FieldLength = 10
          FieldName = ''OMSCHR''
          IsDetail = True
          SQLFieldName = ''OMSCHR''
          TableAlias = ''Klas Groep''
          TableName = ''sis_bgrp''
          TableSQLAlias = ''sis_bgrp''
        end
        object daField14: TdaField
          Alias = ''Leerling.Tussenv.''
          DisplayWidth = 10
          FieldAlias = ''Leerling.Tussenv.''
          FieldLength = 10
          FieldName = ''tussenvoeg''
          IsDetail = True
          SQLFieldName = ''tussenvoeg''
          TableAlias = ''Leerling''
          TableName = ''sis_leer''
          TableSQLAlias = ''sis_leer''
        end
        object daField15: TdaField
          Alias = ''Leerling.Achternaam''
          DisplayWidth = 40
          FieldAlias = ''Leerling.Achternaam''
          FieldLength = 10
          FieldName = ''achternaam''
          IsDetail = True
          SQLFieldName = ''achternaam''
          TableAlias = ''Leerling''
          TableName = ''sis_leer''
          TableSQLAlias = ''sis_leer''
        end
        object daField16: TdaField
          Alias = ''Leerling.Roepnaam''
          DisplayWidth = 20
          FieldAlias = ''Leerling.Roepnaam''
          FieldLength = 10
          FieldName = ''roepnaam''
          IsDetail = True
          SQLFieldName = ''roepnaam''
          TableAlias = ''Leerling''
          TableName = ''sis_leer''
          TableSQLAlias = ''sis_leer''
        end
        object daField17: TdaField
          Alias = ''Vakken_per_studie.Volgnr''
          DataType = dtInteger
          DisplayWidth = 0
          FieldAlias = ''Vakken_per_studie.Volgnr''
          FieldLength = 10
          FieldName = ''volgnr''
          IsDetail = True
          SQLFieldName = ''volgnr''
          TableAlias = ''sis_svak''
          TableName = ''sis_svak''
          TableSQLAlias = ''sis_svak''
        end
        object daField18: TdaField
          Alias = ''groep''
          DisplayWidth = 10
          FieldAlias = ''groep''
          FieldLength = 10
          FieldName = ''groep''
          SQLFieldName = ''groep_2''
          TableAlias = ''Klas Groep''
          TableName = ''sis_bgrp''
          TableSQLAlias = ''sis_bgrp_2''
        end
        object daField19: TdaField
          Alias = ''Docent stamnr''
          DataType = dtInteger
          DisplayWidth = 10
          FieldAlias = ''stamnr''
          FieldLength = 10
          FieldName = ''stamnr''
          IsDetail = True
          SQLFieldName = ''stamnr_3''
          TableAlias = ''Personeel''
          TableName = ''sis_pers''
          TableSQLAlias = ''sis_pers''
        end
        object daField20: TdaField
          Alias = ''Docent 2 stamnr''
          DataType = dtInteger
          DisplayWidth = 10
          FieldAlias = ''stamnr''
          FieldLength = 10
          FieldName = ''stamnr''
          IsDetail = True
          SQLFieldName = ''stamnr_4''
          TableAlias = ''Personeel''
          TableName = ''sis_pers''
          TableSQLAlias = ''sis_pers_2''
        end
        object daField21: TdaField
          Alias = ''Brin''
          DisplayWidth = 10
          FieldAlias = ''Administratieve_eenheid.BRIN''
          FieldLength = 10
          FieldName = ''brin_nr''
          IsDetail = True
          SQLFieldName = ''brin_nr''
          TableAlias = ''Administratieve_eenheid''
          TableName = ''sis_blok''
          TableSQLAlias = ''sis_blok''
        end
        object daField22: TdaField
          Alias = ''Leerjaar''
          DataType = dtInteger
          DisplayWidth = 10
          FieldAlias = ''Leerfase.Leerjaar''
          FieldLength = 10
          FieldName = ''leerjaar''
          IsDetail = True
          SQLFieldName = ''leerjaar''
          TableAlias = ''Leerfase''
          TableName = ''sis_blfa''
          TableSQLAlias = ''sis_blfa''
        end
        object daField23: TdaField
          Alias = ''doc_code''
          DisplayWidth = 10
          FieldAlias = ''doc_code''
          FieldLength = 10
          FieldName = ''doc_code''
          IsDetail = True
          SQLFieldName = ''doc_code''
          TableAlias = ''Personeel''
          TableName = ''sis_pers''
          TableSQLAlias = ''sis_pers''
        end
        object daField24: TdaField
          Alias = ''doc_code (2)''
          DisplayWidth = 10
          FieldAlias = ''doc_code''
          FieldLength = 10
          FieldName = ''doc_code''
          IsDetail = True
          SQLFieldName = ''doc_code_2''
          TableAlias = ''Personeel''
          TableName = ''sis_pers''
          TableSQLAlias = ''sis_pers_2''
        end
        object daField25: TdaField
          Alias = ''doc_code (3)''
          DisplayWidth = 10
          FieldAlias = ''doc_code''
          FieldLength = 10
          FieldName = ''doc_code''
          IsDetail = True
          SQLFieldName = ''doc_code_3''
          TableAlias = ''Personeel''
          TableName = ''sis_pers''
          TableSQLAlias = ''sis_pers_3''
        end
        object daField26: TdaField
          Alias = ''doc_code (4)''
          DisplayWidth = 10
          FieldAlias = ''doc_code''
          FieldLength = 10
          FieldName = ''doc_code''
          IsDetail = True
          SQLFieldName = ''doc_code_4''
          TableAlias = ''Personeel''
          TableName = ''sis_pers''
          TableSQLAlias = ''sis_pers_4''
        end
        object daField27: TdaField
          Alias = ''Aanmelding.Examennummer''
          DataType = dtInteger
          DisplayWidth = 10
          FieldAlias = ''Aanmelding.Examennummer''
          FieldLength = 10
          FieldName = ''exam_nr''
          SQLFieldName = ''exam_nr''
          TableAlias = ''Aanmelding''
          TableName = ''sis_aanm''
          TableSQLAlias = ''sis_aanm''
        end
        object daField28: TdaField
          ChildType = 2
          Alias = ''aanmelding.stamnr''
          DataType = dtInteger
          DisplayWidth = 0
          FieldAlias = ''aanmelding.stamnr''
          FieldLength = 0
          FieldName = ''STAMNR''
          SQLFieldName = ''STAMNR''
          TableAlias = ''Aanmelding''
          TableName = ''sis_aanm''
          TableSQLAlias = ''sis_aanm''
        end
        object daCalculation9: TdaCalculation
          ChildType = 2
          Alias = ''SoortVak''
          DisplayWidth = 10
          FieldAlias = ''voornamen''
          FieldLength = 10
          FieldName = ''voornamen''
          SQLFieldName = ''CASE_WHEN_sis_lvak_bGem_1''
          TableAlias = ''Personeel''
          TableName = ''sis_pers''
          TableSQLAlias = ''sis_pers''
          CalcType = dacaExpression
          Expression = 
            ''CASE WHEN sis_lvak.bGem=1 THEN ''#39''Gemeenschappelijk''#39'' ELSE CASE WHE'' +
            ''N sis_lvak.bPvak=1 THEN ''#39''Profielvak''#39'' ELSE ''#39''Vrij vak''#39''END END''
        end
        object daField29: TdaField
          ChildType = 2
          Alias = ''volgnr''
          DataType = dtInteger
          DisplayWidth = 10
          FieldAlias = ''volgnr''
          FieldLength = 0
          FieldName = ''volgnr''
          SQLFieldName = ''volgnr''
          TableAlias = ''sis_svak''
          TableName = ''sis_svak''
          TableSQLAlias = ''sis_svak''
        end
        object daTable1: TdaTable
          ChildType = 5
          Alias = ''Aanmelding''
          JoinType = dajtNone
          SQLAlias = ''sis_aanm''
          TableAlias = ''Aanmelding''
          TableName = ''sis_aanm''
        end
        object daTable2: TdaTable
          ChildType = 5
          Alias = ''Leerling''
          SQLAlias = ''sis_leer''
          TableAlias = ''Leerling''
          TableName = ''sis_leer''
          object daTableJoin1: TdaTableJoin
            ChildType = 6
            object daField31: TdaField
              ChildType = 3
              Alias = ''Leerling.Stamnummer''
              DataType = dtInteger
              DisplayWidth = 0
              FieldAlias = ''Leerling.Stamnummer''
              FieldLength = 0
              FieldName = ''STAMNR''
              SQLFieldName = ''STAMNR''
              TableAlias = ''Leerling''
              TableName = ''sis_leer''
              TableSQLAlias = ''sis_leer''
            end
            object daField30: TdaField
              ChildType = 4
              Alias = ''Aanmelding.Stamnummer''
              DataType = dtInteger
              DisplayWidth = 0
              FieldAlias = ''Aanmelding.Stamnummer''
              FieldLength = 0
              FieldName = ''STAMNR''
              SQLFieldName = ''STAMNR''
              TableAlias = ''Aanmelding''
              TableName = ''sis_aanm''
              TableSQLAlias = ''sis_aanm''
            end
          end
        end
        object daTable3: TdaTable
          ChildType = 5
          Alias = ''Vak leerling''
          JoinType = dajtLeftOuter
          SQLAlias = ''sis_lvak''
          TableAlias = ''Vak leerling''
          TableName = ''sis_lvak''
          object daTableJoin2: TdaTableJoin
            ChildType = 6
            object daField33: TdaField
              ChildType = 3
              Alias = ''vak leerling.stamnr''
              DataType = dtInteger
              DisplayWidth = 0
              FieldAlias = ''vak leerling.stamnr''
              FieldLength = 0
              FieldName = ''STAMNR''
              SQLFieldName = ''STAMNR''
              TableAlias = ''Vak leerling''
              TableName = ''sis_lvak''
              TableSQLAlias = ''sis_lvak''
            end
            object daField32: TdaField
              ChildType = 4
              Alias = ''aanmelding.stamnr''
              DataType = dtInteger
              DisplayWidth = 0
              FieldAlias = ''aanmelding.stamnr''
              FieldLength = 0
              FieldName = ''STAMNR''
              SQLFieldName = ''STAMNR''
              TableAlias = ''Aanmelding''
              TableName = ''sis_aanm''
              TableSQLAlias = ''sis_aanm''
            end
          end
          object daTableJoin3: TdaTableJoin
            ChildType = 6
            object daField35: TdaField
              ChildType = 3
              Alias = ''vak leerling.idStud''
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = ''vak leerling.idStud''
              FieldLength = 0
              FieldName = ''idStud''
              SQLFieldName = ''idStud''
              TableAlias = ''Vak leerling''
              TableName = ''sis_lvak''
              TableSQLAlias = ''sis_lvak''
            end
            object daField34: TdaField
              ChildType = 4
              Alias = ''aanmelding.idStud''
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = ''aanmelding.idStud''
              FieldLength = 0
              FieldName = ''idStud''
              SQLFieldName = ''idStud''
              TableAlias = ''Aanmelding''
              TableName = ''sis_aanm''
              TableSQLAlias = ''sis_aanm''
            end
          end
        end
        object daTable4: TdaTable
          ChildType = 5
          Alias = ''Klas Groep''
          JoinType = dajtLeftOuter
          SQLAlias = ''sis_bgrp''
          TableAlias = ''Klas Groep''
          TableName = ''sis_bgrp''
          object daTableJoin4: TdaTableJoin
            ChildType = 6
            object daField37: TdaField
              ChildType = 3
              Alias = ''klas groep.idBgrp''
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = ''klas groep.idBgrp''
              FieldLength = 0
              FieldName = ''idBgrp''
              SQLFieldName = ''idBgrp''
              TableAlias = ''Klas Groep''
              TableName = ''sis_bgrp''
              TableSQLAlias = ''sis_bgrp''
            end
            object daField36: TdaField
              ChildType = 4
              Alias = ''aanmelding.idBgrp''
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = ''aanmelding.idBgrp''
              FieldLength = 0
              FieldName = ''idBgrp''
              SQLFieldName = ''idBgrp''
              TableAlias = ''Aanmelding''
              TableName = ''sis_aanm''
              TableSQLAlias = ''sis_aanm''
            end
          end
        end
        object daTable5: TdaTable
          ChildType = 5
          Alias = ''Personeel groep vak''
          JoinType = dajtLeftOuter
          SQLAlias = ''sis_pgvk''
          TableAlias = ''Personeel groep vak''
          TableName = ''sis_pgvk''
          object daTableJoin5: TdaTableJoin
            ChildType = 6
            object daField39: TdaField
              ChildType = 3
              Alias = ''personeel groep vak.idBgrp''
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = ''personeel groep vak.idBgrp''
              FieldLength = 0
              FieldName = ''idBgrp''
              SQLFieldName = ''idBgrp''
              TableAlias = ''Personeel groep vak''
              TableName = ''sis_pgvk''
              TableSQLAlias = ''sis_pgvk''
            end
            object daField38: TdaField
              ChildType = 4
              Alias = ''klas groep.idBgrp''
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = ''klas groep.idBgrp''
              FieldLength = 0
              FieldName = ''idBgrp''
              SQLFieldName = ''idBgrp''
              TableAlias = ''Klas Groep''
              TableName = ''sis_bgrp''
              TableSQLAlias = ''sis_bgrp''
            end
          end
          object daTableJoin6: TdaTableJoin
            ChildType = 6
            object daField41: TdaField
              ChildType = 3
              Alias = ''personeel groep vak.c_vak''
              DisplayWidth = 0
              FieldAlias = ''personeel groep vak.c_vak''
              FieldLength = 0
              FieldName = ''C_VAK''
              SQLFieldName = ''C_VAK''
              TableAlias = ''Personeel groep vak''
              TableName = ''sis_pgvk''
              TableSQLAlias = ''sis_pgvk''
            end
            object daField40: TdaField
              ChildType = 4
              Alias = ''vak leerling.c_vak''
              DisplayWidth = 0
              FieldAlias = ''vak leerling.c_vak''
              FieldLength = 0
              FieldName = ''C_VAK''
              SQLFieldName = ''C_VAK''
              TableAlias = ''vak leerling''
              TableName = ''sis_lvak''
              TableSQLAlias = ''sis_lvak''
            end
          end
        end
        object daTable6: TdaTable
          ChildType = 5
          Alias = ''Personeel''
          JoinType = dajtLeftOuter
          SQLAlias = ''sis_pers''
          TableAlias = ''Personeel''
          TableName = ''sis_pers''
          object daTableJoin7: TdaTableJoin
            ChildType = 6
            object daField43: TdaField
              ChildType = 3
              Alias = ''personeel.idPers''
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = ''personeel.idPers''
              FieldLength = 0
              FieldName = ''idPers''
              SQLFieldName = ''idPers''
              TableAlias = ''Personeel''
              TableName = ''sis_pers''
              TableSQLAlias = ''sis_pers''
            end
            object daField42: TdaField
              ChildType = 4
              Alias = ''personeel groep vak.idPers''
              DataType = dtInteger
              DisplayWidth = 0
              FieldAlias = ''personeel groep vak.idPers''
              FieldLength = 0
              FieldName = ''idPers''
              SQLFieldName = ''idPers''
              TableAlias = ''Personeel groep vak''
              TableName = ''sis_pgvk''
              TableSQLAlias = ''sis_pgvk''
            end
          end
        end
        object daTable7: TdaTable
          ChildType = 5
          Alias = ''Klas Groep''
          JoinType = dajtLeftOuter
          SQLAlias = ''sis_bgrp_2''
          TableAlias = ''Klas Groep''
          TableName = ''sis_bgrp''
          object daTableJoin8: TdaTableJoin
            ChildType = 6
            object daField45: TdaField
              ChildType = 3
              Alias = ''klas groep.idBgrp''
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = ''klas groep.idBgrp''
              FieldLength = 0
              FieldName = ''idBgrp''
              SQLFieldName = ''idBgrp''
              TableAlias = ''Klas Groep''
              TableName = ''sis_bgrp''
              TableSQLAlias = ''sis_bgrp_2''
            end
            object daField44: TdaField
              ChildType = 4
              Alias = ''vak leerling.idBgrp''
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = ''vak leerling.idBgrp''
              FieldLength = 0
              FieldName = ''idBgrp''
              SQLFieldName = ''idBgrp''
              TableAlias = ''Vak leerling''
              TableName = ''sis_lvak''
              TableSQLAlias = ''sis_lvak''
            end
          end
        end
        object daTable8: TdaTable
          ChildType = 5
          Alias = ''Personeel groep vak''
          JoinType = dajtLeftOuter
          SQLAlias = ''sis_pgvk_2''
          TableAlias = ''Personeel groep vak''
          TableName = ''sis_pgvk''
          object daTableJoin9: TdaTableJoin
            ChildType = 6
            object daField47: TdaField
              ChildType = 3
              Alias = ''personeel groep vak.idBgrp''
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = ''personeel groep vak.idBgrp''
              FieldLength = 0
              FieldName = ''idBgrp''
              SQLFieldName = ''idBgrp''
              TableAlias = ''Personeel groep vak''
              TableName = ''sis_pgvk''
              TableSQLAlias = ''sis_pgvk_2''
            end
            object daField46: TdaField
              ChildType = 4
              Alias = ''vak leerling.idBgrp''
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = ''vak leerling.idBgrp''
              FieldLength = 0
              FieldName = ''idBgrp''
              SQLFieldName = ''idBgrp''
              TableAlias = ''Vak leerling''
              TableName = ''sis_lvak''
              TableSQLAlias = ''sis_lvak''
            end
          end
          object daTableJoin10: TdaTableJoin
            ChildType = 6
            object daField49: TdaField
              ChildType = 3
              Alias = ''personeel groep vak.c_vak''
              DisplayWidth = 6
              FieldAlias = ''personeel groep vak.c_vak''
              FieldLength = 6
              FieldName = ''C_VAK''
              SQLFieldName = ''C_VAK''
              TableAlias = ''Personeel groep vak''
              TableName = ''sis_pgvk''
              TableSQLAlias = ''sis_pgvk_2''
            end
            object daField48: TdaField
              ChildType = 4
              Alias = ''vak leerling.c_vak''
              DisplayWidth = 6
              FieldAlias = ''vak leerling.c_vak''
              FieldLength = 6
              FieldName = ''C_VAK''
              SQLFieldName = ''C_VAK''
              TableAlias = ''Vak leerling''
              TableName = ''sis_lvak''
              TableSQLAlias = ''sis_lvak''
            end
          end
        end
        object daTable9: TdaTable
          ChildType = 5
          Alias = ''Personeel''
          JoinType = dajtLeftOuter
          SQLAlias = ''sis_pers_2''
          TableAlias = ''Personeel''
          TableName = ''sis_pers''
          object daTableJoin11: TdaTableJoin
            ChildType = 6
            object daField51: TdaField
              ChildType = 3
              Alias = ''personeel.idPers''
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = ''personeel.idPers''
              FieldLength = 0
              FieldName = ''idPers''
              SQLFieldName = ''idPers''
              TableAlias = ''Personeel''
              TableName = ''sis_pers''
              TableSQLAlias = ''sis_pers_2''
            end
            object daField50: TdaField
              ChildType = 4
              Alias = ''personeel groep vak.idPers''
              DataType = dtInteger
              DisplayWidth = 0
              FieldAlias = ''personeel groep vak.idPers''
              FieldLength = 0
              FieldName = ''idPers''
              SQLFieldName = ''idPers''
              TableAlias = ''Personeel groep vak''
              TableName = ''sis_pgvk''
              TableSQLAlias = ''sis_pgvk_2''
            end
          end
        end
        object daTable10: TdaTable
          ChildType = 5
          Alias = ''Vak''
          JoinType = dajtLeftOuter
          SQLAlias = ''sis_bvak''
          TableAlias = ''Vak''
          TableName = ''sis_bvak''
          object daTableJoin12: TdaTableJoin
            ChildType = 6
            object daField53: TdaField
              ChildType = 3
              Alias = ''vak.c_vak''
              DisplayWidth = 6
              FieldAlias = ''vak.c_vak''
              FieldLength = 6
              FieldName = ''C_VAK''
              SQLFieldName = ''C_VAK''
              TableAlias = ''Vak''
              TableName = ''sis_bvak''
              TableSQLAlias = ''sis_bvak''
            end
            object daField52: TdaField
              ChildType = 4
              Alias = ''vak leerling.c_vak''
              DisplayWidth = 6
              FieldAlias = ''vak leerling.c_vak''
              FieldLength = 6
              FieldName = ''C_VAK''
              SQLFieldName = ''C_VAK''
              TableAlias = ''Vak leerling''
              TableName = ''sis_lvak''
              TableSQLAlias = ''sis_lvak''
            end
          end
        end
        object daTable11: TdaTable
          ChildType = 5
          Alias = ''Personeel''
          JoinType = dajtLeftOuter
          SQLAlias = ''sis_pers_3''
          TableAlias = ''Personeel''
          TableName = ''sis_pers''
          object daTableJoin13: TdaTableJoin
            ChildType = 6
            object daField55: TdaField
              ChildType = 3
              Alias = ''personeel.idPers''
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = ''personeel.idPers''
              FieldLength = 0
              FieldName = ''idPers''
              SQLFieldName = ''idPers''
              TableAlias = ''Personeel''
              TableName = ''sis_pers''
              TableSQLAlias = ''sis_pers_3''
            end
            object daField54: TdaField
              ChildType = 4
              Alias = ''klas groep.idPers_mentor1''
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = ''klas groep.idPers_mentor1''
              FieldLength = 0
              FieldName = ''idPers_mentor1''
              SQLFieldName = ''idPers_mentor1''
              TableAlias = ''Klas Groep''
              TableName = ''sis_bgrp''
              TableSQLAlias = ''sis_bgrp''
            end
          end
        end
        object daTable12: TdaTable
          ChildType = 5
          Alias = ''Personeel''
          JoinType = dajtLeftOuter
          SQLAlias = ''sis_pers_4''
          TableAlias = ''Personeel''
          TableName = ''sis_pers''
          object daTableJoin14: TdaTableJoin
            ChildType = 6
            object daField57: TdaField
              ChildType = 3
              Alias = ''personeel.idPers''
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = ''personeel.idPers''
              FieldLength = 0
              FieldName = ''idPers''
              SQLFieldName = ''idPers''
              TableAlias = ''Personeel''
              TableName = ''sis_pers''
              TableSQLAlias = ''sis_pers_4''
            end
            object daField56: TdaField
              ChildType = 4
              Alias = ''klas groep.idPers_mentor2''
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = ''klas groep.idPers_mentor2''
              FieldLength = 0
              FieldName = ''idPers_mentor2''
              SQLFieldName = ''idPers_mentor2''
              TableAlias = ''Klas Groep''
              TableName = ''sis_bgrp''
              TableSQLAlias = ''sis_bgrp''
            end
          end
        end
        object daTable13: TdaTable
          ChildType = 5
          Alias = ''Studie richting''
          JoinType = dajtLeftOuter
          SQLAlias = ''sis_stud''
          TableAlias = ''Studie richting''
          TableName = ''sis_stud''
          object daTableJoin15: TdaTableJoin
            ChildType = 6
            object daField59: TdaField
              ChildType = 3
              Alias = ''studie richting.idStud''
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = ''studie richting.idStud''
              FieldLength = 0
              FieldName = ''idStud''
              SQLFieldName = ''idStud''
              TableAlias = ''Studie richting''
              TableName = ''sis_stud''
              TableSQLAlias = ''sis_stud''
            end
            object daField58: TdaField
              ChildType = 4
              Alias = ''aanmelding.idStud''
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = ''aanmelding.idStud''
              FieldLength = 0
              FieldName = ''idStud''
              SQLFieldName = ''idStud''
              TableAlias = ''Aanmelding''
              TableName = ''sis_aanm''
              TableSQLAlias = ''sis_aanm''
            end
          end
        end
        object daTable14: TdaTable
          ChildType = 5
          Alias = ''sis_svak''
          JoinType = dajtLeftOuter
          SQLAlias = ''sis_svak''
          TableAlias = ''sis_svak''
          TableName = ''sis_svak''
          object daTableJoin16: TdaTableJoin
            ChildType = 6
            object daField61: TdaField
              ChildType = 3
              Alias = ''idStud''
              DataType = dtInteger
              DisplayWidth = 10
              FieldAlias = ''idStud''
              FieldLength = 0
              FieldName = ''idStud''
              SQLFieldName = ''idStud''
              TableAlias = ''sis_svak''
              TableName = ''sis_svak''
              TableSQLAlias = ''sis_svak''
            end
            object daField60: TdaField
              ChildType = 4
              Alias = ''idStud''
              DataType = dtInteger
              DisplayWidth = 10
              FieldAlias = ''idStud''
              FieldLength = 0
              FieldName = ''idStud''
              SQLFieldName = ''idStud''
              TableAlias = ''Vak leerling''
              TableName = ''sis_lvak''
              TableSQLAlias = ''sis_lvak''
            end
          end
          object daTableJoin17: TdaTableJoin
            ChildType = 6
            object daField63: TdaField
              ChildType = 3
              Alias = ''C_VAK''
              DisplayWidth = 6
              FieldAlias = ''C_VAK''
              FieldLength = 6
              FieldName = ''C_VAK''
              SQLFieldName = ''C_VAK''
              TableAlias = ''sis_svak''
              TableName = ''sis_svak''
              TableSQLAlias = ''sis_svak''
            end
            object daField62: TdaField
              ChildType = 4
              Alias = ''C_VAK''
              DisplayWidth = 6
              FieldAlias = ''C_VAK''
              FieldLength = 6
              FieldName = ''C_VAK''
              SQLFieldName = ''C_VAK''
              TableAlias = ''Vak leerling''
              TableName = ''sis_lvak''
              TableSQLAlias = ''sis_lvak''
            end
          end
        end
        object daTable15: TdaTable
          ChildType = 5
          Alias = ''Administratieve_eenheid''
          JoinType = dajtLeftOuter
          SQLAlias = ''sis_blok''
          TableAlias = ''Administratieve_eenheid''
          TableName = ''sis_blok''
          object daTableJoin18: TdaTableJoin
            ChildType = 6
            object daField65: TdaField
              ChildType = 3
              Alias = ''Administratieve_eenheid.Adm. Eenheid''
              DisplayWidth = 10
              FieldAlias = ''Administratieve_eenheid.Adm. Eenheid''
              FieldLength = 10
              FieldName = ''c_lokatie''
              SQLFieldName = ''c_lokatie''
              TableAlias = ''Administratieve_eenheid''
              TableName = ''sis_blok''
              TableSQLAlias = ''sis_blok''
            end
            object daField64: TdaField
              ChildType = 4
              Alias = ''Klas.c_lokatie''
              DisplayWidth = 10
              FieldAlias = ''Klas.c_lokatie''
              FieldLength = 10
              FieldName = ''c_lokatie''
              SQLFieldName = ''c_lokatie''
              TableAlias = ''Klas Groep''
              TableName = ''sis_bgrp''
              TableSQLAlias = ''sis_bgrp''
            end
          end
        end
        object daTable16: TdaTable
          ChildType = 5
          Alias = ''Leerfase''
          JoinType = dajtLeftOuter
          SQLAlias = ''sis_blfa''
          TableAlias = ''Leerfase''
          TableName = ''sis_blfa''
          object daTableJoin19: TdaTableJoin
            ChildType = 6
            object daField67: TdaField
              ChildType = 3
              Alias = ''Leerfase.Sleutelveld''
              DataType = dtInteger
              DisplayWidth = 10
              FieldAlias = ''Leerfase.Sleutelveld''
              FieldLength = 10
              FieldName = ''idBlfa''
              SQLFieldName = ''idBlfa''
              TableAlias = ''Leerfase''
              TableName = ''sis_blfa''
              TableSQLAlias = ''sis_blfa''
            end
            object daField66: TdaField
              ChildType = 4
              Alias = ''Studie.idBlfa''
              DataType = dtInteger
              DisplayWidth = 10
              FieldAlias = ''Studie.idBlfa''
              FieldLength = 10
              FieldName = ''idBlfa''
              SQLFieldName = ''idBlfa''
              TableAlias = ''Studie richting''
              TableName = ''sis_stud''
              TableSQLAlias = ''sis_stud''
            end
          end
        end
      end
    end
  end
  object ppDesignLayers1: TppDesignLayers
    object ppDesignLayer1: TppDesignLayer
      UserName = ''Foreground''
      LayerType = ltBanded
      Index = 0
    end
  end
  object ppParameterList1: TppParameterList
  end
end
',NULL,NULL,0,NULL,639,0);
