EN
Español
English
Português
    ASMS_TIMES

    Contains timer tracking configuration information

    Data model

    Fields

    Field Type Description
    builtin_id INT Identifier in the data source built into the timer
    compliance INT Percentage of compliance value if successful
    end_state_id INT Identifier of the state in which the timer stops
    id* INT Unique identifier of the timer tracking object
    model_id* INT Model identifier associated with the timer, reference the ASMS_MODEL.id table
    name* NVARCHAR (100) Timer object name
    priority NVARCHAR (MAX) Json string representing the time objectives for each of the system’s priorities
    reactive_time* BIT Identify whether time will resume or reactivate the time count
    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
    start_state_id INT Identifier of the state in which the timer is triggered
    target INT Target time for service delivery
    type_agree* INT Type of agreement associated with the timer
    type_id* INT Case model type identifier related to the timer

    Primary Key

    PK_ASMS_TIMES
    id

    References

    Column Referenced Table Referenced column Name
    builtin_id Bod. ASMS_TIMES_BUILTIN id FK02_ASMS_TIMES
    model_id* dbo.ASMS_MODEL id FK01_ASMS_TIMES
    type_agree* dbo.ASMS_TYPES id FK03_ASMS_TIMES