PFHSTSALFUT

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PMOTMUDSAL.CODCOLIGADA FKPFHSTSALFUT_PMOTMUDSALR
PFUNC.CODCOLIGADA FKPFHSTSALFUT_PFUNCR
PEVENTO.CODCOLIGADA FKPFHSTSALFUT_PEVENTOR
CHAPA DCHAPA 16 null
PFUNC.CHAPA FKPFHSTSALFUT_PFUNCR
DTMUDANCA datetime 16,3 null
MOTIVO varchar 2 null
PMOTMUDSAL.CODCLIENTE FKPFHSTSALFUT_PMOTMUDSALR
NROSALARIO smallint 2 null
SALARIO RMDVALOR2 17,2 √ null
JORNADA smallint 2 √ null
DATADEINCLUSAO datetime 16,3 √ null
CODEVENTO varchar 4 √ null
PEVENTO.CODIGO FKPFHSTSALFUT_PEVENTOR
DATADEREFERENCIA datetime 16,3 null
ALTERACAOJORNADA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PERCENTAPLICADO RMDVALOR2 17,2 √ null
HISTORICOTABELASALARIAL varchar 10 √ null
HISTORICODEFAIXA varchar 10 √ null
HISTORICODENIVEL varchar 10 √ null
IDAUMENTO smallint 2 ((0))
REFERENCIA RMDVALOR2 17,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)
PKPFHSTSALFUT Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + DTMUDANCA + NROSALARIO
IXPFHSTSALFUT Performance Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + DATADEREFERENCIA + NROSALARIO

Relationships

Close relationships within degrees of separation