Appearance
dbo.primeExportUpdatedStatus
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.primeExportUpdatedStatus.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | Supervisor | nvarchar(100) | yes | Display name of the supervisor | |
| 2 | JobNumber | nvarchar(50) | no | Human-readable job number/reference used in Prime Ecosystem | |
| 3 | SiteAddress | nvarchar(255) | yes | Full site/property address for the job | |
| 4 | CurrentStatus | nvarchar(200) | yes | Current status of the job/record | |
| 5 | CurrentStatusChangedAt | datetime2(3) | yes | Timestamp the current status was last changed |
Indexes
| Name | Type | Unique | PK | Key columns | Included | Filter |
|---|---|---|---|---|---|---|
| PK_primeExportUpdatedStatus | CLUSTERED | yes | yes | JobNumber |
Referenced by
Procedures: dbo.spUpsertPrimeExportUpdatedStatus