Contains the detailed information of the latest version of the case in the ASMS suite, within the DataWarehouse environment
Fields
| Field | Type | Description |
|---|---|---|
| applicant_sk | INT | Case requester identifier |
| attention_date | DATETIME2 | Date of first modification with a status behavior of “In process” |
| attention_date_key | INT | Case Care Date Dimension Identifier |
| attention_time | FLOAT | Time in minutes between case creation and first modification with an ‘In Process’ status behavior |
| 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 |
| case* | INT | Indicates that the record corresponds to a case |
| case_onhold | INT | Indicates whether the current status behavior of the case is “On Hold” |
| case_pending | INT | Indicates whether the current state behavior is different from “Fixed,” “Closed,” or “Void” |
| case_pending_unassigned | INT | Indicates if the current status behavior is different from “Fixed”, “Closed”, or “Voided” and has not been assigned to a specialist |
| case_solved | INT | Indicates whether the current status behavior of the case is “Fixed” or “Closed” |
| case_unanswered | INT | Indicates if the case has not received public notes from the assigned specialist |
| category_sk | INT | Case category identifier |
| change | INT | Indicates whether the case corresponds to a change |
| 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 minutes of the default time at the time of saving the case |
| current_time_formatted | VARCHAR (20) | Default time elapsed at the time of saving the case in HH:MM:SS format |
| 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 |
| estimated_time | FLOAT | Estimated time value for the case |
| f_assign_to_resolution_time | FLOAT | Time in minutes between the first assignment of the case to a specialist and the resolution of the case |
| first_assignment_time | FLOAT | Time in minutes the case remained without an assigned specialist |
| first_reply_date | DATETIME2 | Date a specialist was first assigned |
| id* | INT | Case ID |
| id_by_project* | NVARCHAR (512) | Case identifier by project |
| impact_sk | INT | Impact identifier for the case |
| incident | INT | Indicates whether the case corresponds to an incident |
| 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 |
| last_assign_solve_time | FLOAT | Time in minutes between the last assignment of the case to a specialist and the date of resolution of the case |
| 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 |
| new_case | INT | Indicates whether the current status behavior of the case is “New” |
| new_change | INT | Indicates whether the case corresponds to a change and the current state behavior is “New” |
| new_incident | INT | Indicates whether the case corresponds to an incident and the current status behavior is “New”. |
| new_problem | INT | Indicates whether the case corresponds to an issue and the current status behavior is “New” |
| new_requirement | INT | Indicates whether the case corresponds to a requirement and the current status behavior is “New” |
| note_count | FLOAT | Total grades |
| 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 |
| private_note_count | FLOAT | Total Private Notes |
| problem | INT | Indicates whether the case corresponds to a problem |
| profit_center_sk | INT | Revenue center identifier for the case |
| project_sk | INT | Associated project ID |
| provider_sk | INT | Provider identifier for the case |
| public_note_count | FLOAT | Total public notes |
| 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 |
| release | INT | Indicates whether the case corresponds to a release |
| requirement | INT | Indicates whether the case corresponds to a requirement |
| 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_time | FLOAT | Time in minutes between case creation and resolution date |
| solved_current_month | INT | Indicates whether the case was resolved during the current month |
| solved_current_quarter | INT | Indicates whether the case was resolved during the current quarter |
| solved_current_week | INT | Indicates whether the case was resolved during the current week |
| solved_current_year | INT | Indicates whether the case was resolved during the current year |
| solved_last_year | INT | Indicates whether the case was resolved during the previous year |
| solved_multiple_interventions | INT | Indicate if the case was solved with more than one public note |
| solved_non_interventions | INT | Indicate if the case was solved without public notes |
| solved_one_intervention | INT | Indicate if the case was solved with a public note |
| solved_outside_sla | INT | Indicates whether the case was resolved outside the established time, according to the assigned SLA calendar |
| solved_same_month_last_year | INT | Indicates whether the case was resolved during the same month of the previous year |
| solved_same_quarter_last_year | INT | Indicates whether the case was resolved during the same quarter of the previous year |
| solved_within_sla | INT | Indicates whether the case was resolved within the established time, according to the assigned SLA calendar |
| specialist_group_sk | INT | Group identifier for the case |
| specialist_user_sk | INT | Identifier of the specialist responsible for the case |
| specialist_wait_time | FLOAT | Time in minutes the case remained in states with “On Hold” behavior |
| 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 | Case Change Date Dimension ID |
| time | FLOAT | Amount of calendar time between the previous modification and the current modification in minutes |
| time_formatted | VARCHAR (20) | Amount of Calendar Time Between Previous Change and Current Change in HH:MM:SS Format |
| 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 |
| wait_time | FLOAT | Time in minutes that the case remained in states with “New” behavior |