Case History Dataform
The Case History dataform stores PEO Client Service Case workflow details. This includes historical workflow data such as date/time stamps and the length of time (in minutes) that a case remains in a certain state.
-
The form is a multi-form.
-
The form is Active by default.
-
Can Have Multiple is enabled by default (indicating a one-to-many relationship).
-
Enable Triggering is not enabled.
Access the Case History dataform by opening a Client Service Case and then clicking the Case History link in the Links section of the Action Center.
Note:
-
All fields on the form are "Read Only" as the information displayed on the form is either being retrieved from the Client Service Case record or otherwise calculated by the system.
-
Case History dataforms are not available for cases created prior to ClientSpace version R126 (when this feature was released).
You can use the associated dataform table (gen_CaseHistory) to create Business Intelligence reports based on Case History details.
For instance, you can build a report displaying the following:
-
Average time from case creation to assignment
-
Average time from case creation to resolution
-
Average time cases spend in a particular Status
-
Average time cases spend flagged as a particular Priority (such as High or Critical)
-
Average "first response time"
Case History Record Fields
The Case History record fields are listed in the table below.
Note:
-
Functions to calculate duration states in minutes (Status State Duration, Assigned To State Duration, Priority State Duration, and Case Type State Duration) factor in ClientSpace application settings that define a PEO's business hours, work week parameters, and holidays. The accuracy of the calculations is dependent on these settings being correct.
-
Date Time fields are set using PEO application time zone settings defined in ClientSpace.
Label | Data type |
---|---|
Client Service Case |
Integer (Parent form field linked to associated Client Service Case record) |
Current Record | Bit (Checkbox) |
Create Date | Date Time |
Updated By User |
Integer (User field) |
Case Record State |
Text - Lookup (with values Active and Inactive) |
Status |
Text - Lookup (with values New, Assigned, In Progress, On Hold, Resolved) |
Status State Duration (min) |
Integer |
Status Start Date |
Date Time |
Status End Date |
Date Time |
Assigned To |
Integer |
Assigned To State Duration (min) |
Integer (User field) |
Assigned To Start Date |
Date Time |
Assigned To End Date |
Date Time |
Priority |
Text - Lookup (with values Low, High, Medium, Critical) |
Priority State Duration (min) |
Integer |
Priority Start Date |
Date Time |
Priority End Date |
Date Time |
Case Type |
Integer |
Case Type Duration (min) |
Integer |
Case Type Start Date |
Date Time |
Case Type End Date |
Date Time |
Client Service Case Workflow History Fields
Three fields that support Case History workflow tracking and related calculations are located in the Case Assignment dataset of the Client Service Case dataform:
-
First Response
-
Status Change Date
-
Assigned To Change Date
These fields are set to Read Only by default.
Case History Business Rules and Triggers
Create History Record
The Create History Record business rule uses the SetHistoryRecord business rule method to create or update a new Case History record. The rule is triggered when:
-
A new Client Service Case record is created
OR
-
A Client Service Case record is updated and one or more of the following fields change:
-
Status
-
Assigned To
-
Case Type
-
Priority
-
Active flag
-
Set First Response
The Set First Response business rule uses the SetFirstReponseDateTime business rule method to set the current date and time in the First Response field located on the Client Service Case record. The rule is triggered on a new case when all of the following conditions are True:
-
The First Response field is blank.
-
A first time entry is made to the Comments field.
-
The current user is an internal user.
Case History Workflow Description
Case history is tracked on new and updated Client Service cases using the following workflow:
New Cases
-
When a new Client Service Case is added, a Case History record is created and applicable start date fields (Status Start Date, Priority Start Date, and Case Type Start Date) are set with the current date and time. Other relevant fields, such as Assigned To, Case Type and Priority, are also set.
-
The new Case History record is flagged Current Record.
Updated Cases
-
When a change is made to a field (Status, Assigned To, Case Type, Priority or Active ) on the Client Service Case that triggers additional Case History data collection, the following occurs:
-
The Case History record originally flagged as the Current Record when the Client Service Case was initially added is cloned (i.e., copied).
-
The copied record becomes the historical record. Before it is finalized as the historical record, the updated case fields are used to set the applicable end date fields (Status End Date, Priority End Date, and Case Type End Date) with the current date and time and duration fields (Status State Duration, Assigned To State Duration, Priority State Duration, and Case Type State Duration) are calculated and updated as applicable.
Example: The Assigned To changes from Bob Anderson to Jane Smith. The copied case history record stores the last Assigned To as Bob Anderson. The Assigned To End Date stores the date and time the assignment changed from Bob to Jane. Now, Bob's Assigned To Start Date and Assigned To End Date are used to calculate an Assigned To State Duration in minutes and this calculation is also stored on the historical record.
-
The Start dates on the Current Record (i.e., the "cloned from" record) are set with the current date and time and the current record is updated with the newest values.
Example: Continuing with the previous scenario, the Assigned To is set to Jane Smith. The Assigned To Start Date is set to the date and time that the assignment changed from Bob to Jane. Assigned To End Date and Assigned To State Duration are not set at this time as this is still Jane's current assignment.
Current assignment details always follow the record flagged as Current Record. The Current Record is the first Case History record that is created when a new case is added. All other Case History records are copied from the original case history record and finalized as a historical record each time a key field is updated.
-
-
End date field and duration fields are also set when a Client Service Case is marked Inactive (i.e., Active flag is unchecked) or marked Complete (under Workflow in the Action Center). The Current Record is copied just as described previously and the copied record becomes the historical record.
Note: If the case is marked Active again, the Current Record is copied once again and the Inactive record becomes the historical record while the Current Record is updated as Active.