VREQTRANSFPROMOCAOPARECER

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLREQUISICAO DCODCOLIGADA 2 null
VTABSALARIAIS.CODCOLIGADA FKVREQTRANSFPROPARECER_VTABSALR
PMOTMUDSAL.CODCOLIGADA FKVREQTRANSFPROMPAR_PMOTMUDSALR
PMOTMUDFUNCAO.CODCOLIGADA FKVREQTRANSFPROMPAR_PMOTMUDFUNR
VREQTRANSFPROMOCAO.CODCOLREQUISICAO FKVREQTRANSFPRPAR_VREQTRANSFPRR
PFUNCAO.CODCOLIGADA FKVREQTRANSFPROPARECER_PFUNCAOR
PMOTMUDSECAO.CODCOLIGADA FKVREQTRANSFPRPAR_PMOTMUDSECAOR
PSECAO.CODCOLIGADA FKVREQTRANSFPROMPARECER_PSECAOR
VFAIXASALARIAL.CODCOLIGADA FKVREQTRANSFPROMPAR_VFAIXASALAR
GFILIAL.CODCOLIGADA FKVREQTRANSFPROPARECER_GFILIALR
VNIVELFUNCAO.CODCOLIGADA FKVREQTRANSFPROMPAR_VNIVELFUNCR
IDPARECER int 4 null
IDREQ int 4 null
VREQTRANSFPROMOCAO.IDREQ FKVREQTRANSFPRPAR_VREQTRANSFPRR
CODCOLSOLICITANTE DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKVREQTRANSFPROMPARECER_PFUNCR
CHAPASOLICITANTE varchar 16 null
PFUNC.CHAPA FKVREQTRANSFPROMPARECER_PFUNCR
PARECER MEMO 2147483647 null
CODSTATUS int 4 null
VREQSTATUS.CODCLIENTE FKVREQTRANSFPRPAREC_VREQSTATUSR
DATAPARECER datetime 16,3 null
DATAPREVISTA datetime 16,3 √ null
SUSPENSAO DLOGICO 2 null
CRIASUBSTITUICAO DLOGICO 2 null
CODFILIAL smallint 2 null
GFILIAL.CODFILIAL FKVREQTRANSFPROPARECER_GFILIALR
CODSECAO varchar 35 null
PSECAO.CODIGO FKVREQTRANSFPROMPARECER_PSECAOR
CODFUNCAO varchar 10 null
PFUNCAO.CODIGO FKVREQTRANSFPROPARECER_PFUNCAOR
CODTABELASALARIAL varchar 10 √ null
VTABSALARIAIS.CODTABELA FKVREQTRANSFPROPARECER_VTABSALR
CODNIVELSALARIAL varchar 10 √ null
VNIVELFUNCAO.CODNIVEL FKVREQTRANSFPROMPAR_VNIVELFUNCR
CODFAIXASALARIAL varchar 10 √ null
VFAIXASALARIAL.CODFAIXA FKVREQTRANSFPROMPAR_VFAIXASALAR
VLRSALARIO RMDVALOR2 17,2 √ null
CODMOTMUDFUNCAO varchar 2 √ null
PMOTMUDFUNCAO.CODCLIENTE FKVREQTRANSFPROMPAR_PMOTMUDFUNR
CODMOTMUDSALARIO varchar 2 √ null
PMOTMUDSAL.CODCLIENTE FKVREQTRANSFPROMPAR_PMOTMUDSALR
CODMOTMUDSECAO varchar 2 √ null
PMOTMUDSECAO.CODCLIENTE FKVREQTRANSFPRPAR_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
CODCOLHIERARQUIADESTINO DCODCOLIGADANULL 2 √ null
VHIERARQUIA.CODCOLIGADA FKVREQTRANSFPROMOCAOPARECER_VR
IDHIERARQUIADESTINO int 4 √ null
VHIERARQUIA.IDHIERARQUIA FKVREQTRANSFPROMOCAOPARECER_VR

Indexes

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

Relationships

Close relationships within degrees of separation