// Example of columns available in PV_CHANGE_REQUEST_WORK_ITEM
{
"workitem_id": "Composite identifier (activity_instance_id:activity_instance_database:workflow_instance_iteration)",
"workflow_instance_name": "Name of the workflow step (e.g., Supervisor Approval)",
"complete_by": "User ID responsible for completion (-1 for system)",
"category_name": "Category of the work item",
"change_request_id": "Foreign Key referencing CHANGE_REQUESTS.ID",
"job_reference": "Reference identifier for the job",
"activity_instance_id": "ID of the activity instance in the workflow engine",
"activity_instance_database": "Database identifier (e.g., WPDS)",
"workflow_instance_iteration": "Iteration number of the workflow instance",
"process_instance_id": "ID of the associated process instance",
"name": "Display name of the work item",
"work_state": "Current state (e.g., Completed, Canceled)",
"job_state_id": "Numeric identifier for the job state",
"planned_time": "Planned completion time in seconds",
"duration_type": "Type of duration measurement",
"accumulated_time": "Time accumulated in seconds",
"available_date": "Date/time the work item became available",
"open_date": "Date/time the work item was opened",
"first_open_date": "First date/time the work item was opened",
"complete_date": "Date/time the work item was completed",
"last_modified_user_id": "User ID who last modified the record (-1 for system)",
"last_modified_date": "Date/time of the last modification",
"completion_code": "Numeric completion code",
"due_date": "Date/time the work item is due",
"in_queue_time_value": "Queue time as fractional days",
"in_queue_time_hours": "Queue time in whole hours",
"in_queue_time_days": "Queue time in whole days",
"in_queue_time_text": "Human-readable queue time",
"open_time_value": "Open time as fractional days",
"open_time_hours": "Open time in whole hours",
"open_time_days": "Open time in whole days",
"open_time_text": "Human-readable open time",
"total_time_value": "Total elapsed time (available to complete) as fractional days",
"total_time_hours": "Total elapsed time in whole hours",
"total_time_days": "Total elapsed time in whole days",
"total_time_text": "Human-readable total elapsed time",
"overdue_time_value": "Overdue time as fractional days",
"overdue_time_hours": "Overdue time in whole hours",
"overdue_time_days": "Overdue time in whole days",
"overdue_time_text": "Human-readable overdue time",
"available_date_no_time": "Available date at midnight",
"available_date_year": "Year of available date",
"available_date_month": "Month number (1-12)",
"available_date_month_text": "Full month name",
"available_date_month_abv": "Abbreviated month name",
"available_date_day": "Day of month",
"available_week_of_year": "ISO week number",
"open_date_no_time": "Open date at midnight"
}