EN
Español
English
Português
    CMDB_CI

    It contains the information about the configuration items (CIs). Ex: computer, laptop, etc…

    Data model

    Fields

    Field Type Description
    accept_date DATETIME Date of acceptance of the company
    asset_tag NVARCHAR (400) CI Inventory Label Identifier
    author_id INT Identifier of the author who registered the CI
    barcode NVARCHAR (400) Barcode
    brand_id INT IC Brand Identifier
    category_id INT Category identifier
    checkin_date DATETIME Date of registration or entry
    checkout_date DATETIME Departure Date
    closed_date DATETIME Date on which an IC reaches an end state
    costcenter_id INT Cost center ID
    created_date DATETIME IC creation date
    depreciation_method INT Depreciation Method 1 = Indicates that depreciation will be calculated using the straight-line method 2 = Indicates that depreciation will be calculated using the method of summing the digits of the years
    description NVARCHAR (2000) Description of the IC
    file_id INT CI Image Identifier
    group_id INT Group identifier for the IC
    id* INT Unique ID
    impact_id INT Identifier of the impact of the IC on the organization
    installation_date DATETIME Installation Date
    integration_id INT Integration ID
    interface_id NVARCHAR (200) Identifier of the source system associated with the CI, this is given by integration
    license_number NVARCHAR (200) IC License Number
    location_id INT IC Location Identifier
    manufacturer_id INT IC Manufacturer Identifier
    model_id INT Model identifier
    modified_date DATETIME Last Date IC Changed
    modifier_id INT Identifier of the last user who modified the CI
    name* NVARCHAR (400) Name of the IC, unique in the table
    previous_status_id INT Identifier of the last state of the CI before it was closed
    price NUMERIC Price or monetary value of IQ
    provider_id INT CI Provider Identifier
    reason_id INT Identifier of the reason why it is in the current state
    reponsible_date DATETIME Date the user became responsible for the CI
    residual_value NUMERIC Residual value of the IC price relative to its original price
    responsible_id INT Identifier of the CI Leader
    rfid NVARCHAR (400) Radio frequency identifier for IC
    risk_level INT Risk level (1 = Low, 2 = Medium, 3 = High)
    serial NVARCHAR (160) IC serial number
    state_id INT CI Status Identifier
    type_id INT Identifier of the type of the IC. (21 = IC, 48 = Packet)
    unit_id INT IC unit of measurement identifier Ex: inches
    unit_size NVARCHAR (140) IC size value, for example: 17 inches
    useful_life INT Lifetime value of the IC, to calculate depreciation
    version INT Current CI Version Identifier

    Primary Key

    PK_CMDB_CI
    id

    References

    Column Referenced Table Referenced column Name
    author_id dbo.AFW_USERS user_id FK06_CMDB_CI
    category_id dbo.ASMS_MODEL id FK01_CMDB_CI
    file_id Bod. ASMS_FILE id FK12_CMDB_CI
    group_id dbo.AFW_GROUPS grou_id FK13_CMDB_CI
    impact_id Bod. AFW_CATALOG_CODE code_id FK08_CMDB_CI
    integration_id dbo.ASMS_INTEGRATIONS id FK10_CMDB_CI
    location_id dbo.ASMS_LOCATION id FK11_CMDB_CI
    manufacturer_id dbo.ASMS_COMPANY id FK02_CMDB_CI
    modifier_id dbo.AFW_USERS user_id FK05_CMDB_CI
    provider_id dbo.ASMS_COMPANY id FK03_CMDB_CI
    responsible_id dbo.AFW_USERS user_id FK07_CMDB_CI
    state_id dbo.ASMS_STATUS stat_id FK04_CMDB_CI
    type_id dbo.ASMS_TYPES id FK09_CMDB_CI