| calendar_id |
INT |
Calendar ID selected for the case, reference table ASMS_CALENDAR. CALENDAR_ID |
| 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, reference table ASMS_STATUS.stat_id |
| 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, reference table ASDK_ITEM.id |
| item_type_id* |
INT |
Case type identifier, reference table ASMS_TYPES.id |
| 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, reference the table ASMS_STATUS.stat_id |
| status_type* |
BIT |
Timer status ( 0 = stopped, 1 = running) |
| time_id* |
INT |
Timer ID associated with the case, reference the ASMS_TIMES.id table |
| time_type_id* |
INT |
Identifies the type of time calculation, (0 = per state, 1 = per condition) |
| type_agree |
INT |
Type of associated service agreement, reference table ASMS_TYPES.id |
