Appearance
dbo.endataLocations
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.endataLocations.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | ID | int | no | identity | Primary key identifier for this location record. |
| 2 | LocationName | varchar(500) | no | Name of the location as sourced from Endata. | |
| 3 | IsStale | bit | no | Flag (1/0) indicating whether this record was not seen in the most recent Endata sync and should be treated as outdated. | |
| 4 | LocationHash | varbinary(32) | no | Hash of the location name used to detect duplicate or changed locations. | |
| 5 | CreatedAt | datetime2(7) | yes | Timestamp when this record was first created in this table. | |
| 6 | UpdatedAt | datetime2(7) | yes | Timestamp when this record was last updated by an Endata sync. | |
| 7 | ValidFrom | datetime2(7) | no | Start of the period during which this row is the current version (system-versioning/history tracking). | |
| 8 | ValidTo | datetime2(7) | no | End of the period during which this row is the current version (system-versioning/history tracking). |
Indexes
| Name | Type | Unique | PK | Key columns | Included | Filter |
|---|---|---|---|---|---|---|
| PK__endataLo__3214EC270A9B6275 | CLUSTERED | yes | yes | ID | ||
| IX_endataLocations_LocationHash | NONCLUSTERED | LocationHash |
Referenced by
Procedures: dbo.spEndataSyncLocations, dbo.spEndataUpsertLocations