EN
Español
English
Português
    ASDK_ITEM

    Contains case information in the ASMS suite

    Data model

    Fields

    Field Type Description
    applicant_id INT Case requester identifier
    author_email NVARCHAR (510) Email of the user who created the case
    author_id* INT Identifier of the user who created the case
    available_cost BIT Indicates that the case has an available cost quota
    available_count BIT Indicates that the case has an available count quota
    available_effort BIT Indicates that the case has an available effort quota
    available_price BIT Indicates that the case has an available price quota
    calendar_ola_id INT OLA calendar ID
    calendar_sla_id INT SLA calendar identifier
    calendar_uc_id INT UC Calendar ID
    category_id INT Case category identifier
    cause NVARCHAR (MAX) Case Cause
    cause_nohtml NVARCHAR (MAX) Case Cause Without HTML Elements
    ci_id INT Configuration Item (CI) ID associated with the case
    closed_date DATETIME Date the case was closed
    commentary NVARCHAR (MAX) Case Solution
    commentary_nohtml NVARCHAR (MAX) Case solution without HTML elements
    company_id INT Company identifier for the case
    cost FLOAT Case Cost Value
    cost_center_id INT Cost center ID for the case
    cost_model_id INT Cost model identifier for the case
    created_date DATETIME Date the case was created
    customer_id INT Client ID assigned to the case
    description* NVARCHAR (MAX) Case description
    description_nohtml NVARCHAR (MAX) Description of the case without HTML elements
    effort FLOAT Recorded effort to attend to the case
    group_id INT Group identifier for the case
    id* INT Unique Case Identifier
    id_by_project* NVARCHAR (512) Case identifier by project
    impact_id INT Impact identifier for the case
    income_center_id INT Revenue center identifier for the case
    integration_id INT Identifier of the external system to which the case belongs
    interface_id NVARCHAR (200) Identifier of the source system associated with the case, this is given by integration
    location_id INT Identifier of the associated location
    model_id INT Model identifier for the case
    modified_date DATETIME Date Case Changed
    ola_id INT OLA identifier for the case
    opened_date* DATETIME Date on which the case is opened
    previous_status_id INT Previous case status identifier
    price FLOAT Case Price Value
    priority_id INT Case priority identifier
    project_id* INT Associated project ID
    provider_id INT Provider identifier for the case
    reason_id INT Case Reason Identifier
    receptor_id INT Identifier of the first specialist assigned to the case
    registry_type_id INT Record type identifier for the case
    responsible_id INT Identifier of the specialist responsible for the case
    rev INT Consecutive number of the current case review
    service_id INT Service ID for the case
    sla_id INT SLA identifier for the case
    state_id* INT State ID for the case
    subject NVARCHAR (800) Describe the subject of the case
    survey_token NVARCHAR (200) Associated survey ID
    type_id* INT Case Type Identifier
    uc_id INT UC identifier for the case
    unit_id INT Identifier of the internal area associated with the case
    urgency_id INT Case Urgency Identifier

    Primary Key

    PK_ASDK_ITEM
    id

    References

    Column Referenced Table Referenced column Name
    applicant_id dbo.AFW_USERS user_id FK33_ASDK_ITEM
    author_id* dbo.AFW_USERS user_id FK22_ASDK_ITEM
    calendar_ola_id dbo.ASMS_CALENDAR calendar_id FK28_ASDK_ITEM
    calendar_sla_id dbo.ASMS_CALENDAR calendar_id FK02_ASDK_ITEM
    calendar_uc_id dbo.ASMS_CALENDAR calendar_id FK27_ASDK_ITEM
    category_id dbo.ASDK_CATEGORY ctg_index FK11_ASDK_ITEM
    ci_id dbo.CMDB_CI_DW_LAST id FK19_ASDK_ITEM
    company_id dbo.ASMS_COMPANY id FK09_ASDK_ITEM
    contract_id dbo.ASMS_CONTRACT contractid FK32_ASDK_ITEM
    cost_center_id dbo.ASMS_COST_CENTER id FK30_ASDK_ITEM
    cost_model_id dbo.ASDK_MODEL_COST_PRICE mod_id FK25_ASDK_ITEM
    customer_id dbo.AFW_USERS user_id FK21_ASDK_ITEM
    group_id dbo.AFW_GROUPS grou_id FK03_ASDK_ITEM
    impact_id dbo.AFW_CATALOG_CODE code_id FK12_ASDK_ITEM
    income_center_id dbo.ASMS_COST_CENTER id FK26_ASDK_ITEM
    location_id dbo.ASMS_LOCATION id FK31_ASDK_ITEM
    model_id dbo.ASMS_MODEL id FK05_ASDK_ITEM
    modifier_id dbo.AFW_USERS user_id FK23_ASDK_ITEM
    ola_id dbo.ASDK_SLA sla_id FK17_ASDK_ITEM
    priority_id dbo.AFW_CATALOG_CODE code_id FK13_ASDK_ITEM
    project_id* dbo.ASMS_PROJECTS proj_id FK06_ASDK_ITEM
    provider_id dbo.ASMS_COMPANY id FK10_ASDK_ITEM
    reason_id dbo.ASMS_STATUS_REASON reas_id FK08_ASDK_ITEM
    receptor_id dbo.AFW_USERS user_id FK24_ASDK_ITEM
    registry_type_id dbo.AFW_CATALOG_CODE code_id FK29_ASDK_ITEM
    responsible_id dbo.AFW_USERS user_id FK20_ASDK_ITEM
    service_id dbo.ASDK_SERVICE id FK14_ASDK_ITEM
    sla_id dbo.ASDK_SLA sla_id FK15_ASDK_ITEM
    state_id* dbo.ASMS_STATUS stat_id FK07_ASDK_ITEM
    type_id* dbo.ASMS_TYPES id FK01_ASDK_ITEM
    uc_id dbo.ASDK_SLA sla_id FK16_ASDK_ITEM
    unit_id dbo.AFW_GROUPS grou_id FK04_ASDK_ITEM
    urgency_id dbo.AFW_CATALOG_CODE code_id FK18_ASDK_ITEM