PFDEPEND

43 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFDEPENDCOMPL.CODCOLIGADA FKPFDEPENDCOMPL_PFDEPENDR
PFDEPEVENTOS.CODCOLIGADA FKPFDEPEVENTOS_PFDEPENDR
PFDEPIRRFDED.CODCOLIGADA FKPFDEPIRRFDED_PFDEPENDR
PFDEPMOV.CODCOLIGADA FKPFDEPMOV_PFDEPENDR
PFREEMBOLSOOPERADORA.CODCOLIGADA FKPFREEMBOLSOOPERADORA_PFDEPENR
VBENEFCARTAO.CODCOLIGADA FKVBENEFCARTAO_PFDEPENDR
VBENEFDEPEND.CODCOLIGADA FKVBENEFDEPEND_PFDEPENDR
VBENEFVINCDEPEND.CODCOLIGADA FKVBENEFVINCDEPEND_PFDEPENDR
VHISTBENEFDEPEND.CODCOLIGADA FKVHISTBENEFDEPEND_PFDEPENDR
VHISTBENEFVINCDEPEND.CODCOLIGADA FKVHISTBENEFVINCDEPEND_PFDEPENR
VREQBENEFICIO.CODCOLIGADA FKVREQBENEFICIO_PFDEPENDR
PFUNC.CODCOLIGADA FKPFDEPEND_PFUNCR
GFORMULA.CODCOLIGADA PKPFDEPEND_GFORMPENSAOR
CHAPA DCHAPA 16 null
PFDEPENDCOMPL.CHAPA FKPFDEPENDCOMPL_PFDEPENDR
PFDEPEVENTOS.CHAPA FKPFDEPEVENTOS_PFDEPENDR
PFDEPIRRFDED.CHAPA FKPFDEPIRRFDED_PFDEPENDR
PFDEPMOV.CHAPA FKPFDEPMOV_PFDEPENDR
PFREEMBOLSOOPERADORA.CHAPA FKPFREEMBOLSOOPERADORA_PFDEPENR
VBENEFCARTAO.CHAPA FKVBENEFCARTAO_PFDEPENDR
VBENEFDEPEND.CHAPA FKVBENEFDEPEND_PFDEPENDR
VBENEFVINCDEPEND.CHAPA FKVBENEFVINCDEPEND_PFDEPENDR
VHISTBENEFDEPEND.CHAPA FKVHISTBENEFDEPEND_PFDEPENDR
VHISTBENEFVINCDEPEND.CHAPA FKVHISTBENEFVINCDEPEND_PFDEPENR
VREQBENEFICIO.CHAPA FKVREQBENEFICIO_PFDEPENDR
PFUNC.CHAPA FKPFDEPEND_PFUNCR
NRODEPEND smallint 2 null
PFDEPENDCOMPL.NRODEPEND FKPFDEPENDCOMPL_PFDEPENDR
PFDEPEVENTOS.NRODEPEND FKPFDEPEVENTOS_PFDEPENDR
PFDEPIRRFDED.NRODEPEND FKPFDEPIRRFDED_PFDEPENDR
PFDEPMOV.NRODEPEND FKPFDEPMOV_PFDEPENDR
PFREEMBOLSOOPERADORA.NRODEPEND FKPFREEMBOLSOOPERADORA_PFDEPENR
VBENEFCARTAO.NRODEPEND FKVBENEFCARTAO_PFDEPENDR
VBENEFDEPEND.NRODEPEND FKVBENEFDEPEND_PFDEPENDR
VBENEFVINCDEPEND.NRODEPEND FKVBENEFVINCDEPEND_PFDEPENDR
VHISTBENEFDEPEND.NRODEPEND FKVHISTBENEFDEPEND_PFDEPENDR
VHISTBENEFVINCDEPEND.NRODEPEND FKVHISTBENEFVINCDEPEND_PFDEPENR
VREQBENEFICIO.NRODEPEND FKVREQBENEFICIO_PFDEPENDR
NOME varchar 120 √ null
CPF varchar 12 √ null
DTNASCIMENTO datetime 16,3 √ null
SEXO varchar 1 √ null
PCODSEXO.CODCLIENTE FKPFDEPEND_PCODSEXOR
ESTADOCIVIL varchar 1 √ null
PCODESTCIVIL.CODCLIENTE FKPFDEPEND_PCODESTCIVILR
LOCALNASCIMENTO varchar 32 √ null
CARTORIO varchar 40 √ null
NROREGISTRO varchar 10 √ null
NROLIVRO varchar 8 √ null
NROFOLHA varchar 5 √ null
INCIRRF smallint 2 √ null
INCINSS smallint 2 √ null
INCASSISTMEDICA smallint 2 √ null
INCPENSAO smallint 2 √ null
INCDEFINIVEIS varchar 20 √ null
GRAUPARENTESCO char 1 √ null
PCODPARENT.CODCLIENTE FKPFDEPEND_PCODPARENTR
CARTAOVACINA smallint 2 √ (0)
PERCENTUAL RMDVALOR2 17,2 √ null
TIPOPENSAO smallint 2 √ null
PTPPENSAO.CODCLIENTE FKPFDEPEND_PTPPENSAOR
BANCO varchar 3 √ null
GAGENCIA.NUMBANCO FKPFDEPEND_GAGENCIAR
GBANCO.NUMBANCO FKPFDEPEND_GBANCOR
AGENCIA varchar 6 √ null
GAGENCIA.NUMAGENCIA FKPFDEPEND_GAGENCIAR
CONTACORRENTE varchar 15 √ null
RESPONSAVEL varchar 45 √ null
APLICACAO varchar 1 √ null
GFORMULA.APLICACAO FKPFDEPEND_GFORMULAR
FORCALCULO varchar 8 √ null
GFORMULA.CODIGO FKPFDEPEND_GFORMULAR
BRUTO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
DATAENTREGACERTIDAO datetime 16,3 √ null
FREQESCOLAR DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
UNIVERSITARIO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
INCSALFAM DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
OBSERVACAO varchar 80 √ null
FORMPENSAO varchar 8 √ null
GFORMULA.CODIGO PKPFDEPEND_GFORMPENSAOR
DATAINICIODESCPENSAO datetime 16,3 √ null
CODCOLFORNEC DCODCOLIGADANULL 2 √ null
FCFO.CODCOLIGADA FKPFDEPEND_FCFOR
CODFORNECEDOR varchar 25 √ null
FCFO.CODCFO FKPFDEPEND_FCFOR
OPBANCARIA varchar 10 √ null
VALORFIXO RMDVALOR2 17,2 √ null
ID int identity 4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
NUMEROCARTAOSUS varchar 100 √ null
NUMDECLARANASCVIVO varchar 20 √ null
DATAFIMDESCPENSAO datetime2 16,7 √ null
DEPENDENTEBENEFICIARIOINCAPAZ smallint 2 √ null
DESCRICAODEPENDENCIA varchar 100 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPFDEPEND Primary key Asc/Asc/Asc CODCOLIGADA + CHAPA + NRODEPEND
PXFDEPENDID Must be unique Asc ID

Relationships

Close relationships within degrees of separation