PMOTMUDSAL

15 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PESOCIALPARAMMOTDISSIDIO.CODCOLIGADA FKPESOCIALPARAMMOTDISSIDIO_PMOR
PFHSTSAL.CODCOLIGADA FKPFHSTSAL_PMOTMUDSALR
PFHSTSALFUT.CODCOLIGADA FKPFHSTSALFUT_PMOTMUDSALR
PFRESILICAO.CODCOLIGADA FKPFRESILICAO_PMOTMUDSALR
PORCAMENTOREAJUSTESALARIAL.CODCOLIGADA FKPORCAMREAJUSTSAL_PMOTMUDSALR
PORCAMENTOREAJUSTESALCOMP.CODCOLIGADA FKPORCAMENTOREAJSALCOMP_PMOTMUR
VALTDADFUNCPROG.CODCOLIGADA FKVALTDADFUNCPROG_PMOTMUDSALR
VFLUXOREQPROMOCAO.CODCOLIGADA FKVFLUXOREQPROMOCAO_PMOTMUDSALR
VMOTIVOREQUISICAO.CODCOLIGADA FKVMOTIVOREQUISICAO_PMOTMUDSALR
VREQPROMOCAO.CODCOLREQUISICAO FKVREQPROMOCAO_PMOTMUDSALR
VREQPROMOCAOPARECER.CODCOLREQUISICAO FKVREQPROMOCPARECER_PMOTMUDSALR
VREQTIPOPARAMSMOTIVO.CODCOLIGADA FKVREQTIPOPARAMSMOTIVO_PMOTMUDR
VREQTRANSFPROMOCAO.CODCOLREQUISICAO FKVREQTRANSFPROMOCA_PMOTMUDSALR
VREQTRANSFPROMOCAOPARECER.CODCOLREQUISICAO FKVREQTRANSFPROMPAR_PMOTMUDSALR
VTRANSFALTDADFUNCPROG.CODCOLIGADA FKVTRANSFALTDADFUNCPROG_PMOTMR
GCOLIGADA.CODCOLIGADA FKPMOTMUDSAL_GCOLIGADAR
CODCLIENTE varchar 2 null
PESOCIALPARAMMOTDISSIDIO.MOTDISSIDIO FKPESOCIALPARAMMOTDISSIDIO_PMOR
PFHSTSAL.MOTIVO FKPFHSTSAL_PMOTMUDSALR
PFHSTSALFUT.MOTIVO FKPFHSTSALFUT_PMOTMUDSALR
PFRESILICAO.MOTMUDANCASALARIO FKPFRESILICAO_PMOTMUDSALR
PORCAMENTOREAJUSTESALARIAL.CODMOTIVO FKPORCAMREAJUSTSAL_PMOTMUDSALR
PORCAMENTOREAJUSTESALCOMP.CODMOTIVO FKPORCAMENTOREAJSALCOMP_PMOTMUR
VALTDADFUNCPROG.CODMOTMUDSAL FKVALTDADFUNCPROG_PMOTMUDSALR
VFLUXOREQPROMOCAO.CODCLIENTEMUDSAL FKVFLUXOREQPROMOCAO_PMOTMUDSALR
VMOTIVOREQUISICAO.MOTIVOLABORE FKVMOTIVOREQUISICAO_PMOTMUDSALR
VREQPROMOCAO.CODMOTMUDSALARIO FKVREQPROMOCAO_PMOTMUDSALR
VREQPROMOCAOPARECER.CODMOTMUDSALARIO FKVREQPROMOCPARECER_PMOTMUDSALR
VREQTIPOPARAMSMOTIVO.CODCLIENTE FKVREQTIPOPARAMSMOTIVO_PMOTMUDR
VREQTRANSFPROMOCAO.CODMOTMUDSALARIO FKVREQTRANSFPROMOCA_PMOTMUDSALR
VREQTRANSFPROMOCAOPARECER.CODMOTMUDSALARIO FKVREQTRANSFPROMPAR_PMOTMUDSALR
VTRANSFALTDADFUNCPROG.CODMOTMUDSAL FKVTRANSFALTDADFUNCPROG_PMOTMR
CODINTERNO varchar 2 null
PTPFINAGRI.CODINTERNO Implied ConstraintR
DESCRICAO varchar 50 √ null
PODEALTERAR smallint 2 √ null
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)
PKPMOTMUDSAL Primary key Asc/Asc CODCOLIGADA + CODCLIENTE

Relationships

Close relationships within degrees of separation