| author_id |
INT |
Service Author Identifier, reference table AFW_USERS.user_id |
| 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 |
| 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 |
| 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 |
| name |
NVARCHAR (510) |
Service Name |
| ola_id |
INT |
Identifier of the associated default OLA, reference the table ASDK_SLA. SLA_ID |
| 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 |
| reason_id |
INT |
Identifier of the reason associated with the service state, reference to the ASMS_STATUS_REASON.reas_id table |
| responsible_id |
INT |
Identifier of the user who owns the service, references the table AFW_USERS.user_id |
| sla_id |
INT |
Identifier of the associated default SLA, reference the table ASDK_SLA. SLA_ID |
| state_id |
INT |
Service status identifier, reference the ASMS_STATUS.stat_id table |
| type_id |
INT |
Service type identifier, (0 = Internal, 1 = External) |
| uc_id |
INT |
Identifier of the associated default UC, reference the ASDK_SLA table. SLA_ID |
