VTRANSFALTDADFUNCPROG

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODIGO int 4 null
CODCOLIGADA DCODCOLIGADA 2 null
VTABSALARIAIS.CODCOLIGADA FKVTRANSFALTDADFUNCPROG_VTABSAR
PMOTMUDSAL.CODCOLIGADA FKVTRANSFALTDADFUNCPROG_PMOTMR
PMOTMUDFUNCAO.CODCOLIGADA FKVTRANSFALTDADFUNCPROG_PMOTMUR
PFUNC.CODCOLIGADA FKVTRANSFALTDADFUNCPROG_PFUNCR
VREQTRANSFPROMOCAO.CODCOLREQUISICAO FKVTRANSFALTDADFUNCPROG_VREQTRR
PFUNCAO.CODCOLIGADA FKVTRANSFALTDADFUNCPROG_PFUNCAR
VFAIXASALARIAL.CODCOLIGADA FKVTRANSFALTDADFUNCPROG_VFAIXAR
VNIVELFUNCAO.CODCOLIGADA FKVTRANSFALTDADFUNCPROG_VNIVELR
IDREQ int 4 null
VREQTRANSFPROMOCAO.IDREQ FKVTRANSFALTDADFUNCPROG_VREQTRR
SALARIO RMDVALOR2 17,2 √ null
PERCENTUALAUMENTO RMDVALOR2 17,2 √ null
CODFUNCAOALT varchar 10 √ null
PFUNCAO.CODIGO FKVTRANSFALTDADFUNCPROG_PFUNCAR
CODTABSALALT varchar 10 √ null
VTABSALARIAIS.CODTABELA FKVTRANSFALTDADFUNCPROG_VTABSAR
CODNIVELALT varchar 10 √ null
VNIVELFUNCAO.CODNIVEL FKVTRANSFALTDADFUNCPROG_VNIVELR
CODFAIXAALT varchar 10 √ null
VFAIXASALARIAL.CODFAIXA FKVTRANSFALTDADFUNCPROG_VFAIXAR
CODMOTMUDFUNCAO varchar 2 √ null
PMOTMUDFUNCAO.CODCLIENTE FKVTRANSFALTDADFUNCPROG_PMOTMUR
CODMOTMUDSAL varchar 2 √ null
PMOTMUDSAL.CODCLIENTE FKVTRANSFALTDADFUNCPROG_PMOTMR
DATAMINEFETIVACAO DDATETIME 16,3 null
DATAEFETIVACAO DDATETIME 16,3 √ null
STATUS char 1 √ ('P')
CHAPA DCHAPANULL 16 √ null
PFUNC.CHAPA FKVTRANSFALTDADFUNCPROG_PFUNCR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKVTRANSFALTDADFUNCPROG Primary key Asc/Asc CODIGO + CODCOLIGADA

Relationships

Close relationships within degrees of separation