Name: Consulta Pública

Display Field: CreatedBy

Type: Table

Geometry Type: N/A

Description:

Service Item Id: null

Copyright Text:

Default Visibility: false

MaxRecordCount: 1500

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• GlobalID ( type: esriFieldTypeGUID, alias: globalid, editable: true, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• CreatedOn ( type: esriFieldTypeDate, alias: CreatedOn, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CreatedOn )
• ModifiedOn ( type: esriFieldTypeDate, alias: ModifiedOn, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ModifiedOn )
• CreatedBy ( type: esriFieldTypeString, alias: CreatedBy, editable: true, nullable: true, length: 200, defaultValue: null, modelName: CreatedBy )
• ModifiedBy ( type: esriFieldTypeString, alias: ModifiedBy, editable: true, nullable: true, length: 200, defaultValue: null, modelName: ModifiedBy )
• ModifiedByHost ( type: esriFieldTypeString, alias: ModifiedByHost, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ModifiedByHost )
• SessionId ( type: esriFieldTypeString, alias: SessionId, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SessionId )
• OBJECTID ( type: esriFieldTypeOID, alias: objectid, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• nm_candidato ( type: esriFieldTypeString, alias: Nome do Candidato, editable: true, nullable: true, length: 70, defaultValue: null, modelName: nm_candidato )
• dt_ncandidato ( type: esriFieldTypeDate, alias: Data de Nascimento do Candidato, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dt_ncandidato )
• dm_estado_civil ( type: esriFieldTypeString, alias: Estado civil, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: dm_estado_civil )
• ocupacao ( type: esriFieldTypeString, alias: Ocupação, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ocupacao )
• num_nis ( type: esriFieldTypeString, alias: NIS do Candidato, editable: true, nullable: true, length: 11, defaultValue: null, modelName: num_nis )
• num_cpf ( type: esriFieldTypeString, alias: CPF, editable: true, nullable: true, length: 50, defaultValue: null, modelName: num_cpf )
• num_rg ( type: esriFieldTypeString, alias: Documento de Identificação, editable: true, nullable: true, length: 15, defaultValue: null, modelName: num_rg )
• org_exp_rg ( type: esriFieldTypeString, alias: Órgão de expedição do Documento, editable: true, nullable: true, length: 100, defaultValue: null, modelName: org_exp_rg )
• dm_uf_emissor ( type: esriFieldTypeString, alias: Sigla da UF do Emissor do Documento, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: dm_uf_emissor )
• dt_expedicao_rg ( type: esriFieldTypeDate, alias: Data de Expedição do Documento, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dt_expedicao_rg )
• pis_pasep ( type: esriFieldTypeString, alias: PIS/PASEP, editable: true, nullable: true, length: 15, defaultValue: null, modelName: pis_pasep )
• num_ctps ( type: esriFieldTypeString, alias: CTPS - Caterira de Trabalho e Previdência Social, editable: true, nullable: true, length: 50, defaultValue: null, modelName: num_ctps )
• passaporte ( type: esriFieldTypeString, alias: Passaporte, editable: true, nullable: true, length: 15, defaultValue: null, modelName: passaporte )
• num_cnh ( type: esriFieldTypeString, alias: CNH - Carteira Nacional de Habilitação, editable: true, nullable: true, length: 15, defaultValue: null, modelName: num_cnh )
• email ( type: esriFieldTypeString, alias: E-mail, editable: true, nullable: true, length: 150, defaultValue: null, modelName: email )
• num_ddd1 ( type: esriFieldTypeSmallInteger, alias: DDD Residencial, editable: true, nullable: true, defaultValue: null, modelName: num_ddd1 )
• num_tel1 ( type: esriFieldTypeInteger, alias: Telefone Residencial, editable: true, nullable: true, defaultValue: null, modelName: num_tel1 )
• ramal1 ( type: esriFieldTypeSmallInteger, alias: Ramal Telefone 1, editable: true, nullable: true, defaultValue: null, modelName: ramal1 )
• falar_com1 ( type: esriFieldTypeString, alias: Falar com (Residência), editable: true, nullable: true, length: 70, defaultValue: null, modelName: falar_com1 )
• num_ddd2 ( type: esriFieldTypeSmallInteger, alias: DDD Celular, editable: true, nullable: true, defaultValue: null, modelName: num_ddd2 )
• num_tel2 ( type: esriFieldTypeInteger, alias: Telefone Celular, editable: true, nullable: true, defaultValue: null, modelName: num_tel2 )
• ramal2 ( type: esriFieldTypeSmallInteger, alias: Ramal Telefone 2, editable: true, nullable: true, defaultValue: null, modelName: ramal2 )
• falar_com2 ( type: esriFieldTypeString, alias: falar_com2, editable: true, nullable: true, length: 70, defaultValue: null, modelName: falar_com2 )
• num_ddd3 ( type: esriFieldTypeSmallInteger, alias: DDD Recado, editable: true, nullable: true, defaultValue: null, modelName: num_ddd3 )
• num_tel3 ( type: esriFieldTypeInteger, alias: Telefone Recado, editable: true, nullable: true, defaultValue: null, modelName: num_tel3 )
• ramal3 ( type: esriFieldTypeSmallInteger, alias: ramal3, editable: true, nullable: true, defaultValue: null, modelName: ramal3 )
• falar_com3 ( type: esriFieldTypeString, alias: falar_com3, editable: true, nullable: true, length: 70, defaultValue: null, modelName: falar_com3 )
• num_ddd4 ( type: esriFieldTypeSmallInteger, alias: DDD Comercial, editable: true, nullable: true, defaultValue: null, modelName: num_ddd4 )
• num_tel4 ( type: esriFieldTypeInteger, alias: Telefone Comercial, editable: true, nullable: true, defaultValue: null, modelName: num_tel4 )
• ramal4 ( type: esriFieldTypeSmallInteger, alias: ramal4, editable: true, nullable: true, defaultValue: null, modelName: ramal4 )
• falar_com4 ( type: esriFieldTypeString, alias: falar_com4, editable: true, nullable: true, length: 70, defaultValue: null, modelName: falar_com4 )
• dt_uatucadastro ( type: esriFieldTypeDate, alias: Data da Última Atualização do Cadastro, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dt_uatucadastro )
• dm_st_cadastro ( type: esriFieldTypeString, alias: Situação do Cadastro, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: dm_st_cadastro )
• nis_titular ( type: esriFieldTypeString, alias: NIS Titular do Grupo Familiar, editable: true, nullable: true, length: 11, defaultValue: null, modelName: nis_titular )
• logradouro ( type: esriFieldTypeString, alias: Logradouro, editable: true, nullable: true, length: 50, defaultValue: null, modelName: logradouro )
• numero ( type: esriFieldTypeInteger, alias: Número, editable: true, nullable: true, defaultValue: null, modelName: numero )
• complemento ( type: esriFieldTypeString, alias: Complemento, editable: true, nullable: true, length: 300, defaultValue: null, modelName: complemento )
• dm_bairro ( type: esriFieldTypeString, alias: Bairro, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: dm_bairro )
• cod_municipio ( type: esriFieldTypeString, alias: Municipio, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: cod_municipio )
• localizacao ( type: esriFieldTypeString, alias: UF, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: localizacao )
• cep ( type: esriFieldTypeString, alias: CEP, editable: true, nullable: true, length: 10, defaultValue: null, modelName: cep )
• nm_conjuge ( type: esriFieldTypeString, alias: Nome do cônjuge, editable: true, nullable: true, length: 70, defaultValue: null, modelName: nm_conjuge )
• num_nis_conjuge ( type: esriFieldTypeString, alias: NIS do cônjuge, editable: true, nullable: true, length: 11, defaultValue: null, modelName: num_nis_conjuge )
• num_cpf_conjuge ( type: esriFieldTypeString, alias: CPF do cônjuge, editable: true, nullable: true, length: 50, defaultValue: null, modelName: num_cpf_conjuge )
• qt_dependente ( type: esriFieldTypeSmallInteger, alias: Quantidade de Dependentes, editable: true, nullable: true, defaultValue: null, modelName: qt_dependente )
• dm_part_PNE ( type: esriFieldTypeString, alias: Possui Participante PCD com Laudo Médico, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: dm_part_PNE )
• sitah_dm_st_gfam ( type: esriFieldTypeString, alias: Situação na Pesquisa Cadastral, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: sitah_dm_st_gfam )
• sitah_mot_rej ( type: esriFieldTypeString, alias: Motivo de Rejeição, editable: true, nullable: true, length: 255, defaultValue: null, modelName: sitah_mot_rej )
• dm_f_selecionado ( type: esriFieldTypeString, alias: Foi Selecionado no sorteio, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: dm_f_selecionado )
• dt_sorteio ( type: esriFieldTypeDate, alias: Data do Sorteio, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dt_sorteio )
• dt_agentrevista ( type: esriFieldTypeDate, alias: Data Agendada para a Entrevista, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dt_agentrevista )
• apf_empreendimento ( type: esriFieldTypeInteger, alias: APF do Empreendimento, editable: true, nullable: true, defaultValue: null, modelName: apf_empreendimento )
• nm_empreendimento ( type: esriFieldTypeString, alias: Nome do Empreendimento, editable: true, nullable: true, length: 60, defaultValue: null, modelName: nm_empreendimento )
• dm_bairro_empreendimento ( type: esriFieldTypeString, alias: Bairro do Empreendimento, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: dm_bairro_empreendimento )
• dm_status_obra ( type: esriFieldTypeString, alias: Status da Obra, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: dm_status_obra )
• per_obra ( type: esriFieldTypeDouble, alias: Percentual da Obra, editable: true, nullable: true, defaultValue: null, modelName: per_obra )

Templates:

• Name: Consulta Pública
  Description:
  Prototype:
  dm_status_obra: null
  GlobalID: {00000000-0000-0000-0000-000000000000}
  CreatedOn: null
  ModifiedOn: null
  CreatedBy: null
  ModifiedBy: null
  ModifiedByHost: null
  SessionId: null
  per_obra: null
  nm_candidato: null
  dt_ncandidato: null
  dm_estado_civil: null
  ocupacao: null
  num_nis: null
  num_cpf: null
  num_rg: null
  org_exp_rg: null
  dm_uf_emissor: null
  dt_expedicao_rg: null
  pis_pasep: null
  num_ctps: null
  passaporte: null
  num_cnh: null
  email: null
  num_ddd1: null
  num_tel1: null
  ramal1: null
  falar_com1: null
  num_ddd2: null
  num_tel2: null
  ramal2: null
  falar_com2: null
  num_ddd3: null
  num_tel3: null
  ramal3: null
  falar_com3: null
  num_ddd4: null
  num_tel4: null
  ramal4: null
  falar_com4: null
  dt_uatucadastro: null
  dm_st_cadastro: null
  nis_titular: null
  logradouro: null
  numero: null
  complemento: null
  dm_bairro: null
  cod_municipio: null
  localizacao: null
  cep: null
  nm_conjuge: null
  num_nis_conjuge: null
  num_cpf_conjuge: null
  qt_dependente: null
  dm_part_PNE: null
  sitah_dm_st_gfam: null
  sitah_mot_rej: null
  dm_f_selecionado: null
  dt_sorteio: null
  dt_agentrevista: null
  apf_empreendimento: null
  nm_empreendimento: null
  dm_bairro_empreendimento: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata