Special Processing in the Calculated Grid Columns

The One View Case Management Inquiry application has numerous calculated columns provided in the grid. These columns aggregate or designate information about each case to facilitate reporting over data that is not available in the database in a form easy to report on. The reports delivered with the application are possible because of these columns. You can also use them when defining custom reports.

The One View Case Management Inquiry application uses the following special processing in these calculated columns in the grid:

• Case Age in Days

  The number of days from today's date and the Begin Date (EFTB) if the case is open, or the number of days from the Ending Date (END) and the Begin Date (EFTB) if the case is closed. The system uses this in the Case Aging report.

• Case Age 0-1 Days

  Depending on the value in the Case Age in Days column, the system uses "1" if the case age falls in this range and "0" if it does not. The system uses this in the Case Aging report.

• Case Age 2-7 Days

  Depending on the value in the Case Age in Days column, the system uses "1" if the case age falls in this range and "0" if it does not. The system uses this in the Case Aging report.

• Case Age 8-30 Days

  Depending on the value in the Case Age in Days column, the system uses "1" if the case age falls in this range and "0" if it does not. The system uses this in the Case Aging report.

• Case Age>30 Days

  Depending on the value in the Case Age in Days column, the system uses "1" if the case age falls in this range and "0" if it does not. The system uses this in the Case Aging report.

• Case Record Type

  Cases are open, cancelled, or closed based on the values that you set in the processing options. Open cases are those that are neither closed nor cancelled. The system uses this in all five reports.

• Case Days Completed

  This is applicable only when the value of the Case Record Type = Closed. This is the number of days of Ending Date (END) minus Commit Date (CDATE). The system uses this in the Case Commitment Results report.

• Case Commitment Met

  This is applicable only when the value of the Case Record Type = Closed. If the value of the Case Days Completed is "0" or is a negative value, the case was closed early or on-time and the system indicates this with a value of "1". Else, the system uses "0" to indicate that the case was closed late. The system uses this in the Case Commitment Results report.

• Case Commitment Up To 1 Month Late

  This is applicable only when the value of the Case Record Type = Closed. If the value of the Case Days Completed is 1 through 30, the case was closed late by a month or less than a month and the system indicates this with a value of "1". Else, the system uses "0" to indicate that the case was closed after a month. The system uses this in the Case Commitment Results report.

• Case Commitment >1 Month Late

  This is applicable only when the value of the Case Record Type = Closed. If the value of the Case Days Completed is greater than "30", the case was closed late by more than a month and the system indicates this with a value of "1". Else, the system uses "0" to indicate that the case was closed within a month. The system uses this in the Case Commitment Results report.

• Case Timeliness N/A

  This is applicable for cases that fulfil any of the conditions below:

  • Case is not closed (based on the value in the Case Record Type).

  • Case has blank Ending Date (END) and blank Commit Date (CDATE) values.

  • Case has blank Ending Date (END) or blank Commit Date (CDATE) values.

  The system assigns "1" to cases that meet any of these conditions. Else, the system assigns "0". The system uses this in the Case Commitment Results report.

• Entitled Case

  This is applicable for both open and closed cases and indicates if a case is entitled. If the value in the Entitlement Check (ENTCK) field is equal to 1, 2, 3, or 4, the system assigns "1" in this column to indicate that the case is entitled. Else, the system assigns "0" to indicate that it is not. The system uses this in the Case Statistics report.

• Escalated Case

  This is applicable for both open and closed cases and indicates if a case has been escalated. If the value in either the ESC1 or the ESC2 field is greater than 1, the system assigns "1" in this column to indicate that the case has been escalated. Else, the system assigns "0" to indicate that it has not been escalated. The system uses this in the Case Statistics report.

• Overdue Case

  This indicates if a case is overdue. For open cases, if today's date is greater than the Commit Date (CDATE), the system assigns "1" in this column to indicate that the case is overdue. For closed cases, if the Ending Date (END) field is greater than the value in the Commit Date (CDATE) field, the system assigns "1" to indicate that the case is overdue. If a case is not overdue, the system assigns "0" in this column. The system uses this in the Overdue Open Cases report.

• Days Overdue

  This is applicable for overdue cases and indicates the number of days overdue. For open cases that are overdue (based on the value in the Overdue Case field), the system subtracts the Commit Date (CDATE) from today's date and assigns the difference in this column. For closed cases, the system subtracts the Commit Date (CDATE) from the Ending date (END) and assigns the difference in this column. If a case is not overdue, the system assigns "0" in this column. The system uses this in the Overdue Open Cases report.

• Incoming Case Period

  This indicates the period (P1 through P13) that the case falls in based on the Begin Date (EFTB) and today's date. A case may not fall in any of the 13 periods if the case begin date is either before Period 1 or after Period 13. You define period as days, weeks, or months in the header. The system uses this in the Case Load report.

• Incoming Load Period (1-13, a column for each period)

  The values in the columns from 1-13 indicate if the case falls in that period. The system assigns "1" in a column to indicate that the case falls in that period and "0" to indicate that it does not. The system uses these in the Case Load report.

• Committed Case Period

  This indicates the period that the case falls in based on the Commit Date (CDATE) and today's date (values are P1 - P13) fields. A case may not fall in any of the 13 periods if the case commit date is either before Period 1 or after Period 13. You define period as days, weeks, or months in the header. The system uses this in the Case Load report.

• Committed Load Period (1-13, a column for each period)

  The values in the columns from 1-13 indicate if the case falls in that period. The system assigns "1" in a column to indicate that the case falls in that period and a value of "0" to indicate that it does not. The system uses these in the Case Load report.

• Closed Case Period

  This indicates the period that the case falls in based on the Ending Date (END) and today's date (values are P1 - P13) fields. A case may not fall in any of the 13 periods if the case commit date is either before Period 1 or after Period 13. You define period as days, weeks, or months in the header. The system uses this in the Case Load report.

• Closed Load Period (1-13, a column for each period)

  The values in the columns from 1-13 indicate if the case falls in that period. A value of "1" in a column indicates that the case falls in that period and a value of "0" indicates that it does not. The system uses these in the Case Load report.

• Status Type of Selected Cases

  The system uses the value in this column internally in all five reports to know which header check boxes are selected. The value is the same for all cases.

• Period Type to Analyze

  The system uses the value in this column internally in the Case Load report to know which period type (days, weeks, or months) to use to analyze data. The value is the same for all cases.