VALTDADFUNCPROG

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODIGO int 4 null
CODCOLIGADA DCODCOLIGADA 2 null
VTABSALARIAIS.CODCOLIGADA FKVALTDADFUNCPROG_VTABSALARIAIR
PMOTMUDSAL.CODCOLIGADA FKVALTDADFUNCPROG_PMOTMUDSALR
VREQPROMOCAO.CODCOLREQUISICAO FKVALTDADFUNCPROG_VREQPROMOCAOR
PMOTMUDFUNCAO.CODCOLIGADA FKVALTDADFUNCPROG_PMOTMUDFUNCAR
PFUNC.CODCOLIGADA FKVALTDADFUNCPROG_PFUNCR
PFUNCAO.CODCOLIGADA FKVALTDADFUNCPROG_PFUNCAOR
VFAIXASALARIAL.CODCOLIGADA FKVALTDADFUNCPROG_VFAIXASALARIR
VNIVELFUNCAO.CODCOLIGADA FKVALTDADFUNCPROG_VNIVELFUNCAOR
IDREQ int 4 null
VREQPROMOCAO.IDREQ FKVALTDADFUNCPROG_VREQPROMOCAOR
SALARIO RMDVALOR2 17,2 √ null
PERCENTUALAUMENTO RMDVALOR2 17,2 √ null
CODFUNCAOALT varchar 10 √ null
PFUNCAO.CODIGO FKVALTDADFUNCPROG_PFUNCAOR
CODTABSALALT varchar 10 √ null
VTABSALARIAIS.CODTABELA FKVALTDADFUNCPROG_VTABSALARIAIR
CODNIVELALT varchar 10 √ null
VNIVELFUNCAO.CODNIVEL FKVALTDADFUNCPROG_VNIVELFUNCAOR
CODFAIXAALT varchar 10 √ null
VFAIXASALARIAL.CODFAIXA FKVALTDADFUNCPROG_VFAIXASALARIR
CODMOTMUDFUNCAO varchar 2 √ null
PMOTMUDFUNCAO.CODCLIENTE FKVALTDADFUNCPROG_PMOTMUDFUNCAR
CODMOTMUDSAL varchar 2 √ null
PMOTMUDSAL.CODCLIENTE FKVALTDADFUNCPROG_PMOTMUDSALR
DATAMINEFETIVACAO DDATETIME 16,3 null
DATAEFETIVACAO DDATETIME 16,3 √ null
STATUS char 1 √ ('P')
CHAPA DCHAPANULL 16 √ null
PFUNC.CHAPA FKVALTDADFUNCPROG_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)
PKVALTDADFUNCPROG Primary key Asc/Asc CODIGO + CODCOLIGADA

Relationships

Close relationships within degrees of separation