EN
Español
English
Português
    ASDK_ITEM_DW_OLD

    Contains version information about cases in the ASMS suite - DataWareHouse

    Data model

    Fields

    Field Type Description
    applicant_id INT Case requester identifier
    applicant_name NVARCHAR (1020) Case Applicant’s Name
    author_email NVARCHAR (510) Email of the user who created the case
    author_id INT Identifier of the user who created the case
    author_name NVARCHAR (510) Case Author Name
    available_cost BIT Indicates that the case has an available cost quota
    available_count BIT Indicates that the case has an available count quota
    available_effort BIT Indicates that the case has an available effort quota
    available_price BIT Indicates that the case has an available price quota
    calendar_ola_id INT OLA calendar ID
    calendar_ola_name NVARCHAR (510) Name of the OLA calendar associated with the case
    calendar_sla_id INT SLA calendar identifier
    calendar_sla_name NVARCHAR (510) Name of the SLA calendar associated with the case
    calendar_uc_id INT UC Calendar ID
    calendar_uc_name NVARCHAR (510) Name of the UC calendar associated with the case
    category_hierarchy NVARCHAR (510) Case category hierarchy
    category_id INT Case category identifier
    category_name NVARCHAR (510) Case Category Name
    cause NVARCHAR (MAX) Case Cause
    cause_nohtml NVARCHAR (MAX) Case Cause Without HTML Elements
    ci_asset_tag NVARCHAR (510) Property label of the CI associated with the case
    ci_id INT Configuration Item (CI) ID associated with the case
    ci_name NVARCHAR (510) Name of the IC associated with the case
    ci_serial NVARCHAR (510) Serial number of the IC associated with the case
    closed_date DATETIME Date the case was closed
    commentary NVARCHAR (MAX) Case Solution
    commentary_nohtml NVARCHAR (MAX) Case solution without HTML elements
    company_id INT Company identifier for the case
    company_name NVARCHAR (510) Name of the company assigned to the case
    contract_id INT Associated contract identifier
    cost FLOAT Case Cost Value
    cost_center_id INT Cost center ID for the case
    cost_model_id INT Cost model identifier for the case
    created_date DATETIME Date the case was created
    current_progress FLOAT Current Progress of the Case
    current_time FLOAT Time elapsed during the case
    customer_id INT Client ID assigned to the case
    customer_name NVARCHAR (510) Case Client Name
    description NVARCHAR (MAX) Case description
    description_nohtml NVARCHAR (MAX) Description of the case without HTML elements
    effort FLOAT Recorded effort to attend to the case
    estimated_date DATETIME Estimated date of the case model primary timer
    estimated_time FLOAT Estimated time of the main timer of the case model
    group_id INT Group identifier for the case
    group_name NVARCHAR (510) Case Group Name
    id* INT Case ID
    id_by_project* NVARCHAR (512) Case identifier by project
    impact_id INT Impact identifier for the case
    impact_name NVARCHAR (510) Case Impact Name
    income_center_id INT Revenue center identifier for the case
    integration_id INT Identifier of the external system to which the case belongs
    interface_id NVARCHAR (200) Identifier of the source system associated with the case, this is given by integration
    location_id INT Identifier of the associated location
    model_id INT Model identifier for the case
    model_name NVARCHAR (510) Case Model Name
    modified_date* DATETIME2 Date Case Changed
    modifier_name NVARCHAR (510) Name of the last user who modified the case
    note NVARCHAR (MAX) Note associated with the case
    ola_id INT OLA identifier for the case
    ola_name NVARCHAR (510) Name of the OLA of the case
    opened_date DATETIME Date on which the case is opened
    previous_status_id INT Previous case status identifier
    price FLOAT Case Price Value
    priority_id INT Case priority identifier
    priority_name NVARCHAR (510) Case priority name
    project_id INT Associated project ID
    project_name NVARCHAR (510) Case Project Name
    provider_id INT Provider identifier for the case
    provider_name NVARCHAR (510) Name of the provider associated with the case
    real_date DATETIME Case Model Primary Timer Actual Date
    reason_id INT Case Reason Identifier
    reason_name NVARCHAR (510) Name of the reason for the case
    receptor_id INT Identifier of the first specialist assigned to the case
    receptor_name NVARCHAR (510) Name of the first user to whom the case was assigned
    registry_type_id INT Record type identifier for the case
    registry_type_name NVARCHAR (510) Case Record Type Name
    responsible_id INT Identifier of the specialist responsible for the case
    responsible_name NVARCHAR (510) Name of the person responsible for the case
    rev INT Consecutive number of the current case review
    service_id INT Service ID for the case
    service_name NVARCHAR (510) Case Service Name
    sla_id INT SLA identifier for the case
    sla_name NVARCHAR (510) Case SLA Name
    state_final INT Identify whether the status is final or not. (1 = End)
    state_id INT State ID for the case
    state_initial INT Identify whether the state is initial or not. (1 = is initial)
    state_name NVARCHAR (510) Case Status Name
    status_color NVARCHAR (510) Current state color
    subject NVARCHAR (800) Describe the subject of the case
    survey_token NVARCHAR (200) Associated survey ID
    type_id* INT Case Type Identifier
    type_name NVARCHAR (510) Case Type Name
    uc_id INT UC identifier for the case
    uc_name NVARCHAR (510) Case UC Name
    unit_id INT Identifier of the internal area associated with the case
    unit_name NVARCHAR (510) Name of the organizational area associated with the case
    urgency_id INT Case Urgency Identifier
    urgency_name NVARCHAR (510) Name of the urgency of the case

    Primary Key

    PK_ASDK_ITEM_DW
    id, modified_date