Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ActionID | int | 4 | null |
|
|
Action identifier - Unique identifier for the workflow action sourced 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 workflow state |
|
| SourceID | varchar | 65 | √ | null |
|
|
Source identifier - Reference to the payment source or data source associated with the action, linked through PaysourceInProgramType to local payment configurations |
|
| fkProgramID | int | 4 | √ | null |
|
|
Program reference - Links to the program type associated with this action through PaysourceInProgramType relationship for program-specific workflow management |
|
| LevelName | varchar | 20 | √ | null |
|
|
Level name - Descriptive name of the action level or hierarchy from iCS2.dbo.ActionInLevel defining workflow escalation and processing levels |
|
| fkGroupID | int | 4 | √ | null |
|
|
Group reference - Links to user groups associated with this action (nullable) for role-based workflow assignment and processing |
|
| fkFormID | int | 4 | √ | null |
|
|
Form reference - Links to forms associated with this action workflow from iCS2.dbo.ActionInBillingMethod for form-driven business processes |
|
| 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
Close relationships within degrees of separation
