dbo.gdl_entidad_scoring

Description

Properties

Name	Value
File Collation
File Group
Filestream File Group
Is Partitioned	False
Partitioned Column
Partition Scheme
File Groups
Filestream Partition Scheme
Filestream File Groups
Heap	False
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	0
Created	3/6/2025 6:55:53 PM
Last Modified	3/6/2025 6:55:53 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Computed	Persisted
entidad_juridica	int	4	10	0	True	False	False
score_version	int	4	10	0	True	False	False
rubro	int	4	10	0	False	False	False
ultimo_balance	smalldatetime	4	16	0	False	False	False
fecha_version	datetime	8	23	3	True	False	False
score01	float	8	53	0	False	False	False
score01_clr	varchar	1	0	0	False	False	False
score02	float	8	53	0	False	False	False
score02_clr	varchar	1	0	0	False	False	False
score03	float	8	53	0	False	False	False
score03_clr	varchar	1	0	0	False	False	False
score04	float	8	53	0	False	False	False
score04_clr	varchar	1	0	0	False	False	False
score05	float	8	53	0	False	False	False
score05_clr	varchar	1	0	0	False	False	False
solvencia	float	8	53	0	False	False	False
solvencia_clr	varchar	1	0	0	False	False	False
deuda_corriente	float	8	53	0	False	False	False
deuda_corriente_clr	varchar	1	0	0	False	False	False
rentabilidad	float	8	53	0	False	False	False
rentabilidad_clr	varchar	1	0	0	False	False	False
liquidez_acida	float	8	53	0	False	False	False
liquidez_acida_clr	varchar	1	0	0	False	False	False
liquidez_corriente	float	8	53	0	False	False	False
liquidez_corriente_clr	varchar	1	0	0	False	False	False
bancario	float	8	53	0	False	False	False
bancario_clr	varchar	1	0	0	False	False	False
ref_clientes	float	8	53	0	False	False	False
ref_clientes_clr	varchar	1	0	0	False	False	False
informe_base	float	8	53	0	False	False	False
informe_base_clr	varchar	1	0	0	False	False	False
score_balance	float	8	53	0	False	False	False
score_balance_clr	varchar	1	0	0	False	False	False
analisis_disc	float	8	53	0	False	False	False
analisis_disc_clr	varchar	1	0	0	False	False	False
asp_formales	float	8	53	0	False	False	False
asp_formales_clr	varchar	1	0	0	False	False	False
scoring_final	float	8	53	0	False	False	False
scoring_final_clr	varchar	1	0	0	False	False	False
conclusion	varchar	2	0	0	False	False	False
antig_flota	tinyint	1	3	0	False	False	False
dependencia_economica	float	8	53	0	False	False	False
compliance	float	8	53	0	False	False	False
compliance_clr	varchar	1	0	0	False	False	False
informe_comercial	float	8	53	0	False	False	False
informe_comercial_clr	varchar	1	0	0	False	False	False
valoracion_ic	float	8	53	0	False	False	False
valoracion_ic_clr	varchar	1	0	0	False	False	False
dependencia_calculada	tinyint	1	3	0	False	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__gdl_enti__286BDD3B798C1125	entidad_juridica, score_version	True

SQL Script

Copy

CREATE TABLE dbo.gdl_entidad_scoring_historico (
  entidad_juridica int NOT NULL,
  score_version int NOT NULL,
  rubro int NULL,
  ultimo_balance smalldatetime NULL,
  fecha_version datetime NOT NULL,
  score01 float NULL,
  score01_clr varchar(1) NULL,
  score02 float NULL,
  score02_clr varchar(1) NULL,
  score03 float NULL,
  score03_clr varchar(1) NULL,
  score04 float NULL,
  score04_clr varchar(1) NULL,
  score05 float NULL,
  score05_clr varchar(1) NULL,
  solvencia float NULL,
  solvencia_clr varchar(1) NULL,
  deuda_corriente float NULL,
  deuda_corriente_clr varchar(1) NULL,
  rentabilidad float NULL,
  rentabilidad_clr varchar(1) NULL,
  liquidez_acida float NULL,
  liquidez_acida_clr varchar(1) NULL,
  liquidez_corriente float NULL,
  liquidez_corriente_clr varchar(1) NULL,
  bancario float NULL,
  bancario_clr varchar(1) NULL,
  ref_clientes float NULL,
  ref_clientes_clr varchar(1) NULL,
  informe_base float NULL,
  informe_base_clr varchar(1) NULL,
  score_balance float NULL,
  score_balance_clr varchar(1) NULL,
  analisis_disc float NULL,
  analisis_disc_clr varchar(1) NULL,
  asp_formales float NULL,
  asp_formales_clr varchar(1) NULL,
  scoring_final float NULL,
  scoring_final_clr varchar(1) NULL,
  conclusion varchar(2) NULL,
  antig_flota tinyint NULL,
  dependencia_economica float NULL,
  compliance float NULL,
  compliance_clr varchar(1) NULL,
  informe_comercial float NULL,
  informe_comercial_clr varchar(1) NULL,
  valoracion_ic float NULL,
  valoracion_ic_clr varchar(1) NULL,
  dependencia_calculada tinyint NULL,
  CONSTRAINT PK__gdl_enti__286BDD3B798C1125 PRIMARY KEY CLUSTERED (entidad_juridica, score_version) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found