object DM: TDM
  OldCreateOrder = False
  Height = 689
  Width = 781
  object conexao: TSQLConnection
    ConnectionName = 'SISESCOLA2'
    DriverName = 'Firebird'
    LoginPrompt = False
    Params.Strings = (
      'DriverName=Firebird'
      'DriverUnit=Data.DBXFirebird'
      
        'DriverPackageLoader=TDBXDynalinkDriverLoader,DbxCommonDriver260.' +
        'bpl'
      
        'DriverAssemblyLoader=Borland.Data.TDBXDynalinkDriverLoader,Borla' +
        'nd.Data.DbxCommonDriver,Version=24.0.0.0,Culture=neutral,PublicK' +
        'eyToken=91d62ebb5b0d1b1b'
      
        'MetaDataPackageLoader=TDBXFirebirdMetaDataCommandFactory,DbxFire' +
        'birdDriver260.bpl'
      
        'MetaDataAssemblyLoader=Borland.Data.TDBXFirebirdMetaDataCommandF' +
        'actory,Borland.Data.DbxFirebirdDriver,Version=24.0.0.0,Culture=n' +
        'eutral,PublicKeyToken=91d62ebb5b0d1b1b'
      'LibraryName=dbxfb.dll'
      'LibraryNameOsx=libsqlfb.dylib'
      'VendorLib=fbclient.dll'
      'VendorLibWin64=fbclient.dll'
      'VendorLibOsx=/Library/Frameworks/Firebird.framework/Firebird'
      'Database=C:\SISPREF\SISESCOLA\banco\banco.fdb'
      'User_Name=sysdba'
      'Password=masterkey'
      'Role=RoleName'
      'MaxBlobSize=-1'
      'LocaleCode=0000'
      'IsolationLevel=ReadCommitted'
      'SQLDialect=3'
      'CommitRetain=False'
      'WaitOnLocks=True'
      'TrimChar=False'
      'BlobSize=-1'
      'ErrorResourceFile='
      'RoleName=RoleName'
      'ServerCharSet='
      'Trim Char=False')
    BeforeConnect = conexaoBeforeConnect
    Connected = True
    Left = 16
    Top = 8
  end
  object SDSlogin: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select * from acesso'#13#10'where USUARIO = :nome and SENHA = :senha'
    MaxBlobSize = 1
    Params = <
      item
        DataType = ftString
        Name = 'nome'
        ParamType = ptInput
      end
      item
        DataType = ftString
        Name = 'senha'
        ParamType = ptInput
      end>
    SQLConnection = conexao
    Left = 72
    Top = 16
    object SDSloginID_SENHA: TIntegerField
      FieldName = 'ID_SENHA'
    end
    object SDSloginNOME: TStringField
      FieldName = 'NOME'
      Size = 40
    end
    object SDSloginUSUARIO: TStringField
      FieldName = 'USUARIO'
      Size = 30
    end
    object SDSloginSENHA: TStringField
      FieldName = 'SENHA'
      Size = 30
    end
    object SDSloginNIVEL: TIntegerField
      FieldName = 'NIVEL'
    end
  end
  object DSPlogin: TDataSetProvider
    DataSet = SDSlogin
    Options = [poAllowCommandText, poUseQuoteChar]
    Left = 68
    Top = 68
  end
  object CDSlogin: TClientDataSet
    Aggregates = <>
    Params = <
      item
        DataType = ftString
        Name = 'nome'
        ParamType = ptInput
      end
      item
        DataType = ftString
        Name = 'senha'
        ParamType = ptInput
      end>
    ProviderName = 'DSPlogin'
    Left = 64
    Top = 122
    object CDSloginID_SENHA: TIntegerField
      FieldName = 'ID_SENHA'
    end
    object CDSloginNOME: TStringField
      FieldName = 'NOME'
      Size = 40
    end
    object CDSloginUSUARIO: TStringField
      FieldName = 'USUARIO'
      Size = 30
    end
    object CDSloginSENHA: TStringField
      FieldName = 'SENHA'
      Size = 30
    end
    object CDSloginNIVEL: TIntegerField
      FieldName = 'NIVEL'
    end
  end
  object SqlUsuario: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select * from  ACESSO'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = conexao
    Left = 136
    Top = 16
    object SqlUsuarioID_SENHA: TIntegerField
      FieldName = 'ID_SENHA'
      Required = True
    end
    object SqlUsuarioNOME: TStringField
      FieldName = 'NOME'
      Size = 40
    end
    object SqlUsuarioUSUARIO: TStringField
      FieldName = 'USUARIO'
      Size = 30
    end
    object SqlUsuarioSENHA: TStringField
      FieldName = 'SENHA'
      Size = 30
    end
    object SqlUsuarioNIVEL: TIntegerField
      FieldName = 'NIVEL'
    end
  end
  object DspUsuario: TDataSetProvider
    DataSet = SqlUsuario
    Left = 136
    Top = 72
  end
  object CdsUsuario: TClientDataSet
    Aggregates = <>
    IndexFieldNames = 'USUARIO'
    Params = <>
    ProviderName = 'DspUsuario'
    Left = 136
    Top = 123
    object CdsUsuarioID_SENHA: TIntegerField
      FieldName = 'ID_SENHA'
      Required = True
    end
    object CdsUsuarioNOME: TStringField
      FieldName = 'NOME'
      Size = 40
    end
    object CdsUsuarioUSUARIO: TStringField
      FieldName = 'USUARIO'
      Size = 30
    end
    object CdsUsuarioSENHA: TStringField
      FieldName = 'SENHA'
      Size = 30
    end
    object CdsUsuarioNIVEL: TIntegerField
      FieldName = 'NIVEL'
    end
  end
  object cdspresidente: TClientDataSet
    Aggregates = <>
    Filtered = True
    Params = <>
    ProviderName = 'provpresidente'
    Left = 200
    Top = 131
    object cdspresidenteCODIGO_PRESIDENTE: TIntegerField
      FieldName = 'CODIGO_PRESIDENTE'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object cdspresidenteNOME_PRESIDENTE: TStringField
      FieldName = 'NOME_PRESIDENTE'
      Size = 100
    end
    object cdspresidenteDATA_VIGENTE: TStringField
      FieldName = 'DATA_VIGENTE'
      Size = 50
    end
    object cdspresidenteANO_VIGENTE: TStringField
      FieldName = 'ANO_VIGENTE'
      Size = 10
    end
    object cdspresidenteCIDADE: TStringField
      FieldName = 'CIDADE'
      Size = 100
    end
    object cdspresidenteRESP_TRANSPORTE: TStringField
      FieldName = 'RESP_TRANSPORTE'
      Size = 100
    end
  end
  object sqlpresidente: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select * from PRESIDENTE'
    MaxBlobSize = 1
    Params = <>
    SQLConnection = conexao
    Left = 200
    Top = 16
  end
  object provpresidente: TDataSetProvider
    DataSet = sqlpresidente
    Options = [poAllowCommandText, poUseQuoteChar]
    Left = 200
    Top = 72
  end
  object sqlaluno: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select * from ENCAMINHAMENTO'
    MaxBlobSize = 1
    Params = <>
    SQLConnection = conexao
    Left = 264
    Top = 16
  end
  object provaluno: TDataSetProvider
    DataSet = sqlaluno
    Options = [poAllowCommandText, poUseQuoteChar]
    Left = 264
    Top = 72
  end
  object cdsaluno: TClientDataSet
    Aggregates = <>
    Filtered = True
    IndexFieldNames = 'DATA_ATENDIMENTO'
    Params = <>
    ProviderName = 'provaluno'
    Left = 264
    Top = 131
    object cdsalunoCODIGO: TIntegerField
      FieldName = 'CODIGO'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object cdsalunoDATA_ATENDIMENTO: TDateField
      FieldName = 'DATA_ATENDIMENTO'
      EditMask = '!99/99/0000;1;_'
    end
    object cdsalunoNOME_ALUNO: TStringField
      FieldName = 'NOME_ALUNO'
      Size = 255
    end
    object cdsalunoDATA_NASC: TDateField
      FieldName = 'DATA_NASC'
      EditMask = '!99/99/0000;1;_'
    end
    object cdsalunoRESPONSAVEL_1: TStringField
      FieldName = 'RESPONSAVEL_1'
      Size = 255
    end
    object cdsalunoRESPONSAVEL_2: TStringField
      FieldName = 'RESPONSAVEL_2'
      Size = 255
    end
    object cdsalunoENDERECO: TStringField
      FieldName = 'ENDERECO'
      Size = 255
    end
    object cdsalunoCONTATO_1: TStringField
      FieldName = 'CONTATO_1'
      EditMask = '!\(99\)00000-0000;1;_'
      Size = 255
    end
    object cdsalunoCONTATO_2: TStringField
      FieldName = 'CONTATO_2'
      EditMask = '!\(99\)00000-0000;1;_'
      Size = 255
    end
    object cdsalunoBAIRRO: TStringField
      FieldName = 'BAIRRO'
      Size = 255
    end
    object cdsalunoOBS: TStringField
      FieldName = 'OBS'
      Size = 255
    end
    object cdsalunoSTATUS: TStringField
      FieldName = 'STATUS'
      Size = 255
    end
    object cdsalunoSITUACAO: TStringField
      FieldName = 'SITUACAO'
      Size = 255
    end
    object cdsalunoESCOLA_TROCA: TStringField
      FieldName = 'ESCOLA_TROCA'
      Size = 255
    end
    object cdsalunoNOME_ESCOLAS: TStringField
      FieldName = 'NOME_ESCOLAS'
      Size = 100
    end
    object cdsalunoNOMES_TURNOS: TStringField
      FieldName = 'NOMES_TURNOS'
      Size = 100
    end
    object cdsalunoNOMES_SERIES: TStringField
      FieldName = 'NOMES_SERIES'
      Size = 100
    end
    object cdsalunoNIS_ALUNO: TStringField
      FieldName = 'NIS_ALUNO'
      EditMask = '000\.000\.000\-00;1;_'
    end
    object cdsalunoRECEBE_S_N: TStringField
      FieldName = 'RECEBE_S_N'
    end
    object cdsalunoCPF: TStringField
      FieldName = 'CPF'
      EditMask = '000\.000\.000\-00;1;_'
      Size = 15
    end
    object cdsalunoID_ESCOLA: TIntegerField
      FieldName = 'ID_ESCOLA'
    end
    object cdsalunoID_SERIE: TIntegerField
      FieldName = 'ID_SERIE'
    end
    object cdsalunoID_TURNO: TIntegerField
      FieldName = 'ID_TURNO'
    end
    object cdsalunoUSUARIO: TStringField
      FieldName = 'USUARIO'
      Size = 50
    end
    object cdsalunoDATA_ED: TDateField
      FieldName = 'DATA_ED'
      EditMask = '!99/99/0000;1;_'
    end
    object cdsalunoHORA_ED: TTimeField
      FieldName = 'HORA_ED'
      EditMask = '!90:00:00>;1;_'
    end
  end
  object cdsvagas: TClientDataSet
    Aggregates = <
      item
        Active = True
        AggregateName = 'qtdv'
        Expression = 'sum(qtd_vagas)'
        Visible = False
      end
      item
        Active = True
        AggregateName = 'qtq'
        Expression = 'sum(q_mat_1)'
        Visible = False
      end>
    AggregatesActive = True
    Filtered = True
    Params = <>
    ProviderName = 'provvagas'
    Left = 328
    Top = 131
    object cdsvagasVAGA_CODIGO: TIntegerField
      FieldName = 'VAGA_CODIGO'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object cdsvagasESCOLA: TStringField
      FieldName = 'ESCOLA'
      Size = 100
    end
    object cdsvagasSERIE: TStringField
      FieldName = 'SERIE'
      Size = 100
    end
    object cdsvagasTURNO: TStringField
      FieldName = 'TURNO'
      Size = 100
    end
    object cdsvagasQTD_VAGAS: TIntegerField
      FieldName = 'QTD_VAGAS'
    end
    object cdsvagasUSUARIO: TStringField
      FieldName = 'USUARIO'
      Size = 50
    end
    object cdsvagasQ_MAT_1: TIntegerField
      FieldName = 'Q_MAT_1'
    end
    object cdsvagasDATA: TDateField
      FieldName = 'DATA'
      EditMask = '!99/99/0000;1;_'
    end
    object cdsvagasHORA: TTimeField
      FieldName = 'HORA'
      EditMask = '!90:00;1;_'
    end
  end
  object sqlvagas: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select * from VAGAS'
    MaxBlobSize = 1
    Params = <>
    SQLConnection = conexao
    Left = 328
    Top = 16
  end
  object provvagas: TDataSetProvider
    DataSet = sqlvagas
    Options = [poAllowCommandText, poUseQuoteChar]
    Left = 328
    Top = 72
  end
  object sql_patrimonio: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select *  from PATRIMONIO'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = conexao
    Left = 656
    Top = 24
  end
  object prov_patrimonio: TDataSetProvider
    DataSet = sql_patrimonio
    Left = 656
    Top = 80
  end
  object cds_patrimonio: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'prov_patrimonio'
    Left = 656
    Top = 139
    object cds_patrimonioID: TIntegerField
      FieldName = 'ID'
      Required = True
    end
    object cds_patrimonioNUM_PATRIMONIO: TIntegerField
      FieldName = 'NUM_PATRIMONIO'
    end
    object cds_patrimonioDATA: TDateField
      FieldName = 'DATA'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_patrimonioDESCRICAO: TStringField
      FieldName = 'DESCRICAO'
      Size = 200
    end
    object cds_patrimonioSETOR: TStringField
      FieldName = 'SETOR'
      Size = 100
    end
    object cds_patrimonioESTADO: TStringField
      FieldName = 'ESTADO'
      Size = 50
    end
    object cds_patrimonioQTD: TIntegerField
      FieldName = 'QTD'
    end
  end
  object sql_funcionario: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select * from FUNCIONARIO'
    MaxBlobSize = 1
    Params = <>
    SQLConnection = conexao
    Left = 56
    Top = 184
  end
  object prov_funcionario: TDataSetProvider
    DataSet = sql_funcionario
    Left = 56
    Top = 240
  end
  object cds_funcionario: TClientDataSet
    Active = True
    Aggregates = <>
    IndexFieldNames = 'NOME'
    Params = <>
    ProviderName = 'prov_funcionario'
    Left = 56
    Top = 299
    object cds_funcionarioID: TIntegerField
      FieldName = 'ID'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object cds_funcionarioNOME: TStringField
      FieldName = 'NOME'
      Size = 100
    end
    object cds_funcionarioENDERECO: TStringField
      FieldName = 'ENDERECO'
      Size = 100
    end
    object cds_funcionarioNUMERO: TStringField
      FieldName = 'NUMERO'
      Size = 10
    end
    object cds_funcionarioBAIRRO: TStringField
      FieldName = 'BAIRRO'
      Size = 30
    end
    object cds_funcionarioCIDADE: TStringField
      FieldName = 'CIDADE'
      Size = 30
    end
    object cds_funcionarioCONTATO: TStringField
      FieldName = 'CONTATO'
      EditMask = '!\(99\)00000-0000;1;_'
    end
    object cds_funcionarioFUNCAO: TStringField
      FieldName = 'FUNCAO'
      Size = 50
    end
    object cds_funcionarioDN: TDateField
      FieldName = 'DN'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_funcionarioFOTO: TBlobField
      FieldName = 'FOTO'
      Size = 1
    end
    object cds_funcionarioDATA_ADMISSAO: TDateField
      FieldName = 'DATA_ADMISSAO'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_funcionarioSEXO: TStringField
      FieldName = 'SEXO'
    end
    object cds_funcionarioNATURALIDADE: TStringField
      FieldName = 'NATURALIDADE'
      Size = 30
    end
    object cds_funcionarioCPF: TStringField
      FieldName = 'CPF'
      EditMask = '000\.000\.000\-00;1;_'
    end
    object cds_funcionarioRG: TStringField
      FieldName = 'RG'
    end
    object cds_funcionarioRG_D_EMISSAO: TDateField
      FieldName = 'RG_D_EMISSAO'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_funcionarioRG_ORGAO: TStringField
      FieldName = 'RG_ORGAO'
      Size = 10
    end
    object cds_funcionarioCNH: TStringField
      FieldName = 'CNH'
      Size = 30
    end
    object cds_funcionarioCNH_CAT: TStringField
      FieldName = 'CNH_CAT'
      FixedChar = True
      Size = 10
    end
    object cds_funcionarioTITULO_ELEITOR: TStringField
      FieldName = 'TITULO_ELEITOR'
      Size = 30
    end
    object cds_funcionarioTITULO_ZONA: TStringField
      FieldName = 'TITULO_ZONA'
      FixedChar = True
      Size = 10
    end
    object cds_funcionarioTITULO_SECAO: TStringField
      FieldName = 'TITULO_SECAO'
      FixedChar = True
      Size = 10
    end
    object cds_funcionarioPASSAPORTE: TStringField
      FieldName = 'PASSAPORTE'
      Size = 30
    end
    object cds_funcionarioMAE: TStringField
      FieldName = 'MAE'
      Size = 100
    end
    object cds_funcionarioPAI: TStringField
      FieldName = 'PAI'
      Size = 100
    end
    object cds_funcionarioUSUARIO: TStringField
      FieldName = 'USUARIO'
      Size = 50
    end
    object cds_funcionarioMATRICULA: TStringField
      FieldName = 'MATRICULA'
      Size = 50
    end
    object cds_funcionarioVINCULO: TStringField
      FieldName = 'VINCULO'
      Size = 100
    end
    object cds_funcionarioDPTO: TStringField
      FieldName = 'DPTO'
      Size = 100
    end
    object cds_funcionarioLOCAL: TStringField
      FieldName = 'LOCAL'
      Size = 100
    end
  end
  object sql_controle_transp: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select * from  C_TRANSPORTE'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = conexao
    Left = 136
    Top = 192
  end
  object prov_controle_transp: TDataSetProvider
    DataSet = sql_controle_transp
    Left = 136
    Top = 248
  end
  object cds_controle_transp: TClientDataSet
    Aggregates = <>
    IndexFieldNames = 'NOME_ALUNO'
    Params = <>
    ProviderName = 'prov_controle_transp'
    Left = 136
    Top = 307
    object cds_controle_transpID: TIntegerField
      FieldName = 'ID'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object cds_controle_transpESCOLA: TStringField
      FieldName = 'ESCOLA'
      Size = 100
    end
    object cds_controle_transpTURNO: TStringField
      FieldName = 'TURNO'
      Size = 50
    end
    object cds_controle_transpSERIE: TStringField
      FieldName = 'SERIE'
      Size = 50
    end
    object cds_controle_transpLOCAL_EMBARQUE: TStringField
      FieldName = 'LOCAL_EMBARQUE'
      Size = 200
    end
    object cds_controle_transpNOME_MONITOR: TStringField
      FieldName = 'NOME_MONITOR'
      Size = 100
    end
    object cds_controle_transpCONTATO_MONITOR: TStringField
      FieldName = 'CONTATO_MONITOR'
      EditMask = '!\(99\)00000-0000;1;_'
    end
    object cds_controle_transpUSUARIO: TStringField
      FieldName = 'USUARIO'
    end
    object cds_controle_transpSITUACAO: TStringField
      FieldName = 'SITUACAO'
      Size = 25
    end
    object cds_controle_transpRESPONSAVEL_1: TStringField
      FieldName = 'RESPONSAVEL_1'
      Size = 100
    end
    object cds_controle_transpCONTATO_RESPONSAVEL_1: TStringField
      FieldName = 'CONTATO_RESPONSAVEL_1'
      EditMask = '!\(99\)00000-0000;1;_'
    end
    object cds_controle_transpNOME_ALUNO: TStringField
      FieldName = 'NOME_ALUNO'
      Size = 100
    end
    object cds_controle_transpDN: TDateField
      FieldName = 'DN'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_controle_transpDATA_HOJE: TDateField
      FieldName = 'DATA_HOJE'
      EditMask = '!99/99/0000;1;_'
    end
  end
  object sql_turno: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select *  from TURNO'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = conexao
    Left = 216
    Top = 200
    object sql_turnoTUNO_ID: TIntegerField
      FieldName = 'TUNO_ID'
      Required = True
    end
    object sql_turnoTURNO: TStringField
      FieldName = 'TURNO'
      Size = 100
    end
  end
  object prov_turno: TDataSetProvider
    DataSet = sql_turno
    Left = 216
    Top = 256
  end
  object cds_turno: TClientDataSet
    Active = True
    Aggregates = <>
    Params = <>
    ProviderName = 'prov_turno'
    Left = 216
    Top = 315
    object cds_turnoTUNO_ID: TIntegerField
      FieldName = 'TUNO_ID'
      Required = True
    end
    object cds_turnoTURNO: TStringField
      FieldName = 'TURNO'
      Size = 100
    end
  end
  object sql_serie: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select *  from SERIE'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = conexao
    Left = 288
    Top = 200
    object sql_serieSERIE_ID: TIntegerField
      FieldName = 'SERIE_ID'
      Required = True
    end
    object sql_serieSERIE: TStringField
      FieldName = 'SERIE'
      Size = 100
    end
  end
  object prov_serie: TDataSetProvider
    DataSet = sql_serie
    Left = 288
    Top = 256
  end
  object cds_serie: TClientDataSet
    Active = True
    Aggregates = <>
    Params = <>
    ProviderName = 'prov_serie'
    Left = 288
    Top = 315
    object cds_serieSERIE_ID: TIntegerField
      FieldName = 'SERIE_ID'
      Required = True
    end
    object cds_serieSERIE: TStringField
      FieldName = 'SERIE'
      Size = 100
    end
  end
  object cds_cad_cronograma_escolar: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'prov_cad_cronograma_escolar'
    Left = 416
    Top = 136
    object cds_cad_cronograma_escolarID: TIntegerField
      FieldName = 'ID'
      Required = True
    end
    object cds_cad_cronograma_escolarDATA_I_E_I: TDateField
      FieldName = 'DATA_I_E_I'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_cad_cronograma_escolarDATA_F_E_I: TDateField
      FieldName = 'DATA_F_E_I'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_cad_cronograma_escolarDATA_I_E_F: TDateField
      FieldName = 'DATA_I_E_F'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_cad_cronograma_escolarDATA_F_E_F: TDateField
      FieldName = 'DATA_F_E_F'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_cad_cronograma_escolarDATA_I_CAD_GERAL: TDateField
      FieldName = 'DATA_I_CAD_GERAL'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_cad_cronograma_escolarDATA_F_CAD_GERAL: TDateField
      FieldName = 'DATA_F_CAD_GERAL'
      EditMask = '!99/99/0000;1;_'
    end
  end
  object prov_cad_cronograma_escolar: TDataSetProvider
    DataSet = sql_cad_cronograma_escolar
    Left = 416
    Top = 72
  end
  object sql_cad_cronograma_escolar: TSQLDataSet
    CommandText = 'select * from CAD_ESCOLAR_CRON'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = conexao
    Left = 416
    Top = 16
  end
  object cds_cad_escolar_anual: TClientDataSet
    Active = True
    Aggregates = <>
    Params = <>
    ProviderName = 'prov_cad_escolar_anual'
    Left = 544
    Top = 131
    object cds_cad_escolar_anualCODIGO: TIntegerField
      FieldName = 'CODIGO'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object cds_cad_escolar_anualDATA_ATENDIMENTO: TDateField
      FieldName = 'DATA_ATENDIMENTO'
    end
    object cds_cad_escolar_anualNOME_ALUNO: TStringField
      FieldName = 'NOME_ALUNO'
      Size = 100
    end
    object cds_cad_escolar_anualDATA_NASC: TDateField
      FieldName = 'DATA_NASC'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_cad_escolar_anualCPF: TStringField
      FieldName = 'CPF'
      EditMask = '000\.000\.000\-00;1;_'
      Size = 15
    end
    object cds_cad_escolar_anualNIS_ALUNO: TStringField
      FieldName = 'NIS_ALUNO'
    end
    object cds_cad_escolar_anualENDERECO: TStringField
      FieldName = 'ENDERECO'
      Size = 100
    end
    object cds_cad_escolar_anualBAIRRO: TStringField
      FieldName = 'BAIRRO'
      Size = 100
    end
    object cds_cad_escolar_anualRESPONSAVEL_1: TStringField
      FieldName = 'RESPONSAVEL_1'
      Size = 100
    end
    object cds_cad_escolar_anualCONTATO_1: TStringField
      FieldName = 'CONTATO_1'
      EditMask = '!\(99\)00000-0000;1;_'
    end
    object cds_cad_escolar_anualRESPONSAVEL_2: TStringField
      FieldName = 'RESPONSAVEL_2'
      Size = 100
    end
    object cds_cad_escolar_anualCONTATO_2: TStringField
      FieldName = 'CONTATO_2'
      EditMask = '!\(99\)00000-0000;1;_'
    end
    object cds_cad_escolar_anualOBS: TStringField
      FieldName = 'OBS'
      Size = 255
    end
    object cds_cad_escolar_anualSITUACAO: TStringField
      FieldName = 'SITUACAO'
      Size = 50
    end
    object cds_cad_escolar_anualRECEBE_S_N: TStringField
      FieldName = 'RECEBE_S_N'
    end
    object cds_cad_escolar_anualANO_BASE: TStringField
      FieldName = 'ANO_BASE'
      Size = 10
    end
    object cds_cad_escolar_anualUSUARIO: TStringField
      FieldName = 'USUARIO'
      Size = 50
    end
    object cds_cad_escolar_anualNOME_ESCOLA: TStringField
      FieldName = 'NOME_ESCOLA'
      Size = 50
    end
    object cds_cad_escolar_anualNOME_SERIE: TStringField
      FieldName = 'NOME_SERIE'
      Size = 50
    end
    object cds_cad_escolar_anualNOME_TURNO: TStringField
      FieldName = 'NOME_TURNO'
      Size = 50
    end
    object cds_cad_escolar_anualDECL_TRABALHO: TStringField
      FieldName = 'DECL_TRABALHO'
      Size = 10
    end
    object cds_cad_escolar_anualDECL_ENDERECO: TStringField
      FieldName = 'DECL_ENDERECO'
      Size = 10
    end
    object cds_cad_escolar_anualNUM_SUS: TStringField
      FieldName = 'NUM_SUS'
    end
    object cds_cad_escolar_anualDEFICIENCIA: TStringField
      FieldName = 'DEFICIENCIA'
      Size = 100
    end
    object cds_cad_escolar_anualCONTROLE_INTERNO: TStringField
      FieldName = 'CONTROLE_INTERNO'
      Size = 10
    end
    object cds_cad_escolar_anualCRITERIO: TStringField
      FieldName = 'CRITERIO'
      Size = 50
    end
  end
  object prov_cad_escolar_anual: TDataSetProvider
    DataSet = sql_cad_escolar_anual
    Left = 544
    Top = 72
  end
  object sql_cad_escolar_anual: TSQLDataSet
    CommandText = 'select * from CAD_ESCOLAR_ANUAL'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = conexao
    Left = 544
    Top = 16
  end
  object dscadalunosanual: TDataSource
    AutoEdit = False
    DataSet = cds_cad_escolar_anual
    Left = 544
    Top = 176
  end
  object sql_aluno_geral: TSQLDataSet
    CommandText = 'select *  from ALUNOS_GERAL'
    MaxBlobSize = 1
    Params = <>
    SQLConnection = conexao
    Left = 448
    Top = 200
  end
  object prov_aluno_geral: TDataSetProvider
    DataSet = sql_aluno_geral
    Left = 456
    Top = 264
  end
  object cds_aluno_geral: TClientDataSet
    Aggregates = <>
    FileName = 'NOME'
    IndexFieldNames = 'NOME'
    Params = <>
    ProviderName = 'prov_aluno_geral'
    Left = 456
    Top = 320
    object cds_aluno_geralID: TIntegerField
      FieldName = 'ID'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object cds_aluno_geralCODIGO: TStringField
      FieldName = 'CODIGO'
    end
    object cds_aluno_geralNOME: TStringField
      FieldName = 'NOME'
      Size = 100
    end
    object cds_aluno_geralSITUACAO: TStringField
      FieldName = 'SITUACAO'
      Size = 50
    end
    object cds_aluno_geralSEXO: TStringField
      FieldName = 'SEXO'
      Size = 1
    end
    object cds_aluno_geralTELEFONE_ALUNO: TStringField
      FieldName = 'TELEFONE_ALUNO'
      EditMask = '!\(99\)00000-0000;1;_'
    end
    object cds_aluno_geralDN: TDateField
      FieldName = 'DN'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_aluno_geralENDERECO: TStringField
      FieldName = 'ENDERECO'
      Size = 60
    end
    object cds_aluno_geralCOMPLEMENTO: TStringField
      FieldName = 'COMPLEMENTO'
    end
    object cds_aluno_geralNUMEND: TStringField
      FieldName = 'NUMEND'
    end
    object cds_aluno_geralBAIRRO: TStringField
      FieldName = 'BAIRRO'
      Size = 60
    end
    object cds_aluno_geralCEP: TStringField
      FieldName = 'CEP'
      EditMask = '00000\-999;1;_'
      Size = 15
    end
    object cds_aluno_geralUF: TStringField
      FieldName = 'UF'
      Size = 2
    end
    object cds_aluno_geralCIDADE: TStringField
      FieldName = 'CIDADE'
      Size = 60
    end
    object cds_aluno_geralDISTRITO: TStringField
      FieldName = 'DISTRITO'
      Size = 60
    end
    object cds_aluno_geralZONA_RESIDENCIAL: TStringField
      FieldName = 'ZONA_RESIDENCIAL'
      Size = 60
    end
    object cds_aluno_geralNATURALIDADE_CIDADE: TStringField
      FieldName = 'NATURALIDADE_CIDADE'
      Size = 60
    end
    object cds_aluno_geralNATURALIDADE_UF: TStringField
      FieldName = 'NATURALIDADE_UF'
      Size = 2
    end
    object cds_aluno_geralESTADO_CIVIL: TStringField
      FieldName = 'ESTADO_CIVIL'
      Size = 30
    end
    object cds_aluno_geralRACA: TStringField
      FieldName = 'RACA'
      Size = 30
    end
    object cds_aluno_geralRG_ALUNO: TStringField
      FieldName = 'RG_ALUNO'
    end
    object cds_aluno_geralRG_DATA_EXP: TDateField
      FieldName = 'RG_DATA_EXP'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_aluno_geralRG_ORGAO_EXP: TStringField
      FieldName = 'RG_ORGAO_EXP'
      Size = 30
    end
    object cds_aluno_geralCPF: TStringField
      FieldName = 'CPF'
      EditMask = '000\.000\.000\-00;1;_'
    end
    object cds_aluno_geralNIS: TStringField
      FieldName = 'NIS'
    end
    object cds_aluno_geralCARTORIO: TStringField
      FieldName = 'CARTORIO'
      Size = 60
    end
    object cds_aluno_geralCERTIDAO_MATRIC_NOVA: TStringField
      FieldName = 'CERTIDAO_MATRIC_NOVA'
      Size = 60
    end
    object cds_aluno_geralCERTIDAO_LIVRO: TStringField
      FieldName = 'CERTIDAO_LIVRO'
    end
    object cds_aluno_geralCERTIDAO_TERMO: TStringField
      FieldName = 'CERTIDAO_TERMO'
    end
    object cds_aluno_geralCERTIDAO_DATA: TDateField
      FieldName = 'CERTIDAO_DATA'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_aluno_geralCERTIDAO_FOLHA: TStringField
      FieldName = 'CERTIDAO_FOLHA'
    end
    object cds_aluno_geralCERTIDAO_CIDADE: TStringField
      FieldName = 'CERTIDAO_CIDADE'
      Size = 30
    end
    object cds_aluno_geralCERTIDAO_UF: TStringField
      FieldName = 'CERTIDAO_UF'
      Size = 2
    end
    object cds_aluno_geralMAE: TStringField
      FieldName = 'MAE'
      Size = 60
    end
    object cds_aluno_geralMAE_RG: TStringField
      FieldName = 'MAE_RG'
    end
    object cds_aluno_geralMAE_ORG_EPEDI_RG: TStringField
      FieldName = 'MAE_ORG_EPEDI_RG'
    end
    object cds_aluno_geralMAE_RG_DATA: TDateField
      FieldName = 'MAE_RG_DATA'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_aluno_geralMAE_RG_UF: TStringField
      FieldName = 'MAE_RG_UF'
      Size = 2
    end
    object cds_aluno_geralMAE_NIS: TStringField
      FieldName = 'MAE_NIS'
    end
    object cds_aluno_geralMAE_CPF: TStringField
      FieldName = 'MAE_CPF'
      EditMask = '000\.000\.000\-00;1;_'
    end
    object cds_aluno_geralMAE_FALECIDA: TStringField
      FieldName = 'MAE_FALECIDA'
      Size = 10
    end
    object cds_aluno_geralMAE_PROFISSAO: TStringField
      FieldName = 'MAE_PROFISSAO'
      Size = 30
    end
    object cds_aluno_geralPAI: TStringField
      FieldName = 'PAI'
      Size = 60
    end
    object cds_aluno_geralPAI_ORG_EPEDI_RG: TStringField
      FieldName = 'PAI_ORG_EPEDI_RG'
    end
    object cds_aluno_geralPAI_RG: TStringField
      FieldName = 'PAI_RG'
    end
    object cds_aluno_geralPAI_RG_DATA: TDateField
      FieldName = 'PAI_RG_DATA'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_aluno_geralPAI_RG_UF: TStringField
      FieldName = 'PAI_RG_UF'
      Size = 2
    end
    object cds_aluno_geralPAI_CPF: TStringField
      FieldName = 'PAI_CPF'
      EditMask = '000\.000\.000\-00;1;_'
    end
    object cds_aluno_geralPAI_NIS: TStringField
      FieldName = 'PAI_NIS'
    end
    object cds_aluno_geralPAI_FALECIDO: TStringField
      FieldName = 'PAI_FALECIDO'
      Size = 10
    end
    object cds_aluno_geralPAI_PROFISSAO: TStringField
      FieldName = 'PAI_PROFISSAO'
      Size = 30
    end
    object cds_aluno_geralNACIONALIDADE: TStringField
      FieldName = 'NACIONALIDADE'
    end
    object cds_aluno_geralOCUPACAO: TStringField
      FieldName = 'OCUPACAO'
    end
    object cds_aluno_geralLOCAL_TRABALHO: TStringField
      FieldName = 'LOCAL_TRABALHO'
    end
    object cds_aluno_geralCONTATO_TRABALHO: TStringField
      FieldName = 'CONTATO_TRABALHO'
      EditMask = '!\(99\)00000-0000;1;_'
    end
    object cds_aluno_geralRESPONSAVEL_LEGAL: TStringField
      FieldName = 'RESPONSAVEL_LEGAL'
      Size = 60
    end
    object cds_aluno_geralGRAU_PARENTESCO: TStringField
      FieldName = 'GRAU_PARENTESCO'
      Size = 10
    end
    object cds_aluno_geralPROBLEMA_SAUDE: TStringField
      FieldName = 'PROBLEMA_SAUDE'
      Size = 1
    end
    object cds_aluno_geralPROBLEMA_QUAIS: TStringField
      FieldName = 'PROBLEMA_QUAIS'
      Size = 50
    end
    object cds_aluno_geralDIFICULDADE_FALA: TStringField
      FieldName = 'DIFICULDADE_FALA'
      Size = 1
    end
    object cds_aluno_geralPISICOLOGICO: TStringField
      FieldName = 'PISICOLOGICO'
      Size = 1
    end
    object cds_aluno_geralFONOUADIOLOGO: TStringField
      FieldName = 'FONOUADIOLOGO'
      Size = 1
    end
    object cds_aluno_geralDEFICIENCIA_MENTAL: TStringField
      FieldName = 'DEFICIENCIA_MENTAL'
      Size = 1
    end
    object cds_aluno_geralDEFICIENCIA_AUDITIVA: TStringField
      FieldName = 'DEFICIENCIA_AUDITIVA'
      Size = 1
    end
    object cds_aluno_geralDEFICIENCIA_MULTIPLA: TStringField
      FieldName = 'DEFICIENCIA_MULTIPLA'
      Size = 1
    end
    object cds_aluno_geralSUPERDOTADO: TStringField
      FieldName = 'SUPERDOTADO'
      Size = 1
    end
    object cds_aluno_geralDEFICIENCIA_NERO_MENTAL: TStringField
      FieldName = 'DEFICIENCIA_NERO_MENTAL'
      Size = 1
    end
    object cds_aluno_geralDEPENDENCIAS: TStringField
      FieldName = 'DEPENDENCIAS'
      Size = 1
    end
    object cds_aluno_geralCONTEUDO: TStringField
      FieldName = 'CONTEUDO'
      Size = 30
    end
    object cds_aluno_geralRECLASSIFICADO: TStringField
      FieldName = 'RECLASSIFICADO'
      Size = 10
    end
    object cds_aluno_geralCONDICAO_FINAL: TStringField
      FieldName = 'CONDICAO_FINAL'
      Size = 30
    end
    object cds_aluno_geralOBS: TStringField
      FieldName = 'OBS'
      Size = 200
    end
    object cds_aluno_geralBOLSAFAMILIA: TStringField
      FieldName = 'BOLSAFAMILIA'
      Size = 1
    end
    object cds_aluno_geralCARTAO_SUS: TStringField
      FieldName = 'CARTAO_SUS'
      Size = 30
    end
    object cds_aluno_geralFOTO: TBlobField
      FieldName = 'FOTO'
      Size = 1
    end
    object cds_aluno_geralUSUARIO: TStringField
      FieldName = 'USUARIO'
      Size = 50
    end
    object cds_aluno_geralDATA_CAD: TDateField
      FieldName = 'DATA_CAD'
      EditMask = '!99/99/0000;1;_'
    end
  end
  object sql_turmas: TSQLDataSet
    CommandText = 'select * from TURMAS'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = conexao
    Left = 368
    Top = 200
  end
  object prov_turmas: TDataSetProvider
    DataSet = sql_turmas
    Left = 368
    Top = 256
  end
  object cds_turmas: TClientDataSet
    Active = True
    Aggregates = <>
    Params = <>
    ProviderName = 'prov_turmas'
    Left = 376
    Top = 320
    object cds_turmasID: TIntegerField
      FieldName = 'ID'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object cds_turmasTURMA: TStringField
      FieldName = 'TURMA'
      Size = 40
    end
  end
  object sqlcabeca: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select * from  ENTURMACAO'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = conexao
    Left = 48
    Top = 376
  end
  object sqlcorpo: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select * from  ENTURMACAO_DETALHES'#13#10'where id =:id'
    DataSource = dsdetalhe
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'ID'
        ParamType = ptInput
      end>
    SQLConnection = conexao
    Left = 96
    Top = 376
  end
  object dsdetalhe: TDataSource
    DataSet = sqlcabeca
    Left = 104
    Top = 432
  end
  object dscabeca: TDataSource
    DataSet = cdscabeca
    Left = 48
    Top = 552
  end
  object dspcabeca: TDataSetProvider
    DataSet = sqlcabeca
    Options = [poAllowCommandText, poUseQuoteChar]
    Left = 48
    Top = 432
  end
  object cdscabeca: TClientDataSet
    Active = True
    Aggregates = <>
    Params = <>
    ProviderName = 'dspcabeca'
    Left = 48
    Top = 488
    object cdscabecaID: TIntegerField
      FieldName = 'ID'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object cdscabecaID_TURMAS: TIntegerField
      FieldName = 'ID_TURMAS'
    end
    object cdscabecasqlcorpo: TDataSetField
      FieldName = 'sqlcorpo'
    end
    object cdscabecaNOME_TURMA: TStringField
      FieldKind = fkLookup
      FieldName = 'NOME_TURMA'
      LookupDataSet = cds_turmas
      LookupKeyFields = 'ID'
      LookupResultField = 'TURMA'
      KeyFields = 'ID_TURMAS'
      Size = 100
      Lookup = True
    end
    object cdscabecaID_ESCOLA: TIntegerField
      FieldName = 'ID_ESCOLA'
    end
    object cdscabecaNOME_ESCOLA: TStringField
      FieldKind = fkLookup
      FieldName = 'NOME_ESCOLA'
      LookupDataSet = cds_escola
      LookupKeyFields = 'ID_ESCOLA'
      LookupResultField = 'ESCOLA'
      KeyFields = 'ID_ESCOLA'
      Size = 100
      Lookup = True
    end
    object cdscabecaID_TURNO: TIntegerField
      FieldName = 'ID_TURNO'
    end
    object cdscabecaNOME_TURNO: TStringField
      FieldKind = fkLookup
      FieldName = 'NOME_TURNO'
      LookupDataSet = cds_turno
      LookupKeyFields = 'TUNO_ID'
      LookupResultField = 'TURNO'
      KeyFields = 'ID_TURNO'
      Size = 100
      Lookup = True
    end
    object cdscabecaID_SERIE: TIntegerField
      FieldName = 'ID_SERIE'
    end
    object cdscabecaNOME_SERIE: TStringField
      FieldKind = fkLookup
      FieldName = 'NOME_SERIE'
      LookupDataSet = cds_serie
      LookupKeyFields = 'SERIE_ID'
      LookupResultField = 'SERIE'
      KeyFields = 'ID_SERIE'
      Size = 100
      Lookup = True
    end
  end
  object cdscorpo: TClientDataSet
    Active = True
    Aggregates = <>
    AggregatesActive = True
    DataSetField = cdscabecasqlcorpo
    Params = <>
    Left = 104
    Top = 488
    object cdscorpoID: TIntegerField
      FieldName = 'ID'
      Required = True
    end
    object cdscorpoID_ALUNO: TIntegerField
      FieldName = 'ID_ALUNO'
    end
    object cdscorpoDATA_NASC: TStringField
      FieldKind = fkLookup
      FieldName = 'DATA_NASC'
      LookupDataSet = cds_cad_escolar_anual
      LookupKeyFields = 'CODIGO'
      LookupResultField = 'DATA_NASC'
      KeyFields = 'ID_ALUNO'
      Lookup = True
    end
    object cdscorpoNOME_ALUNO: TStringField
      FieldKind = fkLookup
      FieldName = 'NOME_ALUNO'
      LookupDataSet = cds_cad_escolar_anual
      LookupKeyFields = 'CODIGO'
      LookupResultField = 'NOME_ALUNO'
      KeyFields = 'ID_ALUNO'
      Size = 100
      Lookup = True
    end
    object cdscorpoqtd: TAggregateField
      FieldName = 'qtd'
      Active = True
      DisplayName = ''
      Expression = 'count(id)'
    end
  end
  object dscorpo: TDataSource
    DataSet = cdscorpo
    Left = 104
    Top = 552
  end
  object sql_escola: TSQLDataSet
    CommandText = 'select * from ESCOLA'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = conexao
    Left = 632
    Top = 216
  end
  object prov_escola: TDataSetProvider
    DataSet = sql_escola
    Left = 632
    Top = 264
  end
  object cds_escola: TClientDataSet
    Active = True
    Aggregates = <>
    IndexFieldNames = 'ESCOLA'
    Params = <>
    ProviderName = 'prov_escola'
    Left = 632
    Top = 312
    object cds_escolaID_ESCOLA: TIntegerField
      FieldName = 'ID_ESCOLA'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object cds_escolaESCOLA: TStringField
      FieldName = 'ESCOLA'
      Size = 100
    end
    object cds_escolaENDERECO: TStringField
      FieldName = 'ENDERECO'
      Size = 100
    end
    object cds_escolaEMAIL: TStringField
      FieldName = 'EMAIL'
      Size = 100
    end
    object cds_escolaCONTATO: TStringField
      FieldName = 'CONTATO'
      EditMask = '!\(99\)00000-0000;1;_'
    end
    object cds_escolaRESPONSAVEL: TStringField
      FieldName = 'RESPONSAVEL'
      Size = 100
    end
  end
  object sql_logs: TSQLDataSet
    CommandText = 'select * from LOGS'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = conexao
    Left = 696
    Top = 208
  end
  object prov_logs: TDataSetProvider
    DataSet = sql_logs
    Left = 696
    Top = 256
  end
  object cds_logs: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'prov_logs'
    Left = 696
    Top = 304
    object cds_logsID: TIntegerField
      FieldName = 'ID'
      Required = True
    end
    object cds_logsDATA: TDateField
      FieldName = 'DATA'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_logsHORA: TTimeField
      FieldName = 'HORA'
      EditMask = '!90:00:00>;1;_'
    end
    object cds_logsIP: TStringField
      FieldName = 'IP'
    end
    object cds_logsUSUARIO: TStringField
      FieldName = 'USUARIO'
      Size = 40
    end
  end
  object sql_rh_freq: TSQLDataSet
    CommandText = 'select * from RH_FREQ'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = conexao
    Left = 552
    Top = 232
  end
  object prov_rh_freq: TDataSetProvider
    DataSet = sql_rh_freq
    Left = 552
    Top = 280
  end
  object cds_rh_freq: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'prov_rh_freq'
    Left = 552
    Top = 328
    object cds_rh_freqID: TIntegerField
      FieldName = 'ID'
      Required = True
    end
    object cds_rh_freqMES: TStringField
      FieldName = 'MES'
      Size = 50
    end
    object cds_rh_freqLOCA_TRABALHO: TStringField
      FieldName = 'LOCA_TRABALHO'
      Size = 100
    end
    object cds_rh_freqMATRICULA: TStringField
      FieldName = 'MATRICULA'
      Size = 15
    end
    object cds_rh_freqFUNCIONARIO: TStringField
      FieldName = 'FUNCIONARIO'
      Size = 100
    end
    object cds_rh_freqCARGO: TStringField
      FieldName = 'CARGO'
      Size = 100
    end
    object cds_rh_freqDATA_ADM: TDateField
      FieldName = 'DATA_ADM'
      EditMask = '!99/99/0000;1;_'
    end
    object cds_rh_freqSITUACAO: TStringField
      FieldName = 'SITUACAO'
      Size = 10
    end
    object cds_rh_freqFALTAS: TIntegerField
      FieldName = 'FALTAS'
    end
    object cds_rh_freqATESTADO: TIntegerField
      FieldName = 'ATESTADO'
    end
    object cds_rh_freqLIC_GESTACAO: TIntegerField
      FieldName = 'LIC_GESTACAO'
    end
    object cds_rh_freqDIAS_FERIAS: TIntegerField
      FieldName = 'DIAS_FERIAS'
    end
    object cds_rh_freqDIAS_TRABALHADO: TIntegerField
      FieldName = 'DIAS_TRABALHADO'
    end
    object cds_rh_freqHORAS_AULA: TIntegerField
      FieldName = 'HORAS_AULA'
    end
    object cds_rh_freqADICIONAL_ZONA_RURAL: TStringField
      FieldName = 'ADICIONAL_ZONA_RURAL'
      FixedChar = True
      Size = 1
    end
    object cds_rh_freqADICIONAL_NOTURNO: TStringField
      FieldName = 'ADICIONAL_NOTURNO'
      FixedChar = True
      Size = 1
    end
    object cds_rh_freqOBSERVACAO: TStringField
      FieldName = 'OBSERVACAO'
      Size = 250
    end
  end
  object sql_rh_freq_cabeca: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select *  from RH_FREQ_CABECA'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = conexao
    Left = 288
    Top = 384
  end
  object sql_rh_freq_corpo: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select *  from RH_FREQ_CORPO'#13#10'where id =:id'
    DataSource = ds_rh_freq_detalhes
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'ID'
        ParamType = ptInput
      end>
    SQLConnection = conexao
    Left = 392
    Top = 384
  end
  object ds_rh_freq_detalhes: TDataSource
    DataSet = sql_rh_freq_cabeca
    Left = 400
    Top = 440
  end
  object ds_rh_freq_cabeca: TDataSource
    DataSet = cds_rh_freq_cabeca
    Left = 288
    Top = 560
  end
  object dsp_rh_freq_cabeca: TDataSetProvider
    DataSet = sql_rh_freq_cabeca
    Options = [poAllowCommandText, poUseQuoteChar]
    Left = 288
    Top = 440
  end
  object cds_rh_freq_cabeca: TClientDataSet
    Active = True
    Aggregates = <>
    Params = <>
    ProviderName = 'dsp_rh_freq_cabeca'
    Left = 288
    Top = 496
    object cds_rh_freq_cabecaID: TIntegerField
      FieldName = 'ID'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object cds_rh_freq_cabecaMES: TStringField
      FieldName = 'MES'
      Size = 15
    end
    object cds_rh_freq_cabecasql_rh_freq_corpo: TDataSetField
      FieldName = 'sql_rh_freq_corpo'
    end
  end
  object cds_rh_freq_corpo: TClientDataSet
    Active = True
    Aggregates = <>
    AggregatesActive = True
    DataSetField = cds_rh_freq_cabecasql_rh_freq_corpo
    FieldDefs = <
      item
        Name = 'ID'
        Attributes = [faRequired]
        DataType = ftInteger
      end
      item
        Name = 'ID_ESCOLA'
        DataType = ftInteger
      end
      item
        Name = 'ID_FUNCIONARIO'
        DataType = ftInteger
      end
      item
        Name = 'SITUACAO'
        DataType = ftString
        Size = 100
      end
      item
        Name = 'FALTAS'
        DataType = ftInteger
      end
      item
        Name = 'ATESTADO'
        DataType = ftInteger
      end
      item
        Name = 'LIC_GESTACAO'
        DataType = ftInteger
      end
      item
        Name = 'DIAS_FERIAS'
        DataType = ftInteger
      end
      item
        Name = 'DIAS_TRABALHADO'
        DataType = ftInteger
      end
      item
        Name = 'HORAS_AULA'
        DataType = ftInteger
      end
      item
        Name = 'ADICIONAL_ZONA_RURAL'
        Attributes = [faFixed]
        DataType = ftString
        Size = 1
      end
      item
        Name = 'ADICIONAL_NOTURNO'
        Attributes = [faFixed]
        DataType = ftString
        Size = 1
      end
      item
        Name = 'OBSERVACAO'
        DataType = ftString
        Size = 200
      end>
    IndexDefs = <>
    Params = <>
    StoreDefs = True
    Left = 400
    Top = 496
    object cds_rh_freq_corpoID: TIntegerField
      FieldName = 'ID'
      Required = True
    end
    object cds_rh_freq_corpoID_ESCOLA: TIntegerField
      FieldName = 'ID_ESCOLA'
    end
    object cds_rh_freq_corpoID_FUNCIONARIO: TIntegerField
      FieldName = 'ID_FUNCIONARIO'
    end
    object cds_rh_freq_corpoSITUACAO: TStringField
      FieldName = 'SITUACAO'
      Size = 100
    end
    object cds_rh_freq_corpoFALTAS: TIntegerField
      FieldName = 'FALTAS'
    end
    object cds_rh_freq_corpoATESTADO: TIntegerField
      FieldName = 'ATESTADO'
    end
    object cds_rh_freq_corpoLIC_GESTACAO: TIntegerField
      FieldName = 'LIC_GESTACAO'
    end
    object cds_rh_freq_corpoDIAS_FERIAS: TIntegerField
      FieldName = 'DIAS_FERIAS'
    end
    object cds_rh_freq_corpoDIAS_TRABALHADO: TIntegerField
      FieldName = 'DIAS_TRABALHADO'
    end
    object cds_rh_freq_corpoHORAS_AULA: TIntegerField
      FieldName = 'HORAS_AULA'
    end
    object cds_rh_freq_corpoADICIONAL_ZONA_RURAL: TStringField
      FieldName = 'ADICIONAL_ZONA_RURAL'
      FixedChar = True
      Size = 1
    end
    object cds_rh_freq_corpoADICIONAL_NOTURNO: TStringField
      FieldName = 'ADICIONAL_NOTURNO'
      FixedChar = True
      Size = 1
    end
    object cds_rh_freq_corpoOBSERVACAO: TStringField
      FieldName = 'OBSERVACAO'
      Size = 200
    end
    object cds_rh_freq_corpoNOME_FUNCIONARIO: TStringField
      FieldKind = fkLookup
      FieldName = 'NOME_FUNCIONARIO'
      LookupDataSet = cds_funcionario
      LookupKeyFields = 'ID'
      LookupResultField = 'NOME'
      KeyFields = 'ID_FUNCIONARIO'
      Size = 100
      Lookup = True
    end
    object cds_rh_freq_corpoNOME_ESCOLA: TStringField
      FieldKind = fkLookup
      FieldName = 'NOME_ESCOLA'
      LookupDataSet = cds_escola
      LookupKeyFields = 'ID_ESCOLA'
      LookupResultField = 'ESCOLA'
      KeyFields = 'ID_ESCOLA'
      Size = 100
      Lookup = True
    end
    object cds_rh_freq_corpoMATRICULA: TStringField
      FieldKind = fkLookup
      FieldName = 'MATRICULA'
      LookupDataSet = cds_funcionario
      LookupKeyFields = 'ID'
      LookupResultField = 'MATRICULA'
      KeyFields = 'ID_FUNCIONARIO'
      Size = 50
      Lookup = True
    end
    object cds_rh_freq_corpoDATA_ADM: TDateField
      FieldKind = fkLookup
      FieldName = 'DATA_ADM'
      LookupDataSet = cds_funcionario
      LookupKeyFields = 'ID'
      LookupResultField = 'DATA_ADMISSAO'
      KeyFields = 'ID_FUNCIONARIO'
      EditMask = '!99/99/0000;1;_'
      Lookup = True
    end
    object cds_rh_freq_corpoCARGO: TStringField
      FieldKind = fkLookup
      FieldName = 'CARGO'
      LookupDataSet = cds_funcionario
      LookupKeyFields = 'ID'
      LookupResultField = 'FUNCAO'
      KeyFields = 'ID_FUNCIONARIO'
      Size = 100
      Lookup = True
    end
    object cds_rh_freq_corpoVINCULO: TStringField
      FieldKind = fkLookup
      FieldName = 'VINCULO'
      LookupDataSet = cds_funcionario
      LookupKeyFields = 'ID'
      LookupResultField = 'VINCULO'
      KeyFields = 'ID_FUNCIONARIO'
      Size = 100
      Lookup = True
    end
    object cds_rh_freq_corpoDPTO: TStringField
      FieldKind = fkLookup
      FieldName = 'DPTO'
      LookupDataSet = cds_funcionario
      LookupKeyFields = 'ID'
      LookupResultField = 'DPTO'
      KeyFields = 'ID_FUNCIONARIO'
      Size = 100
      Lookup = True
    end
    object cds_rh_freq_corpoLOCAL: TStringField
      FieldKind = fkLookup
      FieldName = 'LOCAL'
      LookupDataSet = cds_funcionario
      LookupKeyFields = 'ID'
      LookupResultField = 'LOCAL'
      KeyFields = 'ID_FUNCIONARIO'
      Size = 100
      Lookup = True
    end
  end
  object ds_rh_freq_corpo: TDataSource
    DataSet = cds_rh_freq_corpo
    Left = 400
    Top = 560
  end
  object sql_folha: TSQLDataSet
    CommandText = 'select *  from FOLHA'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = conexao
    Left = 616
    Top = 368
  end
  object prov_folha: TDataSetProvider
    DataSet = sql_folha
    Left = 616
    Top = 416
  end
  object cds_folha: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'prov_folha'
    Left = 616
    Top = 472
    object cds_folhaID: TIntegerField
      FieldName = 'ID'
      Required = True
    end
    object cds_folhaMATRICULA: TStringField
      FieldName = 'MATRICULA'
    end
    object cds_folhaANO: TStringField
      FieldName = 'ANO'
      Size = 10
    end
    object cds_folhaMES: TStringField
      FieldName = 'MES'
      Size = 2
    end
    object cds_folhaSERVIDOR: TStringField
      FieldName = 'SERVIDOR'
      Size = 150
    end
    object cds_folhaDATA_ADM: TDateField
      FieldName = 'DATA_ADM'
    end
    object cds_folhaCARGO: TStringField
      FieldName = 'CARGO'
      Size = 100
    end
    object cds_folhaVINCULO: TStringField
      FieldName = 'VINCULO'
      Size = 100
    end
    object cds_folhaDPTO: TStringField
      FieldName = 'DPTO'
      Size = 100
    end
    object cds_folhaLOCAL: TStringField
      FieldName = 'LOCAL'
      Size = 100
    end
    object cds_folhaVALOR: TFMTBCDField
      FieldName = 'VALOR'
      Precision = 18
      Size = 2
    end
  end
  object dsfolha: TDataSource
    DataSet = cds_folha
    Left = 616
    Top = 520
  end
end
