Contains detailed information about the versions of the cases registered in the ASMS suite, within the DataWarehouse environment
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 |
| case* | INT | Indicates that the record corresponds to a case |
| case_reopened | INT | Indicates whether the case was resolved and subsequently reopened by moving to a status other than “Closed” |
| case_resolved | INT | Indicates whether the case status behavior is “Fixed”, considering only transitions from a different state |
| 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 |
| 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 | Cumulative effort recorded to attend to the case |
| current_price | FLOAT | Case Price Value |
| 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 |
| customer_user_sk | INT | Client ID assigned to the case |
| date_sk* | INT | Case Change Date Dimension ID |
| estimated_date | DATETIME | Estimated date for the default case timer |
| 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 |
| 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_case_current_month | INT | Indicates whether the case was created during the current month and has gone through a “New” status behavior |
| new_case_current_quarter | INT | Indicates whether the case was created during the current quarter and has gone through a “New” status behavior |
| new_case_current_week | INT | Indicates whether the case was created during the current week and has gone through a “New” status behavior |
| new_case_current_year | INT | Indicates whether the case was created during the current year and has gone through a “New” status behavior |
| new_case_last_year | INT | Indicates whether the case was created during the previous year and has gone through a “New” status behavior |
| new_case_same_month_last_year | INT | Indicates whether the case was created during the same month of the previous year and whether it has gone through a status of “New” behavior |
| new_case_same_quarter_last_year | INT | Indicates whether the case was created during the same quarter of the previous year and whether it has gone through a status of “New” behavior |
| 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 |
| 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 |
| 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 |
| specialist_group_sk | INT | Group identifier for the case |
| specialist_reassigned | INT | Indicates whether the case has been reassigned from one specialist to another |
| 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 | Identifier of the state in which the case is located |
| time | FLOAT | Amount of calendar time between the previous modification and the current modification in minutes |
| 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 |