EN
Español
English
Português
    FACT_ASDK_ITEM_REVISION

    Contains instant release information about cases in the ASMS suite - DataWareHouse

    Data model

    Fields

    Field Type Description
    applicant_sk INT Case requester identifier
    author_user_sk INT Identifier of the user who created the case
    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
    company_sk INT Company identifier for the case
    contract_sk INT Associated contract identifier
    cost_center_sk INT Cost center ID for the case
    cost_model_sk INT Cost model identifier for the case
    current_cost FLOAT Case Cost Cumulative Value
    current_effort FLOAT Partial effort recorded to attend to the case
    current_price FLOAT Case Price Value
    current_progress FLOAT Current case progress is calculated tiempo_actual/tiempo_estimado
    current_time FLOAT Default Stopwatch Time for Case Model
    customer_user_sk INT Client ID assigned to the case
    date_sk* INT Identifier of the date dimension in which the case was modified
    estimated_date DATETIME Estimated date of the case model primary timer
    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
    note_count FLOAT Total grades
    ola_sk INT OLA identifier for the case
    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
    priority_sk INT Case priority identifier
    private_note_count FLOAT Total Private Notes
    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 of the current case review
    service_sk INT Service ID for the case
    sla_sk INT SLA identifier for the case
    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 status is final 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 time accumulated between the previous modification and the 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_REVISION
    id, modified_date