Enumeration Parameters

Enumeration parameters map to fields that have a set list of possible values. When running a report with a enumeration parameter, P6 will offer a list to select one of the values. Users will see the localized text for the enumeration value's description; however, the return value will be the English description of the enumeration, which is the value the PX Views database stores.

This section contains the following information for each supported enumeration parameter:

Identifier: The value you must enter in the identifier field in BI Publisher when creating the parameter for the report.
Details: A description and technical details of the parameter.
Values: The values that will be available in P6.
Maps to field: The database field the return value maps to in the PX Views database. It could match multiple fields in the database, so only the primary table is listed.
Use case: An example of how you might use the parameter in a report.
The following enumeration parameters are supported:

Parameter: Activity Priority

Identifier: p_activity_priority
Details: Allows users to select the leveling priority of an activity.
Values: Top, High, Normal, Low, Lowest
Maps to field: ACTIVITY.LEVELINGPRIORITY
Use case: Filter activity data by leveling priority.

Parameter: Assignment Proficiency

Identifier: p_assignment_proficiency
Details: Allows users to select a value for assignment proficiency.
Values: Master, Expert, Skilled, Proficient, Inexperienced
Maps to field: RESOURCEASSIGNMENT.PROFICIENCY
Use case: Filter resource assignment data by the proficiency of the assignment.

Parameter: Activity Status

Identifier: p_activity_status
Details: Allows users to select activity status.
Values: Not Started, In Progress, Completed
Maps to field: ACTIVITY.STATUS
Use case: Filter activity reports based on a certain status.

Parameter: Activity Type

Identifier: p_activity_type
Details: Allows users to select the activity type.
Values: Task Dependent, Resource Dependent, Level of Effort, Start Milestone, Finish Milestone, WBS Summary
Maps to field: ACTIVITY.TYPE
Use case: Filter activity reports based on the type of the activity.

Parameter: Constraint Type

Identifier: p_contstraint_type
Details: Allows users to select an activity constraint type.
Values: Start On, Start On or Before, Start On or After, Finish On, Finish On or Before, Finish On or After, As Late As Possible, Mandatory Start, Mandatory Finish
Maps to field: ACTIVITY.PRIMARYCONSTRAINTTYPE and ACTIVITY.SECONDARYCONSTRAINTTYPE
Use case: Filter activities in a report by the activity primary or secondary constraint type.

Parameter: Duration Type

Identifier: p_duration_type
Details: Allows users to select the duration types of an activity.
Values: Fixed Units/Time, Fixed Duration & Units/Time, Fixed Units, Fixed Duration & Units
Maps to field: ACTIVITY.DURATIONTYPE
Use case: Filter activities in a report based on their duration type.

Parameter: Percent Complete Type

Identifier: p_percent_complete_type
Details: Allows users to select the percent complete type of an activity.
Values: Physical, Duration, Units
Maps to field: ACTIVITY.PERCENTCOMPLETETYPE
Use case: Filter activities in a report based on the percent complete type of the activity.

Parameter: Project Status

Identifier: p_project_status
Details: Allows users to select the status of a project.
Values: Planned, Active, Inactive, What If, Requested, Template
Maps to field: PROJECT.STATUS
Use case: Filter the projects in a report based on the desired type. For example, you might want to use this for a report that needs to display information only on planned projects.

Parameter: Rate Source

Identifier: p_rate_source
Details: Allows users to select the rate source of an assignment.
Values: Resource, Role, Override
Maps to field: RESOURCEASSIGNMENT.RATESOURCE
Use case: Filter resource assignments included in a report based on the rate source of the assignment.

Parameter: Rate Type

Identifier: p_rate_type
Details: Allows users to select the rate type of an assignment.
Values: Price/Unit, Price/Unit 2, Price/Unit 3, Price/Unit 4, Price/Unit 5
Maps to field: RESOURCEASSIGNMENT.RATETYPE
Use case: Filter resource assignments included in a report based on the rate type of the assignment.

Parameter: Resource Type

Identifier: p_resource_type
Details: Allows users to select the resource type of an assignment.
Values: Labor, Nonlabor, Material
Maps to field: RESOURCEASSIGNMENT.RESOURCETYPE
Use case: Filter resource assignments included in a report based on the resource type of the assignment.

Parameter: Risk Status

Identifier: p_risk_status
Details: Allows users to select the status of a risk.
Values: Proposed, Open, Active, Rejected (Closed), Managed (Closed), Impacted (Closed)
Maps to field: RISK.RISKSTATUS
Use case: Filter risks in a report based on the status of the risk.

Parameter: Risk Type

Identifier: p_risk_type
Details: Allows users to select the type of a risk.
Values: Threat, Opportunity
Maps to field: RISK.RISKTYPE
Use case: Filter risks in a report based on the type of risk.