EN
Español
English
Português
    FACT_ASDK_ITEM

    Contains information from the latest versions about cases in the ASMS suite - DataWareHouse

    Data model

    Fields

    Field Type Description
    applicant_sk INT Case requester identifier
    attention_date DATETIME Date of Case Attention
    attention_date_key INT Case Care Date Dimension Identifier
    author_email NVARCHAR (1020) Author’s email
    author_user_sk INT Identifier of the user who created the case
    available_cost BIT Cost available at the time the case is created
    available_count BIT Indicates the number of cases available at the time the case is created according to the number of cases per service
    available_effort BIT Amount of effort available at the time the case is created
    available_price BIT Price available at the time the case is created
    calendar_ola_sk INT OLA calendar ID
    calendar_sla_sk INT SLA calendar identifier
    calendar_uc_sk INT UC Calendar ID
    category_sk INT Case category identifier
    ci_sk INT Configuration Item (CI) ID associated with the case
    close_date_sk INT Case Close Date Dimension ID
    closed_date DATETIME Case Closing Date
    company_sk INT Company identifier for the case
    contract_sk INT Associated contract identifier
    cost FLOAT Case Cost Cumulative Value
    cost_center_sk INT Cost center ID for the case
    cost_model_sk INT Cost model identifier for the case
    created_date DATETIME Case Creation Date
    created_date_sk INT Case Creation Date Dimension ID
    current_progress FLOAT Progress represented in a percentage number at the time of saving the case
    current_time FLOAT Elapsed time in seconds from the default time at the time of saving the case
    customer_user_sk INT Client ID assigned to the case
    default_time_real_date DATETIME Date for the default case timer
    default_time_real_date_sk INT Date dimension identifier for the default stopwatch of the case
    effort FLOAT Cumulative effort recorded to attend to the case
    estimated_date DATETIME Estimated date for the default case timer
    estimated_date_sk INT Estimated date dimension identifier for the default stopwatch in the case
    id* INT Case ID
    id_by_project* NVARCHAR (512) Case identifier by project
    impact_sk INT Impact identifier for the case
    integration_sk INT Identifier of the external system to which the case belongs
    interface_sk NVARCHAR (200) Identifier of the source system associated with the case, this is given by integration
    item_type_sk* INT Case Type Identifier
    location_sk INT Identifier of the associated location
    model_sk INT Model identifier for the case
    modified_date* DATETIME2 Date Case Changed
    modifier_user_sk INT Identifier of the specialist who modified the case
    ola_sk INT OLA identifier for the case
    open_date_sk INT Case Opening Date Dimension ID
    opened_date DATETIME Case Opening Date
    previous_specialist_group_sk INT Previous group of specialists assigned to the case
    previous_specialist_user_sk INT Specialists Previously Assigned to the Case
    previous_status_sk INT Previous case status identifier
    price FLOAT Case Price Value
    priority_sk INT Case priority identifier
    profit_center_sk INT Revenue center identifier for the case
    project_sk INT Associated project ID
    provider_sk INT Provider identifier for the case
    reason_sk INT Case Reason Identifier
    receptor_user_sk INT Identifier of the first specialist assigned to the case
    registry_type_sk INT Record type identifier for the case
    rev INT Consecutive number that identifies the current version of the record
    service_sk INT Service ID for the case
    sla_sk INT SLA identifier for the case
    solution_date DATETIME Case Resolution Date
    solution_date_key INT Date dimension identifier for the case solution
    specialist_group_sk INT Group identifier for the case
    specialist_user_sk INT Identifier of the specialist responsible for the case
    state_final INT Identify whether the state is initial or not. (1 = End)
    state_initial INT Identify whether the state is initial or not. (1 = is initial)
    status_sk INT State ID for the case
    time FLOAT Amount of Calendar Time Between Previous Modification and Current Modification
    uc_sk INT UC identifier for the case
    unit_sk INT Identifier of the internal area associated with the case
    urgency_sk INT Case Urgency Identifier

    Primary Key

    PK_FACT_ASDK_ITEM
    id