PFHSTASSMEDCOPART

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKPFHSTASSMEDCOPART_PFUNCR
VBENEFICIOS.CODCOLIGADA FKPFHSTASSMEDCOPART_VBENEFICIOR
PEVENTO.CODCOLIGADA FKPFHSTASSMEDCOPART_PEVENTOR
PFHSTASSMED.CODCOLIGADA FKPFHSTASSMEDCOPART_PFHSTASSMER
CHAPA DCHAPA 16 null
PFUNC.CHAPA FKPFHSTASSMEDCOPART_PFUNCR
PFHSTASSMED.CHAPA FKPFHSTASSMEDCOPART_PFHSTASSMER
ANOCOMP smallint 2 null
PFHSTASSMED.ANOCOMP FKPFHSTASSMEDCOPART_PFHSTASSMER
MESCOMP smallint 2 null
PFHSTASSMED.MESCOMP FKPFHSTASSMEDCOPART_PFHSTASSMER
NROPERIODO smallint 2 null
PFHSTASSMED.NROPERIODO FKPFHSTASSMEDCOPART_PFHSTASSMER
NRODEPEND smallint 2 null
PFHSTASSMED.NRODEPEND FKPFHSTASSMEDCOPART_PFHSTASSMER
CODEVENTO varchar 4 null
PFHSTASSMED.CODEVENTO FKPFHSTASSMEDCOPART_PFHSTASSMER
PEVENTO.CODIGO FKPFHSTASSMEDCOPART_PEVENTOR
TIPOVALOR smallint 2 null
PFHSTASSMED.TIPOVALOR FKPFHSTASSMEDCOPART_PFHSTASSMER
DTATENDIMENTO datetime2 16,7 null
CODBENEFICIO varchar 10 null
VBENEFICIOS.CODBENEFICIO FKPFHSTASSMEDCOPART_VBENEFICIOR
VALOR RMDVALOR2 17,2 √ null
CODENTIDADE varchar 16 √ null
VENTIDADES.CODENTIDADE FKPFHSTASSMEDCOPART_VENTIDADESR
ESPECIALIDADE varchar 100 √ null
CODCID varchar 10 √ null
VCID.CID FKPFHSTASSMEDCOPART_VCIDR
CODTPATENDIMENTO smallint 2 √ null
PTPATENDICOPART.CODCLIENTE FKPFHSTASSMEDCOPART_PTPATENDICR
QTDEUTILIZADA DVALOR2 17,2 √ null
DESCATENDIMENTO varchar 300 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime2 16,7 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime2 16,7 √ null

Indexes

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

Relationships

Close relationships within degrees of separation