VREQPROMOCAOPARECER

13 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLREQUISICAO DCODCOLIGADA 2 null
VTABSALARIAIS.CODCOLIGADA FKVREQPROPARECER_VTABSALARIAISR
PMOTMUDSAL.CODCOLIGADA FKVREQPROMOCPARECER_PMOTMUDSALR
VREQPROMOCAO.CODCOLREQUISICAO FKVREQPROMPARECER_VREQPROMOCAOR
PMOTMUDFUNCAO.CODCOLIGADA FKVREQPROMOPAREC_PMOTMUDFUNCAOR
PFUNCAO.CODCOLIGADA FKVREQPROMOCAOPARECER_PFUNCAOR
PSECAO.CODCOLIGADA FKVREQPROMOCAOPARECER_PSECAOR
VFAIXASALARIAL.CODCOLIGADA FKVREQPROMPAREC_VFAIXASALARIALR
VHIERARQUIA.CODCOLIGADA FKVREQPROMOCAOPARECER_VHIERARR
VNIVELFUNCAO.CODCOLIGADA FKVREQPROMPARECER_VNIVELFUNCAOR
IDPARECER int 4 null
IDREQ int 4 null
VREQPROMOCAO.IDREQ FKVREQPROMPARECER_VREQPROMOCAOR
CODCOLSOLICITANTE DCODCOLIGADA 2 null
CHAPASOLICITANTE varchar 16 null
PARECER MEMO 2147483647 null
CODSTATUS int 4 null
VREQSTATUS.CODCLIENTE FKVREQPROMOCPARECER_VREQSTATUSR
DATAPARECER datetime 16,3 null
DATAPREVISTA datetime 16,3 √ null
SUSPENSAO DLOGICO 2 null
CODFUNCAO varchar 10 null
PFUNCAO.CODIGO FKVREQPROMOCAOPARECER_PFUNCAOR
CODSECAO varchar 35 √ null
PSECAO.CODIGO FKVREQPROMOCAOPARECER_PSECAOR
CODTABELASALARIAL varchar 10 √ null
VTABSALARIAIS.CODTABELA FKVREQPROPARECER_VTABSALARIAISR
CODNIVELSALARIAL varchar 10 √ null
VNIVELFUNCAO.CODNIVEL FKVREQPROMPARECER_VNIVELFUNCAOR
CODFAIXASALARIAL varchar 10 √ null
VFAIXASALARIAL.CODFAIXA FKVREQPROMPAREC_VFAIXASALARIALR
VLRSALARIO RMDVALOR2 17,2 √ null
CODMOTMUDFUNCAO varchar 2 √ null
PMOTMUDFUNCAO.CODCLIENTE FKVREQPROMOPAREC_PMOTMUDFUNCAOR
CODMOTMUDSALARIO varchar 2 √ null
PMOTMUDSAL.CODCLIENTE FKVREQPROMOCPARECER_PMOTMUDSALR
CRIASUBSTITUICAO smallint 2 null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDHIERARQUIADESTINO int 4 √ null
VHIERARQUIA.IDHIERARQUIA FKVREQPROMOCAOPARECER_VHIERARR

Indexes

Constraint Name Type Sort Column(s)
PKVREQPROMOCAOPARECER Primary key Asc/Asc/Asc CODCOLREQUISICAO + IDPARECER + IDREQ

Relationships

Close relationships within degrees of separation