PFSALCMP

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PEVTRELACSALCMP.CODCOLIGADA FKPEVTRELACSALCMP_PFSALCMPR
PFSALCMPCC.CODCOLIGADA FKPFSALCMPCC_PFSALCMPR
PCCUSTO.CODCOLIGADA FKPFSALCMP_PCCUSTOR
PFUNC.CODCOLIGADA FKPFSALCMP_PFUNCR
PEVENTO.CODCOLIGADA FKPFSALCMP_PEVENTOR
CHAPA DCHAPA 16 null
PEVTRELACSALCMP.CHAPA FKPEVTRELACSALCMP_PFSALCMPR
PFSALCMPCC.CHAPA FKPFSALCMPCC_PFSALCMPR
PFUNC.CHAPA FKPFSALCMP_PFUNCR
CODEVENTO varchar 4 null
PEVTRELACSALCMP.CODEVENTOSALCMP FKPEVTRELACSALCMP_PFSALCMPR
PFSALCMPCC.CODEVENTO FKPFSALCMPCC_PFSALCMPR
PEVENTO.CODIGO FKPFSALCMP_PEVENTOR
NROSALARIO smallint 2 null
JORNADA smallint 2 √ null
VALOR RMDVALOR2 17,2 √ null
CODCCUSTO varchar 25 √ null
PCCUSTO.CODCCUSTO FKPFSALCMP_PCCUSTOR
INICIOVIGENCIA datetime 16,3 √ null
FIMVIGENCIA datetime 16,3 √ null
VALORESFORCADOS smallint 2 √ null
REFERENCIA RMDVALOR2 17,2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODNIVELSAL varchar 10 √ null
CODFAIXASAL varchar 10 √ null
CODTABELA varchar 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPFSALCMP Primary key Asc/Asc/Asc CODCOLIGADA + CHAPA + CODEVENTO
PXPFUNCNROSALARIO Must be unique Asc/Asc/Asc CODCOLIGADA + CHAPA + NROSALARIO

Relationships

Close relationships within degrees of separation