SIMULAÇÃO PROCESSO DE MANUTENÇÃO

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

ID	FrequencyID	DefinitionID	IncludeOption
	ID	VersionMajor	VersionMinor	Date	User	Desc
	31	2	1	1998-07-21	GH	New format
	32	3	1	1999-09-01	GH	Moved the time units field from rep table to runoutput
	33	4	1	1999-09-02	sb	Fixed the table queries, to allow for the movement of the time units field
	34	5	1	1999-09-08	sb	Corrected the "count" relationship
	35	6	1	1999-09-10	sb	Deleted the "StatisticType" Table.
	36	7	1	2009-01-14	ms	Added columns Output.IsPeriodic and Statistic.IsPeriodic. Changed query StatsAndOutputQry. Changed column OutputFile.OutputFileName field size to 255.
	Object Type	Object Name	Error Description
	Table	MSysACEs	-3831: The current file format no longer supports user-level security. The conversion or compaction process has removed any user-level permissions.
	ID	DefinitionID	ReplicationID	Count
	name	Description
	All	All model output and scenario manager output
	None	Nothing is output to the database
	Response only	Only scenario manager responses
	ID	ReportID	Name	Format	ReportLineDefinitionID	ArgumentIndex	Expression	Type	RunOutputID	OutputFileID	SourceDataTypeID	SourceCategoryID	SourceProcessID	DefinitionTypeID	Limit
	1	1	Entity 1.WIP		0	0			1	1	16	2	1	2	0
	2	1	Tecnico de Elevador.NumberBusy		0	0			1	1	15	4	2	2	0
	3	1	Tecnico de Elevador.NumberScheduled		0	0			1	1	17	4	2	2	0
	4	1	Tecnico de Elevador.Utilization		0	0			1	1	37	4	2	2	0
	5	1	Reparo do Elevador.Queue.NumberInQueue		0	0			1	1	19	3	3	2	0
	6	1	Entity 1.NumberIn		0	0	Not implemented		1	1	36	2	1	6	0
	7	1	Entity 1.NumberOut		0	0	Not implemented		1	1	21	2	1	6	0
	8	1	Tecnico de Elevador.NumberSeized		0	0	Not implemented		1	1	38	4	2	6	0
	9	1	Tecnico de Elevador.ScheduledUtilization		0	0	Not implemented		1	1	28	4	2	6	0
	10	1	System.NumberOut		0	0	Not implemented		1	1	21	5	4	6	0
	ID	Name
	1	CSTAT
	2	DSTAT
	3	TALLY
	4	COUNTER
	5	FREQUENCY
	6	OUTPUT
	7	REPORT
	8	REPORTLINE
	9	REPORTLINEARG
	10	CATEGORY
	ID	ReplicationID	DefinitionID	NumObs	AvgTime	StandardPercent	RestrictedPercent
	ErrorCode	ErrorDescription	ErrorTable	ErrorRecid
	-3831	The current file format no longer supports user-level security. The conversion or compaction process has removed any user-level permissions.	MSysACEs	
	ID	DefinitionID	ReplicationID	Value	IsPeriodic
	1	6	1	24.0	0
	2	7	1	0.0	0
	3	8	1	0.0	0
	4	9	1	0.0	0
	5	10	1	0.0	0
	ID	RunOutputID	OutputFileName
	1	1	System
	ID	Name	Analyst	Date	Version	Description
	1	Unnamed Project	Wallace			
	ID	RunOutputID	ReplicationNumber	StartTime	EndTime	ExecutionStartDate	ExecutionEndDate	StatsCleared	IsWarmingUp
	1	1	1	0.0	54000.0			true	false
	ID	RunOutputID	Name	FileName	Title	Heading	SortName	FormatName
	1	1	System				UNSORTED	FREE
	Name	Description
	COUNTERS	
	CSTATS	
	FREE	Default report setting
	FREQUENCIES	
	OUTPUTS	
	REPORTLINES	
	TALLIES	
	ID	DefinitionID	ReplicationID	Value	StringValue
	ID	StatisticID	DefinitionID	Name
	ID	ScenarioID	RepsPerRun	RepsCompleted	ModelName	ModelRevisionDate	OutputCreationDate	TimeUnits
	1	1	1	1		2022-06-03	2022-06-03	1
	ID	ProjectID	GroupName	Name	StatusName	RepsPerRun	RepsCompleted	InitializeSystem	InitializeStatistics	StartingTime	StoppingRule	StoppingTime	StoppingCondition	TruncationTime	RepOutput	RunOutput	ModelName	Desc
	1	1	Default	Undefined	Active	0	0	true	true	0.0	Time	0.0	Time	0.0	All	All	C:\Users\Wallace\OneDrive\UVA\SIMULAÇÃO PROCESSO DE MANUTENÇÃO.p	
	ID	Name	RunOutputID	ArrayIndex	StartingSeed	EndingSeed
	Name	Description
	ASCENDING	
	DESCENDING	
	UNSORTED	
	ID	Name
	1	Process
	2	Entity
	3	Queue
	4	Resource
	5	System
	ID	Name
	1	Wait Time
	2	VA Time
	3	Total Cost
	4	Wait Cost
	5	Cycle Time
	6	VA Cost
	7	NVA Time
	8	Tran Time
	9	Other Time
	10	NVA Cost
	11	Tran Cost
	12	Other Cost
	13	Waiting Time
	14	Waiting Cost
	15	Number Busy
	16	WIP
	17	Number Scheduled
	18	Utilization
	19	Number Waiting
	20	Total Wait Time
	21	Number Out
	22	Total VA Cost
	23	Number Times Used
	24	Total Transfer Cost
	25	Total Wait Cost
	26	Total TransferTime
	27	Usage Cost
	28	Scheduled Utilization
	29	Total NVA Time
	30	Total Other Time
	31	Total NVA Cost
	32	Total Other Cost
	33	Idle Cost
	34	Total VA Time
	35	Busy Cost
	36	Number In
	37	Instantaneous Utilization
	38	Total Number Seized
	ID	Name	Parent
	1	Entity 1	0
	2	Tecnico de Elevador	0
	3	Reparo do Elevador.Queue	0
	4	System	0
	ID	ReplicationID	DefinitionID	MinObs	MaxObs	AvgObs	HalfWidth	LastValue	NumObs	StdDev	IsPeriodic
	1	1	1	0.0	24.0	15.640363643727502	2.0E20	24.0	0	6	0
	2	1	2	0.0	0.0	0.0	2.0E20	0.0	0	0	0
	3	1	3	1.0	1.0	1.0	2.0E20	1.0	0	0	0
	4	1	4	0.0	0.0	0.0	2.0E20	0.0	0	0	0
	5	1	5	0.0	24.0	15.640363643727502	2.0E20	24.0	0	6	0
SELECT Project.Name, Scenario.Name, Definition.*, Scenario.ModelName, RunOutput.OutputCreationDate, Rep.*, RunOutput.TimeUnits, DefinitionType.Name
FROM DefinitionType INNER JOIN ((Project INNER JOIN Scenario ON Project.ID = Scenario.ProjectID) INNER JOIN ((RunOutput INNER JOIN Definition ON RunOutput.ID = Definition.RunOutputID) INNER JOIN Rep ON RunOutput.ID = Rep.RunOutputID) ON Scenario.ID = RunOutput.ScenarioID) ON DefinitionType.ID = Definition.DefinitionTypeID;
SELECT DISTINCT Definition.Name, Definition_1.Name, Frequency.ID, Frequency.NumObs, Frequency.AvgTime, Frequency.StandardPercent, Frequency.RestrictedPercent, Category.ID, SourceProcess.Name, Frequency.DefinitionID AS OwnersID, "Replication " & [ReplicationNumber] AS Rep, Project.Name, Rep.ID, IIf([TimeUnits]=4,"Days",IIf([TimeUnits]=3,"Hours",IIf([TimeUnits]=2,"Minutes",IIf([TimeUnits]=1,"Seconds")))) AS [Time Units], RunOutput.OutputCreationDate, Rep.StartTime, Rep.EndTime, Scenario.ModelName, Category.IncludeOption, Rep.IsWarmingUp
FROM Definition AS Definition_1 INNER JOIN (SourceProcess INNER JOIN ((Project INNER JOIN Scenario ON Project.ID = Scenario.ProjectID) INNER JOIN (RunOutput INNER JOIN (Rep INNER JOIN ((DefinitionType INNER JOIN (Definition INNER JOIN Frequency ON Definition.ID = Frequency.DefinitionID) ON DefinitionType.ID = Definition.DefinitionTypeID) INNER JOIN Category ON Frequency.ID = Category.FrequencyID) ON Rep.ID = Frequency.ReplicationID) ON RunOutput.ID = Rep.RunOutputID) ON Scenario.ID = RunOutput.ScenarioID) ON SourceProcess.ID = Definition.SourceProcessID) ON Definition_1.ID = Category.DefinitionID
GROUP BY Definition.Name, Definition_1.Name, Frequency.ID, Frequency.NumObs, Frequency.AvgTime, Frequency.StandardPercent, Frequency.RestrictedPercent, Category.ID, SourceProcess.Name, Frequency.DefinitionID, "Replication " & [ReplicationNumber], Project.Name, Rep.ID, IIf([TimeUnits]=4,"Days",IIf([TimeUnits]=3,"Hours",IIf([TimeUnits]=2,"Minutes",IIf([TimeUnits]=1,"Seconds")))), RunOutput.OutputCreationDate, Rep.StartTime, Rep.EndTime, Scenario.ModelName, Category.IncludeOption, Rep.IsWarmingUp
HAVING (((Rep.IsWarmingUp)=False));
SELECT Frequency.ID, Frequency.ReplicationID, Frequency.DefinitionID, Frequency.NumObs, Frequency.AvgTime, Frequency.StandardPercent, Frequency.RestrictedPercent, Category.FrequencyID, Category.DefinitionID, Category.IncludeOption
FROM Frequency INNER JOIN Category ON Frequency.ID = Category.FrequencyID;
SELECT Project.Name, DefinitionType.Name AS TypeName, Definition.Name AS DefinitionName, Scenario.Name, Count.Count, Definition.Limit, IIf([Limit]=-1,"Infinite",[Limit]) AS [Count Limit], Report.FileName, Report.Title, Report.Heading, Report.SortName, Report.FormatName, OutputFile.OutputFileName, Report.Name, RunOutput.ID, SourceProcess.Name, SourceCategory.Name, SourceDataType.Name, Rep.ReplicationNumber
FROM Rep INNER JOIN (SourceProcess INNER JOIN (SourceDataType INNER JOIN (SourceCategory INNER JOIN ((Project INNER JOIN Scenario ON Project.ID = Scenario.ProjectID) INNER JOIN (RunOutput INNER JOIN (Report INNER JOIN (OutputFile INNER JOIN (DefinitionType INNER JOIN (Count INNER JOIN Definition ON Count.DefinitionID = Definition.ID) ON DefinitionType.ID = Definition.DefinitionTypeID) ON OutputFile.ID = Definition.OutputFileID) ON Report.ID = Definition.ReportID) ON (RunOutput.ID = Report.RunOutputID) AND (RunOutput.ID = OutputFile.RunOutputID) AND (RunOutput.ID = Definition.RunOutputID))
ON Scenario.ID = RunOutput.ScenarioID) ON SourceCategory.ID = Definition.SourceCategoryID) ON SourceDataType.ID = Definition.SourceDataTypeID) ON SourceProcess.ID = Definition.SourceProcessID) ON (SourceCategory.ID = Rep.ID) AND (RunOutput.ID = Rep.RunOutputID) AND (Rep.ID = Count.ReplicationID)
ORDER BY Count.ID;
SELECT Project.Name, Scenario.Name, Replication.ReplicationNumber, FrequencyDefinition.Name AS DefinitionName, CategoryDefinition.Name, Frequency.NumObs, Frequency.AvgTime, Frequency.StandardPercent, IIf([IncludeOption]=True,[RestrictedPercent],"---") AS [Restricted Percent], Report.FileName, Report.Title, Report.Heading, Report.SortName, Report.FormatName, OutputFile.OutputFileName, Report.Name
FROM (Project INNER JOIN Scenario ON Project.ID = Scenario.ProjectID) INNER JOIN (RunOutput INNER JOIN (Report INNER JOIN (Replication INNER JOIN (OutputFile INNER JOIN (FrequencyDefinition INNER JOIN (Frequency INNER JOIN (CategoryDefinition INNER JOIN Category ON CategoryDefinition.ID = Category.DefinitionID) ON Frequency.ID = Category.FrequencyID) ON FrequencyDefinition.ID = Frequency.DefinitionID) ON OutputFile.ID = FrequencyDefinition.OutputFileID) ON Replication.ID = Frequency.ReplicationID) ON Report.ID = FrequencyDefinition.ReportID) ON (RunOutput.ID = Report.RunOutputID) AND (RunOutput.ID = Replication.RunOutputID) AND (RunOutput.ID = OutputFile.RunOutputID) AND (RunOutput.ID = FrequencyDefinition.RunOutputID) AND (RunOutput.ID = CategoryDefinition.RunOutputID)) ON Scenario.ID = RunOutput.ScenarioID
ORDER BY Replication.ID, FrequencyDefinition.ID, CategoryDefinition.ID;
SELECT Project.Name, DefinitionType.Name AS TypeName, Scenario.Name, Output.Value, Report.Name, SourceProcess.Name, SourceCategory.Name, SourceDataType.Name, Rep.ReplicationNumber
FROM Rep INNER JOIN (SourceProcess INNER JOIN (SourceDataType INNER JOIN (SourceCategory INNER JOIN ((Project INNER JOIN Scenario ON Project.ID = Scenario.ProjectID) INNER JOIN (RunOutput INNER JOIN (Report INNER JOIN (DefinitionType INNER JOIN (Definition INNER JOIN Output ON Definition.ID = Output.DefinitionID) ON DefinitionType.ID = Definition.DefinitionTypeID) ON Report.ID = Definition.ReportID) ON (RunOutput.ID = Report.RunOutputID) AND (RunOutput.ID = Definition.RunOutputID)) ON Scenario.ID = RunOutput.ScenarioID) ON SourceCategory.ID = Definition.SourceCategoryID) ON SourceDataType.ID = Definition.SourceDataTypeID) ON SourceProcess.ID = Definition.SourceProcessID) ON (SourceCategory.ID = Rep.ID) AND (RunOutput.ID = Rep.RunOutputID) AND (Rep.ID = Output.ReplicationID);
SELECT Project.Name, Output.Value, DefinitionType.Name AS TypeName, Report.Name, SourceDataType.Name, SourceProcess.Name, SourceCategory.Name, Rep.ReplicationNumber
FROM Rep INNER JOIN (SourceProcess INNER JOIN (SourceDataType INNER JOIN (SourceCategory INNER JOIN ((Project INNER JOIN Scenario ON Project.ID = Scenario.ProjectID) INNER JOIN (RunOutput INNER JOIN (Report INNER JOIN (DefinitionType INNER JOIN (Definition INNER JOIN Output ON Definition.ID = Output.DefinitionID) ON DefinitionType.ID = Definition.DefinitionTypeID) ON Report.ID = Definition.ReportID) ON (RunOutput.ID = Report.RunOutputID) AND (RunOutput.ID = Definition.RunOutputID)) ON Scenario.ID = RunOutput.ScenarioID) ON SourceCategory.ID = Definition.SourceCategoryID) ON SourceDataType.ID = Definition.SourceDataTypeID) ON SourceProcess.ID = Definition.SourceProcessID) ON (SourceCategory.ID = Rep.ID) AND (RunOutput.ID = Rep.RunOutputID) AND (Rep.ID = Output.ReplicationID);
SELECT Project.Name, DefinitionType.Name AS TypeName, Scenario.Name, Report.Name, Definition.ArgumentIndex, IIf([Type]="STR",[StringValue],[Value]) AS ArgumentValue, Rep.ReplicationNumber
FROM Rep INNER JOIN ((Project INNER JOIN Scenario ON Project.ID = Scenario.ProjectID) INNER JOIN (RunOutput INNER JOIN (Report INNER JOIN (DefinitionType INNER JOIN (Definition INNER JOIN ReportLineArgument ON Definition.ID = ReportLineArgument.DefinitionID) ON DefinitionType.ID = Definition.DefinitionTypeID) ON Report.ID = Definition.ReportID) ON (RunOutput.ID = Report.RunOutputID) AND (RunOutput.ID = Definition.RunOutputID)) ON Scenario.ID = RunOutput.ScenarioID) ON (Project.ID = Rep.ID) AND (RunOutput.ID = Rep.RunOutputID) AND (Rep.ID = ReportLineArgument.ReplicationID);
SELECT Statistic.ID, DefinitionType.Name AS TypeName, Project.Name, Statistic.MinObs, Statistic.MaxObs, Statistic.AvgObs, IIf([HalfWidth]=3E+20,"(Correl)",IIf([HalfWidth]=1E+20,"(Unknown)",IIf([HalfWidth]=2E+20,"(Insuff)",Format([HalfWidth],"0.000")))) AS [Half Width], Statistic.LastValue, Statistic.NumObs, Report.Name, Report.Heading, Statistic.HalfWidth, SourceDataType.Name, SourceProcess.Name, SourceCategory.Name, Rep.ReplicationNumber
FROM Rep INNER JOIN (SourceProcess INNER JOIN (SourceDataType INNER JOIN (SourceCategory INNER JOIN ((Project INNER JOIN Scenario ON Project.ID = Scenario.ProjectID) INNER JOIN (RunOutput INNER JOIN (Report INNER JOIN (OutputFile INNER JOIN (DefinitionType INNER JOIN (Definition INNER JOIN Statistic ON Definition.ID = Statistic.DefinitionID) ON DefinitionType.ID = Definition.DefinitionTypeID) ON OutputFile.ID = Definition.OutputFileID) ON Report.ID = Definition.ReportID) ON (RunOutput.ID = Report.RunOutputID) AND (RunOutput.ID = OutputFile.RunOutputID) AND (RunOutput.ID = Definition.RunOutputID)) ON Scenario.ID = RunOutput.ScenarioID) ON SourceCategory.ID = Definition.SourceCategoryID) ON SourceDataType.ID = Definition.SourceDataTypeID) ON SourceProcess.ID = Definition.SourceProcessID) ON (SourceCategory.ID = Rep.ID) AND (RunOutput.ID = Rep.RunOutputID) AND (Rep.ID = Statistic.ReplicationID)
ORDER BY Statistic.ID;
SELECT Statistic.ID, Project.Name, Scenario.Name, "Replication " & [ReplicationNumber] AS ReplicationNum, DefinitionType.Name AS TypeName, Statistic.MinObs, Statistic.MaxObs, Statistic.AvgObs, IIf([HalfWidth]=3E+20,"(Correlated)",IIf([HalfWidth]=1E+20,"(Unknown)",IIf([HalfWidth]=2E+20,"(Insufficient)",Format([HalfWidth],"0.000")))) AS [Half Width], Statistic.LastValue, Statistic.NumObs, Report.Name, Report.FileName, Report.Heading, Report.SortName, Report.FormatName, OutputFile.OutputFileName, Statistic.HalfWidth, SourceDataType.Name, SourceProcess.Name, SourceCategory.Name, RunOutput.OutputCreationDate
FROM Rep INNER JOIN (SourceProcess INNER JOIN (SourceDataType INNER JOIN (SourceCategory INNER JOIN ((Project INNER JOIN Scenario ON Project.ID = Scenario.ProjectID) INNER JOIN (RunOutput INNER JOIN (Report INNER JOIN (OutputFile INNER JOIN (DefinitionType INNER JOIN (Definition INNER JOIN Statistic ON Definition.ID = Statistic.DefinitionID) ON DefinitionType.ID = Definition.DefinitionTypeID) ON OutputFile.ID = Definition.OutputFileID) ON Report.ID = Definition.ReportID) ON (RunOutput.ID = Report.RunOutputID) AND (RunOutput.ID = OutputFile.RunOutputID) AND (RunOutput.ID = Definition.RunOutputID)) ON Scenario.ID = RunOutput.ScenarioID) ON SourceCategory.ID = Definition.SourceCategoryID) ON SourceDataType.ID = Definition.SourceDataTypeID) ON SourceProcess.ID = Definition.SourceProcessID) ON (SourceCategory.ID = Rep.ID) AND (RunOutput.ID = Rep.RunOutputID) AND (Rep.ID = Statistic.ReplicationID)
ORDER BY Statistic.ID;
SELECT Project.Name, Scenario.GroupName, Scenario.ID, Scenario.Name, Scenario.*
FROM Project INNER JOIN Scenario ON Project.ID = Scenario.ProjectID;
SELECT Output.Value, Statistic.MaxObs, Statistic.AvgObs, Statistic.LastValue, Statistic.NumObs, Statistic.StdDev, SourceCategory.Name, SourceProcess.Name, SourceDataType.Name, Statistic.MinObs, IIf([TimeUnits]=4,"Days",IIf([TimeUnits]=3,"Hours",IIf([TimeUnits]=2,"Minutes",IIf([TimeUnits]=1,"Seconds")))) AS [Time Units], "Replication " & [ReplicationNumber] AS Rep, SourceDataType.Name AS Subgroup, IIf([HalfWidth]=3E+20,"(Correlated)",IIf([HalfWidth]=1E+20,"(Unknown)",IIf([HalfWidth]=2E+20,"(Insufficient)",IIf([HalfWidth]>99999,Format([HalfWidth],"0.0"),IIf([HalfWidth]>9999,Format([HalfWidth],"0.00"),IIf([HalfWidth]>99,Format([HalfWidth],"0.000"),IIf([HalfWidth]>1,Format([HalfWidth],"0.00000"),IIf([HalfWidth]<1,Format([HalfWidth],"0.000000000")))))))))
AS [Half Width], DefinitionSelectQry.Project.Name, DefinitionSelectQry.StartTime, DefinitionSelectQry.EndTime, DefinitionSelectQry.OutputCreationDate, DefinitionSelectQry.ModelName, Count.Count, DefinitionType.Name, Output.ID, Count.ID, Frequency.NumObs, Frequency.AvgTime, Frequency.StandardPercent, Frequency.RestrictedPercent, DefinitionSelectQry.IsWarmingUp, IIf(IsNull([Statistic].[IsPeriodic]),-1,[Statistic].[IsPeriodic]) AS IsPeriodicDstat, IIf(IsNull([Output].[IsPeriodic]),-1,[Output].[IsPeriodic]) AS IsPeriodicOutput
FROM (((((SourceProcess INNER JOIN (SourceCategory INNER JOIN (SourceDataType INNER JOIN DefinitionSelectQry ON SourceDataType.ID = DefinitionSelectQry.SourceDataTypeID) ON SourceCategory.ID = DefinitionSelectQry.SourceCategoryID) ON SourceProcess.ID = DefinitionSelectQry.SourceProcessID) LEFT JOIN Statistic ON (DefinitionSelectQry.Rep.ID = Statistic.ReplicationID) AND (DefinitionSelectQry.Definition.ID = Statistic.DefinitionID)) LEFT JOIN Output ON (DefinitionSelectQry.Rep.ID = Output.ReplicationID) AND (DefinitionSelectQry.Definition.ID = Output.DefinitionID)) LEFT JOIN Count ON (DefinitionSelectQry.Definition.ID = Count.DefinitionID) AND (DefinitionSelectQry.Rep.ID = Count.ReplicationID)) INNER JOIN DefinitionType ON DefinitionSelectQry.DefinitionTypeID = DefinitionType.ID) LEFT JOIN Frequency ON (DefinitionSelectQry.Definition.ID = Frequency.DefinitionID) AND (DefinitionSelectQry.Rep.ID = Frequency.ReplicationID)
GROUP BY Output.Value, Statistic.MaxObs, Statistic.AvgObs, Statistic.LastValue, Statistic.NumObs, Statistic.StdDev, SourceCategory.Name, SourceProcess.Name, SourceDataType.Name, Statistic.MinObs, IIf([TimeUnits]=4,"Days",IIf([TimeUnits]=3,"Hours",IIf([TimeUnits]=2,"Minutes",IIf([TimeUnits]=1,"Seconds")))), "Replication " & [ReplicationNumber], SourceDataType.Name, IIf([HalfWidth]=3E+20,"(Correlated)",IIf([HalfWidth]=1E+20,"(Unknown)",IIf([HalfWidth]=2E+20,"(Insufficient)",IIf([HalfWidth]>99999,Format([HalfWidth],"0.0"),IIf([HalfWidth]>9999,Format([HalfWidth],"0.00"),IIf([HalfWidth]>99,Format([HalfWidth],"0.000"),IIf([HalfWidth]>1,Format([HalfWidth],"0.00000"),IIf([HalfWidth]<1,Format([HalfWidth],"0.000000000"))))))))), DefinitionSelectQry.Project.Name, DefinitionSelectQry.StartTime, DefinitionSelectQry.EndTime, DefinitionSelectQry.OutputCreationDate, DefinitionSelectQry.ModelName, Count.Count, DefinitionType.Name, Output.ID, Count.ID, Frequency.NumObs, Frequency.AvgTime, Frequency.StandardPercent, Frequency.RestrictedPercent, DefinitionSelectQry.IsWarmingUp, IIf(IsNull([Statistic].[IsPeriodic]),-1,[Statistic].[IsPeriodic]), IIf(IsNull([Output].[IsPeriodic]),-1,[Output].[IsPeriodic])
HAVING (((DefinitionSelectQry.IsWarmingUp)=False))
ORDER BY SourceDataType.Name;