PFHSTASSMED

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFHSTASSMEDCOPART.CODCOLIGADA FKPFHSTASSMEDCOPART_PFHSTASSMER
PFUNC.CODCOLIGADA FKPFHSTASSMED_PFUNCR
PEVENTO.CODCOLIGADA FKPFHSTASSMED_PEVENTOR
CHAPA DCHAPA 16 null
PFHSTASSMEDCOPART.CHAPA FKPFHSTASSMEDCOPART_PFHSTASSMER
PFUNC.CHAPA FKPFHSTASSMED_PFUNCR
ANOCOMP smallint 2 null
PFHSTASSMEDCOPART.ANOCOMP FKPFHSTASSMEDCOPART_PFHSTASSMER
MESCOMP smallint 2 null
PFHSTASSMEDCOPART.MESCOMP FKPFHSTASSMEDCOPART_PFHSTASSMER
NROPERIODO smallint 2 null
PFHSTASSMEDCOPART.NROPERIODO FKPFHSTASSMEDCOPART_PFHSTASSMER
NRODEPEND smallint 2 null
PFHSTASSMEDCOPART.NRODEPEND FKPFHSTASSMEDCOPART_PFHSTASSMER
CODEVENTO varchar 4 null
PFHSTASSMEDCOPART.CODEVENTO FKPFHSTASSMEDCOPART_PFHSTASSMER
PEVENTO.CODIGO FKPFHSTASSMED_PEVENTOR
TIPOVALOR smallint 2 null
PFHSTASSMEDCOPART.TIPOVALOR FKPFHSTASSMEDCOPART_PFHSTASSMER
DTPAGTO DDATETIME 16,3 null
ANOREF smallint 2 √ null
MESREF smallint 2 √ null
PERIODOREF smallint 2 √ null
VALOR RMDVALOR2 17,2 √ null
VALORORIGINAL RMDVALOR2 17,2 √ null
FOIALTERADO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODEVENTOFERIAS varchar 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPFHSTASSMED Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + ANOCOMP + MESCOMP + NROPERIODO + NRODEPEND + CODEVENTO + TIPOVALOR

Relationships

Close relationships within degrees of separation