ASMS_TIMES_DATA | Aranda Database

Contains information about a specific timer linked to a case

Data model

Field	Type	Description
calendar_id	INT	Calendar ID selected for the case
complies	BIT	Determine if the service time is as expected
end_date	DATETIME	End date for case execution
end_state_id	INT	End-state identifier for timer
end_time	FLOAT	Final Time Value for the Case
estimated_date	DATETIME	Estimated date for case execution
estimated_time	FLOAT	Estimated time value for the case
item_id*	INT	Unique Case Identifier
item_type_id*	INT	Case Type Identifier
next_active_date	DATETIME	Identify the start date so that it starts counting down time
next_inactive_date	DATETIME	Identifies the final date by which time should be counted
recalculate_date*	BIT	Identifies whether time needs to be recalculated when a pause ends, i.e., switches from an inactive state or condition to an active one
sdb_current_paused	FLOAT	Store the elapsed pause time
sdb_current_progress	FLOAT	Value of current progress
sdb_current_time	FLOAT	Integer value representation of elapsed time
sdb_last_shot	DATETIME	Timer Last Run Date
sdb_time	FLOAT	Identifies the current elapsed time
sdb_total_paused	FLOAT	Store the total paused time
start_date	DATETIME	Case Kick-Off Date
start_state_id	INT	Initial state identifier for the timer
status_type*	BIT	Timer status ( 0 = stopped, 1 = running)
time_id*	INT	Timer ID associated with the case
time_type_id*	INT	Identifies the type of time calculation, (0 = per state, 1 = per condition)
type_agree	INT	Type of associated service agreement

PK_ASMS_TIMES_DATA
item_id, time_id, item_type_id

Column	Referenced Table	Referenced column	Name
time_id*	dbo.ASMS_TIMES	id	FK01_ASMS_TIMES_DATA
type_agree	dbo.ASMS_TYPES	id	FK02_ASMS_TIMES_DATA