VADAVALIACAO

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VADACAOAVALIADA.CODCOLIGADA FKVADACAOAVALIADA_VADAVALIACAOR
VADCOMPETENCIAAVALIADA.CODCOLIGADA FKVADCOMPAVAL_VADAVALIACAOR
VADCOMPLPARTICIPANTE.CODCOLIGADA FKVADCOMPLPARTICIP_VADAVALIACAR
VADCONTROLEMETAS.CODCOLIGADA FKVADCONTROLEMETAS_VADAVALIACAR
VADESCALA.CODCOLIGADA FKVADESCALA_VADAVALIACAOR
VADFATORORGAVALIADO.CODCOLIGADA FKVADFATORORGAVAL_VADAVALIACAOR
VADFEEDBACK.CODCOLIGADA FKVADFEEDBACK_VADAVALIACAOR
VADGESTAOMETASAVALIADAS.CODCOLIGADA FKVADGESTAOMETASAVAL_VADAVALIAR
VADGRAFICOS.CODCOLIGADA FKVADGRAFICOS_VADAVALIACAOR
VADMETAS.CODCOLIGADA FKVADMETAS_VADAVALIACAOR
VADNOTATOTAL.CODCOLIGADA FKVADNOTATOTAL_VADAVALIACAOR
VADPARTICIPANTES.CODCOLIGADA FKVADPARTICIPANTE_VADAVALIACAOR
VADPDI.CODCOLIGADA FKVADPDI_VADAVALIACAOR
VADPERFORMANCEAVALIADA.CODCOLIGADA FKVADPERFAVALIADA_VADAVALIACAOR
VADPESOTIPOAVALIADOR.CODCOLIGADA FKVADPESOTIPOAVAL_VADAVALIACAOR
VADQUESTIONARIOS.CODCOLIGADA FKVADQUESTI_VADAVALIACAOR
VADQUESTPARTICIPANTE.CODCOLIGADA FKVADQUESTPARTICIP_VADAVALIACAR
VGQUADAVALIACAO.CODCOLIGADAAVALIACAO FKVGQUADAVALIACAO_VADAVALIACAOR
GCOLIGADA.CODCOLIGADA FKVADAVALIACAO_GCOLIGADAR
VEMAIL.CODCOLIGADA FKVADAVALIACAO_VEMAILEMAILEXECR
CODAVALIACAO varchar 10 null
VADACAOAVALIADA.CODAVALIACAO FKVADACAOAVALIADA_VADAVALIACAOR
VADCOMPETENCIAAVALIADA.CODAVALIACAO FKVADCOMPAVAL_VADAVALIACAOR
VADCOMPLPARTICIPANTE.CODAVALIACAO FKVADCOMPLPARTICIP_VADAVALIACAR
VADCONTROLEMETAS.CODAVALIACAO FKVADCONTROLEMETAS_VADAVALIACAR
VADESCALA.CODAVALIACAO FKVADESCALA_VADAVALIACAOR
VADFATORORGAVALIADO.CODAVALIACAO FKVADFATORORGAVAL_VADAVALIACAOR
VADFEEDBACK.CODAVALIACAO FKVADFEEDBACK_VADAVALIACAOR
VADGESTAOMETASAVALIADAS.CODAVALIACAO FKVADGESTAOMETASAVAL_VADAVALIAR
VADGRAFICOS.CODAVALIACAO FKVADGRAFICOS_VADAVALIACAOR
VADMETAS.CODAVALIACAO FKVADMETAS_VADAVALIACAOR
VADNOTATOTAL.CODAVALIACAO FKVADNOTATOTAL_VADAVALIACAOR
VADPARTICIPANTES.CODAVALIACAO FKVADPARTICIPANTE_VADAVALIACAOR
VADPDI.CODAVALIACAO FKVADPDI_VADAVALIACAOR
VADPERFORMANCEAVALIADA.CODAVALIACAO FKVADPERFAVALIADA_VADAVALIACAOR
VADPESOTIPOAVALIADOR.CODAVALIACAO FKVADPESOTIPOAVAL_VADAVALIACAOR
VADQUESTIONARIOS.CODAVALIACAO FKVADQUESTI_VADAVALIACAOR
VADQUESTPARTICIPANTE.CODAVALIACAO FKVADQUESTPARTICIP_VADAVALIACAR
VGQUADAVALIACAO.CODAVALIACAO FKVGQUADAVALIACAO_VADAVALIACAOR
DATAABERTURA datetime 16,3 null
DATAFECHAMENTO datetime 16,3 √ null
NOME varchar 120 null
MODALIDADE smallint 2 null
MODELO smallint 2 null
EXIBIRPESOS DLOGICO 2 null
AGRUPARPOR smallint 2 √ null
CONSENSUAL DLOGICO 2 null
AUTOAVALIACAO DLOGICO 2 null
CHEFES DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
SUBORDINADOS DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CLIENTES DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
FORNECEDORES DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PARES DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
OUTROS DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
USACOMPTEC DLOGICO 2 null
USACOMPCOMPORT DLOGICO 2 null
USAFATORORG DLOGICO 2 null
USAACOES DLOGICO 2 null
DATALIMITE datetime 16,3 √ null
ID int identity 4 √ null
USAOUTRASCOMPETENCIAS DLOGICO 2 (0)
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
EXIBEACAOPRIMEIRO smallint 2 √ null
CODCOLREL smallint 2 √ null
IDREL int 4 √ null
RELAUTOAVALIACAO smallint 2 √ null
RELCHEFES smallint 2 √ null
RELSUBORDINADOS smallint 2 √ null
RELCLIENTES smallint 2 √ null
RELFORNECEDORES smallint 2 √ null
RELPARES smallint 2 √ null
RELOUTROS smallint 2 √ null
CONSIDERASUPERVIDOR smallint 2 √ null
USAMETAS DLOGICO 2 ((0))
CODPDI varchar 16 √ null
LIBERARPDIAPOSAD smallint 2 √ ((0))
SUBORDESTRUTLOTACAO int 4 ((1))
SUBORDESTRUTHIERARQUIA int 4 ((1))
INTERVALOSESCALA smallint 2 √ null
COMPETENCIASPORCARGO DLOGICO 2 ((0))
COMPETENCIASPORFUNCAO DLOGICO 2 ((0))
COMPETENCIASPORSECAO DLOGICO 2 ((0))
COMPETENCIASPORLOTACAO DLOGICO 2 ((0))
COMPETENCIASPORTAREFA DLOGICO 2 ((0))
COMPETENCIASPORFUNCAOPOSTOTRAB DLOGICO 2 ((0))
COMPETENCIASPORFUNCIONARIO DLOGICO 2 ((0))
CODEMAILEXECUCAO varchar 10 √ null
VEMAIL.CODEMAIL FKVADAVALIACAO_VEMAILEMAILEXECR
CODEMAILCONSENSUAL varchar 10 √ null
VEMAIL.CODEMAIL FKVADAVALIACAO_VEMAILEMAILCONSR
ENVIAREMAILAVALIACOESPENDENTES DLOGICO 2 ((0))
EXIBIRPORTIPOCOMP DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
EXIBIRAUTOGESTOR DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
OCULTARCALCULOCOMPETENCIA smallint 2 √ null
PERMITIRADDIRETAMENTE int 4 √ null
CODEMAILPENDENCIA varchar 10 √ null
COMPETENCIASPORNIVELCARREIRA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
USAFEEDBACK smallint 2 √ ((0))

Indexes

Constraint Name Type Sort Column(s)
PKVADAVALIACAO Primary key Asc/Asc CODCOLIGADA + CODAVALIACAO
VXADAVALIACAOID Must be unique Asc ID

Relationships

Close relationships within degrees of separation