Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkProcessID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each business process record |
|
| Type | varchar | 50 | √ | null |
|
|
Process type - Type or category of the business process (e.g., ‘Report’, ‘Import’, ‘Export’, ‘Workflow’) |
|
| Status | varchar | 50 | √ | null |
|
|
Process status - Current status of the process (e.g., ‘Running’, ‘Completed’, ‘Failed’, ‘Pending’) |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator reference - Links to AccessUser table for the user who initiated this process |
|
| DateCreated | datetime | 16,3 | √ | (getdate()) |
|
|
Creation timestamp - Date and time when the process was created or started |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updater reference - Links to AccessUser table for the user who last updated this process |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update timestamp - Date and time when the process was last modified |
|
| fileName | varchar | 500 | √ | null |
|
|
Input file name - Name of the file being processed or used as input for the process |
|
| AgencyID | int | 4 | √ | null |
|
|
Agency reference - Links to Agency table for the healthcare organization associated with this process |
|
| Comments | text | 2147483647 | √ | null |
|
|
Process comments - Detailed comments, notes, or log information about the process execution |
|
| HTMLStr | text | 2147483647 | √ | null |
|
|
HTML content - HTML string content generated or processed by this business process |
|
| outputFileName | varchar | 100 | √ | null |
|
|
Output file name - Name of the file generated as output from this process |
Relationships
Close relationships within degrees of separation
