Contains information about the latest configuration items in the Data WareHouse
Data model
Fields
| Field | Type | Description |
|---|---|---|
| accept_date | DATETIME | Date of acceptance of the company |
| asset_tag | NVARCHAR (400) | CI Inventory Tag ID |
| author_id | INT | Identifier of the author who registered the CI, reference the table AFW_USERS.user_id |
| author_name | NVARCHAR (510) | Author’s Name |
| barcode | NVARCHAR (400) | Barcode |
| brand_id | INT | CI brand identifier, reference table AFW_CATALOG_CODE.code_id |
| brand_name | NVARCHAR (400) | IC Mark |
| category_id | INT | Category identifier, reference table ASMS_MODEL.id |
| category_image | NVARCHAR (MAX) | Category Image Name |
| category_name | NVARCHAR (400) | Category Name |
| 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, reference table ASMS_COST_CENTER.id |
| costcenter_name | NVARCHAR (400) | Cost Center Name |
| 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 | ID of the CI image, reference to table ASMS_FILE. Id |
| id* | INT | Unique ID |
| impact_id | INT | Identifying the impact of CI on the organization, reference the table AFW_CATALOG_CODE.code_id |
| impact_name | NVARCHAR (400) | Impact Description |
| installation_date | DATETIME | Installation Date |
| integration_id | INT | Integration ID, reference table ASMS_INTEGRATIONS.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 | Identifier of the CI location, reference the ASMS_LOCATION.id table |
| manufacturer_id | INT | IC Manufacturer Identifier, reference table ASMS_COMPANY.id |
| manufacturer_name | NVARCHAR (400) | Name of IC Manufacturer |
| model_id | INT | Model ID, reference to table AFW_CATALOG_CODE.code_id |
| model_name | NVARCHAR (400) | Model Name |
| modified_date* | DATETIME | Last Date IC Changed |
| modifier_id | INT | Identifier of the last user who modified the CI, references the AFW_USERS.user_id table |
| modifier_name | NVARCHAR (510) | Name of the last person to modify the IC |
| name* | NVARCHAR (400) | Name of the IC, unique in the table |
| note | NVARCHAR (510) | IC Note |
| 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, reference table ASMS_COMPANY.id |
| provider_name | NVARCHAR (400) | Name of IC Provider |
| reason_id | INT | Identifier of the reason why it is in the current state, reference the table ASMS_STATUS_REASON.reas_id |
| reason_name | NVARCHAR (400) | Name of the reason why you are 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 | CI Owner ID, reference table AFW_USERS.user_id |
| responsible_name | NVARCHAR (400) | Name of the IC officer |
| 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_color | NVARCHAR (400) | Color representation of the IC status in RGB scale Ex: 99.255.10 |
| state_final | INT | Indicates whether the IQ has reached an end state 0 = Open 1 = Closed |
| state_id | INT | CI status identifier, reference table ASMS_STATUS.stat_id |
| state_name | NVARCHAR (400) | Name of the state in which the IC is located |
| type_id | INT | Identifier of the type of the IC. (21 = CI, 48 = Packet), reference the ASMS_TYPES.id table |
| type_name | NVARCHAR (510) | Description of the type of IC |
| unit_id | INT | Identifier of the CI unit of measure, references the AFW_CATALOG_CODE.code_id table. Ex: inches |
| unit_name | NVARCHAR (510) | Name of IC unit of measurement |
| 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_DW_LAST |
|---|
| id |