EN
Español
English
Português
    V_FACT_ASDK_TASK_REVISION

    Contains detailed information about the versions of tasks registered in the ASMS suite, within the DataWarehouse environment

    Fields

    Field Type Description
    author_user_sk INT Identifier of the user who created the task
    calendar_sla_sk INT SLA calendar identifier
    category_sk INT Task category identifier
    current_cost FLOAT Cumulative value of the cost of the task
    current_duration FLOAT Cumulative Time in Minutes
    current_duration_formatted VARCHAR (20) Cumulative time in minutes in HH:MM:SS format
    current_effort FLOAT Recorded cumulative effort to attend to the task
    current_price FLOAT Task Price Cumulative Value
    current_progress FLOAT A numerical value that indicates the current progress or progress of the task, represented as a percentage
    date_sk* INT Task Modification Date Dimension ID
    duration FLOAT Time in minutes between previous modification and current modification
    duration_formatted VARCHAR (20) Time between previous modification and current modification in HH:MM:SS format
    estimated_date DATETIME Estimated date by which the task should be completed according to the SLA schedule
    id* INT Task ID
    id_by_project* NVARCHAR (512) Task ID by Project
    integration_sk INT Identifier of the external system to which the task belongs
    model_sk INT Model ID for the task
    modified_date* DATETIME2 Date the task was modified
    modifier_user_sk INT Identifier of the specialist who modified the task
    note_count FLOAT Total grades
    parent_case_change INT Indicates whether the parent case of the task is a change
    parent_case_incident INT Indicates whether the parent case of the task is an incident
    parent_case_problem INT Indicates whether the parent case of the task is a problem
    parent_case_release INT Indicates whether the parent case of the task is a release
    parent_case_requirement INT Indicates whether the parent case of the task is a requirement
    previous_specialist_group_sk INT Previous Specialist Group Assigned to the Task
    previous_specialist_user_sk INT Specialists Previously Assigned to the Task
    previous_status_sk INT Task Previous Status Identifier
    private_note_count FLOAT Total Private Notes
    project_sk INT Associated project ID
    public_note_count FLOAT Total public notes
    reason_sk INT Task Reason Identifier
    receptor_user_sk INT Identifier of the first specialist assigned to the task
    rev INT Consecutive number that identifies the current version of the record
    service_sk INT Service ID for the task
    specialist_group_reassigned INT Indicates whether the task has been reassigned from one specialist group to another
    specialist_group_sk INT Group ID for the task
    specialist_reassigned INT Indicates whether the task has been reassigned from one specialist to another
    specialist_user_sk INT Identifier of the specialist responsible for the task
    status_sk INT Identifier of the status in which the task is located
    task* INT Indicates that the record corresponds to a task
    task_closed INT Indicates if the task is closed
    task_closed_current_month INT Indicates whether the task was closed during the current month
    task_closed_current_quarter INT Indicates whether the task was closed during the current quarter
    task_closed_current_week INT Indicates whether the task was closed during the current week
    task_closed_current_year INT Indicates whether the task was closed during the current year
    task_closed_last_year INT Indicates whether the task was closed during the previous year
    task_closed_outside_estimate_date INT Indicates if the task was closed outside of the estimated date
    task_closed_same_month_last_year INT Indicates whether the task was closed during the same month of the previous year
    task_closed_same_quarter_last_year INT Indicates whether the task was closed during the same quarter of the previous year
    task_closed_within_estimate_date INT Indicates whether the task was closed within the estimated date
    task_created_current_month INT Indicates whether the task was created during the current month
    task_created_current_quarter INT Indicates whether the task was created during the current quarter
    task_created_current_week INT Indicates whether the task was created during the current week
    task_created_current_year INT Indicates whether the task was created during the current year
    task_created_last_year INT Indicates whether the task was created during the previous year
    task_created_same_month_last_year INT Indicates whether the task was created during the same month of the previous year
    task_created_same_quarter_last_year INT Indicates whether the task was created during the same quarter of the previous year
    task_open INT Indicates if the task is open
    task_subtype* VARCHAR (8) Task subtype