How Can We Help?

Search for answers or browse our knowledge base.

XSPOC Database Columns

Created OnMarch 30, 2020

byAndrew Binning

"

Search the Table Here

Table	Column	Data Type	Max Length	Precision
dtproperties	id	int	4	10
dtproperties	lvalue	image	16	0
dtproperties	objectid	int	4	10
dtproperties	property	varchar	64	0
dtproperties	uvalue	nvarchar	510	0
dtproperties	value	varchar	255	0
dtproperties	version	int	4	10
LEGO	AVG_BPD	smallint	2	5
LEGO	ID	int	4	10
LEGO	NodeID	nvarchar	100	0
Results	Access	nvarchar	510	0
Results	Address	int	4	10
Results	CollectionMode	int	4	10
Results	DataCollection	bit	1	1
Results	DataType	smallint	2	5
Results	Decimals	int	4	10
Results	Description	nvarchar	510	0
Results	Offset	real	4	24
Results	POCType	int	4	10
Results	ScaleFactor	real	4	24
Results	Setpoint	bit	1	1
Results	StatusScan	bit	1	1
sysdiagrams	definition	varbinary	-1	0
sysdiagrams	diagram_id	int	4	10
sysdiagrams	name	sysname	256	0
sysdiagrams	principal_id	int	4	10
sysdiagrams	version	int	4	10
tblAccel	Address	nvarchar	100	0
tblAccel	Date	datetime	8	23
tblAccel	NodeID	nvarchar	100	0
tblAccel	Value	real	4	24
tblAlarmBits	Address	int	4	10
tblAlarmBits	AlarmPriority	smallint	2	5
tblAlarmBits	Bit	smallint	2	5
tblAlarmBits	Description	varchar	15	0
tblAlarmBits	Enabled	bit	1	1
tblAlarmBits	Locked	bit	1	1
tblAlarmBits	NormalState	bit	1	1
tblAlarmBits	PagingEnabled	bit	1	1
tblAlarmBits	POCType	int	4	10
tblAlarmConfigByPOCType	AlarmAction	int	4	10
tblAlarmConfigByPOCType	Bit	smallint	2	5
tblAlarmConfigByPOCType	CalloutEnabled	bit	1	1
tblAlarmConfigByPOCType	Description	nvarchar	100	0
tblAlarmConfigByPOCType	Enabled	bit	1	1
tblAlarmConfigByPOCType	HiLimit	real	4	24
tblAlarmConfigByPOCType	Locked	bit	1	1
tblAlarmConfigByPOCType	LoLimit	real	4	24
tblAlarmConfigByPOCType	NormalState	bit	1	1
tblAlarmConfigByPOCType	PhraseID	int	4	10
tblAlarmConfigByPOCType	POCType	int	4	10
tblAlarmConfigByPOCType	Priority	smallint	2	5
tblAlarmConfigByPOCType	Register	int	4	10
tblAlarmEvents	AcknowledgedDateTime	datetime	8	23
tblAlarmEvents	AcknowledgedUserName	nvarchar	200	0
tblAlarmEvents	AlarmID	int	4	10
tblAlarmEvents	AlarmType	int	4	10
tblAlarmEvents	EventDateTime	datetime	8	23
tblAlarmEvents	EventType	int	4	10
tblAlarmEvents	ID	int	4	10
tblAlarmEvents	PictureID	int	4	10
tblAlarmEvents	Value	real	4	24
tblAlarmEventTypes	ID	int	4	10
tblAlarmEventTypes	Name	nvarchar	100	0
tblAlarmEventTypes	PhraseID	int	4	10
tblAlarmHistory	Date	datetime	8	23
tblAlarmHistory	Description	varchar	50	0
tblAlarmHistory	NodeID	nvarchar	100	0
tblAlarmPictures	ID	int	4	10
tblAlarmPictures	Picture	varbinary	-1	0
tblAlarmPictures	Thumbnail	varbinary	-1	0
tblAlarmPictures	Token	varchar	50	0
tblAlarmTypes	ID	int	4	10
tblAlarmTypes	Name	nvarchar	100	0
tblAlarmTypes	PhraseID	int	4	10
tblAnalysisCorrelationDefaults	CorrelationTypeID	int	4	10
tblAnalysisCorrelationDefaults	DefaultAnalysisCorrelationID	int	4	10
tblAnalysisCorrelations	CorrelationID	int	4	10
tblAnalysisCorrelations	CorrelationTypeID	int	4	10
tblAnalysisCorrelations	ID	int	4	10
tblAnalysisCurveSet	AnalysisResultId	int	4	10
tblAnalysisCurveSet	AnalysisResultSourceId	int	4	10
tblAnalysisCurveSet	CurveSetId	int	4	10
tblAnalysisCurveSet	CurveSetTypeId	int	4	10
tblAnalysisCurveSetMembers	CurveSetId	int	4	10
tblAnalysisCurveSetMembers	CurveSetMemberId	int	4	10
tblAnalysisCurveSetTypes	ID	int	4	10
tblAnalysisCurveSetTypes	Name	nvarchar	100	0
tblAnalysisCurveSetTypes	PhraseID	int	4	10
tblAnalysisInputDefaults	ApplicationID	int	4	10
tblAnalysisInputDefaults	DefaultValue	real	4	24
tblAnalysisInputDefaults	Locked	bit	1	1
tblAnalysisInputDefaults	ParamStandardType	int	4	10
tblAnalysisParamStandardTypeBehaviors	ExcludeZeroesFromAverage	bit	1	1
tblAnalysisParamStandardTypeBehaviors	Locked	bit	1	1
tblAnalysisParamStandardTypeBehaviors	ParamStandardType	int	4	10
tblAnalysisResultCurves	AnalysisResultID	int	4	10
tblAnalysisResultCurves	CurveTypeID	int	4	10
tblAnalysisResultCurves	ID	int	4	10
tblAnalysisSources	ID	int	4	10
tblAnalysisSources	Name	nvarchar	100	0
tblAnalysisSources	PhraseID	int	4	10
tblAnalysisTypes	ID	int	4	10
tblAnalysisTypes	Name	nvarchar	100	0
tblAnalysisTypes	PhraseID	int	4	10
tblAnalyticsCategories	ID	int	4	10
tblAnalyticsCategories	Name	nvarchar	100	0
tblAnalyticsCategories	PhraseID	int	4	10
tblAnalyticsClassificationFilters	Description	nvarchar	-1	0
tblAnalyticsClassificationFilters	ID	int	4	10
tblAnalyticsClassificationFilters	PhraseID	int	4	10
tblAnalyticsClassifications	Acknowledged	bit	1	1
tblAnalyticsClassifications	ClassificationTypeID	int	4	10
tblAnalyticsClassifications	EndDate	datetime	8	23
tblAnalyticsClassifications	ID	int	4	10
tblAnalyticsClassifications	NodeID	nvarchar	100	0
tblAnalyticsClassifications	SecondClassificationTypeID	int	4	10
tblAnalyticsClassifications	StartDate	datetime	8	23
tblAnalyticsClassifications	ThirdClassificationTypeID	int	4	10
tblAnalyticsClassificationSuppressions	ClassificationTypeID	int	4	10
tblAnalyticsClassificationSuppressions	EndDate	datetime	8	23
tblAnalyticsClassificationSuppressions	ID	int	4	10
tblAnalyticsClassificationSuppressions	NodeID	nvarchar	100	0
tblAnalyticsClassificationTypes	Color	nvarchar	100	0
tblAnalyticsClassificationTypes	Description	nvarchar	-1	0
tblAnalyticsClassificationTypes	Enabled	bit	1	1
tblAnalyticsClassificationTypes	ID	int	4	10
tblAnalyticsClassificationTypes	IsState	bit	1	1
tblAnalyticsClassificationTypes	Locked	bit	1	1
tblAnalyticsClassificationTypes	Name	nvarchar	-1	0
tblAnalyticsClassificationTypes	PhraseID	int	4	10
tblAnalyticsClassificationTypes	Priority	int	4	10
tblAnalyticsEvents	EndDate	datetime	8	23
tblAnalyticsEvents	ID	int	4	10
tblAnalyticsEvents	NodeID	nvarchar	100	0
tblAnalyticsEvents	StartDate	datetime	8	23
tblAnalyticsEvents	TrendTypeID	int	4	10
tblAnalyticsGroups	ClassificationTypeID	int	4	10
tblAnalyticsGroups	GroupName	nvarchar	-1	0
tblAnalyticsGroups	ID	int	4	10
tblAnalyticsParameters	ApplicationID	int	4	10
tblAnalyticsParameters	CategoryID	int	4	10
tblAnalyticsParameters	DataTypeID	int	4	10
tblAnalyticsParameters	ID	int	4	10
tblAnalyticsParameters	Locked	bit	1	1
tblAnalyticsParameters	Name	nvarchar	100	0
tblAnalyticsParameters	PhraseID	int	4	10
tblAnalyticsParameters	Value	nvarchar	-1	0
tblAnalyticsTrendTypes	ApplicationID	int	4	10
tblAnalyticsTrendTypes	HighlightColor	nvarchar	100	0
tblAnalyticsTrendTypes	ID	int	4	10
tblAnalyticsTrendTypes	Order	int	4	10
tblAnalyticsTrendTypes	StandardMeasurementID	int	4	10
tblAnalyticsTrendTypes	TrendColor	nvarchar	100	0
tblApplicationParameters	Address	int	4	10
tblApplicationParameters	ApplicationID	int	4	10
tblApplicationParamStandardTypes	AllowsNote	bit	1	1
tblApplicationParamStandardTypes	ApplicationID	int	4	10
tblApplicationParamStandardTypes	DisplayOrder	int	4	10
tblApplicationParamStandardTypes	IsRequiredForAnalysis	bit	1	1
tblApplicationParamStandardTypes	IsUsedForAnalysis	bit	1	1
tblApplicationParamStandardTypes	ParamStandardType	int	4	10
tblApplications	ID	int	4	10
tblApplications	Name	varchar	50	0
tblApplications	PhraseID	int	4	10
tblArchiveFunctions	Description	varchar	20	0
tblArchiveFunctions	ID	int	4	10
tblArchiveFunctions	PhraseID	int	4	10
tblBugNotes	Comment	varchar	100	0
tblBugNotes	Date	datetime	8	23
tblBugNotes	Priority	char	1	0
tblBugNotes	Resolved	bit	1	1
tblBugNotes	UserID	varchar	20	0
tblCameraAlarms	AlarmType	int	4	10
tblCameraAlarms	CameraID	int	4	10
tblCameraAlarms	ContactListID	int	4	10
tblCameraAlarms	EmailOnAlarm	bit	1	1
tblCameraAlarms	Enabled	bit	1	1
tblCameraAlarms	ID	int	4	10
tblCameraAlarmTypes	ID	int	4	10
tblCameraAlarmTypes	Name	nvarchar	100	0
tblCameraAlarmTypes	PhraseID	int	4	10
tblCameras	CameraTypeID	int	4	10
tblCameras	Hostname	nvarchar	-1	0
tblCameras	ID	int	4	10
tblCameras	Name	nvarchar	200	0
tblCameras	NodeID	nvarchar	100	0
tblCameras	Password	varchar	-1	0
tblCameras	Port	int	4	10
tblCameras	Token	varchar	50	0
tblCameras	Username	nvarchar	-1	0
tblCameras	VideoFormatID	int	4	10
tblCameraTypes	ID	int	4	10
tblCameraTypes	Name	nvarchar	100	0
tblCameraTypes	PhraseID	int	4	10
tblCardData	AnalysisDate	datetime	8	23
tblCardData	Area	int	4	10
tblCardData	AreaLimit	int	4	10
tblCardData	CardArea	int	4	10
tblCardData	CardType	varchar	1	0
tblCardData	CauseID	int	4	10
tblCardData	CorrectedCard	text	16	0
tblCardData	Date	datetime	8	23
tblCardData	DownholeCard	text	16	0
tblCardData	DownholeCardB	image	16	0
tblCardData	ElectrogramCardB	image	16	0
tblCardData	Fillage	real	4	24
tblCardData	FillBasePct	int	4	10
tblCardData	HiLoadLimit	int	4	10
tblCardData	LoadLimit	int	4	10
tblCardData	LoadLimit2	smallint	2	5
tblCardData	LoadSpanLimit	int	4	10
tblCardData	LoLoadLimit	int	4	10
tblCardData	MalLoadLimit	int	4	10
tblCardData	MalPositionLimit	int	4	10
tblCardData	NodeID	nvarchar	100	0
tblCardData	PermissibleLoadDownB	image	16	0
tblCardData	PermissibleLoadUpB	image	16	0
tblCardData	PocDHCard	text	16	0
tblCardData	POCDownholeCard	text	16	0
tblCardData	POCDownholeCardB	image	16	0
tblCardData	PositionLimit	int	4	10
tblCardData	PositionLimit2	smallint	2	5
tblCardData	PredictedCard	text	16	0
tblCardData	PredictedCardB	image	16	0
tblCardData	ProcessCard	int	4	10
tblCardData	Runtime	real	4	24
tblCardData	Saved	bit	1	1
tblCardData	SecondaryPumpFillage	real	4	24
tblCardData	SPM	real	4	24
tblCardData	StrokeLength	int	4	10
tblCardData	SurfaceCard	text	16	0
tblCardData	SurfaceCardB	image	16	0
tblCardData	TorquePlotCurrent	text	16	0
tblCardData	TorquePlotCurrentB	image	16	0
tblCardData	TorquePlotMinEnergy	text	16	0
tblCardData	TorquePlotMinEnergyB	image	16	0
tblCardData	TorquePlotMinTorque	text	16	0
tblCardData	TorquePlotMinTorqueB	image	16	0
tblCasings	CasingSizeId	int	4	10
tblCasings	Diameter	real	4	24
tblCasings	Length	int	4	10
tblCasings	NodeID	nvarchar	100	0
tblCasings	OrderNum	smallint	2	5
tblCasingSizes	CasingSizeID	int	4	10
tblCasingSizes	CasingWeight	real	4	24
tblCasingSizes	InnerDiameter	real	4	24
tblCasingSizes	OuterDiameter	real	4	24
tblCommandActions	Action	varchar	50	0
tblCommandActions	DataType	int	4	10
tblCommandActions	POCType	int	4	10
tblCommandActions	Register	varchar	50	0
tblCommandActions	Sequence	int	4	10
tblCommandActions	Value	real	4	24
tblCommLog	Color	int	4	10
tblCommLog	CommLogID	int	4	10
tblCommLog	Date	datetime	8	23
tblCommLog	Message	ntext	16	0
tblCommLog	NodeID	nvarchar	100	0
tblCommLog	PortID	int	4	10
tblCommLog	Verbosity	int	4	10
tblCompany	ID	int	4	10
tblCompany	Name	nvarchar	250	0
tblComparisonOperators	Description	varchar	50	0
tblComparisonOperators	Id	int	4	10
tblComparisonOperators	PhraseID	int	4	10
tblConditionalFormats	BackColor	int	4	10
tblConditionalFormats	ColumnID	int	4	10
tblConditionalFormats	ForeColor	int	4	10
tblConditionalFormats	ID	int	4	10
tblConditionalFormats	MaxValue	real	4	24
tblConditionalFormats	MinValue	real	4	24
tblConditionalFormats	OperatorID	int	4	10
tblConditionalFormats	StringValue	nvarchar	-1	0
tblConditionalFormats	Value	real	4	24
tblContactLists	ID	int	4	10
tblContactLists	Name	nvarchar	510	0
tblContactListsRel	ContactID	int	4	10
tblContactListsRel	ContactListID	int	4	10
tblContactListsRel	Order	int	4	10
tblContacts	Email	nvarchar	510	0
tblContacts	Enabled	bit	1	1
tblContacts	Firstname	nvarchar	100	0
tblContacts	ID	int	4	10
tblContacts	Lastname	nvarchar	100	0
tblContacts	Phone	nvarchar	100	0
tblControlActions	ControlActionID	int	4	10
tblControlActions	Description	varchar	50	0
tblCorrelations	ID	int	4	10
tblCorrelations	Name	nvarchar	100	0
tblCorrelations	PhraseID	int	4	10
tblCorrelationTypes	ID	int	4	10
tblCorrelationTypes	Name	nvarchar	120	0
tblCorrelationTypes	PhraseID	int	4	10
tblCurrRawScanData	Address	int	4	10
tblCurrRawScanData	DateTimeUpdated	datetime	8	23
tblCurrRawScanData	NodeID	nvarchar	100	0
tblCurrRawScanData	StringValue	nvarchar	-1	0
tblCurrRawScanData	Value	real	4	24
tblCurveCoordinates	CurveID	int	4	10
tblCurveCoordinates	ID	int	4	10
tblCurveCoordinates	X	real	4	24
tblCurveCoordinates	Y	real	4	24
tblCurveSetCoordinates	CurveID	int	4	10
tblCurveSetCoordinates	ID	int	4	10
tblCurveSetCoordinates	X	real	4	24
tblCurveSetCoordinates	Y	real	4	24
tblCurveTypes	ApplicationTypeID	int	4	10
tblCurveTypes	ID	int	4	10
tblCurveTypes	Name	nvarchar	100	0
tblCurveTypes	PhraseID	int	4	10
tblDatabaseConnections	ConnectionString	nvarchar	-1	0
tblDatabaseConnections	ID	int	4	10
tblDatabaseConnections	Name	nvarchar	100	0
tblDataHistory	Address	int	4	10
tblDataHistory	Date	datetime	8	23
tblDataHistory	NodeID	nvarchar	100	0
tblDataHistory	Value	real	4	24
tblDataHistoryArchive	Address	int	4	10
tblDataHistoryArchive	Date	datetime	8	23
tblDataHistoryArchive	NodeID	nvarchar	100	0
tblDataHistoryArchive	Value	real	4	24
tblDataHistoryStaging	Address	int	4	10
tblDataHistoryStaging	Date	datetime	8	23
tblDataHistoryStaging	NodeID	nvarchar	100	0
tblDataHistoryStaging	ProcessingStatus	int	4	10
tblDataHistoryStaging	Value	real	4	24
tblDataHistoryStagingStatus	ID	int	4	10
tblDataHistoryStagingStatus	StatusDescription	nvarchar	200	0
tblDataTypes	Comment	nvarchar	100	0
tblDataTypes	DataType	tinyint	1	3
tblDataTypes	Description	nvarchar	100	0
tblDefaults	DefaultsGroup	varchar	50	0
tblDefaults	Property	varchar	50	0
tblDefaults	UID	varchar	50	0
tblDefaults	Value	nvarchar	500	0
tblDeviations	Azimuth	real	4	24
tblDeviations	Inclination	real	4	24
tblDeviations	MeasuredDepth	smallint	2	5
tblDeviations	NodeID	nvarchar	100	0
tblDialerLog	Address	int	4	10
tblDialerLog	AlarmDate	datetime	8	23
tblDialerLog	AlarmState	int	4	10
tblDialerLog	Bit	smallint	2	5
tblDialerLog	HostAlarmID	int	4	10
tblDialerLog	Message	nvarchar	500	0
tblDialerLog	MessageText	nvarchar	500	0
tblDialerLog	NodeID	nvarchar	100	0
tblDialerLog	ProcessDate	datetime	8	23
tblDialerLog	ResponderListID	int	4	10
tblDialerLog	Tag	varchar	50	0
tblDialerLogDetails	AlarmDate	datetime	8	23
tblDialerLogDetails	PhoneNumber	varchar	50	0
tblDialerLogDetails	ProcessDate	datetime	8	23
tblDialerLogDetails	ResultCode	int	4	10
tblDialerLogDetails	Tag	varchar	50	0
tblDisableCodes	Code	nvarchar	12	0
tblDisableCodes	Description	nvarchar	50	0
tblDisableCodes	DisableCodeID	int	4	10
tblDocuments	CreationDateTime	datetime	8	23
tblDocuments	Data	varbinary	-1	0
tblDocuments	FileName	nvarchar	510	0
tblDocuments	ID	int	4	10
tblDocuments	UserName	nvarchar	200	0
tblDownholeSeparators	ID	int	4	10
tblDownholeSeparators	Manufacturer	nvarchar	100	0
tblDownholeSeparators	Name	nvarchar	100	0
tblDownholeSeparators	PhraseID	int	4	10
tblEFMDailyRecords	Alarms	nvarchar	100	0
tblEFMDailyRecords	ArchSeq	int	4	10
tblEFMDailyRecords	ArchSeqLogPeriodEnd	int	4	10
tblEFMDailyRecords	ArchSeqLogPeriodStart	int	4	10
tblEFMDailyRecords	AvgFrequency	float	8	53
tblEFMDailyRecords	BackFlow	int	4	10
tblEFMDailyRecords	BaseDensity	float	8	53
tblEFMDailyRecords	CloseRead	float	8	53
tblEFMDailyRecords	ContractBarometricPressure	float	8	53
tblEFMDailyRecords	ContractHour	int	4	10
tblEFMDailyRecords	DiffPressure	float	8	53
tblEFMDailyRecords	DiffPressureMax	float	8	53
tblEFMDailyRecords	DiffPressureMin	float	8	53
tblEFMDailyRecords	DiffPressurePercentHigh	float	8	53
tblEFMDailyRecords	DiffPressurePercentLow	float	8	53
tblEFMDailyRecords	EndDateTime	datetime	8	23
tblEFMDailyRecords	Energy	float	8	53
tblEFMDailyRecords	Extension	float	8	53
tblEFMDailyRecords	FlowingTemperature	float	8	53
tblEFMDailyRecords	FlowingTemperatureMax	float	8	53
tblEFMDailyRecords	FlowingTemperatureMin	float	8	53
tblEFMDailyRecords	FlowingTemperaturePercentHigh	float	8	53
tblEFMDailyRecords	FlowingTemperaturePercentLow	float	8	53
tblEFMDailyRecords	FlowTime	int	4	10
tblEFMDailyRecords	GrossStandardVolume	float	8	53
tblEFMDailyRecords	HashCode	int	4	10
tblEFMDailyRecords	Header1	smallint	2	5
tblEFMDailyRecords	Header2	smallint	2	5
tblEFMDailyRecords	Header3	smallint	2	5
tblEFMDailyRecords	ID	bigint	8	19
tblEFMDailyRecords	IndicatedStandardVolume	float	8	53
tblEFMDailyRecords	IndicatedVolume	float	8	53
tblEFMDailyRecords	LastEventSeq	int	4	10
tblEFMDailyRecords	LineDensity	float	8	53
tblEFMDailyRecords	LogDateTime	datetime	8	23
tblEFMDailyRecords	LogPeriodEndSeq	int	4	10
tblEFMDailyRecords	LogPeriodStartSeq	int	4	10
tblEFMDailyRecords	Mass	float	8	53
tblEFMDailyRecords	NetStandardVolume	float	8	53
tblEFMDailyRecords	NodeID	nvarchar	100	0
tblEFMDailyRecords	OpenRead	float	8	53
tblEFMDailyRecords	PressureCorrectionFactor	float	8	53
tblEFMDailyRecords	SedimentAndWaterCorrectionFactor	float	8	53
tblEFMDailyRecords	SedimentAndWaterVolume	float	8	53
tblEFMDailyRecords	Sequence	int	4	10
tblEFMDailyRecords	StaticPressure	float	8	53
tblEFMDailyRecords	StaticPressureMax	float	8	53
tblEFMDailyRecords	StaticPressureMin	float	8	53
tblEFMDailyRecords	StaticPressurePercentHigh	float	8	53
tblEFMDailyRecords	StaticPressurePercentLow	float	8	53
tblEFMDailyRecords	TempCorrectionFactor	float	8	53
tblEFMDailyRecords	Ticket	int	4	10
tblEFMDailyRecords	TotalDailyTime	int	4	10
tblEFMDailyRecords	VerCode	nvarchar	60	0
tblEFMDailyRecords	Volume	float	8	53
tblEFMEventCodes	DataType	int	4	10
tblEFMEventCodes	EventCode	int	4	10
tblEFMEventCodes	EventDescription	nvarchar	200	0
tblEFMEventCodes	FlowCalOffset	int	4	10
tblEFMEventCodes	FlowCalTable	int	4	10
tblEFMEventCodes	ID	bigint	8	19
tblEFMEventCodes	Locked	bit	1	1
tblEFMEventCodes	PhraseID	int	4	10
tblEFMEventCodes	POCType	smallint	2	5
tblEFMEventRecords	ArchSeq	int	4	10
tblEFMEventRecords	Description	nvarchar	160	0
tblEFMEventRecords	EventCode	int	4	10
tblEFMEventRecords	HashCode	int	4	10
tblEFMEventRecords	ID	bigint	8	19
tblEFMEventRecords	LogDateTime	datetime	8	23
tblEFMEventRecords	NewValue	nvarchar	60	0
tblEFMEventRecords	NodeID	nvarchar	100	0
tblEFMEventRecords	OldValue	nvarchar	60	0
tblEFMEventRecords	Sequence	int	4	10
tblEFMEventRecords	sFlags	nvarchar	40	0
tblEFMEventRecords	VerCode	nvarchar	60	0
tblEFMHourlyRecords	Alarms	nvarchar	100	0
tblEFMHourlyRecords	ArchSeq	int	4	10
tblEFMHourlyRecords	AvgFrequency	float	8	53
tblEFMHourlyRecords	BaseDensity	float	8	53
tblEFMHourlyRecords	CloseRead	float	8	53
tblEFMHourlyRecords	ContractBarometricPressure	float	8	53
tblEFMHourlyRecords	DiffPressure	float	8	53
tblEFMHourlyRecords	EndDateTime	datetime	8	23
tblEFMHourlyRecords	Energy	float	8	53
tblEFMHourlyRecords	Extension	float	8	53
tblEFMHourlyRecords	FlowingTemperature	float	8	53
tblEFMHourlyRecords	FlowTime	int	4	10
tblEFMHourlyRecords	GrossStandardVolume	float	8	53
tblEFMHourlyRecords	HashCode	int	4	10
tblEFMHourlyRecords	Header1	smallint	2	5
tblEFMHourlyRecords	Header2	smallint	2	5
tblEFMHourlyRecords	Header3	smallint	2	5
tblEFMHourlyRecords	ID	bigint	8	19
tblEFMHourlyRecords	IndicatedStandardVolume	float	8	53
tblEFMHourlyRecords	IndicatedVolume	float	8	53
tblEFMHourlyRecords	LineDensity	float	8	53
tblEFMHourlyRecords	LogDateTime	datetime	8	23
tblEFMHourlyRecords	Mass	float	8	53
tblEFMHourlyRecords	NetStandardVolume	float	8	53
tblEFMHourlyRecords	NodeID	nvarchar	100	0
tblEFMHourlyRecords	OpenRead	float	8	53
tblEFMHourlyRecords	PressureCorrectionFactor	float	8	53
tblEFMHourlyRecords	SedimentAndWaterCorrectionFactor	float	8	53
tblEFMHourlyRecords	SedimentAndWaterVolume	float	8	53
tblEFMHourlyRecords	Sequence	int	4	10
tblEFMHourlyRecords	StaticPressure	float	8	53
tblEFMHourlyRecords	TempCorrectionFactor	float	8	53
tblEFMHourlyRecords	Ticket	int	4	10
tblEFMHourlyRecords	TotalLogPeriodTime	int	4	10
tblEFMHourlyRecords	VerCode	nvarchar	60	0
tblEFMHourlyRecords	Volume	float	8	53
tblESPAnalysisResults	AnnularSeparationEfficiency	real	4	24
tblESPAnalysisResults	BottomholeTemperature	real	4	24
tblESPAnalysisResults	BottomholeTemperatureSource	int	4	10
tblESPAnalysisResults	CalculatedFluidLevelAbovePump	real	4	24
tblESPAnalysisResults	CasingID	real	4	24
tblESPAnalysisResults	CasingPressure	real	4	24
tblESPAnalysisResults	CasingPressureSource	int	4	10
tblESPAnalysisResults	CasingValveClosed	bit	1	1
tblESPAnalysisResults	CompositeTubingSpecificGravity	real	4	24
tblESPAnalysisResults	DesignScore	real	4	24
tblESPAnalysisResults	DischargeGageDepth	real	4	24
tblESPAnalysisResults	DischargeGagePressure	real	4	24
tblESPAnalysisResults	DischargeGagePressureSource	int	4	10
tblESPAnalysisResults	EnableGasHandling	bit	1	1
tblESPAnalysisResults	ESPPumpID	int	4	10
tblESPAnalysisResults	FlowingBHP	real	4	24
tblESPAnalysisResults	FlowRelativeToRecommendedRange	real	4	24
tblESPAnalysisResults	FluidLevelAbovePump	real	4	24
tblESPAnalysisResults	FluidLevelAbovePumpSource	int	4	10
tblESPAnalysisResults	FluidSpecificGravity	real	4	24
tblESPAnalysisResults	FormationVolumeFactor	real	4	24
tblESPAnalysisResults	FreeGas	real	4	24
tblESPAnalysisResults	FreeGasAtPump	real	4	24
tblESPAnalysisResults	Frequency	int	4	10
tblESPAnalysisResults	FrequencySource	int	4	10
tblESPAnalysisResults	FrictionalLossInTubing	real	4	24
tblESPAnalysisResults	GasCompressibilityFactor	real	4	24
tblESPAnalysisResults	GasDensity	real	4	24
tblESPAnalysisResults	GasInSolution	real	4	24
tblESPAnalysisResults	GasOilRatioAtPump	real	4	24
tblESPAnalysisResults	GasRate	real	4	24
tblESPAnalysisResults	GasRateSource	int	4	10
tblESPAnalysisResults	GasSeparatorEfficiency	real	4	24
tblESPAnalysisResults	GasSpecificGravitySource	int	4	10
tblESPAnalysisResults	GasVolumeAtPump	real	4	24
tblESPAnalysisResults	GasVolumeFactor	real	4	24
tblESPAnalysisResults	GrossRate	real	4	24
tblESPAnalysisResults	HeadAcrossPump	real	4	24
tblESPAnalysisResults	HeadRelativeToPumpCurve	real	4	24
tblESPAnalysisResults	HeadRelativeToRecommendedRange	real	4	24
tblESPAnalysisResults	HeadRelativeToWellPerformance	real	4	24
tblESPAnalysisResults	ID	int	4	10
tblESPAnalysisResults	IPRSlope	real	4	24
tblESPAnalysisResults	LiquidDensity	real	4	24
tblESPAnalysisResults	MaxPotentialFrequency	real	4	24
tblESPAnalysisResults	MaxPotentialProductionRate	real	4	24
tblESPAnalysisResults	MeasuredPumpDepth	real	4	24
tblESPAnalysisResults	NodeID	nvarchar	100	0
tblESPAnalysisResults	NumberOfStages	int	4	10
tblESPAnalysisResults	OilAPI	real	4	24
tblESPAnalysisResults	OilRate	real	4	24
tblESPAnalysisResults	OilRateSource	int	4	10
tblESPAnalysisResults	OilSpecificGravitySource	int	4	10
tblESPAnalysisResults	OilVolumeAtPump	real	4	24
tblESPAnalysisResults	PressureAcrossPump	real	4	24
tblESPAnalysisResults	ProcessedDate	datetime	8	23
tblESPAnalysisResults	ProducingGOR	real	4	24
tblESPAnalysisResults	ProductionIncreasePercentage	real	4	24
tblESPAnalysisResults	ProductivityIndex	real	4	24
tblESPAnalysisResults	PumpDegradation	real	4	24
tblESPAnalysisResults	PumpDischargePressure	real	4	24
tblESPAnalysisResults	PumpEfficiency	real	4	24
tblESPAnalysisResults	PumpIntakePressure	real	4	24
tblESPAnalysisResults	PumpIntakePressureSource	int	4	10
tblESPAnalysisResults	PumpStaticPressure	real	4	24
tblESPAnalysisResults	RateAtBubblePoint	real	4	24
tblESPAnalysisResults	RateAtMaxLiquid	real	4	24
tblESPAnalysisResults	RateAtMaxOil	real	4	24
tblESPAnalysisResults	ResultMessage	nvarchar	-1	0
tblESPAnalysisResults	SpecificGravityOfGas	real	4	24
tblESPAnalysisResults	SpecificGravityOfOil	real	4	24
tblESPAnalysisResults	Success	bit	1	1
tblESPAnalysisResults	TestDate	datetime	8	23
tblESPAnalysisResults	TotalVolumeAtPump	real	4	24
tblESPAnalysisResults	TubingGas	real	4	24
tblESPAnalysisResults	TubingGOR	real	4	24
tblESPAnalysisResults	TubingID	real	4	24
tblESPAnalysisResults	TubingOD	real	4	24
tblESPAnalysisResults	TubingPressure	real	4	24
tblESPAnalysisResults	TubingPressureSource	int	4	10
tblESPAnalysisResults	TurpinParameter	real	4	24
tblESPAnalysisResults	UseDischargeGageInAnalysis	bit	1	1
tblESPAnalysisResults	VerticalPumpDepth	real	4	24
tblESPAnalysisResults	WaterCut	int	4	10
tblESPAnalysisResults	WaterRate	real	4	24
tblESPAnalysisResults	WaterRateSource	int	4	10
tblESPAnalysisResults	WaterSpecificGravity	real	4	24
tblESPAnalysisResults	WaterSpecificGravitySource	int	4	10
tblESPAnalysisResults	WellHeadTemperature	real	4	24
tblESPAnalysisResults	WellHeadTemperatureSource	int	4	10
tblESPAnalysisSources	ID	int	4	10
tblESPAnalysisSources	Name	nvarchar	100	0
tblESPAnalysisSources	PhraseID	int	4	10
tblESPCables	CableDescription	nvarchar	100	0
tblESPCables	CableID	int	4	10
tblESPCables	CableType	nvarchar	100	0
tblESPCables	Description	nvarchar	510	0
tblESPCables	Diameter	float	8	53
tblESPCables	Locked	bit	1	1
tblESPCables	ManufacturerID	int	4	10
tblESPCables	Model	nvarchar	200	0
tblESPCables	Series	nvarchar	100	0
tblESPCurvePoints	Efficiency	float	8	53
tblESPCurvePoints	ESPPumpID	int	4	10
tblESPCurvePoints	FlowRate	float	8	53
tblESPCurvePoints	HeadFeetPerStage	float	8	53
tblESPCurvePoints	Locked	bit	1	1
tblESPCurvePoints	PowerInHP	float	8	53
tblESPDiagResults	Efficiency	real	4	24
tblESPDiagResults	FluidLevelAbovePump	real	4	24
tblESPDiagResults	NodeID	nvarchar	100	0
tblESPDiagResults	PumpDischargePressure	real	4	24
tblESPDiagResults	PumpHead	real	4	24
tblESPDiagResults	TestDate	datetime	8	23
tblESPDiagResults	TotalDynamicHead	real	4	24
tblESPEventRecords	EventTypeID	int	4	10
tblESPEventRecords	Exponent	int	4	10
tblESPEventRecords	ID	bigint	8	19
tblESPEventRecords	LogDateTime	datetime	8	23
tblESPEventRecords	NodeID	nvarchar	100	0
tblESPEventRecords	PointID	int	4	10
tblESPEventRecords	ValueAfterEvent	int	4	10
tblESPEventRecords	ValueBeforeEvent	int	4	10
tblESPEventTypes	Description	nvarchar	100	0
tblESPEventTypes	EventTypeID	int	4	10
tblESPEventTypes	Locked	bit	1	1
tblESPManufacturers	Locked	bit	1	1
tblESPManufacturers	Manufacturer	nvarchar	200	0
tblESPManufacturers	ManufacturerID	int	4	10
tblESPMotorLeads	Description	nvarchar	510	0
tblESPMotorLeads	Locked	bit	1	1
tblESPMotorLeads	ManufacturerID	int	4	10
tblESPMotorLeads	Model	nvarchar	200	0
tblESPMotorLeads	MotorLeadDescription	nvarchar	200	0
tblESPMotorLeads	MotorLeadID	int	4	10
tblESPMotorLeads	MotorLeadType	nvarchar	200	0
tblESPMotorLeads	Series	nvarchar	200	0
tblESPMotors	Amps	float	8	53
tblESPMotors	Description	nvarchar	510	0
tblESPMotors	Diameter	float	8	53
tblESPMotors	HP	float	8	53
tblESPMotors	Locked	bit	1	1
tblESPMotors	ManufacturerID	int	4	10
tblESPMotors	Model	nvarchar	200	0
tblESPMotors	MotorID	int	4	10
tblESPMotors	MotorModel	nvarchar	200	0
tblESPMotors	RatedTemperature	float	8	53
tblESPMotors	Series	nvarchar	200	0
tblESPMotors	Volts	float	8	53
tblESPPumps	BEPBPD	int	4	10
tblESPPumps	Data	varchar	-1	0
tblESPPumps	Eff1Coef	float	8	53
tblESPPumps	Eff2Coef	float	8	53
tblESPPumps	Eff3Coef	float	8	53
tblESPPumps	Eff4Coef	float	8	53
tblESPPumps	Eff5Coef	float	8	53
tblESPPumps	Eff6Coef	float	8	53
tblESPPumps	Eff7Coef	float	8	53
tblESPPumps	Eff8Coef	float	8	53
tblESPPumps	Eff9Coef	float	8	53
tblESPPumps	EfficiencyIntercept	float	8	53
tblESPPumps	ESPPumpID	int	4	10
tblESPPumps	Head1Coef	float	8	53
tblESPPumps	Head2Coef	float	8	53
tblESPPumps	Head3Coef	float	8	53
tblESPPumps	Head4Coef	float	8	53
tblESPPumps	Head5Coef	float	8	53
tblESPPumps	Head6Coef	float	8	53
tblESPPumps	Head7Coef	float	8	53
tblESPPumps	Head8Coef	float	8	53
tblESPPumps	Head9Coef	float	8	53
tblESPPumps	HeadIntercept	float	8	53
tblESPPumps	HousingPressureLimit	int	4	10
tblESPPumps	HP1Coef	float	8	53
tblESPPumps	HP2Coef	float	8	53
tblESPPumps	HP3Coef	float	8	53
tblESPPumps	HP4Coef	float	8	53
tblESPPumps	HP5Coef	float	8	53
tblESPPumps	HP6Coef	float	8	53
tblESPPumps	HP7Coef	float	8	53
tblESPPumps	HP8Coef	float	8	53
tblESPPumps	HP9Coef	float	8	53
tblESPPumps	HPIntercept	float	8	53
tblESPPumps	Locked	bit	1	1
tblESPPumps	ManufacturerID	int	4	10
tblESPPumps	MaxBPD	int	4	10
tblESPPumps	MinBPD	int	4	10
tblESPPumps	MinCasingSize	int	4	10
tblESPPumps	Pump	nvarchar	100	0
tblESPPumps	PumpModel	nvarchar	100	0
tblESPPumps	Series	nvarchar	100	0
tblESPPumps	UseCoefficients	bit	1	1
tblESPSeals	Description	nvarchar	510	0
tblESPSeals	Diameter	float	8	53
tblESPSeals	Locked	bit	1	1
tblESPSeals	ManufacturerID	int	4	10
tblESPSeals	Model	nvarchar	200	0
tblESPSeals	SealID	int	4	10
tblESPSeals	SealModel	nvarchar	100	0
tblESPSeals	Series	nvarchar	100	0
tblESPShutdownCauses	ActiveAlarmID	int	4	10
tblESPShutdownCauses	Description	nvarchar	100	0
tblESPShutdownCauses	Locked	bit	1	1
tblESPShutdownCauses	LockoutID	int	4	10
tblESPShutdownCauses	ShutdownID	int	4	10
tblESPShutdownHistoryRecords	AmpsA	float	8	53
tblESPShutdownHistoryRecords	AmpsB	float	8	53
tblESPShutdownHistoryRecords	AmpsC	float	8	53
tblESPShutdownHistoryRecords	AnalogIn1	float	8	53
tblESPShutdownHistoryRecords	AnalogIn2	float	8	53
tblESPShutdownHistoryRecords	ID	bigint	8	19
tblESPShutdownHistoryRecords	LockoutID	int	4	10
tblESPShutdownHistoryRecords	LogDateTime	datetime	8	23
tblESPShutdownHistoryRecords	NodeID	nvarchar	100	0
tblESPShutdownHistoryRecords	ShutdownID	int	4	10
tblESPShutdownHistoryRecords	VoltAB	float	8	53
tblESPShutdownHistoryRecords	VoltBC	float	8	53
tblESPShutdownHistoryRecords	VoltCA	float	8	53
tblESPTornadoCurveSetAnnotations	CurveSetMemberId	int	4	10
tblESPTornadoCurveSetAnnotations	Frequency	float	8	53
tblESPWellCables	ESPCableID	int	4	10
tblESPWellCables	NodeID	nvarchar	100	0
tblESPWellCables	OrderNumber	int	4	10
tblESPWellDetails	CableID	int	4	10
tblESPWellDetails	DateInstalled	datetime	8	23
tblESPWellDetails	DeratingFactor	int	4	10
tblESPWellDetails	DischargeGageDepth	real	4	24
tblESPWellDetails	EnableGasHandling	bit	1	1
tblESPWellDetails	ESPPumpID	int	4	10
tblESPWellDetails	Frequency	float	8	53
tblESPWellDetails	GasSeparatorEfficiency	real	4	24
tblESPWellDetails	MotorID	int	4	10
tblESPWellDetails	MotorLeadID	int	4	10
tblESPWellDetails	NodeID	nvarchar	100	0
tblESPWellDetails	NumberOfStages	int	4	10
tblESPWellDetails	SealID	int	4	10
tblESPWellDetails	UseDischargeGageInAnalysis	bit	1	1
tblESPWellDetails	UseSwitchboardFrequency	bit	1	1
tblESPWellDetails	UseVariableFrequency	bit	1	1
tblESPWellMotorLeads	ESPMotorLeadID	int	4	10
tblESPWellMotorLeads	NodeID	nvarchar	100	0
tblESPWellMotorLeads	OrderNumber	int	4	10
tblESPWellMotors	ESPMotorID	int	4	10
tblESPWellMotors	NodeID	nvarchar	100	0
tblESPWellMotors	OrderNumber	int	4	10
tblESPWellPumps	ESPPumpID	int	4	10
tblESPWellPumps	ESPWellID	nvarchar	100	0
tblESPWellPumps	NumberOfStages	int	4	10
tblESPWellPumps	OrderNumber	int	4	10
tblESPWellSeals	ESPSealID	int	4	10
tblESPWellSeals	NodeID	nvarchar	100	0
tblESPWellSeals	OrderNumber	int	4	10
tblESPWellTests	Amperage	real	4	24
tblESPWellTests	Frequency	real	4	24
tblESPWellTests	NodeID	nvarchar	100	0
tblESPWellTests	TestDate	datetime	8	23
tblESPWellTests	Voltage	real	4	24
tblEventGroups	AllowUserCreation	bit	1	1
tblEventGroups	EventTypeID	int	4	10
tblEventGroups	Name	varchar	50	0
tblEventGroups	PhraseID	int	4	10
tblEvents	Date	datetime	8	23
tblEvents	Description	varchar	50	0
tblEvents	EventID	int	4	10
tblEvents	EventTypeID	int	4	10
tblEvents	NodeID	nvarchar	100	0
tblEvents	Note	text	16	0
tblEvents	Status	varchar	50	0
tblEvents	UserID	varchar	50	0
tblExceptions	ExceptionGroupName	varchar	50	0
tblExceptions	NodeID	nvarchar	100	0
tblExceptions	Priority	int	4	10
tblExports	DatabaseConnectionID	int	4	10
tblExports	DestinationTable	nvarchar	-1	0
tblExports	Enabled	bit	1	1
tblExports	ExportFilePath	nvarchar	-1	0
tblExports	ExportID	bigint	8	19
tblExports	ExportSQL	nvarchar	-1	0
tblExports	FileMode	nvarchar	20	0
tblExports	LastRun	datetime	8	23
tblExports	SQLMode	nvarchar	20	0
tblFacilityTagGroups	DisplayOrder	int	4	10
tblFacilityTagGroups	ID	int	4	10
tblFacilityTagGroups	Name	nvarchar	60	0
tblFacilityTagHistory	Address	varchar	40	0
tblFacilityTagHistory	Date	datetime	8	23
tblFacilityTagHistory	NodeID	nvarchar	100	0
tblFacilityTagHistory	Value	real	4	24
tblFacilityTags	Address	int	4	10
tblFacilityTags	AlarmAction	int	4	10
tblFacilityTags	AlarmArg	varchar	50	0
tblFacilityTags	AlarmState	int	4	10
tblFacilityTags	AlarmTextClear	nvarchar	510	0
tblFacilityTags	AlarmTextHi	nvarchar	510	0
tblFacilityTags	AlarmTextLo	nvarchar	510	0
tblFacilityTags	ArchiveFunction	int	4	10
tblFacilityTags	Bit	int	4	10
tblFacilityTags	CaptureType	int	4	10
tblFacilityTags	ContactListID	int	4	10
tblFacilityTags	CurrentValue	real	4	24
tblFacilityTags	DataType	int	4	10
tblFacilityTags	Deadband	real	4	24
tblFacilityTags	Decimals	int	4	10
tblFacilityTags	Description	varchar	255	0
tblFacilityTags	DestinationType	int	4	10
tblFacilityTags	DetailViewOnly	bit	1	1
tblFacilityTags	DisplayOrder	int	4	10
tblFacilityTags	Enabled	bit	1	1
tblFacilityTags	EngHi	real	4	24
tblFacilityTags	EngLo	real	4	24
tblFacilityTags	EngUnits	varchar	50	0
tblFacilityTags	FacilityTagGroupID	int	4	10
tblFacilityTags	GroupNodeID	nvarchar	100	0
tblFacilityTags	GroupStatusView	int	4	10
tblFacilityTags	LastCaptureDate	datetime	8	23
tblFacilityTags	Latitude	decimal	5	8
tblFacilityTags	LimitHi	real	4	24
tblFacilityTags	LimitLo	real	4	24
tblFacilityTags	Longitude	decimal	5	9
tblFacilityTags	Name	nvarchar	200	0
tblFacilityTags	NodeID	nvarchar	100	0
tblFacilityTags	NumConsecAlarms	int	4	10
tblFacilityTags	NumConsecAlarmsAllowed	int	4	10
tblFacilityTags	PagingGroup	varchar	50	0
tblFacilityTags	ParamStandardType	int	4	10
tblFacilityTags	RawHi	int	4	10
tblFacilityTags	RawLo	int	4	10
tblFacilityTags	ResponderListID	int	4	10
tblFacilityTags	StateID	int	4	10
tblFacilityTags	Tag	varchar	50	0
tblFacilityTags	Topic	varchar	50	0
tblFacilityTags	TrendType	int	4	10
tblFacilityTags	UnitType	smallint	2	5
tblFacilityTags	UpdateDate	datetime	8	23
tblFacilityTags	VoiceNodeID	nvarchar	100	0
tblFacilityTags	VoiceTextClear	nvarchar	510	0
tblFacilityTags	VoiceTextHi	nvarchar	510	0
tblFacilityTags	VoiceTextLo	nvarchar	510	0
tblFacilityTags	WellGroupName	varchar	50	0
tblFacilityTags	Writeable	bit	1	1
tblFailureCauseAssociations	CauseID	int	4	10
tblFailureCauseAssociations	FailureID	int	4	10
tblFailureCauseAssociations	ID	int	4	10
tblFailureCauseHierarchy	ChildCauseID	int	4	10
tblFailureCauseHierarchy	ID	int	4	10
tblFailureCauseHierarchy	ParentCauseID	int	4	10
tblFailureCauses	ID	int	4	10
tblFailureCauses	Name	nvarchar	510	0
tblFailureCauses	PhraseID	int	4	10
tblFailureComponents	ApplicationID	int	4	10
tblFailureComponents	ID	int	4	10
tblFailureComponents	Name	nvarchar	510	0
tblFailureComponents	PhraseID	int	4	10
tblFailureMechanisms	ID	int	4	10
tblFailureMechanisms	Name	nvarchar	510	0
tblFailureMechanisms	PhraseID	int	4	10
tblFailureMechanismsCauses	CauseID	int	4	10
tblFailureMechanismsCauses	ID	int	4	10
tblFailureMechanismsCauses	MechanismID	int	4	10
tblFailureModes	ID	int	4	10
tblFailureModes	Name	nvarchar	510	0
tblFailureModes	PhraseID	int	4	10
tblFailurePullReasons	ID	int	4	10
tblFailurePullReasons	Name	nvarchar	510	0
tblFailurePullReasons	PhraseID	int	4	10
tblFailures	ComponentID	int	4	10
tblFailures	Date	datetime	8	23
tblFailures	ID	int	4	10
tblFailures	IdentifiedDate	datetime	8	23
tblFailures	Locked	bit	1	1
tblFailures	MechanismID	int	4	10
tblFailures	ModeID	int	4	10
tblFailures	NodeID	nvarchar	100	0
tblFailures	Notes	nvarchar	-1	0
tblFailures	PullReasonID	int	4	10
tblFailures	RecoveryDate	datetime	8	23
tblFailures	RequestedServiceID	int	4	10
tblFailures	RigDownDate	datetime	8	23
tblFailures	RigUpDate	datetime	8	23
tblFailures	SubcomponentID	int	4	10
tblFailures	TotalCost	money	8	19
tblFailureServiceRecords	Date	datetime	8	23
tblFailureServiceRecords	FailureID	int	4	10
tblFailureServiceRecords	ID	int	4	10
tblFailureServiceRecords	LaborCost	money	8	19
tblFailureServiceRecords	MaterialCost	money	8	19
tblFailureServiceRecords	Notes	nvarchar	-1	0
tblFailureServiceRecords	ServiceID	int	4	10
tblFailureServices	ApplicationID	int	4	10
tblFailureServices	DefaultLaborCost	money	8	19
tblFailureServices	DefaultMaterialCost	money	8	19
tblFailureServices	ID	int	4	10
tblFailureServices	Name	nvarchar	510	0
tblFailureServices	PhraseID	int	4	10
tblFailureSubcomponents	ComponentID	int	4	10
tblFailureSubcomponents	ID	int	4	10
tblFailureSubcomponents	Name	nvarchar	510	0
tblFailureSubcomponents	PhraseID	int	4	10
tblFieldDataSources	ID	int	4	10
tblFieldDataSources	Name	nvarchar	-1	0
tblFieldDataSources	PhraseID	int	4	10
tblFieldGroups	ID	int	4	10
tblFieldGroups	Name	nvarchar	-1	0
tblFieldGroups	PhraseID	int	4	10
tblFields	DataSource	int	4	10
tblFields	FieldGroupID	int	4	10
tblFields	Locked	bit	1	1
tblFields	Name	nvarchar	100	0
tblFields	PhraseID	int	4	10
tblFiles	DescriptionPhraseID	int	4	10
tblFiles	File	image	16	0
tblFiles	FileName	nvarchar	100	0
tblFiles	FileTypeID	int	4	10
tblFiles	GroupPhraseID	int	4	10
tblFiles	NodeID	nvarchar	100	0
tblFiles	PreviewFile	image	16	0
tblFiles	ThumbnailFile	image	16	0
tblFiles	TitlePhraseID	int	4	10
tblFileTypes	FileType	varchar	15	0
tblFileTypes	FileTypeID	int	4	10
tblFluidLevelShotPressures	ID	bigint	8	19
tblFluidLevelShotPressures	ShotID	bigint	8	19
tblFluidLevelShotPressures	ShotIndex	int	4	10
tblFluidLevelShotPressures	ShotPressure	real	4	24
tblFluidLevelShots	AmbientPressure	real	4	24
tblFluidLevelShots	AmplificationFactor	int	4	10
tblFluidLevelShots	AmplificationParameter	int	4	10
tblFluidLevelShots	CasingGasPressure	real	4	24
tblFluidLevelShots	CasingVolume	real	4	24
tblFluidLevelShots	DeadFluidLevelGilbert	int	4	10
tblFluidLevelShots	DepthOfDeadFluidLevel	int	4	10
tblFluidLevelShots	DepthOfGraphScale	int	4	10
tblFluidLevelShots	DepthOfOilInWell	int	4	10
tblFluidLevelShots	DpDt	real	4	24
tblFluidLevelShots	ElapsedTimeForShot	int	4	10
tblFluidLevelShots	FluidLevelEcho	int	4	10
tblFluidLevelShots	FluidLevelKen	int	4	10
tblFluidLevelShots	FluidLevelSelected	int	4	10
tblFluidLevelShots	FluidLevelShotSamplingFrequency	int	4	10
tblFluidLevelShots	GilbertCasingGradient	real	4	24
tblFluidLevelShots	ID	bigint	8	19
tblFluidLevelShots	InstantaneousGasProduction	real	4	24
tblFluidLevelShots	LogDateTime	datetime	8	23
tblFluidLevelShots	MaximumPressureNormalized	int	4	10
tblFluidLevelShots	MaximumShotPressure	real	4	24
tblFluidLevelShots	MinimumPressureNormalized	int	4	10
tblFluidLevelShots	MinimumShotPressure	real	4	24
tblFluidLevelShots	NodeID	nvarchar	100	0
tblFluidLevelShots	NumberOfFluidShotPressureSamples	int	4	10
tblFluidLevelShots	NumberOfSamplesAcquired	int	4	10
tblFluidLevelShots	PickIndexPointK	int	4	10
tblFluidLevelShots	PickIndexPointS	int	4	10
tblFluidLevelShots	PlotEnd	int	4	10
tblFluidLevelShots	PlotStart	int	4	10
tblFluidLevelShots	PressureAtStartOfShot	real	4	24
tblFluidLevelShots	PressurizationForThisShot	int	4	10
tblFluidLevelShots	PumpDepth	int	4	10
tblFluidLevelShots	PumpIntakePressureGilbert	int	4	10
tblFluidLevelShots	RangeOfShotPressures	int	4	10
tblFluidLevelShots	RUsed	int	4	10
tblFluidLevelShots	ScalerConversionOfFluidShotData	real	4	24
tblFluidLevelShots	SelectedPick	int	4	10
tblFluidLevelShots	ShotIndex	int	4	10
tblFluidLevelShots	ShotMarker1	int	4	10
tblFluidLevelShots	TargetPressureForShot	real	4	24
tblFluidLevelShots	TodayGasFlow	real	4	24
tblFluidLevelShots	TuningParameterDjumpf	int	4	10
tblFluidLevelShots	TuningParameterDjumpi	int	4	10
tblFluidLevelShots	TuningParameterJump	int	4	10
tblFluidLevelShots	VelocityOfSound	real	4	24
tblFluidLevelShots	YesterdayGasFlow	real	4	24
tblGLAnalysisResults	AdjustedAnalysisToDownholeGaugeReading	bit	1	1
tblGLAnalysisResults	AnalysisType	int	4	10
tblGLAnalysisResults	BottomholeTemperature	real	4	24
tblGLAnalysisResults	BottomholeTemperatureSource	int	4	10
tblGLAnalysisResults	BubblepointPressure	real	4	24
tblGLAnalysisResults	CasingID	real	4	24
tblGLAnalysisResults	CasingPressure	real	4	24
tblGLAnalysisResults	CasingPressureSource	int	4	10
tblGLAnalysisResults	DownholeGageDepth	real	4	24
tblGLAnalysisResults	DownholeGagePressure	real	4	24
tblGLAnalysisResults	DownholeGagePressureSource	int	4	10
tblGLAnalysisResults	EstimateInjectionDepth	bit	1	1
tblGLAnalysisResults	FBHPForOptimumLiquidRate	real	4	24
tblGLAnalysisResults	FlowCorrelationID	int	4	10
tblGLAnalysisResults	FlowingBHP	real	4	24
tblGLAnalysisResults	FlowingBHPAtInjectionDepth	real	4	24
tblGLAnalysisResults	FormationGOR	real	4	24
tblGLAnalysisResults	GasInjectionDepth	real	4	24
tblGLAnalysisResults	GasRate	real	4	24
tblGLAnalysisResults	GasRateSource	int	4	10
tblGLAnalysisResults	GasSpecificGravity	real	4	24
tblGLAnalysisResults	GasSpecificGravitySource	int	4	10
tblGLAnalysisResults	GLRForMaxLiquidRate	real	4	24
tblGLAnalysisResults	GLRForOptimumLiquidRate	real	4	24
tblGLAnalysisResults	GrossRate	real	4	24
tblGLAnalysisResults	ID	int	4	10
tblGLAnalysisResults	InjectedGasRate	real	4	24
tblGLAnalysisResults	InjectedGasRateSource	int	4	10
tblGLAnalysisResults	InjectedGLR	real	4	24
tblGLAnalysisResults	InjectionRateForMaxLiquidRate	real	4	24
tblGLAnalysisResults	InjectionRateForOptimumLiquidRate	real	4	24
tblGLAnalysisResults	InjectionRateForTubingCriticalVelocity	real	4	24
tblGLAnalysisResults	IPRSlope	real	4	24
tblGLAnalysisResults	IsInjectingBelowTubing	bit	1	1
tblGLAnalysisResults	IsProcessed	bit	1	1
tblGLAnalysisResults	KillFluidLevel	real	4	24
tblGLAnalysisResults	MaxLiquidRate	real	4	24
tblGLAnalysisResults	MeasuredWellDepth	real	4	24
tblGLAnalysisResults	MinimumFBHP	real	4	24
tblGLAnalysisResults	MultiphaseFlowCorrelationSource	int	4	10
tblGLAnalysisResults	NodeID	nvarchar	100	0
tblGLAnalysisResults	OilFormationVolumeFactorCorrelationID	int	4	10
tblGLAnalysisResults	OilRate	real	4	24
tblGLAnalysisResults	OilRateSource	int	4	10
tblGLAnalysisResults	OilSpecificGravity	real	4	24
tblGLAnalysisResults	OilSpecificGravitySource	int	4	10
tblGLAnalysisResults	OilViscosityCorrelationID	int	4	10
tblGLAnalysisResults	OptimumLiquidRate	real	4	24
tblGLAnalysisResults	PercentCO2	real	4	24
tblGLAnalysisResults	PercentH2S	real	4	24
tblGLAnalysisResults	PercentN2	real	4	24
tblGLAnalysisResults	ProcessedDate	datetime	8	23
tblGLAnalysisResults	ProductivityIndex	real	4	24
tblGLAnalysisResults	RateAtBubblePoint	real	4	24
tblGLAnalysisResults	RateAtMaxLiquid	real	4	24
tblGLAnalysisResults	RateAtMaxOil	real	4	24
tblGLAnalysisResults	ReservoirFluidLevel	real	4	24
tblGLAnalysisResults	ReservoirPressure	real	4	24
tblGLAnalysisResults	ResultMessage	nvarchar	-1	0
tblGLAnalysisResults	SolutionGasOilRatioCorrelationID	int	4	10
tblGLAnalysisResults	Success	bit	1	1
tblGLAnalysisResults	TestDate	datetime	8	23
tblGLAnalysisResults	TubingCriticalVelocity	real	4	24
tblGLAnalysisResults	TubingCriticalVelocityCorrelationID	int	4	10
tblGLAnalysisResults	TubingID	real	4	24
tblGLAnalysisResults	TubingOD	real	4	24
tblGLAnalysisResults	TubingPressureSource	int	4	10
tblGLAnalysisResults	UseDownholeGageInAnalysis	bit	1	1
tblGLAnalysisResults	ValveCriticalVelocity	real	4	24
tblGLAnalysisResults	VerticalWellDepth	real	4	24
tblGLAnalysisResults	WaterCut	int	4	10
tblGLAnalysisResults	WaterRate	real	4	24
tblGLAnalysisResults	WaterRateSource	int	4	10
tblGLAnalysisResults	WaterSpecificGravity	real	4	24
tblGLAnalysisResults	WaterSpecificGravitySource	int	4	10
tblGLAnalysisResults	WellheadPressure	real	4	24
tblGLAnalysisResults	WellheadTemperature	real	4	24
tblGLAnalysisResults	WellHeadTemperatureSource	int	4	10
tblGLAnalysisResults	ZFactorCorrelationID	int	4	10
tblGLCurveSetAnnotations	AssociatedGasLiquidRatio	float	8	53
tblGLCurveSetAnnotations	CurveSetMemberId	int	4	10
tblGLCurveSetAnnotations	IsPrimary	bit	1	1
tblGLFlowControlDeviceStates	ID	int	4	10
tblGLFlowControlDeviceStates	Name	nvarchar	100	0
tblGLFlowControlDeviceStates	PhraseID	int	4	10
tblGLManufacturers	Locked	bit	1	1
tblGLManufacturers	Manufacturer	nvarchar	200	0
tblGLManufacturers	ManufacturerID	int	4	10
tblGLOrificeStatus	GLAnalysisResultID	int	4	10
tblGLOrificeStatus	InjectionPressureAtDepth	real	4	24
tblGLOrificeStatus	InjectionRateForTubingCriticalVelocity	real	4	24
tblGLOrificeStatus	IsInjectingGas	bit	1	1
tblGLOrificeStatus	NodeID	nvarchar	100	0
tblGLOrificeStatus	OrificeState	int	4	10
tblGLOrificeStatus	TubingCriticalVelocityAtDepth	real	4	24
tblGLValveConfigurationOptions	ID	int	4	10
tblGLValveConfigurationOptions	Name	nvarchar	100	0
tblGLValveConfigurationOptions	PhraseID	int	4	10
tblGLValves	BellowsArea	real	4	24
tblGLValves	Description	nvarchar	100	0
tblGLValves	Diameter	real	4	24
tblGLValves	ID	int	4	10
tblGLValves	ManufacturerID	int	4	10
tblGLValves	OneMinusR	real	4	24
tblGLValves	PortArea	real	4	24
tblGLValves	PortSize	real	4	24
tblGLValves	PortToBellowsAreaRatio	real	4	24
tblGLValves	ProductionPressureEffectFactor	real	4	24
tblGLValveStatus	ClosingPressureAtDepth	real	4	24
tblGLValveStatus	GasRate	real	4	24
tblGLValveStatus	GLAnalysisResultID	int	4	10
tblGLValveStatus	GLWellValveID	int	4	10
tblGLValveStatus	ID	int	4	10
tblGLValveStatus	InjectionPressureAtDepth	real	4	24
tblGLValveStatus	InjectionRateForTubingCriticalVelocity	real	4	24
tblGLValveStatus	IsInjectingGas	bit	1	1
tblGLValveStatus	OpeningPressureAtDepth	real	4	24
tblGLValveStatus	PercentOpen	real	4	24
tblGLValveStatus	TubingCriticalVelocityAtDepth	real	4	24
tblGLValveStatus	ValveState	int	4	10
tblGLWellDetails	DownholeGageDepth	real	4	24
tblGLWellDetails	EstimateInjectionDepth	bit	1	1
tblGLWellDetails	FormationGasOilRatio	real	4	24
tblGLWellDetails	GasInjectionDepth	real	4	24
tblGLWellDetails	GasInjectionPressure	real	4	24
tblGLWellDetails	InjectedGasSpecificGravity	real	4	24
tblGLWellDetails	InjectingBelowTubing	bit	1	1
tblGLWellDetails	NodeID	nvarchar	100	0
tblGLWellDetails	PercentCO2	real	4	24
tblGLWellDetails	PercentH2S	real	4	24
tblGLWellDetails	PercentN2	real	4	24
tblGLWellDetails	UseDownholeGageInAnalysis	bit	1	1
tblGLWellDetails	ValveConfigurationOption	int	4	10
tblGLWellOrifice	ManufacturerID	int	4	10
tblGLWellOrifice	MeasuredDepth	real	4	24
tblGLWellOrifice	NodeID	nvarchar	100	0
tblGLWellOrifice	PortSize	real	4	24
tblGLWellOrifice	VerticalDepth	real	4	24
tblGLWellValves	ClosingPressureAtDepth	real	4	24
tblGLWellValves	ClosingPressureAtSurface	real	4	24
tblGLWellValves	GLValveID	int	4	10
tblGLWellValves	ID	int	4	10
tblGLWellValves	MeasuredDepth	real	4	24
tblGLWellValves	NodeID	nvarchar	100	0
tblGLWellValves	OpeningPressureAtDepth	real	4	24
tblGLWellValves	OpeningPressureAtSurface	real	4	24
tblGLWellValves	TestRackOpeningPressure	real	4	24
tblGLWellValves	VerticalDepth	real	4	24
tblGraphViews	Snapshot	varbinary	-1	0
tblGraphViews	UserID	varchar	50	0
tblGraphViews	ViewID	int	4	10
tblGraphViews	ViewName	varchar	50	0
tblGraphViewSettings	Property	varchar	50	0
tblGraphViewSettings	Value	varchar	50	0
tblGraphViewSettings	ViewID	int	4	10
tblGraphViewTrends	Address	int	4	10
tblGraphViewTrends	AggregateType	smallint	2	5
tblGraphViewTrends	Axis	int	4	10
tblGraphViewTrends	Color	int	4	10
tblGraphViewTrends	ColumnName	nvarchar	200	0
tblGraphViewTrends	MeasureType	int	4	10
tblGraphViewTrends	POCType	int	4	10
tblGraphViewTrends	Source	int	4	10
tblGraphViewTrends	ViewID	int	4	10
tblGraphViewTrendSources	Description	varchar	50	0
tblGraphViewTrendSources	ID	int	4	10
tblGraphViewTrendSources	PhraseID	int	4	10
tblGroupDataHistory	Date	datetime	8	23
tblGroupDataHistory	GroupParameterID	int	4	10
tblGroupDataHistory	ID	bigint	8	19
tblGroupDataHistory	Name	nvarchar	100	0
tblGroupDataHistory	value	float	8	53
tblGroupMembershipCache	GroupName	nvarchar	100	0
tblGroupMembershipCache	NodeID	nvarchar	100	0
tblGroupParameters	Description	nvarchar	100	0
tblGroupParameters	FunctionType	smallint	2	5
tblGroupParameters	ID	int	4	10
tblGroupParameters	PhraseID	int	4	10
tblGroupParameterSources	Address	int	4	10
tblGroupParameterSources	FunctionType	smallint	2	5
tblGroupParameterSources	GroupParameterID	int	4	10
tblGroupParameterSources	ID	int	4	10
tblGroupParameterSources	POCType	int	4	10
tblGroupStandardColumns	Definition	nvarchar	1998	0
tblGroupStandardColumns	ID	int	4	10
tblGroupStandardColumns	Name	nvarchar	50	0
tblGroupStatusColumnFormats	DataType	nvarchar	100	0
tblGroupStatusColumnFormats	FormatID	int	4	10
tblGroupStatusColumnFormats	FormatMask	nvarchar	100	0
tblGroupStatusColumnFormats	Locked	bit	1	1
tblGroupStatusColumns	Alias	nvarchar	200	0
tblGroupStatusColumns	Align	int	4	10
tblGroupStatusColumns	ColumnID	int	4	10
tblGroupStatusColumns	ColumnName	nvarchar	200	0
tblGroupStatusColumns	Formula	nvarchar	-1	0
tblGroupStatusColumns	Measure	varchar	50	0
tblGroupStatusColumns	SourceID	int	4	10
tblGroupStatusColumns	Visible	int	4	10
tblGroupStatusFilterColumns	ColumnID	int	4	10
tblGroupStatusFilterColumns	ColumnName	nvarchar	200	0
tblGroupStatusFilterColumns	FilterID	int	4	10
tblGroupStatusFilterColumns	ID	int	4	10
tblGroupStatusFilterColumns	IsOrCondition	bit	1	1
tblGroupStatusFilterConditions	CompareValue	nvarchar	200	0
tblGroupStatusFilterConditions	ComparisonOperator	int	4	10
tblGroupStatusFilterConditions	FilterColumnID	int	4	10
tblGroupStatusFilterConditions	ID	int	4	10
tblGroupStatusFilterConditions	IsColumn	bit	1	1
tblGroupStatusFilters	FilterName	nvarchar	200	0
tblGroupStatusFilters	ID	int	4	10
tblGroupStatusTables	TableID	int	4	10
tblGroupStatusTables	TableName	varchar	50	0
tblGroupStatusUserViews	GroupName	varchar	50	0
tblGroupStatusUserViews	UserID	varchar	50	0
tblGroupStatusUserViews	ViewID	int	4	10
tblGroupStatusViews	FilterID	int	4	10
tblGroupStatusViews	UserID	varchar	50	0
tblGroupStatusViews	ViewID	int	4	10
tblGroupStatusViews	ViewName	varchar	50	0
tblGroupStatusViewsColumns	ColumnID	int	4	10
tblGroupStatusViewsColumns	FormatID	int	4	10
tblGroupStatusViewsColumns	Orientation	int	4	10
tblGroupStatusViewsColumns	Position	int	4	10
tblGroupStatusViewsColumns	ViewID	int	4	10
tblGroupStatusViewsColumns	Width	int	4	10
tblHostAlarms	Address	int	4	10
tblHostAlarms	AlarmAction	int	4	10
tblHostAlarms	AlarmState	int	4	10
tblHostAlarms	AlarmType	int	4	10
tblHostAlarms	Average30D	real	4	24
tblHostAlarms	CyclesLimit	int	4	10
tblHostAlarms	CyclesValue	int	4	10
tblHostAlarms	DateTimeNotificationIssued	datetime	8	23
tblHostAlarms	DiscreteNormalState	int	4	10
tblHostAlarms	Enabled	bit	1	1
tblHostAlarms	ExactValue	real	4	24
tblHostAlarms	HiHiLimit	real	4	24
tblHostAlarms	HiLimit	real	4	24
tblHostAlarms	ID	int	4	10
tblHostAlarms	IgnoreValue	real	4	24
tblHostAlarms	IgnoreZeroAddress	int	4	10
tblHostAlarms	LastStateChange	datetime	8	23
tblHostAlarms	LoLimit	real	4	24
tblHostAlarms	LoLoLimit	real	4	24
tblHostAlarms	MinToMaxLimit	int	4	10
tblHostAlarms	NodeID	nvarchar	100	0
tblHostAlarms	NumDays	real	4	24
tblHostAlarms	PagerID	varchar	50	0
tblHostAlarms	PagerMessage	varchar	50	0
tblHostAlarms	PagingEnabled	bit	1	1
tblHostAlarms	PercentChange	int	4	10
tblHostAlarms	PersistentNotificationMinutes	int	4	10
tblHostAlarms	Priority	int	4	10
tblHostAlarms	PushEnabled	bit	1	1
tblHostAlarms	StandardDev	real	4	24
tblHostAlarms	ValueChange	real	4	24
tblHostAlarms	XDiagOutputsID	int	4	10
tblImports	AlternateID	smallint	2	5
tblImports	Description	nvarchar	400	0
tblImports	DestinationTableName	nvarchar	400	0
tblImports	Enabled	bit	1	1
tblImports	ID	smallint	2	5
tblImports	IDField	nvarchar	100	0
tblImports	OrderNum	smallint	2	5
tblImports	SourceConnectString	nvarchar	-1	0
tblImports	SQLText	nvarchar	-1	0
tblImports	SQLTextNodeList	nvarchar	-1	0
tblIPRAnalysisResults	AnalysisCorrelationID	int	4	10
tblIPRAnalysisResults	BubblepointPressure	real	4	24
tblIPRAnalysisResults	BubblepointPressureSource	int	4	10
tblIPRAnalysisResults	FBHPCalculationResult	nvarchar	-1	0
tblIPRAnalysisResults	FBHPCalculationUsedDefaults	bit	1	1
tblIPRAnalysisResults	FlowingBottomholePressure	real	4	24
tblIPRAnalysisResults	GrossRate	real	4	24
tblIPRAnalysisResults	ID	int	4	10
tblIPRAnalysisResults	IPRSlope	real	4	24
tblIPRAnalysisResults	NodeID	nvarchar	100	0
tblIPRAnalysisResults	ProductivityIndex	real	4	24
tblIPRAnalysisResults	RateAtBubblePoint	real	4	24
tblIPRAnalysisResults	RateAtMaxLiquid	real	4	24
tblIPRAnalysisResults	RateAtMaxOil	real	4	24
tblIPRAnalysisResults	SBHPCalculationResult	nvarchar	-1	0
tblIPRAnalysisResults	StaticBottomholePressure	real	4	24
tblIPRAnalysisResults	TestDate	datetime	8	23
tblIPRAnalysisResults	WaterCut	real	4	24
tblIPRAnalysisResults	WaterRate	real	4	24
tblIPRWellConfig	AnalysisCorrelationID	int	4	10
tblIPRWellConfig	FBHPAnalysisSourceID	int	4	10
tblIPRWellConfig	GrossRateAnalysisSourceID	int	4	10
tblIPRWellConfig	NodeID	nvarchar	100	0
tblIPRWellConfig	TestDate	datetime	8	23
tblIPRWellConfig	WaterCutAnalysisSourceID	int	4	10
tblKmlMapLayers	Description	nvarchar	100	0
tblKmlMapLayers	Enabled	bit	1	1
tblKmlMapLayers	ID	int	4	10
tblKmlMapLayers	URL	nvarchar	510	0
tblLACTBatchLog	BatchNumber	int	4	10
tblLACTBatchLog	CloseRead	float	8	53
tblLACTBatchLog	CompanyId	int	4	10
tblLACTBatchLog	Data1	float	8	53
tblLACTBatchLog	Data10	int	4	10
tblLACTBatchLog	Data2	float	8	53
tblLACTBatchLog	Data3	float	8	53
tblLACTBatchLog	Data4	float	8	53
tblLACTBatchLog	Data5	float	8	53
tblLACTBatchLog	Data6	int	4	10
tblLACTBatchLog	Data7	int	4	10
tblLACTBatchLog	Data8	int	4	10
tblLACTBatchLog	Data9	int	4	10
tblLACTBatchLog	Density	float	8	53
tblLACTBatchLog	DensMtrFactor	float	8	53
tblLACTBatchLog	FlowPressure	float	8	53
tblLACTBatchLog	FlowRate	float	8	53
tblLACTBatchLog	FlowTemperature	float	8	53
tblLACTBatchLog	GrossVolume	float	8	53
tblLACTBatchLog	IndicatedVolume	float	8	53
tblLACTBatchLog	Mass	float	8	53
tblLACTBatchLog	MeterFactor	float	8	53
tblLACTBatchLog	MeterId	int	4	10
tblLACTBatchLog	NetSW	float	8	53
tblLACTBatchLog	NetVolume	float	8	53
tblLACTBatchLog	NodeID	nvarchar	100	0
tblLACTBatchLog	ObservedDensity	float	8	53
tblLACTBatchLog	ObservedPressure	float	8	53
tblLACTBatchLog	ObservedTemperature	float	8	53
tblLACTBatchLog	OpenRead	float	8	53
tblLACTBatchLog	PressureCorrectionFactor	float	8	53
tblLACTBatchLog	ProductId	int	4	10
tblLACTBatchLog	StartTime	datetime	8	23
tblLACTBatchLog	StopTime	datetime	8	23
tblLACTBatchLog	SWPercent	float	8	53
tblLACTBatchLog	TemperatureCorrectionFactor	float	8	53
tblLACTBatchLog	TransferType	int	4	10
tblLACTBatchLog	TruckId	int	4	10
tblLocalePhrases	1031	nvarchar	2048	0
tblLocalePhrases	1033	nvarchar	2048	0
tblLocalePhrases	1034	nvarchar	2048	0
tblLocalePhrases	1036	nvarchar	2048	0
tblLocalePhrases	1049	nvarchar	2048	0
tblLocalePhrases	2052	nvarchar	2048	0
tblLocalePhrases	Locked	bit	1	1
tblLocalePhrases	PhraseID	int	4	10
tblLocalePhrases	PhraseType	int	4	10
tblMaps	Description	nvarchar	100	0
tblMaps	MapID	int	4	10
tblMaps	MapName	nvarchar	50	0
tblMaps	NELatitude	real	4	24
tblMaps	NELongitude	real	4	24
tblMaps	SWLatitude	real	4	24
tblMaps	SWLongitude	real	4	24
tblMeterColumns	Alias	nvarchar	200	0
tblMeterColumns	ID	int	4	10
tblMeterColumns	MeterTypeID	int	4	10
tblMeterColumns	Name	nvarchar	200	0
tblMeterColumns	Width	int	4	10
tblMeterHistory	AccumVolume	real	4	24
tblMeterHistory	Approved	bit	1	1
tblMeterHistory	CasingPressure	real	4	24
tblMeterHistory	CPrime	float	8	53
tblMeterHistory	Custom01	real	4	24
tblMeterHistory	Custom02	real	4	24
tblMeterHistory	Custom03	real	4	24
tblMeterHistory	Custom04	real	4	24
tblMeterHistory	Custom05	real	4	24
tblMeterHistory	Date	datetime	8	23
tblMeterHistory	DateModified	datetime	8	23
tblMeterHistory	DiffPressure	float	8	53
tblMeterHistory	Energy	float	8	53
tblMeterHistory	HrsOn	float	8	53
tblMeterHistory	InstantRate	real	4	24
tblMeterHistory	NodeID	nvarchar	100	0
tblMeterHistory	Pressure	real	4	24
tblMeterHistory	RecordType	int	4	10
tblMeterHistory	TargetPressure	real	4	24
tblMeterHistory	TargetRate	real	4	24
tblMeterHistory	Temp	float	8	53
tblMeterHistory	TubingPressure	real	4	24
tblMeterHistory	UserID	nvarchar	510	0
tblMeterHistory	ValvePosition	real	4	24
tblMeterHistory	Volume	real	4	24
tblMeterTypes	ID	int	4	10
tblMeterTypes	Name	nvarchar	200	0
tblMethodOfProduction	Description	nvarchar	200	0
tblMethodOfProduction	ID	int	4	10
tblMethodOfProduction	Name	nvarchar	100	0
tblMorningReports	Destination	varchar	50	0
tblMorningReports	Enabled	bit	1	1
tblMorningReports	GroupName	varchar	50	0
tblMorningReports	ReportName	varchar	50	0
tblMorningReports	ReportTypeID	int	4	10
tblMorningReports	ScheduleGroup	varchar	25	0
tblMotorKinds	MotorKindID	int	4	10
tblMotorKinds	Name	nvarchar	510	0
tblMotorKinds	UHS	bit	1	1
tblMotorSettings	FullLoadRPM	real	4	24
tblMotorSettings	MaxLoad	real	4	24
tblMotorSettings	MaxSPV	real	4	24
tblMotorSettings	MotorSettingID	int	4	10
tblMotorSettings	MotorSizeID	int	4	10
tblMotorSettings	Name	nvarchar	510	0
tblMotorSettings	RatedHP	real	4	24
tblMotorSizes	MotorKindID	int	4	10
tblMotorSizes	MotorSizeID	int	4	10
tblMotorSizes	Name	nvarchar	510	0
tblNodeDocuments	DocumentID	int	4	10
tblNodeDocuments	ID	int	4	10
tblNodeDocuments	NodeID	nvarchar	100	0
tblNodeMaster	AdhocGroup1	varchar	20	0
tblNodeMaster	AdhocGroup2	varchar	20	0
tblNodeMaster	AdhocGroup3	varchar	20	0
tblNodeMaster	AlarmAction	int	4	10
tblNodeMaster	AllowStartLock	bit	1	1
tblNodeMaster	APIPassword	nvarchar	-1	0
tblNodeMaster	APIPort	int	4	10
tblNodeMaster	APIUsername	varchar	50	0
tblNodeMaster	ApplicationID	int	4	10
tblNodeMaster	BakerVersion	int	4	10
tblNodeMaster	CommAttempt	smallint	2	5
tblNodeMaster	CommConsecFails	int	4	10
tblNodeMaster	Comment	nvarchar	1000	0
tblNodeMaster	Comment2	nvarchar	1000	0
tblNodeMaster	Comment3	nvarchar	1000	0
tblNodeMaster	CommStatus	varchar	50	0
tblNodeMaster	CommSuccess	smallint	2	5
tblNodeMaster	CompanyID	int	4	10
tblNodeMaster	CreationDateTime	datetime	8	23
tblNodeMaster	DAL_HorizontalWell	bit	1	1
tblNodeMaster	DataCollection	bit	1	1
tblNodeMaster	DefaultWindowID	nvarchar	-1	0
tblNodeMaster	DisableCode	nvarchar	12	0
tblNodeMaster	DisplayName	nvarchar	100	0
tblNodeMaster	Enabled	bit	1	1
tblNodeMaster	EnergyGroup	int	4	10
tblNodeMaster	EnergyMode	int	4	10
tblNodeMaster	FastScan	bit	1	1
tblNodeMaster	FilterID	int	4	10
tblNodeMaster	FirmwareVersion	real	4	24
tblNodeMaster	FiterID	int	4	10
tblNodeMaster	GroupSDFlag	bit	1	1
tblNodeMaster	HighPriAlarm	nvarchar	100	0
tblNodeMaster	HostAlarm	varchar	50	0
tblNodeMaster	HostAlarmState	smallint	2	5
tblNodeMaster	InferredProd	real	4	24
tblNodeMaster	InstalledDate	datetime	8	23
tblNodeMaster	KWH	int	4	10
tblNodeMaster	LastAlarmDate	datetime	8	23
tblNodeMaster	LastAnalCondition	varchar	80	0
tblNodeMaster	LastGoodHistCollection	datetime	8	23
tblNodeMaster	LastGoodHistScan	datetime	8	23
tblNodeMaster	LastGoodScanTime	datetime	8	23
tblNodeMaster	Latitude	real	4	24
tblNodeMaster	Longitude	real	4	24
tblNodeMaster	MapID	int	4	10
tblNodeMaster	Node	varchar	50	0
tblNodeMaster	NodeID	nvarchar	100	0
tblNodeMaster	OperationalScore	real	4	24
tblNodeMaster	OtherWellID1	varchar	50	0
tblNodeMaster	PagingEnabled	bit	1	1
tblNodeMaster	PctCommYest	int	4	10
tblNodeMaster	POCType	smallint	2	5
tblNodeMaster	PortID	smallint	2	5
tblNodeMaster	Positioner	bit	1	1
tblNodeMaster	ProdPotential	int	4	10
tblNodeMaster	PumpFillage	int	4	10
tblNodeMaster	RecSPM	real	4	24
tblNodeMaster	RegisterBlockLimit	int	4	10
tblNodeMaster	RunStatus	varchar	25	0
tblNodeMaster	Runtime24Flag	bit	1	1
tblNodeMaster	RuntimeAcc	int	4	10
tblNodeMaster	RuntimeAccGO	int	4	10
tblNodeMaster	RuntimeAccGOYest	int	4	10
tblNodeMaster	RuntimeAccGOYY	int	4	10
tblNodeMaster	RuntimeSinceStart	int	4	10
tblNodeMaster	ScanCluster	int	4	10
tblNodeMaster	SerialNumber	int	4	10
tblNodeMaster	StartsAcc	int	4	10
tblNodeMaster	StartsAccGO	int	4	10
tblNodeMaster	StartsAccGOYest	int	4	10
tblNodeMaster	StartsAccGOYY	int	4	10
tblNodeMaster	StringID	int	4	10
tblNodeMaster	TechNote	nvarchar	1000	0
tblNodeMaster	TimeInState	int	4	10
tblNodeMaster	TodayCycles	int	4	10
tblNodeMaster	TodayRuntime	real	4	24
tblNodeMaster	TodayRuntimePct	real	4	24
tblNodeMaster	TZDaylight	bit	1	1
tblNodeMaster	TZOffset	real	4	24
tblNodeMaster	VoiceNodeID	nvarchar	100	0
tblNodeMaster	WellOpType	int	4	10
tblNodeMaster	YestRuntimePct	real	4	24
tblNodeTree	ID	int	4	10
tblNodeTree	Node	nvarchar	100	0
tblNodeTree	NumDescendants	int	4	10
tblNodeTree	Parent	nvarchar	100	0
tblNodeTree	Type	smallint	2	5
tblOPCServerTypes	CLSID	varchar	50	0
tblOPCServerTypes	Description	varchar	50	0
tblOPCServerTypes	OPCName	varchar	50	0
tblOperationalScore	ID	int	4	10
tblOperationalScore	NodeID	nvarchar	100	0
tblOperationalScore	OperationalScore	real	4	24
tblOperationalScore	ScoreDateTime	datetime	8	23
tblOperationalScoreWellGroups	GroupName	nvarchar	100	0
tblOperationalScoreWellGroups	OperationalScoreID	int	4	10
tblOperationalScoreWellGroups	ScoreValue	real	4	24
tblOperationStateChangesets	ID	int	4	10
tblOperationStateChangesets	NodeID	nvarchar	100	0
tblOperationStateChangesets	Note	nvarchar	510	0
tblOperationStateChangesets	RecordDate	datetime	8	23
tblOperationStateChangesets	UserName	nvarchar	200	0
tblOperationStateChangesetValues	ChangesetID	int	4	10
tblOperationStateChangesetValues	FieldID	int	4	10
tblOperationStateChangesetValues	Value	int	4	10
tblOperationStateFields	ID	int	4	10
tblOperationStateFields	Name	nvarchar	200	0
tblOperationStateFieldValues	Name	nvarchar	200	0
tblOperationStateFieldValues	OperationStateFieldID	int	4	10
tblOperationStateFieldValues	Value	int	4	10
tblParameterBits	Address	int	4	10
tblParameterBits	Bit	int	4	10
tblParameterBits	Description	nvarchar	100	0
tblParameterBits	PhraseID	int	4	10
tblParameterBits	POCType	int	4	10
tblParameterBits	StateID	int	4	10
tblParameters	Access	nvarchar	20	0
tblParameters	Address	int	4	10
tblParameters	ArchiveFunction	int	4	10
tblParameters	CollectionMode	int	4	10
tblParameters	DataCollection	bit	1	1
tblParameters	DataType	smallint	2	5
tblParameters	Decimals	int	4	10
tblParameters	Description	varchar	50	0
tblParameters	DestinationType	int	4	10
tblParameters	EarliestSupportedVersion	real	4	24
tblParameters	FastScan	bit	1	1
tblParameters	GroupStatusView	int	4	10
tblParameters	Locked	bit	1	1
tblParameters	Offset	real	4	24
tblParameters	ParamStandardType	int	4	10
tblParameters	PhraseID	int	4	10
tblParameters	POCType	int	4	10
tblParameters	ScaleFactor	real	4	24
tblParameters	Setpoint	bit	1	1
tblParameters	SetpointGroup	int	4	10
tblParameters	StateID	int	4	10
tblParameters	StatusScan	bit	1	1
tblParameters	Tag	varchar	50	0
tblParameters	UnitType	int	4	10
tblParamStandardTypes	Description	nvarchar	100	0
tblParamStandardTypes	ParamStandardType	int	4	10
tblParamStandardTypes	PhraseID	int	4	10
tblParamStandardTypes	UnitTypeID	int	4	10
tblPCSFDatalogConfigurations	CurrentTransactionCounter	int	4	10
tblPCSFDatalogConfigurations	DatalogName	nvarchar	40	0
tblPCSFDatalogConfigurations	DatalogNumber	int	4	10
tblPCSFDatalogConfigurations	Field2IsWellID	bit	1	1
tblPCSFDatalogConfigurations	IndexOfNewestRecord	int	4	10
tblPCSFDatalogConfigurations	IndexOfOldestRecord	int	4	10
tblPCSFDatalogConfigurations	IntervalMinutes	int	4	10
tblPCSFDatalogConfigurations	LastSavedDateTime	datetime	8	23
tblPCSFDatalogConfigurations	LastSavedIndex	int	4	10
tblPCSFDatalogConfigurations	MaximumNumberOfRecords	int	4	10
tblPCSFDatalogConfigurations	Name1	nvarchar	40	0
tblPCSFDatalogConfigurations	Name10	nvarchar	40	0
tblPCSFDatalogConfigurations	Name11	nvarchar	40	0
tblPCSFDatalogConfigurations	Name12	nvarchar	40	0
tblPCSFDatalogConfigurations	Name2	nvarchar	40	0
tblPCSFDatalogConfigurations	Name3	nvarchar	40	0
tblPCSFDatalogConfigurations	Name4	nvarchar	40	0
tblPCSFDatalogConfigurations	Name5	nvarchar	40	0
tblPCSFDatalogConfigurations	Name6	nvarchar	40	0
tblPCSFDatalogConfigurations	Name7	nvarchar	40	0
tblPCSFDatalogConfigurations	Name8	nvarchar	40	0
tblPCSFDatalogConfigurations	Name9	nvarchar	40	0
tblPCSFDatalogConfigurations	NodeID	nvarchar	100	0
tblPCSFDatalogConfigurations	NumberOfFields	int	4	10
tblPCSFDatalogConfigurations	NumberOfRecords	int	4	10
tblPCSFDatalogConfigurations	OnDemandScanEnabled	bit	1	1
tblPCSFDatalogConfigurations	ScheduledScanEnabled	bit	1	1
tblPCSFDatalogRecords	DatalogNumber	int	4	10
tblPCSFDatalogRecords	LogDateTime	datetime	8	23
tblPCSFDatalogRecords	NodeID	nvarchar	100	0
tblPCSFDatalogRecords	RecordIndex	int	4	10
tblPCSFDatalogRecords	Value10	float	8	53
tblPCSFDatalogRecords	Value11	float	8	53
tblPCSFDatalogRecords	Value12	float	8	53
tblPCSFDatalogRecords	Value2	float	8	53
tblPCSFDatalogRecords	Value3	float	8	53
tblPCSFDatalogRecords	Value4	float	8	53
tblPCSFDatalogRecords	Value5	float	8	53
tblPCSFDatalogRecords	Value6	float	8	53
tblPCSFDatalogRecords	Value7	float	8	53
tblPCSFDatalogRecords	Value8	float	8	53
tblPCSFDatalogRecords	Value9	float	8	53
tblPerforations	Depth	real	4	24
tblPerforations	Diameter	real	4	24
tblPerforations	HolesPerFt	smallint	2	5
tblPerforations	Interval	real	4	24
tblPerforations	NodeID	nvarchar	100	0
tblPlungerLiftDataHistory	Analog01	real	4	24
tblPlungerLiftDataHistory	Analog02	real	4	24
tblPlungerLiftDataHistory	Analog03	real	4	24
tblPlungerLiftDataHistory	Analog04	real	4	24
tblPlungerLiftDataHistory	Analog05	real	4	24
tblPlungerLiftDataHistory	Analog06	real	4	24
tblPlungerLiftDataHistory	Analog07	real	4	24
tblPlungerLiftDataHistory	Analog08	real	4	24
tblPlungerLiftDataHistory	Analog09	real	4	24
tblPlungerLiftDataHistory	Analog10	real	4	24
tblPlungerLiftDataHistory	Battery	real	4	24
tblPlungerLiftDataHistory	BoardTemperature	real	4	24
tblPlungerLiftDataHistory	CasingPressure	real	4	24
tblPlungerLiftDataHistory	Date	datetime	8	23
tblPlungerLiftDataHistory	DifferentialPressure	real	4	24
tblPlungerLiftDataHistory	FCU_DifferentialPressure	real	4	24
tblPlungerLiftDataHistory	FCU_LinePressure	real	4	24
tblPlungerLiftDataHistory	FCU_LineTemperature	real	4	24
tblPlungerLiftDataHistory	FCU_Rate	real	4	24
tblPlungerLiftDataHistory	InjectionPressure	real	4	24
tblPlungerLiftDataHistory	LinePressure	real	4	24
tblPlungerLiftDataHistory	LineTemperature	real	4	24
tblPlungerLiftDataHistory	NodeID	nvarchar	100	0
tblPlungerLiftDataHistory	TankLevel	real	4	24
tblPlungerLiftDataHistory	TubingPressure	real	4	24
tblPlungerLiftDataHistory	UnitTemperature	real	4	24
tblPlungerLiftTanks	NodeID	nvarchar	100	0
tblPlungerLiftTanks	Tank1_Analog	int	4	10
tblPlungerLiftTanks	Tank1_Color	int	4	10
tblPlungerLiftTanks	Tank1_Enabled	bit	1	1
tblPlungerLiftTanks	Tank1_MaxLevel	real	4	24
tblPlungerLiftTanks	Tank1_MinLevel	real	4	24
tblPlungerLiftTanks	Tank1_Name	nvarchar	100	0
tblPlungerLiftTanks	Tank2_Analog	int	4	10
tblPlungerLiftTanks	Tank2_Color	int	4	10
tblPlungerLiftTanks	Tank2_Enabled	bit	1	1
tblPlungerLiftTanks	Tank2_MaxLevel	real	4	24
tblPlungerLiftTanks	Tank2_MinLevel	real	4	24
tblPlungerLiftTanks	Tank2_Name	nvarchar	100	0
tblPlungerLiftTanks	Tank3_Analog	int	4	10
tblPlungerLiftTanks	Tank3_Color	int	4	10
tblPlungerLiftTanks	Tank3_Enabled	bit	1	1
tblPlungerLiftTanks	Tank3_MaxLevel	real	4	24
tblPlungerLiftTanks	Tank3_MinLevel	real	4	24
tblPlungerLiftTanks	Tank3_Name	nvarchar	100	0
tblPlungerLiftTanks	Tank4_Analog	int	4	10
tblPlungerLiftTanks	Tank4_Color	int	4	10
tblPlungerLiftTanks	Tank4_Enabled	bit	1	1
tblPlungerLiftTanks	Tank4_MaxLevel	real	4	24
tblPlungerLiftTanks	Tank4_MinLevel	real	4	24
tblPlungerLiftTanks	Tank4_Name	nvarchar	100	0
tblPOCTypeActions	ControlActionID	int	4	10
tblPOCTypeActions	POCType	int	4	10
tblPOCTypeApplications	ApplicationID	int	4	10
tblPOCTypeApplications	IsDefault	bit	1	1
tblPOCTypeApplications	POCType	int	4	10
tblPOCTypes	Description	varchar	50	0
tblPOCTypes	Enabled	bit	1	1
tblPOCTypes	Icon	varchar	50	0
tblPOCTypes	IsMaster	bit	1	1
tblPOCTypes	MasterPOCType	int	4	10
tblPOCTypes	POCType	int	4	10
tblPOCTypes	ProtocolID	int	4	10
tblPortMaster	BaudRate	int	4	10
tblPortMaster	CommConsecFails	int	4	10
tblPortMaster	CommPort	smallint	2	5
tblPortMaster	ContactListID	int	4	10
tblPortMaster	CTSTimeout	smallint	2	5
tblPortMaster	DataBits	smallint	2	5
tblPortMaster	Description	varchar	30	0
tblPortMaster	Enabled	bit	1	1
tblPortMaster	InterCharTimeout	int	4	10
tblPortMaster	ipHostname	varchar	50	0
tblPortMaster	ipPort	int	4	10
tblPortMaster	KeyDownDelay	smallint	2	5
tblPortMaster	KeyUPDelay	smallint	2	5
tblPortMaster	Parity	smallint	2	5
tblPortMaster	PortID	smallint	2	5
tblPortMaster	PortType	int	4	10
tblPortMaster	Retries	smallint	2	5
tblPortMaster	RTSCTSControl	bit	1	1
tblPortMaster	ServerName	varchar	20	0
tblPortMaster	StopBits	smallint	2	5
tblPortMaster	SuspendDate	datetime	8	23
tblPortMaster	TimeOut	smallint	2	5
tblPortMaster	TurnaroundDelay	int	4	10
tblPortMaster	WaitForCTS	bit	1	1
tblPresetRegisters	Description	nvarchar	100	0
tblPresetRegisters	POCType	int	4	10
tblPresetRegisters	Registers	nvarchar	510	0
tblPresetRegisters	StateID	int	4	10
tblPresetRegisters	Type	int	4	10
tblPresetRegisters	UID	nvarchar	100	0
tblProductionLimits	CurrentVolume	real	4	24
tblProductionLimits	EmptiedTime	datetime	8	23
tblProductionLimits	Enabled	bit	1	1
tblProductionLimits	LastCalculatedTime	datetime	8	23
tblProductionLimits	NodeID	nvarchar	100	0
tblProductionLimits	ResidualVolume	real	4	24
tblProductionLimits	VolumeLimit	real	4	24
tblProductionStatistics	DownProductionBOE	real	4	24
tblProductionStatistics	LatestProductionBOE	real	4	24
tblProductionStatistics	LatestTestDate	datetime	8	23
tblProductionStatistics	NodeID	nvarchar	100	0
tblProductionStatistics	PeakProductionBOE	real	4	24
tblProductionStatistics	ProcessedDate	datetime	8	23
tblPUCustom	A	real	4	24
tblPUCustom	APIDesignation	nvarchar	100	0
tblPUCustom	ArtInertia	real	4	24
tblPUCustom	C	real	4	24
tblPUCustom	CrankHoles	smallint	2	5
tblPUCustom	CrankOffset	real	4	24
tblPUCustom	DrumDiamRatio	real	4	24
tblPUCustom	GearboxRating	real	4	24
tblPUCustom	I	real	4	24
tblPUCustom	K	real	4	24
tblPUCustom	M	real	4	24
tblPUCustom	Manufacturer	nvarchar	100	0
tblPUCustom	MaxStroke	real	4	24
tblPUCustom	OtherInfo	nvarchar	100	0
tblPUCustom	P	real	4	24
tblPUCustom	PitmanArmLength	smallint	2	5
tblPUCustom	R1	real	4	24
tblPUCustom	R2	real	4	24
tblPUCustom	R3	real	4	24
tblPUCustom	R4	real	4	24
tblPUCustom	R5	real	4	24
tblPUCustom	ReqRotation	smallint	2	5
tblPUCustom	S	real	4	24
tblPUCustom	SprocketDiameter	real	4	24
tblPUCustom	SprocketDistance	real	4	24
tblPUCustom	Stroke1	real	4	24
tblPUCustom	Stroke2	real	4	24
tblPUCustom	Stroke3	real	4	24
tblPUCustom	Stroke4	real	4	24
tblPUCustom	Stroke5	real	4	24
tblPUCustom	StructRating	real	4	24
tblPUCustom	Unbalance	real	4	24
tblPUCustom	UnitID	nvarchar	12	0
tblPUCustom	UnitName	nvarchar	100	0
tblPUCustom	UnitType	smallint	2	5
tblPUCustom	V0	real	4	24
tblPUData	API1	smallint	2	5
tblPUData	API2	smallint	2	5
tblPUData	API3	smallint	2	5
tblPUData	APIDesignation	varchar	20	0
tblPUData	Description	varchar	100	0
tblPUData	Manufacturer	varchar	50	0
tblPUData	ThetaID	varchar	8	0
tblPUData	UnitName	varchar	50	0
tblPumpingUnitManufacturers	Abbrev	nvarchar	510	0
tblPumpingUnitManufacturers	ID	int	4	10
tblPumpingUnitManufacturers	Manuf	nvarchar	510	0
tblPumpingUnitManufacturers	RequiredRotation	int	4	10
tblPumpingUnitManufacturers	ShowNames	bit	1	1
tblPumpingUnitManufacturers	SortByName	bit	1	1
tblPumpingUnitManufacturers	UnitTypeID	int	4	10
tblPumpingUnits	APIDesignation	nvarchar	510	0
tblPumpingUnits	CrankHoles	int	4	10
tblPumpingUnits	Dimensions	nvarchar	-1	0
tblPumpingUnits	GearboxRating	real	4	24
tblPumpingUnits	ManufID	nvarchar	510	0
tblPumpingUnits	MaxStroke	real	4	24
tblPumpingUnits	OtherInfo	nvarchar	510	0
tblPumpingUnits	Stroke1	real	4	24
tblPumpingUnits	Stroke2	real	4	24
tblPumpingUnits	Stroke3	real	4	24
tblPumpingUnits	Stroke4	real	4	24
tblPumpingUnits	Stroke5	real	4	24
tblPumpingUnits	StructRating	real	4	24
tblPumpingUnits	UnitID	nvarchar	510	0
tblPumpingUnits	UnitName	nvarchar	510	0
tblPumpingUnits	WV_Make	nvarchar	160	0
tblPumpingUnits	WV_Model	nvarchar	160	0
tblPumpingUnits	WV_OtherInfo	nvarchar	160	0
tblPumpingUnits	WV_Typ	nvarchar	160	0
tblPumpingUnitTypes	ID	int	4	10
tblPumpingUnitTypes	UnitType	nvarchar	100	0
tblPushIDs	DeviceOsId	int	4	10
tblPushIDs	LastAccessDate	datetime	8	23
tblPushIDs	PushesEnabledForDevice	bit	1	1
tblPushIDs	PushID	varchar	50	0
tblPushIDs	Username	nvarchar	60	0
tblReportTypes	Name	nvarchar	100	0
tblReportTypes	PhraseID	int	4	10
tblReportTypes	ReportTypeID	int	4	10
tblResponders	FName	varchar	30	0
tblResponders	LName	varchar	30	0
tblResponders	Phone	varchar	50	0
tblRespondersList	Description	varchar	50	0
tblRespondersList	ResponderListID	int	4	10
tblRespondersListRel	Order	int	4	10
tblRespondersListRel	Phone	varchar	50	0
tblRespondersListRel	ResponderListID	int	4	10
tblRigStatusTypes	Description	varchar	50	0
tblRigStatusTypes	Id	int	4	10
tblRigStatusTypes	PhraseID	int	4	10
tblRodGrades	DisplayOrder	int	4	10
tblRodGrades	Elasticity	real	4	24
tblRodGrades	Name	nvarchar	100	0
tblRodGrades	RodGradeID	int	4	10
tblRodGrades	RodMatlID	int	4	10
tblRodGrades	RodSizeGroupID	int	4	10
tblRodGrades	StressMethodID	int	4	10
tblRodGrades	TensileStrength	real	4	24
tblRodGuides	DefaultDragFrictionCoefficient	real	4	24
tblRodGuides	DefaultSideLoad	real	4	24
tblRodGuides	Name	nvarchar	100	0
tblRodGuides	PhraseID	int	4	10
tblRodGuides	RodGuideID	smallint	2	5
tblRodManufacturers	ID	int	4	10
tblRodManufacturers	Manufacturer	nvarchar	100	0
tblRodMaterials	Name	nvarchar	100	0
tblRodMaterials	RodMatlID	int	4	10
tblRods	Diameter	float	8	53
tblRods	DragFrictionCoefficient	real	4	24
tblRods	Grade	varchar	50	0
tblRods	GuideCountPerRod	int	4	10
tblRods	Length	int	4	10
tblRods	NodeID	nvarchar	100	0
tblRods	RodGradeID	int	4	10
tblRods	RodGuideID	smallint	2	5
tblRods	RodNum	smallint	2	5
tblRods	RodSizeID	int	4	10
tblRodSizeGroups	Name	nvarchar	100	0
tblRodSizeGroups	RodSizeGroupID	int	4	10
tblRodSizes	Diameter	real	4	24
tblRodSizes	DisplayName	nvarchar	100	0
tblRodSizes	RodSizeGroupID	int	4	10
tblRodSizes	RodSizeID	int	4	10
tblRodSizes	RodWeight	real	4	24
tblRodSizes	SinkerBar	bit	1	1
tblSAMPumpingUnits	LufkinUnitDescription	nvarchar	510	0
tblSAMPumpingUnits	LufkinUnitID	nvarchar	510	0
tblSAMPumpingUnits	SAMUnitID	int	4	10
tblSAMPumpingUnits	ThetaID	nvarchar	20	0
tblSavedParameters	Address	int	4	10
tblSavedParameters	NodeID	nvarchar	100	0
tblSavedParameters	Value	real	4	24
tblSchedule	Enabled	bit	1	1
tblSchedule	EventName	varchar	50	0
tblSchedule	Interval	smallint	2	5
tblSchedule	LastEndExecuteDate	datetime	8	23
tblSchedule	LastStartExecuteDate	datetime	8	23
tblSchedule	PortID	smallint	2	5
tblSchedule	SchedFunction	varchar	50	0
tblSchedule	ScheduleId	int	4	10
tblSchedule	StartAt	datetime	8	23
tblSchematics	ClientAppVersion	nvarchar	100	0
tblSchematics	RefreshInterval	int	4	10
tblSchematics	SchematicID	uniqueidentifier	16	0
tblSchematics	SchematicName	nvarchar	50	0
tblSchematics	SchematicType	int	4	10
tblSchematics	TemplateNodeID	nvarchar	100	0
tblSchematics	TemplatePOCType	int	4	10
tblSchematics	XAML	nvarchar	-1	0
tblSensitivityAnalysisCustomInputTypes	Id	int	4	10
tblSensitivityAnalysisCustomInputTypes	Name	nvarchar	100	0
tblSensitivityAnalysisCustomInputTypes	OptionalAnnotationPhraseId	int	4	10
tblSensitivityAnalysisCustomInputTypes	PhraseId	int	4	10
tblSensitivityAnalysisInputOptions	ApplicationId	int	4	10
tblSensitivityAnalysisInputOptions	Id	int	4	10
tblSensitivityAnalysisInputOptions	InputId	int	4	10
tblSensitivityAnalysisInputOptions	InputTypeId	int	4	10
tblSensitivityAnalysisInputOptions	Locked	bit	1	1
tblSensitivityAnalysisInputs	ID	int	4	10
tblSensitivityAnalysisInputs	InputOptionID	int	4	10
tblSensitivityAnalysisInputs	InputValue	real	4	24
tblSensitivityAnalysisInputs	SensitivityAnalysisID	int	4	10
tblSensitivityAnalysisInputTypes	Id	int	4	10
tblSensitivityAnalysisInputTypes	Name	nvarchar	100	0
tblSensitivityAnalysisInputTypes	PhraseId	int	4	10
tblSensitivityAnalysisIPR	IPRAnalysisResultID	int	4	10
tblSensitivityAnalysisIPR	SensitivityAnalysisID	int	4	10
tblSensitivityAnalysisMaster	ApplicationId	int	4	10
tblSensitivityAnalysisMaster	AssociatedAnalysisResultID	int	4	10
tblSensitivityAnalysisMaster	ID	int	4	10
tblServerLogFiles	Contents	varbinary	-1	0
tblServerLogFiles	Date	datetime	8	23
tblServerLogFiles	Filename	nvarchar	510	0
tblSetpointGroups	DisplayName	varchar	50	0
tblSetpointGroups	DisplayOrder	int	4	10
tblSetpointGroups	PhraseID	int	4	10
tblSetpointGroups	SetpointGroup	int	4	10
tblSetpointOptimization	Id	int	4	10
tblSetpointOptimization	NodeId	nvarchar	100	0
tblSetpointOptimization	StatusId	int	4	10
tblSetpointOptimization	TypeId	int	4	10
tblSetpointOptimizationAdvisories	Description	varchar	50	0
tblSetpointOptimizationAdvisories	FilterPhraseID	int	4	10
tblSetpointOptimizationAdvisories	Id	int	4	10
tblSetpointOptimizationAdvisories	OptimizationAllowed	bit	1	1
tblSetpointOptimizationAdvisories	PhraseID	int	4	10
tblSetpointOptimizationAdvisory	AdvisoryId	int	4	10
tblSetpointOptimizationAdvisory	Id	int	4	10
tblSetpointOptimizationAdvisory	SetpointOptimizationId	int	4	10
tblSetpointOptimizationDefaults	Id	int	4	10
tblSetpointOptimizationDefaults	InputOptionId	int	4	10
tblSetpointOptimizationDefaults	InputValue	float	8	53
tblSetpointOptimizationDetails	CurrentValue	real	4	24
tblSetpointOptimizationDetails	Id	int	4	10
tblSetpointOptimizationDetails	NewValue	real	4	24
tblSetpointOptimizationDetails	ParamStandardType	int	4	10
tblSetpointOptimizationDetails	SetpointOptimizationId	int	4	10
tblSetpointOptimizationDetails	TimeCurrentValueUpdated	datetime	8	23
tblSetpointOptimizationDetails	TimeRecommendationApproved	datetime	8	23
tblSetpointOptimizationDetails	TimeRecommendationMade	datetime	8	23
tblSetpointOptimizationExplanation	ExplanationId	int	4	10
tblSetpointOptimizationExplanation	Id	int	4	10
tblSetpointOptimizationExplanation	SetpointOptimizationId	int	4	10
tblSetpointOptimizationExplanations	Description	varchar	50	0
tblSetpointOptimizationExplanations	FilterPhraseID	int	4	10
tblSetpointOptimizationExplanations	Id	int	4	10
tblSetpointOptimizationExplanations	PhraseID	int	4	10
tblSetpointOptimizationInitialStatus	Id	int	4	10
tblSetpointOptimizationInitialStatus	OptimizationTypeId	int	4	10
tblSetpointOptimizationInitialStatus	StatusId	int	4	10
tblSetpointOptimizationInputOptions	Id	int	4	10
tblSetpointOptimizationInputOptions	InputTypeId	int	4	10
tblSetpointOptimizationInputOptions	Name	nvarchar	100	0
tblSetpointOptimizationInputOptions	PhraseId	int	4	10
tblSetpointOptimizationInputs	Id	int	4	10
tblSetpointOptimizationInputs	InputOptionId	int	4	10
tblSetpointOptimizationInputs	InputValue	float	8	53
tblSetpointOptimizationInputs	SetpointOptimizationId	int	4	10
tblSetpointOptimizationInputs	StringInputValue	nvarchar	-1	0
tblSetpointOptimizationInputTypes	Id	int	4	10
tblSetpointOptimizationInputTypes	Name	nvarchar	100	0
tblSetpointOptimizationInputTypes	PhraseId	int	4	10
tblSetpointOptimizationParameters	Comments	nvarchar	510	0
tblSetpointOptimizationParameters	Description	nvarchar	100	0
tblSetpointOptimizationParameters	Id	int	4	10
tblSetpointOptimizationParameters	Value	nvarchar	-1	0
tblSetpointOptimizationStatuses	Description	varchar	50	0
tblSetpointOptimizationStatuses	FilterPhraseID	int	4	10
tblSetpointOptimizationStatuses	Id	int	4	10
tblSetpointOptimizationStatuses	PhraseID	int	4	10
tblSetpointOptimizationSupported	ApplicationId	int	4	10
tblSetpointOptimizationSupported	Id	int	4	10
tblSetpointOptimizationSupported	OptimizationTypeId	int	4	10
tblSetpointOptimizationSupported	PocType	smallint	2	5
tblSetpointOptimizationSupportedInputParamStandardTypes	Id	int	4	10
tblSetpointOptimizationSupportedInputParamStandardTypes	ParamStandardType	int	4	10
tblSetpointOptimizationSupportedInputParamStandardTypes	SupportedId	int	4	10
tblSetpointOptimizationSupportedParamStandardTypes	Id	int	4	10
tblSetpointOptimizationSupportedParamStandardTypes	ParamStandardType	int	4	10
tblSetpointOptimizationSupportedParamStandardTypes	SupportedId	int	4	10
tblSetpointOptimizationTypes	Description	varchar	50	0
tblSetpointOptimizationTypes	Id	int	4	10
tblSetpointOptimizationTypes	PhraseID	int	4	10
tblSizeold	TblData	varchar	80	0
tblSizeold	TblIndex_Size	varchar	80	0
tblSizeold	Tblname	varchar	80	0
tblSizeold	TblReserved	varchar	80	0
tblSizeold	TblRows	int	4	10
tblSizeold	TblUnused	varchar	80	0
tblStateClassifications	Id	int	4	10
tblStateClassifications	Name	nvarchar	100	0
tblStateClassifications	PhraseId	int	4	10
tblStates	AlarmPriority	int	4	10
tblStates	BackColor	int	4	10
tblStates	ForeColor	int	4	10
tblStates	Locked	bit	1	1
tblStates	PhraseID	int	4	10
tblStates	StateID	int	4	10
tblStates	Text	varchar	50	0
tblStates	Value	int	4	10
tblStatusRegisters	Address	int	4	10
tblStatusRegisters	Bit	int	4	10
tblStatusRegisters	Format	varchar	50	0
tblStatusRegisters	Locked	bit	1	1
tblStatusRegisters	Order	int	4	10
tblStatusRegisters	POCType	int	4	10
tblStatusRegisters	Units	varchar	20	0
tblStringPagers	EndTime	datetime	8	23
tblStringPagers	PagingGroup	varchar	15	0
tblStringPagers	StartTime	datetime	8	23
tblStringPagers	StringID	smallint	2	5
tblStringPagers	Weekday	bit	1	1
tblStringPagers	Weekend	bit	1	1
tblStrings	ContactListID	int	4	10
tblStrings	ResponderListID	int	4	10
tblStrings	StringID	int	4	10
tblStrings	StringName	varchar	15	0
tblStructuredData	Data	text	16	0
tblStructuredData	DataB	image	16	0
tblStructuredData	Date	datetime	8	23
tblStructuredData	NodeID	nvarchar	100	0
tblStructuredData	Type	tinyint	1	3
tblSubCables	Description	nvarchar	510	0
tblSubCables	Diameter	float	8	53
tblSubCables	ID	int	4	10
tblSubCables	ManufacturerID	int	4	10
tblSubCables	Model	nvarchar	200	0
tblSubDetails	CableID	int	4	10
tblSubDetails	DateInstalled	datetime	8	23
tblSubDetails	MotorID	int	4	10
tblSubDetails	MotorLeadID	int	4	10
tblSubDetails	NodeID	nvarchar	100	0
tblSubDetails	PumpID	int	4	10
tblSubDetails	PumpMaxFlow	real	4	24
tblSubDetails	PumpMinFlow	real	4	24
tblSubDetails	PumpOptFlow	real	4	24
tblSubDetails	PumpStages	real	4	24
tblSubDetails	SealID	int	4	10
tblSubManufacturers	ID	int	4	10
tblSubManufacturers	Manufacturer	nvarchar	200	0
tblSubMotorLeads	Description	nvarchar	510	0
tblSubMotorLeads	ID	int	4	10
tblSubMotorLeads	ManufacturerID	int	4	10
tblSubMotorLeads	Model	nvarchar	200	0
tblSubMotors	Amps	float	8	53
tblSubMotors	Description	nvarchar	510	0
tblSubMotors	Diameter	float	8	53
tblSubMotors	HP	float	8	53
tblSubMotors	ID	int	4	10
tblSubMotors	ManufacturerID	int	4	10
tblSubMotors	Model	nvarchar	200	0
tblSubMotors	Volts	float	8	53
tblSubPumps	Description	nvarchar	510	0
tblSubPumps	Diameter	float	8	53
tblSubPumps	Drift	float	8	53
tblSubPumps	ID	int	4	10
tblSubPumps	ManufacturerID	int	4	10
tblSubPumps	Model	nvarchar	200	0
tblSubPumps	PBurst	float	8	53
tblSubPumps	PumpMaxFlow	float	8	53
tblSubPumps	PumpMinFlow	float	8	53
tblSubPumps	PumpOptFlow	float	8	53
tblSubPumps	PumpStages	float	8	53
tblSubSeals	Description	nvarchar	510	0
tblSubSeals	Diameter	float	8	53
tblSubSeals	ID	int	4	10
tblSubSeals	ManufacturerID	int	4	10
tblSubSeals	Model	nvarchar	200	0
tblSubsStatus	CurrentA	int	4	10
tblSubsStatus	CurrentB	int	4	10
tblSubsStatus	CurrentC	int	4	10
tblSubsStatus	CurrentUnbalance	int	4	10
tblSubsStatus	NodeID	nvarchar	100	0
tblSubsStatus	PowerFactor	int	4	10
tblSubsStatus	RuntimeAcc	int	4	10
tblSubsStatus	StartsAcc	int	4	10
tblSubsStatus	TimeUntilStart	int	4	10
tblSubsStatus	VoltageAB	int	4	10
tblSubsStatus	VoltageBC	int	4	10
tblSubsStatus	VoltageCA	int	4	10
tblSubsStatus	VoltageUnbalance	int	4	10
tblSurveyData	ID	int	4	10
tblSurveyData	NodeID	nvarchar	100	0
tblSurveyData	SurveyDate	datetime	8	23
tblSystemDataTypes	ID	int	4	10
tblSystemDataTypes	Name	nvarchar	100	0
tblSystemDataTypes	PhraseID	int	4	10
tblSystemParameters	Comment	varchar	100	0
tblSystemParameters	Parameter	varchar	50	0
tblSystemParameters	Value	text	16	0
tblTankNum	NodeID	nvarchar	100	0
tblTankNum	NumTanks	int	4	10
tblTotalflowTrendConfigurations	CollectionStatus	nvarchar	120	0
tblTotalflowTrendConfigurations	CurrentTransactionCounter	int	4	10
tblTotalflowTrendConfigurations	FileSize	int	4	10
tblTotalflowTrendConfigurations	LastSavedDateTime	datetime	8	23
tblTotalflowTrendConfigurations	LogPeriod	int	4	10
tblTotalflowTrendConfigurations	MasterNodeID	nvarchar	100	0
tblTotalflowTrendConfigurations	NumberOfVariables	int	4	10
tblTotalflowTrendConfigurations	OnDemandScanEnabled	bit	1	1
tblTotalflowTrendConfigurations	RecordSize	int	4	10
tblTotalflowTrendConfigurations	ScheduledScanEnabled	bit	1	1
tblTotalflowTrendConfigurations	TrendDescription	nvarchar	60	0
tblTotalflowTrendConfigurations	TrendFileName	nvarchar	100	0
tblTransactions	DateProcess	datetime	8	23
tblTransactions	DateRequest	datetime	8	23
tblTransactions	Input	image	16	0
tblTransactions	InputText	nvarchar	500	0
tblTransactions	NodeID	nvarchar	100	0
tblTransactions	Output	image	16	0
tblTransactions	PortID	int	4	10
tblTransactions	Priority	int	4	10
tblTransactions	Result	nvarchar	100	0
tblTransactions	Source	nvarchar	100	0
tblTransactions	Task	nvarchar	100	0
tblTransactions	TransactionID	int	4	10
tblTransactions	Tries	int	4	10
tblTrendGroups	id	int	4	10
tblTrendGroups	image	varchar	15	0
tblTrendGroups	name	varchar	50	0
tblTrends	group_id	int	4	10
tblTrends	id	int	4	10
tblTrends	name	varchar	50	0
tblTubings	Length	int	4	10
tblTubings	NodeID	nvarchar	100	0
tblTubings	OrderNum	smallint	2	5
tblTubings	TubingSizeID	int	4	10
tblTubingSizes	TubingID	real	4	24
tblTubingSizes	TubingName	nvarchar	100	0
tblTubingSizes	TubingOD	real	4	24
tblTubingSizes	TubingSize	int	4	10
tblTubingSizes	TubingWeight	real	4	24
tblUnitTypes	Description	varchar	50	0
tblUnitTypes	PhraseID	int	4	10
tblUnitTypes	UnitTypeID	int	4	10
tblUserSecurity	Admin	bit	1	1
tblUserSecurity	AdminLite	bit	1	1
tblUserSecurity	Email	nvarchar	200	0
tblUserSecurity	LastAccessDate	datetime	8	23
tblUserSecurity	MustChangePassword	bit	1	1
tblUserSecurity	Password	nvarchar	100	0
tblUserSecurity	UserName	nvarchar	200	0
tblUserSecurity	WebToken	varchar	36	0
tblUserSecurity	WebTokenExpire	datetime	8	23
tblUserSecurity	WellAdmin	bit	1	1
tblUserSecurity	WellConfig	bit	1	1
tblUserSecurity	WellConfigLite	bit	1	1
tblUserSecurity	WellControl	bit	1	1
tblValveCheck	Date	datetime	8	23
tblValveCheck	NodeID	nvarchar	100	0
tblValveCheck	ValveData	varchar	7000	0
tblValveCheck	Work_Or_Ref	char	1	0
tblVideoFormats	ID	int	4	10
tblVideoFormats	Name	nvarchar	100	0
tblVideoFormats	PhraseID	int	4	10
tblWebSessions	MobileServer	varchar	50	0
tblWebSessions	PushID	varchar	50	0
tblWebSessions	UserName	nvarchar	60	0
tblWebSessions	WebToken	varchar	36	0
tblWebSessions	WebTokenExpiration	datetime	8	23
tblWellAnalysisParamConfig	DisregardScanValuesForAnalysis	bit	1	1
tblWellAnalysisParamConfig	NodeId	nvarchar	100	0
tblWellAnalysisParamConfig	ParamStandardType	int	4	10
tblWellCorrelationConfig	AnalysisCorrelationID	int	4	10
tblWellCorrelationConfig	ID	int	4	10
tblWellCorrelationConfig	NodeID	nvarchar	100	0
tblWellDetails	AirTankPressureAtBottomOfStroke	real	4	24
tblWellDetails	AirTankPressureBottomOfStroke	real	4	24
tblWellDetails	BotPerf	int	4	10
tblWellDetails	BottomholeTemperature	real	4	24
tblWellDetails	BubblepointPressure	real	4	24
tblWellDetails	CalcDailyDate	datetime	8	23
tblWellDetails	CalcDailyGas	real	4	24
tblWellDetails	CalcDailyOil	real	4	24
tblWellDetails	CalcDailyWater	real	4	24
tblWellDetails	CasingPressure	smallint	2	5
tblWellDetails	CasingValveClosed	bit	1	1
tblWellDetails	CBCrankAngle	int	4	10
tblWellDetails	CBDataType	int	4	10
tblWellDetails	Clearance	real	4	24
tblWellDetails	Cycles	real	4	24
tblWellDetails	DiffDailyGas	real	4	24
tblWellDetails	DiffDailyGross	real	4	24
tblWellDetails	DiffDailyOil	real	4	24
tblWellDetails	DiffDailyWater	real	4	24
tblWellDetails	DownholeSeparatorID	int	4	10
tblWellDetails	DownReasonCode	varchar	10	0
tblWellDetails	DynoCorrectKinematic	int	4	10
tblWellDetails	DynoCorrectPhase	int	4	10
tblWellDetails	DynoLoadAdjustment	int	4	10
tblWellDetails	DynoPhaseAdjustment	real	4	24
tblWellDetails	DynoTOSAdjustment	real	4	24
tblWellDetails	ElectricityCost	real	4	24
tblWellDetails	FieldName	nvarchar	60	0
tblWellDetails	FlowPressureAtTest	real	4	24
tblWellDetails	FluidLevel	smallint	2	5
tblWellDetails	FluidLevelSource	int	4	10
tblWellDetails	FluidSpecificGravity	real	4	24
tblWellDetails	FluidTemp	int	4	10
tblWellDetails	GasRate	real	4	24
tblWellDetails	GrossRate	real	4	24
tblWellDetails	HasPacker	bit	1	1
tblWellDetails	HoleNumber	smallint	2	5
tblWellDetails	IdleTime	real	4	24
tblWellDetails	LastTestDate	datetime	8	23
tblWellDetails	LoadSensorType	int	4	10
tblWellDetails	MaxCBMoment	int	4	10
tblWellDetails	MinLoad	int	4	10
tblWellDetails	MotorHP	real	4	24
tblWellDetails	MotorSettingID	int	4	10
tblWellDetails	MotorSizeID	int	4	10
tblWellDetails	MotorTypeID	int	4	10
tblWellDetails	NodeID	nvarchar	100	0
tblWellDetails	NumRodSections	smallint	2	5
tblWellDetails	OilAPIGravity	real	4	24
tblWellDetails	PackerDepth	real	4	24
tblWellDetails	PeakLoad	int	4	10
tblWellDetails	PIPSensorInstalled	bit	1	1
tblWellDetails	PlungerDiam	real	4	24
tblWellDetails	PlungerInstallDate	datetime	8	23
tblWellDetails	PlungerModel	nvarchar	40	0
tblWellDetails	PlungerSerial	nvarchar	40	0
tblWellDetails	POCGrossRate	smallint	2	5
tblWellDetails	PowerMeterType	varchar	1	0
tblWellDetails	PressureTarget	real	4	24
tblWellDetails	PrimeMoverType	varchar	4	0
tblWellDetails	ProductionDepth	real	4	24
tblWellDetails	PumpBarrelLength	real	4	24
tblWellDetails	PumpDepth	smallint	2	5
tblWellDetails	PumpDepthVertical	int	4	10
tblWellDetails	PumpingUnitID	varchar	6	0
tblWellDetails	PumpIntakePressure	real	4	24
tblWellDetails	PumpType	varchar	1	0
tblWellDetails	RateAtTest	real	4	24
tblWellDetails	RodLengthAdjust	int	4	10
tblWellDetails	RodTubingFriction	real	4	24
tblWellDetails	Rotation	varchar	3	0
tblWellDetails	Runtime	real	4	24
tblWellDetails	ServiceFactor	real	4	24
tblWellDetails	SpecificGravityOfGas	real	4	24
tblWellDetails	SPM	real	4	24
tblWellDetails	StaticReservoirPressure	real	4	24
tblWellDetails	StrokeLength	real	4	24
tblWellDetails	TopPerf	int	4	10
tblWellDetails	TorqueMode	varchar	2	0
tblWellDetails	TotalRodLength	int	4	10
tblWellDetails	TubingAnchorDepth	smallint	2	5
tblWellDetails	TubingAnchored	bit	1	1
tblWellDetails	TubingFrictionCoefficient	real	4	24
tblWellDetails	TubingID	real	4	24
tblWellDetails	TubingOD	real	4	24
tblWellDetails	TubingPipeQualityFactor	int	4	10
tblWellDetails	TubingPressure	smallint	2	5
tblWellDetails	ValveCheckLeakage	int	4	10
tblWellDetails	ValveCheckSVLoad	int	4	10
tblWellDetails	ValveCheckTVLoad	int	4	10
tblWellDetails	Viscosity	real	4	24
tblWellDetails	WaterCut	real	4	24
tblWellDetails	WaterSG	real	4	24
tblWellDetails	WellName	nvarchar	60	0
tblWellDetails	WellNumber	int	4	10
tblWellDetails	XBALMaxCBMoment	smallint	2	5
tblWellDetails	XDGFileAvailable	bit	1	1
tblWellFailureCauses	CauseCode	int	4	10
tblWellFailureCauses	FailureID	int	4	10
tblWellFailureClasses	ID	int	4	10
tblWellFailureClasses	Name	nvarchar	510	0
tblWellFailureClasses	NamePhraseID	int	4	10
tblWellFailureCodes	Class	int	4	10
tblWellFailureCodes	DefaultLaborCost	money	8	19
tblWellFailureCodes	DefaultMaterialCost	money	8	19
tblWellFailureCodes	ID	int	4	10
tblWellFailureCodes	Locked	bit	1	1
tblWellFailureCodes	Name	nvarchar	510	0
tblWellFailureCodes	NamePhraseID	int	4	10
tblWellFailures	Date	datetime	8	23
tblWellFailures	FailureIdentifiedDate	datetime	8	23
tblWellFailures	ID	int	4	10
tblWellFailures	NodeID	nvarchar	100	0
tblWellFailures	Notes	text	16	0
tblWellFailures	ReasonCode	int	4	10
tblWellFailures	RecoveryDate	datetime	8	23
tblWellFailures	RequestedServiceCode	int	4	10
tblWellFailures	RigDownDate	datetime	8	23
tblWellFailures	RigUpDate	datetime	8	23
tblWellFailures	TotalCost	money	8	19
tblWellFailureServices	Date	datetime	8	23
tblWellFailureServices	FailureID	int	4	10
tblWellFailureServices	LaborCost	money	8	19
tblWellFailureServices	MaterialCost	money	8	19
tblWellFailureServices	Notes	text	16	0
tblWellFailureServices	ServiceCode	int	4	10
tblWellGroupKmlMapLayers	GroupName	nvarchar	100	0
tblWellGroupKmlMapLayers	ID	int	4	10
tblWellGroupKmlMapLayers	KmlMapLayerId	int	4	10
tblWellGroups	AllowStartFlag	bit	1	1
tblWellGroups	AllowStartLock	bit	1	1
tblWellGroups	DAL_WellGroupID	int	4	10
tblWellGroups	DrillDown	bit	1	1
tblWellGroups	EnableEquipmentDownload	int	4	10
tblWellGroups	EnableEquipmentUpload	int	4	10
tblWellGroups	FacGroup	bit	1	1
tblWellGroups	FilterID	int	4	10
tblWellGroups	GroupName	varchar	50	0
tblWellGroups	LastRefreshed	datetime	8	23
tblWellGroups	Locked	bit	1	1
tblWellGroups	ParentGroupName	varchar	50	0
tblWellGroups	Priority	int	4	10
tblWellGroups	RefreshTimeout	int	4	10
tblWellGroups	ScoreValue	real	4	24
tblWellGroups	ShutdownEndDate	datetime	8	23
tblWellGroups	ShutdownFlag	bit	1	1
tblWellGroups	ShutdownStartDate	datetime	8	23
tblWellGroups	SQLText	text	16	0
tblWellGroups	StartupEndDate	datetime	8	23
tblWellGroups	StartupFlag	bit	1	1
tblWellGroups	StartupStartDate	datetime	8	23
tblWellGroups	SuspendPorts	int	4	10
tblWellGroups	ViewID	int	4	10
tblWellGroupSchematics	GroupName	nvarchar	100	0
tblWellGroupSchematics	SchematicID	uniqueidentifier	16	0
tblWellGroupsLibrary	Description	ntext	16	0
tblWellGroupsLibrary	GroupName	varchar	50	0
tblWellGroupsLibrary	SQLText	ntext	16	0
tblWellNotes	Date	datetime	8	23
tblWellNotes	NodeID	nvarchar	100	0
tblWellNotes	Note	text	16	0
tblWellNotes	User	varchar	20	0
tblWellServiceDetails	ActualServiceID	int	4	10
tblWellServiceDetails	DetailID	int	4	10
tblWellServiceDetails	LaborCost	money	8	19
tblWellServiceDetails	MaterialCost	money	8	19
tblWellServiceDetails	NodeID	nvarchar	100	0
tblWellServiceDetails	Notes	text	16	0
tblWellServiceDetails	RequestedServiceID	int	4	10
tblWellServiceDetails	WellDownDate	datetime	8	23
tblWellServiceKeys	Description	nvarchar	510	0
tblWellServiceKeys	ServiceKey	nvarchar	100	0
tblWellServiceKeys	ServiceTypeID	int	4	10
tblWellServices	CauseFailureID	int	4	10
tblWellServices	NodeID	nvarchar	100	0
tblWellServices	PrimaryFailureID	int	4	10
tblWellServices	RTP	datetime	8	23
tblWellServices	WellDownDate	datetime	8	23
tblWellServiceStatusTypes	Description	varchar	50	0
tblWellServiceStatusTypes	Id	int	4	10
tblWellServiceStatusTypes	PhraseID	int	4	10
tblWellServiceTypes	Code	nvarchar	10	0
tblWellServiceTypes	Description	nvarchar	100	0
tblWellServiceTypes	ServiceTypeID	int	4	10
tblWellStatistics	AlarmStateCycles	real	4	24
tblWellStatistics	AlarmStateFillage	real	4	24
tblWellStatistics	AlarmStateRuntime	real	4	24
tblWellStatistics	AverageCycles	real	4	24
tblWellStatistics	AverageFillage	real	4	24
tblWellStatistics	AverageRuntime	real	4	24
tblWellStatistics	NodeID	nvarchar	100	0
tblWellStats	AvgCycles	real	4	24
tblWellStats	AvgFillage	real	4	24
tblWellStats	AvgRuntime	real	4	24
tblWellStats	CyclesAlarmFlag	bit	1	1
tblWellStats	FillageAlarmFlag	bit	1	1
tblWellStats	NodeID	nvarchar	100	0
tblWellStats	RuntimeAlarmFlag	bit	1	1
tblWellStats	StDevCycles	real	4	24
tblWellStats	StDevFillage	real	4	24
tblWellStats	StDevRuntime	real	4	24
tblWellTest	CasingPressure	real	4	24
tblWellTest	Duration	real	4	24
tblWellTest	FluidAbovePump	real	4	24
tblWellTest	GasRate	real	4	24
tblWellTest	NodeID	nvarchar	100	0
tblWellTest	OilRate	real	4	24
tblWellTest	PumpingBHP	real	4	24
tblWellTest	PumpIntakePressure	real	4	24
tblWellTest	StaticBHP	real	4	24
tblWellTest	TestDate	datetime	8	23
tblWellTest	TubingPressure	real	4	24
tblWellTest	WaterRate	real	4	24
tblWellTestColumns	Alignment	int	4	10
tblWellTestColumns	FieldName	varchar	25	0
tblWellTestColumns	FrozenCol	bit	1	1
tblWellTestColumns	Name	varchar	50	0
tblWellTestColumns	Position	int	4	10
tblWellTestColumns	UserID	nvarchar	100	0
tblWellTestColumns	Width	int	4	10
tblWellTests	Approved	bit	1	1
tblWellTests	CasingGasRate	real	4	24
tblWellTests	CasingPressure	real	4	24
tblWellTests	CasingTemp	real	4	24
tblWellTests	CO2	float	8	53
tblWellTests	DateModified	datetime	8	23
tblWellTests	DriveCurrent	real	4	24
tblWellTests	DriveSpeed	real	4	24
tblWellTests	Duration	real	4	24
tblWellTests	FlowlinePressure	real	4	24
tblWellTests	FlowlineTemp	real	4	24
tblWellTests	FluidAbovePump	real	4	24
tblWellTests	GasLiftGasRate	real	4	24
tblWellTests	GasRate	real	4	24
tblWellTests	HighPressureGasRate	real	4	24
tblWellTests	LinePressureToSetting	real	4	24
tblWellTests	MotorTemp	real	4	24
tblWellTests	NodeID	nvarchar	100	0
tblWellTests	OilAPIGravity	real	4	24
tblWellTests	OilRate	real	4	24
tblWellTests	OilRateRaw	real	4	24
tblWellTests	PumpDischargePressure	real	4	24
tblWellTests	PumpIntakePressure	real	4	24
tblWellTests	PumpIntakeTemp	real	4	24
tblWellTests	Pumpsize	real	4	24
tblWellTests	RodRPM	real	4	24
tblWellTests	RodTorque	real	4	24
tblWellTests	Runtime	real	4	24
tblWellTests	SPM	real	4	24
tblWellTests	StrokeLength	real	4	24
tblWellTests	SuctionPressure	real	4	24
tblWellTests	TestDate	datetime	8	23
tblWellTests	TriplexDischargePressure	real	4	24
tblWellTests	TubingPressure	real	4	24
tblWellTests	TubingTemp	real	4	24
tblWellTests	UserID	nvarchar	100	0
tblWellTests	WaterCutUser	real	4	24
tblWellTests	WaterRate	real	4	24
tblWellTests	WaterRateRaw	real	4	24
tblWellTests	WaterSG	real	4	24
tblWriteSequenceRegisters	Address	int	4	10
tblWriteSequenceRegisters	DefaultValue	real	4	24
tblWriteSequenceRegisters	Order	int	4	10
tblWriteSequenceRegisters	WriteSequenceID	int	4	10
tblWriteSequences	ID	int	4	10
tblWriteSequences	Name	nvarchar	200	0
tblWriteSequences	POCType	int	4	10
tblWVPrimeMovers	Frame	nvarchar	50	0
tblWVPrimeMovers	Make	nvarchar	50	0
tblWVPrimeMovers	Model	nvarchar	50	0
tblWVPrimeMovers	ModifiedDate	datetime	8	23
tblWVPrimeMovers	MotorID	nvarchar	24	0
tblWVPrimeMovers	PowerRatingBaseUnits	float	8	53
tblWVPrimeMovers	RPMRating	float	8	53
tblWVPrimeMovers	Setting	nvarchar	50	0
tblWVPrimeMovers	Size	float	8	53
tblWVPrimeMovers	ThetaHP	real	4	24
tblWVPrimeMovers	ThetaKindID	int	4	10
tblWVPrimeMovers	ThetaSettingID	int	4	10
tblWVPrimeMovers	ThetaSizeID	int	4	10
tblWVPrimeMovers	WVPrimeMoversID	int	4	10
tblWVRods	CompSubTyp	nvarchar	50	0
tblWVRods	ehTab	nvarchar	50	0
tblWVRods	IconName	nvarchar	50	0
tblWVRods	ItemDescription	nvarchar	100	0
tblWVRods	Make	nvarchar	50	0
tblWVRods	Material	nvarchar	50	0
tblWVRods	Model	nvarchar	50	0
tblWVRods	ModifiedDate	datetime	8	23
tblWVRods	RodGrade	nvarchar	50	0
tblWVRods	ThetaDiameter	float	8	53
tblWVRods	ThetaGrade	nvarchar	100	0
tblWVRods	ThetaGradeAbbr	nvarchar	20	0
tblWVRods	ThetaRodGradeID	real	4	24
tblWVRods	ThetaRodSizeID	float	8	53
tblWVRods	WVDiameter	real	4	24
tblWVRods	WVRodsID	int	4	10
tblXDiagFlags	AdjustPhase	int	4	10
tblXDiagFlags	BentPumpBarrel	int	4	10
tblXDiagFlags	CalcFluidSPGR	int	4	10
tblXDiagFlags	CalcFrictionStatus	int	4	10
tblXDiagFlags	ClampOn	int	4	10
tblXDiagFlags	ClamponInelegantHackHackPC	int	4	10
tblXDiagFlags	ClamponLoadCell	int	4	10
tblXDiagFlags	CrankHole	int	4	10
tblXDiagFlags	CrankHoleCorrected	int	4	10
tblXDiagFlags	Date	datetime	8	23
tblXDiagFlags	DiagRodPart	int	4	10
tblXDiagFlags	ElectricBillperMonthBalancedE	real	4	24
tblXDiagFlags	ElectricBillperMonthBalancedT	real	4	24
tblXDiagFlags	ElectricBillperMonthExisting	real	4	24
tblXDiagFlags	ExcessiveRodTubingFriction	int	4	10
tblXDiagFlags	ExtremeRodTubingFriction	int	4	10
tblXDiagFlags	FeetFromSurface	int	4	10
tblXDiagFlags	FluidInertia	int	4	10
tblXDiagFlags	FluidLevelCorrected	int	4	10
tblXDiagFlags	FluidLevelSource	int	4	10
tblXDiagFlags	FluidPound	int	4	10
tblXDiagFlags	FluidSPGR	real	4	24
tblXDiagFlags	FluidVelocity	real	4	24
tblXDiagFlags	FullPump	int	4	10
tblXDiagFlags	GasInterference	int	4	10
tblXDiagFlags	GasLock	int	4	10
tblXDiagFlags	GearBoxLoadingBalancedE	real	4	24
tblXDiagFlags	GearBoxLoadingBalancedT	real	4	24
tblXDiagFlags	GearBoxLoadingExisting	real	4	24
tblXDiagFlags	GrossProduction	int	4	10
tblXDiagFlags	GrossPumpStroke	int	4	10
tblXDiagFlags	HittingDown	int	4	10
tblXDiagFlags	HittingUp	int	4	10
tblXDiagFlags	IncompleteFillage	int	4	10
tblXDiagFlags	IncorrectFluidSPGR	int	4	10
tblXDiagFlags	IncorrectPlungerSize	int	4	10
tblXDiagFlags	IncorrectProductionRate	int	4	10
tblXDiagFlags	IncorrectSPM	int	4	10
tblXDiagFlags	KinematicStroke	int	4	10
tblXDiagFlags	LoadShift	real	4	24
tblXDiagFlags	LoadShiftCorrected	int	4	10
tblXDiagFlags	LoadShiftPct	real	4	24
tblXDiagFlags	MalfunctioningTubingAnchor	int	4	10
tblXDiagFlags	MaxFluidSPGR	real	4	24
tblXDiagFlags	MaxRodStressL	real	4	24
tblXDiagFlags	MBalancedE	real	4	24
tblXDiagFlags	MBalancedT	real	4	24
tblXDiagFlags	MeasuredStroke	real	4	24
tblXDiagFlags	MeasuredStrokeCorrected	int	4	10
tblXDiagFlags	MExisting	real	4	24
tblXDiagFlags	NodeID	nvarchar	100	0
tblXDiagFlags	NumRods	int	4	10
tblXDiagFlags	OrigCrankHole	int	4	10
tblXDiagFlags	OrigStrokeLength	real	4	24
tblXDiagFlags	pGrossPumpStroke	int	4	10
tblXDiagFlags	PhaseAdjustment	real	4	24
tblXDiagFlags	PlungerSize	real	4	24
tblXDiagFlags	PlungerTooLarge	int	4	10
tblXDiagFlags	PlungerTooSmall	int	4	10
tblXDiagFlags	PumpConditionGood	int	4	10
tblXDiagFlags	PumpFillage	real	4	24
tblXDiagFlags	PumpFriction	int	4	10
tblXDiagFlags	PumpIntakePressure	real	4	24
tblXDiagFlags	RodPart	int	4	10
tblXDiagFlags	RodsOverloaded	int	4	10
tblXDiagFlags	RodStringCompressed	int	4	10
tblXDiagFlags	RodTubingFriction	int	4	10
tblXDiagFlags	SectFluidVelocity	int	4	10
tblXDiagFlags	SevereDownholeProblem	int	4	10
tblXDiagFlags	ShallowFriction	int	4	10
tblXDiagFlags	SinkerBarWaveReflection	int	4	10
tblXDiagFlags	SPMHigh	int	4	10
tblXDiagFlags	SPMLow	int	4	10
tblXDiagFlags	StuckPump	int	4	10
tblXDiagFlags	SurfaceMatchPoor	int	4	10
tblXDiagFlags	SurfPosKinematicCorrected	int	4	10
tblXDiagFlags	SurfPosKinematicRequired	int	4	10
tblXDiagFlags	SVLeak	real	4	24
tblXDiagFlags	SysDiagFluidSPGR	real	4	24
tblXDiagFlags	TubingAnchored	int	4	10
tblXDiagFlags	TubingAnchorLoose	int	4	10
tblXDiagFlags	TubingLeak	int	4	10
tblXDiagFlags	TubingMovement	real	4	24
tblXDiagFlags	TVLeak	real	4	24
tblXDiagFlags	UnKnownM	int	4	10
tblXDiagFlags	UnknownPumpCondition	int	4	10
tblXDiagFlags	UpperRingValvePump	int	4	10
tblXDiagFlags	WornPump	int	4	10
tblXDiagFlags	WornPumpBarrel	int	4	10
tblXDiagFlags	XDFeetFromSurface	int	4	10
tblXDiagFlags	XDLinesSetH	bit	1	1
tblXDiagOutputs	ID	int	4	10
tblXDiagOutputs	Name	nvarchar	100	0
tblXDiagOutputs	PhraseID	int	4	10
tblXDiagResults	AdditionalUplift	real	4	24
tblXDiagResults	AdditionalUpliftGross	real	4	24
tblXDiagResults	AddOilProduction	int	4	10
tblXDiagResults	AnalysisDate	datetime	8	23
tblXDiagResults	AvgDHDSLoad	int	4	10
tblXDiagResults	AvgDHDSPOLoad	int	4	10
tblXDiagResults	AvgDHUSLoad	int	4	10
tblXDiagResults	AvgDHUSPOLoad	int	4	10
tblXDiagResults	BadSG	bit	1	1
tblXDiagResults	BalanceUnit	bit	1	1
tblXDiagResults	BouyRodWeight	int	4	10
tblXDiagResults	CardType	varchar	1	0
tblXDiagResults	CasingPressure	int	4	10
tblXDiagResults	CurrentCBE	int	4	10
tblXDiagResults	CurrentCLF	real	4	24
tblXDiagResults	CurrentElecBG	real	4	24
tblXDiagResults	CurrentElecBO	real	4	24
tblXDiagResults	CurrentKWH	int	4	10
tblXDiagResults	CurrentMCB	smallint	2	5
tblXDiagResults	CurrentMonthlyElec	int	4	10
tblXDiagResults	Date	datetime	8	23
tblXDiagResults	DownholeAnalysis	text	16	0
tblXDiagResults	DownholeAnalysisLocale	ntext	16	0
tblXDiagResults	DownholeCapacity24	real	4	24
tblXDiagResults	DownholeCapacityRuntime	real	4	24
tblXDiagResults	DownholeCapacityRuntimeFillage	real	4	24
tblXDiagResults	DryRodWeight	int	4	10
tblXDiagResults	ElecCostMinTorquePerBO	money	8	19
tblXDiagResults	ElecCostMonthly	money	8	19
tblXDiagResults	ElecCostPerBG	money	8	19
tblXDiagResults	ElecCostPerBO	money	8	19
tblXDiagResults	ElectCostMinEnergyPerBO	money	8	19
tblXDiagResults	FillagePct	smallint	2	5
tblXDiagResults	FluidLevelXDiag	int	4	10
tblXDiagResults	FluidLoadonPump	int	4	10
tblXDiagResults	FluidSG	real	4	24
tblXDiagResults	Friction	float	8	53
tblXDiagResults	GearBoxLoadPct	smallint	2	5
tblXDiagResults	GearboxTorqueRating	int	4	10
tblXDiagResults	GrossProd	int	4	10
tblXDiagResults	GrossPumpDisplacement	int	4	10
tblXDiagResults	GrossPumpStroke	smallint	2	5
tblXDiagResults	InputAnalysis	text	16	0
tblXDiagResults	InputAnalysisLocale	ntext	16	0
tblXDiagResults	LoadShift	smallint	2	5
tblXDiagResults	MaxRodLoad	smallint	2	5
tblXDiagResults	MinElecCostPerBG	money	8	19
tblXDiagResults	MinEnerGBTorque	int	4	10
tblXDiagResults	MinEnergyCBE	int	4	10
tblXDiagResults	MinEnergyCLF	real	4	24
tblXDiagResults	MinEnergyElecBG	real	4	24
tblXDiagResults	MinEnergyElecBO	real	4	24
tblXDiagResults	MinEnergyGBLoadPct	smallint	2	5
tblXDiagResults	MinEnergyKWH	int	4	10
tblXDiagResults	MinEnergyMCB	smallint	2	5
tblXDiagResults	MinEnergyMonthlyElec	int	4	10
tblXDiagResults	MinGBTorque	int	4	10
tblXDiagResults	MinHP	int	4	10
tblXDiagResults	MinMonthlyElecCost	money	8	19
tblXDiagResults	MinTorqueCBE	int	4	10
tblXDiagResults	MinTorqueCLF	real	4	24
tblXDiagResults	MinTorqueElecBG	real	4	24
tblXDiagResults	MinTorqueElecBO	real	4	24
tblXDiagResults	MinTorqueGBLoadPct	smallint	2	5
tblXDiagResults	MinTorqueKWH	int	4	10
tblXDiagResults	MinTorqueMCB	smallint	2	5
tblXDiagResults	MinTorqueMonthlyElec	int	4	10
tblXDiagResults	MonthlyElecCost	datetime	8	23
tblXDiagResults	MotorLoad	smallint	2	5
tblXDiagResults	MPRL	int	4	10
tblXDiagResults	NetProd	smallint	2	5
tblXDiagResults	NetStrokeApparent	real	4	24
tblXDiagResults	NodeID	nvarchar	100	0
tblXDiagResults	OilAPIGravity	real	4	24
tblXDiagResults	PeakGBTorque	int	4	10
tblXDiagResults	POFluidLoad	int	4	10
tblXDiagResults	PolRodHP	real	4	24
tblXDiagResults	PPRL	int	4	10
tblXDiagResults	PumpCond1	varchar	50	0
tblXDiagResults	PumpCond2	varchar	50	0
tblXDiagResults	PumpCondition	varchar	100	0
tblXDiagResults	PumpEfficiency	int	4	10
tblXDiagResults	PumpEffPct	smallint	2	5
tblXDiagResults	PumpFriction	int	4	10
tblXDiagResults	PumpIntakePressure	int	4	10
tblXDiagResults	PumpSize	real	4	24
tblXDiagResults	PumpStroke	smallint	2	5
tblXDiagResults	RodAnalysis	text	16	0
tblXDiagResults	RodAnalysisLocale	ntext	16	0
tblXDiagResults	SurfaceAnalysis	text	16	0
tblXDiagResults	SurfaceAnalysisLocale	ntext	16	0
tblXDiagResults	SystemEffPct	smallint	2	5
tblXDiagResults	TubingLeak	bit	1	1
tblXDiagResults	TubingMovement	int	4	10
tblXDiagResults	TubingPressure	int	4	10
tblXDiagResults	UnitStructLoad	smallint	2	5
tblXDiagResults	UpliftCalculationMissingRequirements	nvarchar	-1	0
tblXDiagResults	WaterCutPct	smallint	2	5
tblXDiagResults	WaterSG	real	4	24
tblXDiagResultsLast	AdditionalUplift	real	4	24
tblXDiagResultsLast	AdditionalUpliftGross	real	4	24
tblXDiagResultsLast	AddOilProduction	int	4	10
tblXDiagResultsLast	AnalysisDate	datetime	8	23
tblXDiagResultsLast	AvgDHDSLoad	int	4	10
tblXDiagResultsLast	AvgDHDSPOLoad	int	4	10
tblXDiagResultsLast	AvgDHUSLoad	int	4	10
tblXDiagResultsLast	AvgDHUSPOLoad	int	4	10
tblXDiagResultsLast	BadSG	bit	1	1
tblXDiagResultsLast	BalanceUnit	bit	1	1
tblXDiagResultsLast	BouyRodWeight	int	4	10
tblXDiagResultsLast	CardType	varchar	1	0
tblXDiagResultsLast	CasingPressure	int	4	10
tblXDiagResultsLast	CurrentCBE	int	4	10
tblXDiagResultsLast	CurrentCLF	real	4	24
tblXDiagResultsLast	CurrentElecBG	real	4	24
tblXDiagResultsLast	CurrentElecBO	real	4	24
tblXDiagResultsLast	CurrentKWH	int	4	10
tblXDiagResultsLast	CurrentMCB	smallint	2	5
tblXDiagResultsLast	CurrentMonthlyElec	int	4	10
tblXDiagResultsLast	Date	datetime	8	23
tblXDiagResultsLast	DesignScore	nvarchar	200	0
tblXDiagResultsLast	DownholeAnalysis	text	16	0
tblXDiagResultsLast	DownholeAnalysisLocale	ntext	16	0
tblXDiagResultsLast	DownholeCapacity24	real	4	24
tblXDiagResultsLast	DownholeCapacityRuntime	real	4	24
tblXDiagResultsLast	DownholeCapacityRuntimeFillage	real	4	24
tblXDiagResultsLast	DryRodWeight	int	4	10
tblXDiagResultsLast	ElecCostMinTorquePerBO	money	8	19
tblXDiagResultsLast	ElecCostMonthly	money	8	19
tblXDiagResultsLast	ElecCostPerBG	money	8	19
tblXDiagResultsLast	ElecCostPerBO	money	8	19
tblXDiagResultsLast	ElectCostMinEnergyPerBO	money	8	19
tblXDiagResultsLast	FillagePct	smallint	2	5
tblXDiagResultsLast	FluidLevelXDiag	int	4	10
tblXDiagResultsLast	FluidLoadonPump	int	4	10
tblXDiagResultsLast	FluidSG	real	4	24
tblXDiagResultsLast	Friction	float	8	53
tblXDiagResultsLast	GearBoxLoadPct	smallint	2	5
tblXDiagResultsLast	GearboxTorqueRating	int	4	10
tblXDiagResultsLast	GrossProd	int	4	10
tblXDiagResultsLast	GrossPumpDisplacement	int	4	10
tblXDiagResultsLast	GrossPumpStroke	smallint	2	5
tblXDiagResultsLast	InputAnalysis	text	16	0
tblXDiagResultsLast	InputAnalysisLocale	ntext	16	0
tblXDiagResultsLast	LoadShift	smallint	2	5
tblXDiagResultsLast	MaxRodLoad	smallint	2	5
tblXDiagResultsLast	MinElecCostPerBG	money	8	19
tblXDiagResultsLast	MinEnerGBTorque	int	4	10
tblXDiagResultsLast	MinEnergyCBE	int	4	10
tblXDiagResultsLast	MinEnergyCLF	real	4	24
tblXDiagResultsLast	MinEnergyElecBG	real	4	24
tblXDiagResultsLast	MinEnergyElecBO	real	4	24
tblXDiagResultsLast	MinEnergyGBLoadPct	smallint	2	5
tblXDiagResultsLast	MinEnergyKWH	int	4	10
tblXDiagResultsLast	MinEnergyMCB	smallint	2	5
tblXDiagResultsLast	MinEnergyMonthlyElec	int	4	10
tblXDiagResultsLast	MinGBTorque	int	4	10
tblXDiagResultsLast	MinHP	int	4	10
tblXDiagResultsLast	MinMonthlyElecCost	money	8	19
tblXDiagResultsLast	MinTorqueCBE	int	4	10
tblXDiagResultsLast	MinTorqueCLF	real	4	24
tblXDiagResultsLast	MinTorqueElecBG	real	4	24
tblXDiagResultsLast	MinTorqueElecBO	real	4	24
tblXDiagResultsLast	MinTorqueGBLoadPct	smallint	2	5
tblXDiagResultsLast	MinTorqueKWH	int	4	10
tblXDiagResultsLast	MinTorqueMCB	smallint	2	5
tblXDiagResultsLast	MinTorqueMonthlyElec	int	4	10
tblXDiagResultsLast	MotorLoad	smallint	2	5
tblXDiagResultsLast	MPRL	int	4	10
tblXDiagResultsLast	NetProd	smallint	2	5
tblXDiagResultsLast	NetStrokeApparent	real	4	24
tblXDiagResultsLast	NodeID	nvarchar	100	0
tblXDiagResultsLast	OilAPIGravity	real	4	24
tblXDiagResultsLast	PeakGBTorque	int	4	10
tblXDiagResultsLast	POFluidLoad	int	4	10
tblXDiagResultsLast	PolRodHP	real	4	24
tblXDiagResultsLast	PPRL	int	4	10
tblXDiagResultsLast	PumpCond1	varchar	50	0
tblXDiagResultsLast	PumpCond2	varchar	50	0
tblXDiagResultsLast	PumpCondition	varchar	100	0
tblXDiagResultsLast	PumpEfficiency	int	4	10
tblXDiagResultsLast	PumpEffPct	smallint	2	5
tblXDiagResultsLast	PumpFriction	int	4	10
tblXDiagResultsLast	PumpIntakePressure	int	4	10
tblXDiagResultsLast	PumpSize	real	4	24
tblXDiagResultsLast	PumpStroke	smallint	2	5
tblXDiagResultsLast	RodAnalysis	text	16	0
tblXDiagResultsLast	RodAnalysisLocale	ntext	16	0
tblXDiagResultsLast	SurfaceAnalysis	text	16	0
tblXDiagResultsLast	SurfaceAnalysisLocale	ntext	16	0
tblXDiagResultsLast	SystemEffPct	smallint	2	5
tblXDiagResultsLast	TubingLeak	bit	1	1
tblXDiagResultsLast	TubingMovement	int	4	10
tblXDiagResultsLast	TubingPressure	int	4	10
tblXDiagResultsLast	UnitStructLoad	smallint	2	5
tblXDiagResultsLast	UpliftCalculationMissingRequirements	nvarchar	-1	0
tblXDiagResultsLast	WaterCutPct	smallint	2	5
tblXDiagResultsLast	WaterSG	real	4	24
tblXDiagRodResults	BottomMinStress	float	8	53
tblXDiagRodResults	Date	datetime	8	23
tblXDiagRodResults	Diameter	float	8	53
tblXDiagRodResults	DragFrictionCoefficient	real	4	24
tblXDiagRodResults	Grade	varchar	50	0
tblXDiagRodResults	GuideCountPerRod	int	4	10
tblXDiagRodResults	Length	int	4	10
tblXDiagRodResults	Loading	float	8	53
tblXDiagRodResults	NodeID	nvarchar	100	0
tblXDiagRodResults	RodGuideID	smallint	2	5
tblXDiagRodResults	RodNum	smallint	2	5
tblXDiagRodResults	TopMaxStress	float	8	53
tblXDiagRodResults	TopMinStress	float	8	53
tblXDiagScores	BottomMinStressScore	float	8	53
tblXDiagScores	BottomMinStressSummary	ntext	16	0
tblXDiagScores	BottomMinStressSummaryLocale	ntext	16	0
tblXDiagScores	Date	datetime	8	23
tblXDiagScores	GearboxScore	float	8	53
tblXDiagScores	GearboxSummary	ntext	16	0
tblXDiagScores	GearboxSummaryLocale	ntext	16	0
tblXDiagScores	MPRLScore	float	8	53
tblXDiagScores	MPRLSummary	ntext	16	0
tblXDiagScores	MPRLSummaryLocale	ntext	16	0
tblXDiagScores	NodeID	nvarchar	100	0
tblXDiagScores	RodLoadingScore	float	8	53
tblXDiagScores	RodLoadingSummary	ntext	16	0
tblXDiagScores	RodLoadingSummaryLocale	ntext	16	0
tblXDiagScores	StructureLoadingScore	float	8	53
tblXDiagScores	StructureLoadingSummary	ntext	16	0
tblXDiagScores	StructureLoadingSummaryLocale	ntext	16	0
tblXDiagScores	SystemEfficiencyScore	float	8	53
tblXDiagScores	SystemEfficiencySummary	ntext	16	0
tblXDiagScores	SystemEfficiencySummaryLocale	ntext	16	0
tblXDiagScores	TotalScore	float	8	53
tblXDiagScores	TotalSummary	ntext	16	0
tblXDiagScores	TotalSummaryLocale	ntext	16	0

.