VREQTRANSFPROMOCAO

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLREQUISICAO DCODCOLIGADA 2 null
VREQTRANSFPROMOCAOCOMPL.CODCOLREQUISICAO FKVREQTRANSPRCOMPL_VREQTRANSPRR
VREQTRANSFPROMOCAOPARECER.CODCOLREQUISICAO FKVREQTRANSFPRPAR_VREQTRANSFPRR
VREQTRANSFPROMOCAORATEIOCC.CODCOLREQUISICAO FKVREQTRANSFPROMOEIOCC_VREQTRAR
VTRANSFALTDADFUNCPROG.CODCOLIGADA FKVTRANSFALTDADFUNCPROG_VREQTRR
VTABSALARIAIS.CODCOLIGADA FKVREQTRANSFPROM_VTABSALARIAISR
PMOTMUDSAL.CODCOLIGADA FKVREQTRANSFPROMOCA_PMOTMUDSALR
PMOTMUDFUNCAO.CODCOLIGADA FKVREQTRANSFPROM_PMOTMUDFUNCAOR
PFUNCAO.CODCOLIGADA FKVREQTRANSFPROMOCAO_PFUNCAOR
PMOTMUDSECAO.CODCOLIGADA FKVREQTRANSFPROM_PMOTMUDSECAOR
PSECAO.CODCOLIGADA FKVREQTRANSFPROMOCAO_PSECAOR
HATENDIMENTOBASE.CODCOLIGADA FKVREQTRANSFPROM_HATENDIMENEXTR
VFAIXASALARIAL.CODCOLIGADA FKVREQTRANSFPRO_VFAIXASALARIALR
GFILIAL.CODCOLIGADA FKVREQTRANSFPROMOCAO_GFILIALR
VNIVELFUNCAO.CODCOLIGADA FKVREQTRANSFPROM_VNIVELFUNCAOR
IDREQ int 4 null
VREQTRANSFPROMOCAOCOMPL.IDREQ FKVREQTRANSPRCOMPL_VREQTRANSPRR
VREQTRANSFPROMOCAOPARECER.IDREQ FKVREQTRANSFPRPAR_VREQTRANSFPRR
VREQTRANSFPROMOCAORATEIOCC.IDREQ FKVREQTRANSFPROMOEIOCC_VREQTRAR
VTRANSFALTDADFUNCPROG.IDREQ FKVTRANSFALTDADFUNCPROG_VREQTRR
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 FKVREQTRANSFPROMOCAO_PFUNCREQR
CHAPAREQUISITANTE varchar 16 null
PFUNC.CHAPA FKVREQTRANSFPROMOCAO_PFUNCREQR
CODATENDIMENTO int 4 √ null
HATENDIMENTOBASE.CODATENDIMENTO FKVREQTRANSFPROM_HATENDIMENEXTR
CODLOCAL int 4 √ null
HATENDIMENTOBASE.CODLOCAL FKVREQTRANSFPROM_HATENDIMENEXTR
CODSTATUS int 4 null
VREQSTATUS.CODCLIENTE FKVREQTRANSFPRO_VREQSTATUSR
DATAPREVISTA datetime 16,3 √ null
CRIASUBSTITUICAO smallint 2 null
CHAPA varchar 16 √ null
PFUNC.CHAPA FKVREQTRANSFPROMOCAO_PFUNCR
CODCOLORG DCODCOLIGADA 2 null
VPOSICAO.CODCOLIGADA FKVREQTRANSFPROMOCAO_VPOSICAOR
VTABSALARIAIS.CODCOLIGADA FKVREQTRANSFPROM_VTABSALORGR
PFUNC.CODCOLIGADA FKVREQTRANSFPROMOCAO_PFUNCR
PFUNCAO.CODCOLIGADA FKVREQTRANSFPROMOCA_PFUNCAOORGR
PSECAO.CODCOLIGADA FKVREQTRANSFPROMOCAO_PSECAOORGR
VFAIXASALARIAL.CODCOLIGADA FKVREQTRANSFPRO_VFAIXASALORGR
GFILIAL.CODCOLIGADA FKVREQTRANSFPROMOCA_GFILIALORGR
VNIVELFUNCAO.CODCOLIGADA FKVREQTRANSFPR_VNIVELFUNCAOORGR
CODFILIALORG smallint 2 null
GFILIAL.CODFILIAL FKVREQTRANSFPROMOCA_GFILIALORGR
CODSECAOORG varchar 35 null
PSECAO.CODIGO FKVREQTRANSFPROMOCAO_PSECAOORGR
CODFUNCAOORG varchar 10 null
PFUNCAO.CODIGO FKVREQTRANSFPROMOCA_PFUNCAOORGR
CODTABELASALARIALORG varchar 10 √ null
VTABSALARIAIS.CODTABELA FKVREQTRANSFPROM_VTABSALORGR
CODNIVELSALARIALORG varchar 10 √ null
VNIVELFUNCAO.CODNIVEL FKVREQTRANSFPR_VNIVELFUNCAOORGR
CODFAIXASALARIALORG varchar 10 √ null
VFAIXASALARIAL.CODFAIXA FKVREQTRANSFPRO_VFAIXASALORGR
VLRSALARIOORG RMDVALOR2 17,2 √ null
CODFILIAL smallint 2 null
GFILIAL.CODFILIAL FKVREQTRANSFPROMOCAO_GFILIALR
CODSECAO varchar 35 null
PSECAO.CODIGO FKVREQTRANSFPROMOCAO_PSECAOR
CODFUNCAO varchar 10 null
PFUNCAO.CODIGO FKVREQTRANSFPROMOCAO_PFUNCAOR
CODTABELASALARIAL varchar 10 √ null
VTABSALARIAIS.CODTABELA FKVREQTRANSFPROM_VTABSALARIAISR
CODNIVELSALARIAL varchar 10 √ null
VNIVELFUNCAO.CODNIVEL FKVREQTRANSFPROM_VNIVELFUNCAOR
CODFAIXASALARIAL varchar 10 √ null
VFAIXASALARIAL.CODFAIXA FKVREQTRANSFPRO_VFAIXASALARIALR
VLRSALARIO RMDVALOR2 17,2 √ null
CODMOTMUDFUNCAO varchar 2 √ null
PMOTMUDFUNCAO.CODCLIENTE FKVREQTRANSFPROM_PMOTMUDFUNCAOR
CODMOTMUDSALARIO varchar 2 √ null
PMOTMUDSAL.CODCLIENTE FKVREQTRANSFPROMOCA_PMOTMUDSALR
CODMOTMUDSECAO varchar 2 √ null
PMOTMUDSECAO.CODCLIENTE FKVREQTRANSFPROM_PMOTMUDSECAOR
TRANSFERIRVAGA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODCOLHIERARQUIAORIGEM DCODCOLIGADANULL 2 √ null
VHIERARQUIA.CODCOLIGADA FKVREQTRANSFPRO_VHIERARQORIR
IDHIERARQUIAORIGEM int 4 √ null
VHIERARQUIA.IDHIERARQUIA FKVREQTRANSFPRO_VHIERARQORIR
CODCOLHIERARQUIADESTINO DCODCOLIGADANULL 2 √ null
VHIERARQUIA.CODCOLIGADA FKVREQTRANSFPRO_VHIERARQDESTR
IDHIERARQUIADESTINO int 4 √ null
VHIERARQUIA.IDHIERARQUIA FKVREQTRANSFPRO_VHIERARQDESTR
IDPOSICAOORIGEM int 4 √ null
VPOSICAO.IDPOSICAO FKVREQTRANSFPROMOCAO_VPOSICAOR

Indexes

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

Relationships

Close relationships within degrees of separation