Appearance
dbo.ethFactStatus
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.ethFactStatus.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | StatusName | nvarchar(100) | no | The name of a Prime Ecosystem job status, used as a reference/lookup value for reporting. | |
| 2 | ClosedState | nvarchar(50) | no | Classification of whether jobs in this status are considered open or closed, used as a report filter grouping. |
Indexes
| Name | Type | Unique | PK | Key columns | Included | Filter |
|---|---|---|---|---|---|---|
| IX_ethFactStatus_StatusName | NONCLUSTERED | StatusName | ClosedState |
Relationships (inferred)
| From | To | Confidence |
|---|---|---|
| dbo.primeExportJobsRegistered.CurrentStatus | dbo.ethFactStatus.StatusName | medium |
Referenced by
Views: dbo.vReportFilterStatusClosedState