namespace Remuneraciones.DataModel
{
	public class Schema
	{
		#region Comuna
		public struct Comuna
		{
			public const string SP_SELECT_BY_PK = "uSp_FindComuna";
			
		}
		#endregion

		#region Ciudad
		public struct Ciudad
		{
			public const string SP_SELECT_BY_PK = "uSp_FindCiudad";
			
		}
		#endregion

		#region Trabajador
		public struct Trabajador
		{
			public const string SP_SELECT_ALL = "uSp_TrabajadorSelectAll";
			public const string SP_SELECT_BY_PK = "uSp_FindTrabajador";
			public const string SP_SELECT_BY_CODIGO = "uSp_FindTrabajador";
			public const string SP_INSERT = "uSp_TrabajadorSave";
			public const string SP_UPDATE = "uSp_TrabajadorSave";
			public const string SP_DELETE = "uSp_TrabajadorDelete";
			public const string SP_SELECT_BROWSE = "wSp_BrowseTrabajador";
			public const string SP_SELECT_CTA_CTE = "uSp_BrowseTrabajadorCtaCte";
			public const string SP_SELECT_APV = "uSp_BrowseAPVTrabajador";
			public const string SP_SELECT_BY_RUT = "wSp_FindTrabajadorByRut";
			public const string SP_SELECT_BY_RUT_DS = "wSp_FindTrabajadorByRutDS";

			public struct IdNumero
			{
				public const string FieldName = "IdNumero";
				public const string DisplayName = "IdNumero";
				public const int Length = 3;
			}

			public struct Mes
			{
				public const string FieldName = "Mes";
				public const string DisplayName = "Mes";
				public const int Length = 2;
			}

			public struct IdTrabajador
			{
				public const string FieldName = "IdTrabajador";
				public const string DisplayName = "IdTrabajador";
				public const int Length = 8;
			}

			public struct idCargo
			{
				public const string FieldName = "idCargo";
				public const string DisplayName = "idCargo";
				public const int Length = 3;
			}

			public struct idPais
			{
				public const string FieldName = "idPais";
				public const string DisplayName = "idPais";
				public const int Length = 4;
			}

			public struct idSucursal
			{
				public const string FieldName = "idSucursal";
				public const string DisplayName = "idSucursal";
				public const int Length = 3;
			}

			public struct idAfp
			{
				public const string FieldName = "idAfp";
				public const string DisplayName = "idAfp";
				public const int Length = 4;
			}

			public struct IdAfpInp
			{
				public const string FieldName = "IdAfpInp";
				public const string DisplayName = "IdAfpInp";
				public const int Length = 4;
			}

			public struct IdIsapre
			{
				public const string FieldName = "IdIsapre";
				public const string DisplayName = "IdIsapre";
				public const int Length = 4;
			}

			public struct idHorario
			{
				public const string FieldName = "idHorario";
				public const string DisplayName = "idHorario";
				public const int Length = 3;
			}

			public struct idCentro
			{
				public const string FieldName = "idCentro";
				public const string DisplayName = "idCentro";
				public const int Length = 5;
			}

			public struct IdUnidad
			{
				public const string FieldName = "IdUnidad";
				public const string DisplayName = "IdUnidad";
				public const int Length = 3;
			}

			public struct idSindicatos
			{
				public const string FieldName = "idSindicatos";
				public const string DisplayName = "idSindicatos";
				public const int Length = 3;
			}

			public struct Nombre
			{
				public const string FieldName = "Nombre";
				public const string DisplayName = "Nombre";
				public const int Length = 30;
			}

			public struct Paterno
			{
				public const string FieldName = "Paterno";
				public const string DisplayName = "Paterno";
				public const int Length = 20;
			}

			public struct Materno
			{
				public const string FieldName = "Materno";
				public const string DisplayName = "Materno";
				public const int Length = 20;
			}

			public struct Rut
			{
				public const string FieldName = "Rut";
				public const string DisplayName = "Rut";
				public const int Length = 4;
			}

			public struct Dv
			{
				public const string FieldName = "Dv";
				public const string DisplayName = "Dv";
				public const int Length = 1;
			}

			public struct Direccion
			{
				public const string FieldName = "Direccion";
				public const string DisplayName = "Direccion";
				public const int Length = 50;
			}

			public struct Mail
			{
				public const string FieldName = "Mail";
				public const string DisplayName = "Mail";
				public const int Length = 100;
			}

			public struct IdComuna
			{
				public const string FieldName = "IdComuna";
				public const string DisplayName = "IdComuna";
				public const int Length = 3;
			}

			public struct EstadoCivil
			{
				public const string FieldName = "EstadoCivil";
				public const string DisplayName = "EstadoCivil";
				public const int Length = 1;
			}

			public struct Nacionalidad
			{
				public const string FieldName = "Nacionalidad";
				public const string DisplayName = "Nacionalidad";
				public const int Length = 1;
			}

			public struct HoraEntrada
			{
				public const string FieldName = "HoraEntrada";
				public const string DisplayName = "HoraEntrada";
				public const int Length = 8;
			}

			public struct HoraSalida
			{
				public const string FieldName = "HoraSalida";
				public const string DisplayName = "HoraSalida";
				public const int Length = 8;
			}

			public struct TiempoColacion
			{
				public const string FieldName = "TiempoColacion";
				public const string DisplayName = "TiempoColacion";
				public const int Length = 8;
			}

			public struct Telefono
			{
				public const string FieldName = "Telefono";
				public const string DisplayName = "Telefono";
				public const int Length = 30;
			}

			public struct AfpIndemnizacion
			{
				public const string FieldName = "AfpIndemnizacion";
				public const string DisplayName = "AfpIndemnizacion";
				public const int Length = 4;
			}

			public struct AportIndemnizacion
			{
				public const string FieldName = "AportIndemnizacion";
				public const string DisplayName = "AportIndemnizacion";
				public const int Length = 1;
			}

			public struct TipoSueldo
			{
				public const string FieldName = "TipoSueldo";
				public const string DisplayName = "TipoSueldo";
				public const int Length = 1;
			}

			public struct TipoContrato
			{
				public const string FieldName = "TipoContrato";
				public const string DisplayName = "TipoContrato";
				public const int Length = 1;
			}

			public struct CalculoSueldo
			{
				public const string FieldName = "CalculoSueldo";
				public const string DisplayName = "CalculoSueldo";
				public const int Length = 1;
			}

			public struct Profesion
			{
				public const string FieldName = "Profesion";
				public const string DisplayName = "Profesion";
				public const int Length = 40;
			}

			public struct Sexo
			{
				public const string FieldName = "Sexo";
				public const string DisplayName = "Sexo";
				public const int Length = 1;
			}

			public struct FecNaci
			{
				public const string FieldName = "FecNaci";
				public const string DisplayName = "FecNaci";
				public const int Length = 8;
			}

			public struct FecIng
			{
				public const string FieldName = "FecIng";
				public const string DisplayName = "FecIng";
				public const int Length = 8;
			}

			public struct FecReconoce
			{
				public const string FieldName = "FecReconoce";
				public const string DisplayName = "FecReconoce";
				public const int Length = 8;
			}

			public struct FechaTermino
			{
				public const string FieldName = "FechaTermino";
				public const string DisplayName = "FechaTermino";
				public const int Length = 8;
			}

			public struct ModoApv
			{
				public const string FieldName = "ModoApv";
				public const string DisplayName = "ModoApv";
				public const int Length = 2;
			}

			public struct MontoApv
			{
				public const string FieldName = "MontoApv";
				public const string DisplayName = "MontoApv";
				public const int Length = 8;
			}

			public struct ModoAhorro
			{
				public const string FieldName = "ModoAhorro";
				public const string DisplayName = "ModoAhorro";
				public const int Length = 2;
			}

			public struct MontoAhorro
			{
				public const string FieldName = "MontoAhorro";
				public const string DisplayName = "MontoAhorro";
				public const int Length = 8;
			}

			public struct Jubilado
			{
				public const string FieldName = "Jubilado";
				public const string DisplayName = "Jubilado";
				public const int Length = 1;
			}

			public struct ModoPactado
			{
				public const string FieldName = "ModoPactado";
				public const string DisplayName = "ModoPactado";
				public const int Length = 2;
			}

			public struct MontoPactado
			{
				public const string FieldName = "MontoPactado";
				public const string DisplayName = "MontoPactado";
				public const int Length = 8;
			}

			public struct ModoCotiAdicional
			{
				public const string FieldName = "ModoCotiAdicional";
				public const string DisplayName = "ModoCotiAdicional";
				public const int Length = 2;
			}

			public struct MontoCotAdicional
			{
				public const string FieldName = "MontoCotAdicional";
				public const string DisplayName = "MontoCotAdicional";
				public const int Length = 8;
			}

			public struct ModoLey18566
			{
				public const string FieldName = "ModoLey18566";
				public const string DisplayName = "ModoLey18566";
				public const int Length = 2;
			}

			public struct MontoLey18566
			{
				public const string FieldName = "MontoLey18566";
				public const string DisplayName = "MontoLey18566";
				public const int Length = 8;
			}

			public struct ModoSueldo
			{
				public const string FieldName = "ModoSueldo";
				public const string DisplayName = "ModoSueldo";
				public const int Length = 1;
			}

			public struct MontoSueldo
			{
				public const string FieldName = "MontoSueldo";
				public const string DisplayName = "MontoSueldo";
				public const int Length = 8;
			}

			public struct SueldoBase
			{
				public const string FieldName = "SueldoBase";
				public const string DisplayName = "SueldoBase";
				public const int Length = 4;
			}

			public struct Colacion
			{
				public const string FieldName = "Colacion";
				public const string DisplayName = "Colacion";
				public const int Length = 4;
			}

			public struct Movilizacion
			{
				public const string FieldName = "Movilizacion";
				public const string DisplayName = "Movilizacion";
				public const int Length = 4;
			}

			public struct TipoGratificacion
			{
				public const string FieldName = "TipoGratificacion";
				public const string DisplayName = "TipoGratificacion";
				public const int Length = 2;
			}

			public struct MontoGratificacion
			{
				public const string FieldName = "MontoGratificacion";
				public const string DisplayName = "MontoGratificacion";
				public const int Length = 4;
			}

			public struct TramoCargas
			{
				public const string FieldName = "TramoCargas";
				public const string DisplayName = "TramoCargas";
				public const int Length = 1;
			}

			public struct Cargas
			{
				public const string FieldName = "Cargas";
				public const string DisplayName = "Cargas";
				public const int Length = 2;
			}

			public struct CargasInvalides
			{
				public const string FieldName = "CargasInvalides";
				public const string DisplayName = "CargasInvalides";
				public const int Length = 2;
			}

			public struct CargasMaternales
			{
				public const string FieldName = "CargasMaternales";
				public const string DisplayName = "CargasMaternales";
				public const int Length = 1;
			}

			public struct CargasRetroactivas
			{
				public const string FieldName = "CargasRetroactivas";
				public const string DisplayName = "CargasRetroactivas";
				public const int Length = 2;
			}

			public struct MontoRetroactivas
			{
				public const string FieldName = "MontoRetroactivas";
				public const string DisplayName = "MontoRetroactivas";
				public const int Length = 4;
			}

			public struct Ley19404
			{
				public const string FieldName = "Ley19404";
				public const string DisplayName = "Ley19404";
				public const int Length = 1;
			}

			public struct SeguroCesantia
			{
				public const string FieldName = "SeguroCesantia";
				public const string DisplayName = "SeguroCesantia";
				public const int Length = 1;
			}

			public struct MovimientoAfp
			{
				public const string FieldName = "MovimientoAfp";
				public const string DisplayName = "MovimientoAfp";
				public const int Length = 2;
			}

			public struct MovimientoIsapre
			{
				public const string FieldName = "MovimientoIsapre";
				public const string DisplayName = "MovimientoIsapre";
				public const int Length = 2;
			}

			public struct ProporcionarIsapre
			{
				public const string FieldName = "ProporcionarIsapre";
				public const string DisplayName = "ProporcionarIsapre";
				public const int Length = 1;
			}

			public struct Fun
			{
				public const string FieldName = "Fun";
				public const string DisplayName = "Fun";
				public const int Length = 10;
			}

			public struct ImpoLicencia
			{
				public const string FieldName = "ImpoLicencia";
				public const string DisplayName = "ImpoLicencia";
				public const int Length = 4;
			}

			public struct Error
			{
				public const string FieldName = "Error";
				public const string DisplayName = "Error";
				public const int Length = 1;
			}

			public struct Activo
			{
				public const string FieldName = "Activo";
				public const string DisplayName = "Activo";
				public const int Length = 1;
			}

			public struct IdUser
			{
				public const string FieldName = "IdUser";
				public const string DisplayName = "IdUser";
				public const int Length = 10;
			}

			public struct Foto
			{
				public const string FieldName = "Foto";
				public const string DisplayName = "Foto";
				public const int Length = 16;
			}

			public struct IdCtaContable
			{
				public const string FieldName = "IdCtaContable";
				public const string DisplayName = "IdCtaContable";
				public const int Length = 7;
			}

			public struct Unidad
			{
				public const string FieldName = "Unidad";
				public const string DisplayName = "Unidad";
				public const int Length = 3;
			}

			public struct Centro
			{
				public const string FieldName = "Centro";
				public const string DisplayName = "Centro";
				public const int Length = 5;
			}
		}
		#endregion

		#region Cargos
		public struct Cargos
		{
			public const string SP_SELECT_ALL = "uSp_CargosSelectAll";
			public const string SP_SELECT_BY_PK = "uSp_FindCargos";
			public const string SP_SELECT_BROWSE = "uSp_BrowseCargos";
			
			public struct IdNumero
			{
				public const string FieldName = "IdNumero";
				public const string DisplayName = "IdNumero";
				public const int Length = 3;
			}

			public struct Mes
			{
				public const string FieldName = "Mes";
				public const string DisplayName = "Mes";
				public const int Length = 2;
			}

			public struct idCargo
			{
				public const string FieldName = "idCargo";
				public const string DisplayName = "idCargo";
				public const int Length = 3;
			}

			public struct Nombre
			{
				public const string FieldName = "Nombre";
				public const string DisplayName = "Nombre";
				public const int Length = 30;
			}

			public struct IdUser
			{
				public const string FieldName = "IdUser";
				public const string DisplayName = "IdUser";
				public const int Length = 10;
			}
		}
		#endregion

		#region Afp

		public struct Afp
		{
			public const string SP_SELECT_BY_PK = "uSp_FindAfp";
		}

		#endregion

		#region Apv

		public struct Apv
		{
			public const string SP_SELECT_BY_PK = "uSp_FindApv";
		}

		#endregion

		#region Pais

		public struct Pais
		{
			public const string SP_SELECT_BY_PK = "uSp_FindPais";
		}

		#endregion

		#region Haber

		public struct Haber
		{
			public const string SP_SELECT_ALL = "uSp_BrowseHaberAnual";
		}

		#endregion

		#region Isapre

		public struct Isapre
		{
			public const string SP_SELECT_BY_PK = "uSp_FindIsapre";
		}

		#endregion

		#region Costo
		public struct Costo
		{
			public const string SP_SELECT_ALL = "uSp_CostoSelectAll";
			public const string SP_SELECT_BY_PK = "uSp_CostoSelectByPK";
			public const string SP_SELECT_BROWSE = "uSp_BrowseCosto";

			public struct IdNumero
			{
				public const string FieldName = "IdNumero";
				public const string DisplayName = "IdNumero";
				public const int Length = 3;
			}

			public struct idCentro
			{
				public const string FieldName = "idCentro";
				public const string DisplayName = "idCentro";
				public const int Length = 5;
			}

			public struct Nombre
			{
				public const string FieldName = "Nombre";
				public const string DisplayName = "Nombre";
				public const int Length = 35;
			}

			public struct IdUser
			{
				public const string FieldName = "IdUser";
				public const string DisplayName = "IdUser";
				public const int Length = 10;
			}
		}
		#endregion

		#region Sucursal
		public struct Sucursal
		{
			public const string SP_SELECT_ALL = "uSp_SucursalSelectAll";
			public const string SP_SELECT_BY_PK = "uSp_SucursalSelectByPK";
			public const string SP_SELECT_BROWSE = "uSp_BrowseSucursal";
			

			public struct IdNumero
			{
				public const string FieldName = "IdNumero";
				public const string DisplayName = "IdNumero";
				public const int Length = 3;
			}

			public struct Mes
			{
				public const string FieldName = "Mes";
				public const string DisplayName = "Mes";
				public const int Length = 2;
			}

			public struct idSucursal
			{
				public const string FieldName = "idSucursal";
				public const string DisplayName = "idSucursal";
				public const int Length = 3;
			}

			public struct Nombre
			{
				public const string FieldName = "Nombre";
				public const string DisplayName = "Nombre";
				public const int Length = 30;
			}

			public struct CodigoInternet
			{
				public const string FieldName = "CodigoInternet";
				public const string DisplayName = "CodigoInternet";
				public const int Length = 3;
			}

			public struct IdUser
			{
				public const string FieldName = "IdUser";
				public const string DisplayName = "IdUser";
				public const int Length = 10;
			}
		}
		#endregion

		#region UniNegocio
		public struct UniNegocio
		{
			public const string SP_SELECT_ALL = "uSp_UniNegocioSelectAll";
			public const string SP_SELECT_BY_PK = "uSp_FindUnidadNegocio";
			public const string SP_SELECT_BROWSE = "uSp_BrowseUnidadNegocio";

			public struct idIdentity
			{
				public const string FieldName = "idIdentity";
				public const string DisplayName = "idIdentity";
				public const int Length = 4;
			}

			public struct IdNumero
			{
				public const string FieldName = "IdNumero";
				public const string DisplayName = "IdNumero";
				public const int Length = 3;
			}

			public struct IdUnidad
			{
				public const string FieldName = "IdUnidad";
				public const string DisplayName = "IdUnidad";
				public const int Length = 3;
			}

			public struct Nombre
			{
				public const string FieldName = "Nombre";
				public const string DisplayName = "Nombre";
				public const int Length = 30;
			}

			public struct IdUser
			{
				public const string FieldName = "IdUser";
				public const string DisplayName = "IdUser";
				public const int Length = 10;
			}
		}
		#endregion

		#region Horarios

		public struct Horarios
		{
			public const string SP_SELECT_BY_PK = "uSp_FindHorarios";

			public struct idHorario
			{
				public const string FieldName = "idHorario";
				public const string DisplayName = "idHorario";
				public const int Length = 3;
			}

			public struct idNumero
			{
				public const string FieldName = "idNumero";
				public const string DisplayName = "idNumero";
				public const int Length = 3;
			}

			public struct Mes
			{
				public const string FieldName = "Mes";
				public const string DisplayName = "Mes";
				public const int Length = 1;
			}
		}

		#endregion

		#region Sindicatos

		public struct Sindicatos
		{
			public const string SP_SELECT_BY_PK = "uSp_FindSindicatos";

			public struct idSindicatos
			{
				public const string FieldName = "idSindicatos";
				public const string DisplayName = "idSindicatos";
				public const int Length = 3;
			}

			public struct idNumero
			{
				public const string FieldName = "idNumero";
				public const string DisplayName = "idNumero";
				public const int Length = 3;
			}

			public struct Mes
			{
				public const string FieldName = "Mes";
				public const string DisplayName = "Mes";
				public const int Length = 1;
			}
		}

		#endregion

		#region Empresa
		public struct Empresa
		{
			public const string SP_SELECT_BY_PK = "uSp_FindEmpresa";
			public const string SP_SELECT_GENERAL = "uSp_BuscaEmpresa";
			public const string SP_SELECT_ALL = "wSp_Empresas";
			public const string SP_LAST_MONTH_ACTIVE = "wSp_MesInternet";
		}
		#endregion

		#region Listados

		public struct Listados
		{
			public const string SP_SELECT_RESUMEN_PREVISIONAL = "uSp_ResumenRemuneracionesDesglose";
			public const string SP_SELECT_LIQUIDACIONES = "uSp_LiquidaFiltra";
			public const string SP_SELECT_LIBROREMUNERACION = "uSp_LibroRemuneracion";
			public const string SP_SELECT_LIBROREMUNERACION_EXCEL = "uSp_LibroRemuneracionExcel";
			public const string SP_SELECT_RESUMEN_REMUNERACION = "uSp_ResumenRemuneraciones";
			public const string SP_SELECT_VACACIONES_PENDIENTE = "Usp_ListadoVacacionesPendientes";
			public const string SP_SELECT_PROVISION_VACACIONES = "Usp_ListadoProvisionVacaciones";
			public const string SP_SELECT_IMPUESTO_UNICO = "uSp_ListadoImpuestoUnico";
			public const string SP_SELECT_CERTIFICADOS = "uSp_Certificados";
			public const string SP_SELECT_HABERANUAL = "uSp_ListadoAnualHaberTrabajador";
			public const string SP_SELECT_VACACIONES_WEB = "Usp_ListadoVacacionesWeb";
		}

		#endregion

	}
}