QueryPersonnelActual (IProductionReport)

Performs a query against the runtime database for personnel actuals associated with a given segment response based on the selected input parameters. All personnel actuals that match the specified query criteria are returned.

In the Configure Method dialog box, click Next to select query criteria to include as input parameters on the activity configuration panel.

Note: If you do not select any query criteria as input parameters, your query returns all personnel actuals.

Criteria	Data Type	Description
Actual Personnel	DirectoryResource	Specifies a resource to include in your query. Only actuals associated with that resource are returned by the query. You can specify a person (that is, a people resource) or a personnel class. In the Inputs section of the activity configuration panel, click the ellipsis button to open the Universal Browser to select the resource you want to use.
End Time	DateTime	Specifies the utilization end date and time, in UTC, for the actual. As part of defining this parameter, you must also select the Criteria Type as either Not Set (to indicate an unspecified (that is, null) value) or Range (to indicate any value between and including two specified values). If you select Range as the criteria type, two fields are displayed in the Inputs section of the activity configuration panel: End Time (Min), to designate the beginning of the range, and End Time (Max), to designate the end of the range. Click the drop-down arrows within the fields to open the calendar, where you can select the date and specify the time. Only actuals with end times within the specified range are returned by the query.
StartTime	DateTime	Specifies the utilization start date and time, in UTC, for the actual. As part of defining this parameter, you must also select the Criteria Type as either Not Set (to indicate an unspecified (that is, null) value) or Range (to indicate any value between and including two specified values). If you select Range as the criteria type, two fields are displayed in the Inputs section of the activity configuration panel: Start Time (Max), to designate the end of the range, and Start Time (Min), to designate the beginning of the range. Click the drop-down arrows within the fields to open the calendar, where you can select the date and specify the time. Only actuals with start times within the specified range are returned by the query.
Segment Id	GUID	Specifies a unique identifier for the segment response to include in your query. Only actuals associated with that segment response are returned by the query.
Use	String	Specifies the purpose for the actual resource to include in your query. The purpose you enter in this field is based on the resource actual uses defined by your business.

Outputs	Description
PersonnelActualAttributes[]		Returns all of the actuals that match the query parameters. Use a For Each Activity to loop though all resources or use an Index Activity with an integer value. Indexing is supported only by the integer value; it does not support string values.

Outputs

Description

PersonnelActualAttributes[]

Returns all of the actuals that match the query parameters.

Use a For Each Activity to loop though all resources or use an Index Activity with an integer value. Indexing is supported only by the integer value; it does not support string values.