PFATIVREMUNERADA

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFATIVREMUNERADACC.CODCOLIGADA FKPFATIVREMUNCC_PFATIVREMUNR
PFUNC.CODCOLIGADA FKPFATIVREMUNERADA_PFUNCR
PEVENTO.CODCOLIGADA FKPFATIVREMUNERADA_PEVENTOR
CHAPA DCHAPA 16 null
PFATIVREMUNERADACC.CHAPA FKPFATIVREMUNCC_PFATIVREMUNR
PFUNC.CHAPA FKPFATIVREMUNERADA_PFUNCR
CODEVENTO varchar 4 null
PFATIVREMUNERADACC.CODEVENTO FKPFATIVREMUNCC_PFATIVREMUNR
PEVENTO.CODIGO FKPFATIVREMUNERADA_PEVENTOR
NROATIVIDADE smallint 2 null
PFATIVREMUNERADACC.NROATIVIDADE FKPFATIVREMUNCC_PFATIVREMUNR
JORNADA smallint 2 √ null
VALOR RMDVALOR2 17,2 √ null
INICIOVIGENCIA datetime 16,3 √ null
FIMVIGENCIA datetime 16,3 √ null
VALORESFORCADOS smallint 2 √ null
REFERENCIA 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)
PKPFATIVREMUNERADA Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + CODEVENTO + NROATIVIDADE

Relationships

Close relationships within degrees of separation