EN
Español
English
Português
    ASDK_SERVICE

    Contains the information for the ASMS suite service management

    Data model

    Fields

    Field Type Description
    author_id INT Service Author Identifier
    closed_date DATETIME Service Closing Date
    cost_center_id INT Associated cost center identifier
    description NVARCHAR (8000) Description of the service
    group_id INT Identifier of the associated default group
    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
    income_center_id INT Associated revenue center identifier
    modified_date DATETIME Date of modification of the service
    modifier_id INT Identifier of the user who modified the service
    name NVARCHAR (510) Service Name
    ola_id INT Identifier of the associated default OLA
    opened_date DATETIME Service Registration Date
    previous_state_id INT Associated Previous Status Identifier
    project_id INT Associated project ID
    reason_id INT Identifier of the reason associated with the service status
    responsible_id INT Identifier of the user who owns the service
    sla_id INT Associated default SLA identifier
    state_id INT Service Status Identifier
    type_id INT Service type identifier, (0 = Internal, 1 = External)
    uc_id INT Identifier of the associated default UC

    Primary Key

    PK_ASDK_SERVICE
    id

    References

    Column Referenced Table Referenced column Name
    author_id dbo.AFW_USERS user_id FK08_ASDK_SERVICE
    group_id dbo.AFW_GROUPS grou_id FK03_ASDK_SERVICE
    impact_id Bod. AFW_CATALOG_CODE code_id FK02_ASDK_SERVICE
    ola_id dbo.ASDK_SLA sla_id FK11_ASDK_SERVICE
    project_id dbo.ASMS_PROJECTS proj_id FK06_ASDK_SERVICE
    responsible_id dbo.AFW_USERS user_id FK01_ASDK_SERVICE
    sla_id dbo.ASDK_SLA sla_id FK09_ASDK_SERVICE
    state_id dbo.ASMS_STATUS stat_id FK07_ASDK_SERVICE
    uc_id dbo.ASDK_SLA sla_id FK10_ASDK_SERVICE