Cases
The Cases table.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier |
| Name | String | False |
The short description of the bug |
| Date_Entered | Datetime | True |
Date record created |
| Date_Modified | Datetime | True |
Date record last modified |
| Modified_User_Id | String | True |
User who last modified record |
| Modified_By_Name | String | True | |
| Created_By | String | True |
User who created record |
| Created_By_Name | String | True | |
| Description | String | False |
Full text of the note |
| Deleted | Bool | False |
Record deletion indicator |
| Case_Number | Int | False |
Visual unique identifier |
| Type | String | False |
The type of issue (ex: issue, feature) |
| Status | String | False |
The status of the case |
| Priority | String | False |
The priority of the case |
| Resolution | String | False |
The resolution of the case |
| Work_Log | String | False |
Free-form text used to denote activities of interest |
| Follow_Up_Datetime | Datetime | False |
Deadline for following up on an issue |
| Widget_Follow_Up_Datetime | String | True | |
| Resolved_Datetime | Datetime | False |
Date when an issue is resolved |
| Hours_To_Resolution | Decimal | True |
How long it took to resolve this issue, in decimal calendar hours |
| Business_Hours_To_Resolution | Decimal | True |
How long it took to resolve this issue, in decimal business hours |
| Pending_Processing | Bool | True | |
| Account_Name | String | False |
The name of the account represented by the account_id field |
| Account_Id | String | False |
The account to which the case is associated |
| Service_Level | String | True |
Service level of the associated account of case |
| Business_Center_Name | String | True |
The name of the business center represented by the business_center_id field |
| Business_Center_Id | String | False |
The business center to which the case is associated |
| Source | String | False |
An indicator of how the case was entered (ex: via web, email, etc.) |
| Request_Close | Bool | True |
The request close status of the case |
| Request_Close_Date | Datetime | True |
The date/time that the request close was initiated |
| Portal_Viewable | Bool | False | |
| Widget_Status | String | True | |
| Primary_Contact_Name | String | True | |
| Primary_Contact_Id | String | False | |
| Attachment_List | String | True | |
| Action_Claim | String | True | |
| Action_Close | String | True | |
| Action_Unassign | String | True | |
| Following | Bool | False |
Is user following this record |
| My_Favorite | Bool | False |
Favorite for the user |
| Tag | String | False | |
| Commentlog | String | True | |
| Locked_Fields | String | True | |
| Sync_Key | String | True | |
| Assigned_User_Id | String | False |
User ID assigned to record |
| Assigned_User_Name | String | True | |
| Team_Id | String | False |
Team ID for the account |
| Team_Set_Id | String | False | |
| Acl_Team_Set_Id | String | False | |
| Team_Count | String | False | |
| Team_Name | String | False | |
| Acl_Team_Names | String | True | |
| Source_Id | String | False | |
| Source_Type | String | False | |
| Source_Meta | String | False | |
| First_Response_Target_Datetime | Datetime | True | |
| First_Response_Actual_Datetime | Datetime | True | |
| Hours_To_First_Response | Decimal | True | |
| Business_Hrs_To_First_Response | Decimal | True | |
| First_Response_Var_From_Target | Decimal | True | |
| First_Response_Sla_Met | String | False | |
| First_Response_User_Id | String | False | |
| First_Response_User_Name | String | True | |
| First_Response_Sent | Bool | False | |
| Is_Escalated | Bool | True |
Is this escalated? |
| Dri_Workflow_Template_Id | String | False | |
| Dri_Workflow_Template_Name | String | True | |
| Perform_Sugar_Action | Bool | False | |
| Denorm_Account_Name | String | False |
Name of the Company |