Contains the latest information for ASMS suite service management - DataWareHouse
Data model
Fields
| Field | Type | Description |
|---|---|---|
| author_id | INT | Service Author Identifier, reference table AFW_USERS.user_id |
| author_name | NVARCHAR (510) | Service Author Name |
| closed_date | DATETIME | Service Closing Date |
| cost_center_id | INT | Associated cost center ID, reference table ASMS_COST_CENTER.id |
| description | NVARCHAR (8000) | Description of the service |
| group_id | INT | Identifier of the associated default group, reference the table AFW_GROUPS.grou_id |
| group_name | NVARCHAR (510) | Descriptive Group Name |
| id* | INT | Unique Service Identifier |
| image_id | INT | Identifier of the associated image |
| image_name | NVARCHAR (MAX) | Friendly name of the service image |
| impact_id | INT | Identifier of the associated impact, reference the table AFW_CATALOG_CODE.code_id |
| impact_name | NVARCHAR (510) | Descriptive name of the impact |
| income_center_id | INT | Associated revenue center ID, reference table ASMS_COST_CENTER.id |
| modified_date* | DATETIME | Date of modification of the service |
| modifier_id | INT | Identifier of the user who modified the service, references the table AFW_USERS.user_id |
| modifier_name | NVARCHAR (510) | Name of the user modifying the service |
| name | NVARCHAR (510) | Service Name |
| note | NVARCHAR (510) | Note associated with the service |
| ola_id | INT | Identifier of the associated default OLA, reference the table ASDK_SLA. SLA_ID |
| ola_name | NVARCHAR (510) | Default OLA Name |
| opened_date | DATETIME | Service Registration Date |
| previous_state_id | INT | Associated previous state identifier, reference table ASMS_STATUS.stat_id |
| project_id | INT | Associated project ID, reference table ASMS_PROJECTS.proj_id |
| project_name | NVARCHAR (510) | Descriptive name of the associated project |
| reason_id | INT | Identifier of the reason associated with the service state, reference to the ASMS_STATUS_REASON.reas_id table |
| reason_name | NVARCHAR (510) | Descriptive name of the reason |
| responsible_id | INT | Identifier of the user who owns the service, references the table AFW_USERS.user_id |
| responsible_name | NVARCHAR (510) | Name of the user who owns the service |
| sla_id | INT | Identifier of the associated default SLA, reference the table ASDK_SLA. SLA_ID |
| sla_name | NVARCHAR (510) | Default SLA Name |
| stage_id | INT | Service Lifecycle Stage Identifier |
| stage_name | NVARCHAR (510) | Descriptive name of the service lifecycle stage |
| state_final | INT | Identify whether the status is final or not. (1 = End) |
| state_id | INT | Service status identifier, reference the ASMS_STATUS.stat_id table |
| state_name | NVARCHAR (510) | State Friendly Name |
| type_id | INT | Service type identifier, (0 = Internal, 1 = External) |
| type_name | NVARCHAR (510) | Descriptive name of the type of service, Internal - External |
| uc_id | INT | Identifier of the associated default UC, reference the ASDK_SLA table. SLA_ID |
| uc_name | NVARCHAR (510) | Default UC Name |
Primary Key
| PK_ASDK_SERVICE_DW_LAST |
|---|
| id |