Crystal User Productivity
A reporting stored procedure used for the following report(s): User Productivity. These reports can be found in the User Reports category. The stored procedure uses the following table(s) to gather its data set: UserProductivity_viw, Individual.
| Column | Parameter Direction | Data Type (Size) | Description |
|---|---|---|---|
| @WhereClause | INPUT | nvarchar (MAX) | Filters the data set based on the selected filtering options. |
| @OrderClause | INPUT | nvarchar (2048) | Orders the data set based on the selected ordering options. |
| Column | Parameter Direction | Data Type (Size) | Description |
|---|---|---|---|
| i_WhereClause | INPUT | nvarchar2 | Filters the data set based on the selected filtering options. |
| i_OrderClause | INPUT | varchar2 | Orders the data set based on the selected ordering options. |
| o_prc | OUTPUT | sys_refcursor |