| applicant_id |
INT |
Case requester ID, reference table AFW_USERS.user_id |
| author_email |
NVARCHAR (510) |
Email of the user who created the case |
| author_id* |
INT |
Identifier of the user who created the case, references the table AFW_USERS.user_id |
| 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 identifier, reference table ASMS_CALENDAR. CALENDAR_ID |
| calendar_sla_id |
INT |
SLA calendar identifier, reference the ASMS_CALENDAR table. CALENDAR_ID |
| calendar_uc_id |
INT |
UC calendar identifier, reference table ASMS_CALENDAR. CALENDAR_ID |
| category_id |
INT |
Case category identifier, reference table ASDK_CATEGORY.ctg_index |
| cause |
NVARCHAR (MAX) |
Case Cause |
| cause_nohtml |
NVARCHAR (MAX) |
Case Cause Without HTML Elements |
| ci_id |
INT |
Identifier of the configuration element (CI) associated with the case, references the CMDB_CI.id table |
| 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, reference table ASMS_COMPANY. Id |
| cost |
FLOAT |
Case Cost Value |
| cost_center_id |
INT |
Cost center identifier for the case, reference to table ASMS_COST_CENTER.id |
| cost_model_id |
INT |
Cost model identifier for the case, reference to table ASDK_MODEL_COST_PRICE.mod_id |
| created_date |
DATETIME |
Date the case was created |
| customer_id |
INT |
Client ID assigned to the case, reference the AFW_USERS.user_id table |
| 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 ID for the case, reference the table AFW_GROUPS.grou_id |
| id* |
INT |
Unique Case Identifier |
| id_by_project* |
NVARCHAR (512) |
Case identifier by project |
| impact_id |
INT |
Impact identifier for the case, reference table AFW_CATALOG_CODE.code_id |
| income_center_id |
INT |
Revenue center ID for the case, reference to ASMS_COST_CENTER.id table |
| integration_id |
INT |
Identifier of the external system to which the case belongs, references the ASMS_INTEGRATIONS.id table |
| 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, reference to the ASMS_LOCATION table. Id |
| model_id |
INT |
Model ID for the case, reference to the ASMS_MODEL.id table |
| modified_date |
DATETIME |
Date Case Changed |
| ola_id |
INT |
OLA identifier for the case, reference to table ASDK_SLA. SLA_ID |
| opened_date* |
DATETIME |
Date on which the case is opened |
| previous_status_id |
INT |
Previous case status identifier, refer table ASMS_STATUS.stat_id |
| price |
FLOAT |
Case Price Value |
| priority_id |
INT |
Case priority identifier, reference table AFW_CATALOG_CODE.code_id |
| project_id* |
INT |
Associated project ID, reference table ASMS_PROJECTS.proj_id |
| provider_id |
INT |
Supplier identifier for the case, reference to table ASMS_COMPANY. Id |
| reason_id |
INT |
Case reason identifier, reference table ASMS_STATUS_REASON.reas_id |
| receptor_id |
INT |
Identifier of the first specialist assigned to the case, reference the table AFW_USERS.user_id |
| registry_type_id |
INT |
Record type identifier for the case, reference the AFW_CATALOG_CODE.code_id table |
| responsible_id |
INT |
Identifier of the specialist responsible for the case, reference the table AFW_USERS.user_id |
| rev |
INT |
Consecutive number of the current case review |
| service_id |
INT |
Service ID for the case, reference the ASDK_SERVICE.id table |
| sla_id |
INT |
SLA identifier for the case, reference to table ASDK_SLA. SLA_ID |
| state_id* |
INT |
Status ID for the case, reference the ASMS_STATUS.stat_id table |
| subject |
NVARCHAR (800) |
Describe the subject of the case |
| survey_token |
NVARCHAR (200) |
Associated survey ID |
| type_id* |
INT |
Case type identifier, reference table ASMS_TYPES.id |
| uc_id |
INT |
UC ID for the case, reference to table ASDK_SLA. SLA_ID |
| unit_id |
INT |
Identifier of the internal area associated with the case, reference the table AFW_GROUPS.grou_id |
| urgency_id |
INT |
Case urgency identifier, reference table AFW_CATALOG_CODE.code_id |
