ActionN_VW


Description

Simplified action workflow view providing streamlined action information for reporting and operational dashboards. This cross-database view consolidates action data from iCS2.dbo.ClaimActionsNew with market and level information (iCS2.dbo.ActionInLevel) from the centralized iCS2 system, offering a simplified interface for action tracking and workflow monitoring without billing method complexity. The view provides market-specific action filtering through local ActionInMarket associations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ActionID int 4 null

Action identifier - Unique identifier for the workflow action from iCS2.dbo.ClaimActionsNew centralized action management system

ActionStatus varchar 50 null

Action status - Current status of the workflow action from iCS2.dbo.ClaimActionsNew indicating current workflow state

Market varchar 20 null

Market identifier - Identifies the specific market or business segment for this action from local ActionInMarket table for market-specific workflow processing

LevelName varchar 20 null

Level name - Descriptive name of the action level or hierarchy from iCS2.dbo.ActionInLevel defining workflow escalation and processing levels

ActionNotes varchar 5000 null

Action notes - Detailed notes and documentation about the action workflow from iCS2.dbo.ClaimActionsNew for workflow context and processing instructions

Relationships

View Definition


Possibly Referenced Tables/Views