Layers:

Layer: Cadastros_RH_ICM (0)

Name: Cadastros_RH_ICM

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 0705c2e1828448bd8edc43a56de6ddfa

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:
XMin: -180.0
YMin: -90.0
XMax: 180.0
YMax: 90.0
Spatial Reference: 4326  (0)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [255, 0, 0, 255]
Size: 8.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[255, 255, 0, 255] Width: 1
Label: Cadastros RH ICM
Description: Survey Data Locations
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: ObjectID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• uniquerowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: RowID, type: esriFieldTypeGUID )
• imagem ( nullable: true, editable: true, defaultValue: null, length: 255, alias: imagem, type: esriFieldTypeString )
• cod_name_empresa ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Código da empresa:, type: esriFieldTypeString )
• nome_empresa ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Nome da empresa:, type: esriFieldTypeString )
• cnpj ( nullable: true, editable: true, defaultValue: null, length: 255, alias: CNPJ:, type: esriFieldTypeString )
• num_contrato ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Contrato:, type: esriFieldTypeString )
• lote ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Lote:, type: esriFieldTypeString )
• selecionar_cargos ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Quais cargos você deseja preencher?, type: esriFieldTypeString )
• cargo_titulo ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Coordenador Geral (Engenheiro Civil Sênior), type: esriFieldTypeString )
• nome_trabalhador_coor ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Nome do funcionário:, type: esriFieldTypeString )
• data_inicio_cargo ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Data de Início:, type: esriFieldTypeDate )
• graduacao ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Graduações, mínimo de 10 anos de formação?, type: esriFieldTypeString , Coded Values: [sim: Sim] , [não: Não] )
• grad_msg ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Possuo formação mínima de 10 anos, conforme edital., type: esriFieldTypeString )
• exp_eng ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Possui Experiência mínima 10 anos em engenharia?, type: esriFieldTypeString , Coded Values: [sim: Sim] , [não: Não] )
• exp_eng_msg ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Possuo experiência mínima de 10 anos em atividades de engenharia, conforme o edital., type: esriFieldTypeString )
• exp_eng_rod ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Experiência mínima 2 anos em engenharia rodoviária?, type: esriFieldTypeString , Coded Values: [sim: Sim] , [não: Não] )
• exp_eng_rod_msg ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Possuo experiência mínima de 2 anos em atividades de engenharia rodoviária, conforme o edital., type: esriFieldTypeString )
• exp_eng_coord ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Experiência mínima 1 ano em coordenação e/ou gerenciamento?, type: esriFieldTypeString , Coded Values: [sim: Sim] , [não: Não] )
• exp_eng_coord_msg ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Possuo experiência mínima 1 ano com coordenação e/ ou gerenciamento de atividades de engenharia, conforme edital., type: esriFieldTypeString )
• aprovado_1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Esse profissional segue os padrões exigidos em edital., type: esriFieldTypeString )
• cargo_titulo2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Engenheiro Civil Pleno, type: esriFieldTypeString )
• info_cargo_eng ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Edital exige 05 Engenheiros Civis Pleno., type: esriFieldTypeString )
• qtd_eng_pleno ( nullable: true, editable: true, defaultValue: null, alias: Quantidade de Engenheiros Plenos, type: esriFieldTypeInteger )
• cargo_titulo3 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Técnico de Obras, type: esriFieldTypeString )
• info_cargo_tec ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Edital exige 18 Técnicos de Obras, type: esriFieldTypeString )
• qtd_tec_obras ( nullable: true, editable: true, defaultValue: null, alias: Quantidade de Técnicos de Obras, type: esriFieldTypeInteger )
• cargo_titulo4 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Motorista, type: esriFieldTypeString )
• info_cargo_mot ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Edital exige 02 motoristas., type: esriFieldTypeString )
• qtd_motorista ( nullable: true, editable: true, defaultValue: null, alias: Quantidade de Motorista, type: esriFieldTypeInteger )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• lote_coord ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Lote do profissional, type: esriFieldTypeString )
• lote_eng ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Lote do profissional, type: esriFieldTypeString )
• lote_tec ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Lote do profissional, type: esriFieldTypeString )
• lote_mot ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Lote do profissional, type: esriFieldTypeString )
Templates:
• Name: New Feature
  Description:
  Prototype:
  Drawing Tool: N/A

Relationships:

• Cadastros_RH_ICM_lista_eng_pleno (0) -- Related To: lista_eng_pleno (1)
• Cadastros_RH_ICM_lista_tec_obras (1) -- Related To: lista_tec_obras (2)
• Cadastros_RH_ICM_lista_motorista (2) -- Related To: lista_motorista (3)

Tables:

Table: lista_eng_pleno (1)

Name: lista_eng_pleno

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 0705c2e1828448bd8edc43a56de6ddfa

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

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: false
Supports Returning Query Extent: true
Supports Query With Distance: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: ObjectID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• index_eng_pleno ( nullable: true, editable: true, defaultValue: null, length: 255, alias: index_eng_pleno, type: esriFieldTypeString )
• nome_trabalhador_eng ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Nome do funcionário:, type: esriFieldTypeString )
• data_inicio_cargo_eng ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Data de Início:, type: esriFieldTypeDate )
• graduacao_pleno ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Graduações, mínimo de 5 anos de formação?, type: esriFieldTypeString )
• exp_pleno_msg ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Possuo formação mínima de 5 anos, conforme edital., type: esriFieldTypeString )
• exp_plen ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Possui Experiência mínima 5 anos em engenharia?, type: esriFieldTypeString )
• exp_plen_msg ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Possuo experiência mínima de 5 anos em atividades de engenharia, conforme o edital., type: esriFieldTypeString )
• exp_plen_rod ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Experiência mínima 1 ano em engenharia rodoviária?, type: esriFieldTypeString )
• exp_plen_rod_msg ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Possuo experiência mínima de 1 ano em atividades de engenharia rodoviária, conforme o edital., type: esriFieldTypeString )
• cnh_sim ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Possui CNH Categoria B?, type: esriFieldTypeString )
• cnh_sim_msg ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Possuo CNH Categoria B., type: esriFieldTypeString )
• verificar_todas_sim ( nullable: true, editable: true, defaultValue: null, length: 255, alias: ., type: esriFieldTypeString )
• aprovado_2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Status:, type: esriFieldTypeString )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• lote_eng ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Lote do profissional, type: esriFieldTypeString )

Relationships:

• Cadastros_RH_ICM_lista_eng_pleno (0) -- Related To: Cadastros_RH_ICM (0)

Table: lista_tec_obras (2)

Name: lista_tec_obras

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 0705c2e1828448bd8edc43a56de6ddfa

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

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: false
Supports Returning Query Extent: true
Supports Query With Distance: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: ObjectID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• produto_cadastro ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Para qual produto é este cadastro?, type: esriFieldTypeString , Coded Values: [p2: Produto 2] , [p3: Produto 3] )
• regional ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Selecione qual regional pertence:, type: esriFieldTypeString )
• index_tec_obras ( nullable: true, editable: true, defaultValue: null, length: 255, alias: index_tec_obras, type: esriFieldTypeString )
• nome_trabalhador_tec ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Nome do funcionário:, type: esriFieldTypeString )
• data_inicio_cargo_tec ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Data de Início:, type: esriFieldTypeDate )
• tecnico_obras ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Curso técnico na área de Estradas ou Transportes ou Trânsito?, type: esriFieldTypeString )
• exp_tec_msg ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Possuo formação no curso técnico, conforme edital., type: esriFieldTypeString )
• exp_tec ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Possui Experiência mínima 1 ano em infraestrutura viária e/ou operação viária?, type: esriFieldTypeString )
• exp_tecnico_msg ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Possuo experiência mínima de 1 ano em atividades de infraestrutura viária e/ou operação viária, conforme o edital., type: esriFieldTypeString )
• cnh_sim_tec ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Possui CNH Categoria B?, type: esriFieldTypeString )
• cnh_sim_tec_msg ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Possuo CNH Categoria B., type: esriFieldTypeString )
• verificar_todas_tec_sim ( nullable: true, editable: true, defaultValue: null, length: 255, alias: ., type: esriFieldTypeString )
• aprovado_3 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Status:, type: esriFieldTypeString )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• aprovado ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Status:, type: esriFieldTypeString )
• verifica_p2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Status:, type: esriFieldTypeString )
• aprovado_p3 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Status:, type: esriFieldTypeString )
• aprov ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Status:, type: esriFieldTypeString )
• lote_tec ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Lote do profissional, type: esriFieldTypeString )

Relationships:

• Cadastros_RH_ICM_lista_tec_obras (1) -- Related To: Cadastros_RH_ICM (0)

Table: lista_motorista (3)

Name: lista_motorista

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 0705c2e1828448bd8edc43a56de6ddfa

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

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: false
Supports Returning Query Extent: true
Supports Query With Distance: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: ObjectID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• index_motorista ( nullable: true, editable: true, defaultValue: null, length: 255, alias: index_motorista, type: esriFieldTypeString )
• nome_motorista ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Nome do funcionário:, type: esriFieldTypeString )
• data_inicio_cargo_mot ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Data de Início:, type: esriFieldTypeDate )
• cnh_sim_mot ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Possui CNH Categoria B?, type: esriFieldTypeString )
• cnh_sim_mot_msg ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Possuo CNH Categoria B., type: esriFieldTypeString )
• verificar_todas_mot_sim ( nullable: true, editable: true, defaultValue: null, length: 255, alias: ., type: esriFieldTypeString )
• aprovado_4 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Status:, type: esriFieldTypeString )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• aprovado_mot ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Status:, type: esriFieldTypeString )
• lote_mot ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Lote do profissional, type: esriFieldTypeString )

Relationships:

• Cadastros_RH_ICM_lista_motorista (2) -- Related To: Cadastros_RH_ICM (0)