dbo.mis_aportes

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 (~)	7869177
Created	9/18/2017 5:29:07 PM
Last Modified	2/9/2025 4:18:36 AM

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
	id_aportes	int	4	10	0	True	1 - 1		False	False
	cuit	varchar	13	0	0	False			False	False
2	cuit_empleador	varchar	13	0	0	False			False	False
	pagina	smallint	2	5	0	False			False	False
4	periodo	int	4	10	0	False			False	False
	ddjj	varchar	20	0	0	False			False	False
2	aportes_ss	varchar	20	0	0	False			False	False
	aportes_os	varchar	20	0	0	False			False	False
	contr_patronal	varchar	20	0	0	False			False	False
2	inserted	datetime	8	23	3	True		(getdate())	False	False
	detalle_error	text		0	0	False			False	False
	source_html	text		0	0	False			False	False

Indexes

Name	Columns	Unique
idxAportesEmpleador	periodo, aportes_ss, inserted	False
idxAportesEmpleador2	cuit_empleador, periodo, aportes_ss, inserted	False
idxMisAportesCaptcha	cuit, periodo	False
idxMisAportesEmpleador2025	cuit_empleador, periodo	False
PK__mis_apor__C67EED0E0B4D0307	id_aportes	True

SQL Script

Copy

CREATE TABLE dbo.mis_aportes (
  id_aportes int IDENTITY,
  cuit varchar(13) NULL,
  cuit_empleador varchar(13) NULL,
  pagina smallint NULL,
  periodo int NULL,
  ddjj varchar(20) NULL,
  aportes_ss varchar(20) NULL,
  aportes_os varchar(20) NULL,
  contr_patronal varchar(20) NULL,
  inserted datetime NOT NULL DEFAULT (getdate()),
  detalle_error text NULL,
  source_html text NULL,
  PRIMARY KEY CLUSTERED (id_aportes) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

CREATE INDEX idxAportesEmpleador
  ON dbo.mis_aportes (periodo, aportes_ss, inserted)
  INCLUDE (cuit_empleador)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxAportesEmpleador2
  ON dbo.mis_aportes (cuit_empleador, periodo, aportes_ss, inserted)
  INCLUDE (id_aportes)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxMisAportesCaptcha
  ON dbo.mis_aportes (cuit, periodo)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxMisAportesEmpleador2025
  ON dbo.mis_aportes (cuit_empleador, periodo)
  INCLUDE (ddjj, aportes_ss, aportes_os)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas