EN
Español
English
Português
    ASDK_SERVICE_DW_LAST

    Contains the latest information for ASMS suite service management - DataWareHouse

    Data model

    Fields

    Field Type Description
    author_id INT Service Author Identifier
    author_name NVARCHAR (510) Service Author Name
    closed_date DATETIME Service Closing Date
    cost_center_id INT Associated cost center identifier
    description NVARCHAR (8000) Description of the service
    group_id INT Identifier of the associated default group
    group_name NVARCHAR (510) Descriptive Group Name
    id* INT Unique Service Identifier
    image_id INT Identifier of the associated image
    image_name NVARCHAR (MAX) Friendly name of the service image
    impact_id INT Identifier of the associated impact
    impact_name NVARCHAR (510) Descriptive name of the impact
    income_center_id INT Associated revenue center identifier
    modified_date* DATETIME Date of modification of the service
    modifier_id INT Identifier of the user who modified the service
    modifier_name NVARCHAR (510) Name of the user modifying the service
    name NVARCHAR (510) Service Name
    note NVARCHAR (510) Note associated with the service
    ola_id INT Identifier of the associated default OLA
    ola_name NVARCHAR (510) Default OLA Name
    opened_date DATETIME Service Registration Date
    previous_state_id INT Associated Previous Status Identifier
    project_id INT Associated project ID
    project_name NVARCHAR (510) Descriptive name of the associated project
    reason_id INT Identifier of the reason associated with the service status
    reason_name NVARCHAR (510) Descriptive name of the reason
    responsible_id INT Identifier of the user who owns the service
    responsible_name NVARCHAR (510) Name of the user who owns the service
    sla_id INT Associated default SLA identifier
    sla_name NVARCHAR (510) Default SLA Name
    stage_id INT Service Lifecycle Stage Identifier
    stage_name NVARCHAR (510) Descriptive name of the service lifecycle stage
    state_final INT Identify whether the status is final or not. (1 = End)
    state_id INT Service Status Identifier
    state_name NVARCHAR (510) State Friendly Name
    type_id INT Service type identifier, (0 = Internal, 1 = External)
    type_name NVARCHAR (510) Descriptive name of the type of service, Internal - External
    uc_id INT Identifier of the associated default UC
    uc_name NVARCHAR (510) Default UC Name

    Primary Key

    PK_ASDK_SERVICE_DW_LAST
    id