Learn about derived fields in Workbench and customizing them for reporting.
About Derived Fields
Derived fields are standardized definitions in Workbench to simplify filtering for Cases in reports (including aggregate reports) and displaying fields. Workbench provisions standardized definitions of derived fields. To customize derived fields according to your business needs, contact your Veeva Representative.
Standardized Derived Fields
The following table describes some standard derived fields and the Workbench aggregate report in which they are applied:
| Derived Field | Definition | Workbench Aggregate Report |
|---|---|---|
| Case Category | Cases can be categorized as one (1) of the following:
|
|
| Case Completed | This field simplifies Case lifecycle states to determine whether a Case is closed and can be included in certain reports, or open and should not be included in reports. Vault uses the following criteria to determine a Case lifecycle state:
Note: Depending on report criteria, voided and nullified Cases may be automatically excluded. |
|
| Masking | Vault determines whether the Case data is eligible for masked, unmasked, or both reports using the following criteria:
|
|
| Receipt/New Info Date | This field provides the following mapping logic:
|
|