VREQPROMOCAO

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLREQUISICAO DCODCOLIGADA 2 null
VALTDADFUNCPROG.CODCOLIGADA FKVALTDADFUNCPROG_VREQPROMOCAOR
VREQPROMOCAOCOMPL.CODCOLREQUISICAO FKVREQPROMOCCOMPL_VREQPROMOCAOR
VREQPROMOCAOPARECER.CODCOLREQUISICAO FKVREQPROMPARECER_VREQPROMOCAOR
VREQPROMOCAORATEIOCC.CODCOLREQUISICAO FKVREQPROMOCAORATEIOCC_VREQPROR
VPOSICAO.CODCOLIGADA FKVREQPROMOCAO_VPOSICAOR
VTABSALARIAIS.CODCOLIGADA FKVREQPROMOCA_VTABSALARIAISORGR
PMOTMUDSAL.CODCOLIGADA FKVREQPROMOCAO_PMOTMUDSALR
PMOTMUDFUNCAO.CODCOLIGADA FKVREQPROMOCAO_PMOTMUDFUNCAOR
PFUNC.CODCOLIGADA FKVREQPROMOCAO_PFUNCR
PFUNCAO.CODCOLIGADA FKVREQPROMOCAO_PFUNCAOORGR
HATENDIMENTOBASE.CODCOLIGADA FKVREQPROMOCAO_HATENDIMENTOEXTR
VFAIXASALARIAL.CODCOLIGADA FKVREQPROMOC_VFAIXASALARIALREQR
VHIERARQUIA.CODCOLIGADA FKVREQPRO_VHIERARORIGEMR
VNIVELFUNCAO.CODCOLIGADA FKVREQPROMOCAO_VNIVELFUNCAOORGR
IDREQ int 4 null
VALTDADFUNCPROG.IDREQ FKVALTDADFUNCPROG_VREQPROMOCAOR
VREQPROMOCAOCOMPL.IDREQ FKVREQPROMOCCOMPL_VREQPROMOCAOR
VREQPROMOCAOPARECER.IDREQ FKVREQPROMPARECER_VREQPROMOCAOR
VREQPROMOCAORATEIOCC.IDREQ FKVREQPROMOCAORATEIOCC_VREQPROR
TIPOREQPAI int 4 √ null
IDREQPAI int 4 √ null
JUSTIFICATIVA MEMO 2147483647 null
DATAABERTURA datetime 16,3 null
DATACANCELAMENTO datetime 16,3 √ null
DATACONCLUSAO datetime 16,3 √ null
CODCOLREQUISITANTE DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKVREQPROMOCAO_PFUNCREQR
CHAPAREQUISITANTE varchar 16 null
PFUNC.CHAPA FKVREQPROMOCAO_PFUNCREQR
CODATENDIMENTO int 4 √ null
HATENDIMENTOBASE.CODATENDIMENTO FKVREQPROMOCAO_HATENDIMENTOEXTR
CODLOCAL int 4 √ null
HATENDIMENTOBASE.CODLOCAL FKVREQPROMOCAO_HATENDIMENTOEXTR
CODSTATUS int 4 null
VREQSTATUS.CODCLIENTE FKVREQPROMOCAO_VREQSTATUSR
DATAPREVISTA datetime 16,3 √ null
CODFUNCAOORG varchar 10 null
PFUNCAO.CODIGO FKVREQPROMOCAO_PFUNCAOORGR
CODTABELASALARIALORG varchar 10 √ null
VTABSALARIAIS.CODTABELA FKVREQPROMOCA_VTABSALARIAISORGR
CODNIVELSALARIALORG varchar 10 √ null
VNIVELFUNCAO.CODNIVEL FKVREQPROMOCAO_VNIVELFUNCAOORGR
CODFAIXASALARIALORG varchar 10 √ null
VFAIXASALARIAL.CODFAIXA FKVREQPROMOCAO_VFAIXASALARIALR
VLRSALARIOORG RMDVALOR2 17,2 √ null
CODFUNCAO varchar 10 null
PFUNCAO.CODIGO FKVREQPROMOCAO_PFUNCAOR
CODTABELASALARIAL varchar 10 √ null
VTABSALARIAIS.CODTABELA FKVREQPROMOCAO_VTABSALARIAISR
CODNIVELSALARIAL varchar 10 √ null
VNIVELFUNCAO.CODNIVEL FKVREQPROMOCAO_VNIVELFUNCAOR
CODFAIXASALARIAL varchar 10 √ null
VFAIXASALARIAL.CODFAIXA FKVREQPROMOC_VFAIXASALARIALREQR
VLRSALARIO RMDVALOR2 17,2 √ null
CODMOTMUDFUNCAO varchar 2 √ null
PMOTMUDFUNCAO.CODCLIENTE FKVREQPROMOCAO_PMOTMUDFUNCAOR
CODMOTMUDSALARIO varchar 2 √ null
PMOTMUDSAL.CODCLIENTE FKVREQPROMOCAO_PMOTMUDSALR
CRIASUBSTITUICAO smallint 2 null
CHAPA varchar 16 √ null
PFUNC.CHAPA FKVREQPROMOCAO_PFUNCR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDHIERARQUIAORIGEM int 4 √ null
VHIERARQUIA.IDHIERARQUIA FKVREQPRO_VHIERARORIGEMR
IDHIERARQUIADESTINO int 4 √ null
VHIERARQUIA.IDHIERARQUIA FKVREQPRO_VHIERDESTINOR
IDPOSICAOORIGEM int 4 √ null
VPOSICAO.IDPOSICAO FKVREQPROMOCAO_VPOSICAOR

Indexes

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

Relationships

Close relationships within degrees of separation