Entity Definition

Logical Name : GeophysicalLocationAddress
Physical Name : LO_ADS_LCN_GEO_PHY

A geo-physical location's use of an address.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
AddressID (FK)(PK) A unique system allocated identifier for the Address. ID_ADS Identity integer Address(LO_ADS)
EffectiveDateTime (PK) The date & time from which the nominated GeoPhysicalLocation uses the nominated Address. TS_EF EffectiveDateTime datetime
GeographicLocationID (FK)(PK) Token ID for a GeographicLocation ID_GEO_LCN Identity integer GeophysicalLocation(CO_GEO_LCN)
ExpirationDateTime The date & time after which the nominated GeoPhysicalLocation no longer uses the nominated Address. TS_EP ExpirationDateTime datetime


Parent Entity Verb Phrase Child Entity
GeophysicalLocation is physical place of GeophysicalLocationAddress
Address is used at GeophysicalLocationAddress

Logical Views containing GeophysicalLocationAddress

Logical View
Logical 02340 - Retail Transaction - Shipping View
Logical 05000 - Taxation - Macro View
Logical 05100 - Taxation - Rules View
Logical 05200 - Taxation - Retail Transaction View
Logical 07030 - Customer Segment Independent Characteristics
Logical 10100 - Enterprise - Locations Macro View
Logical 10108 - Enterprise - Physical Locations View
Logical 10108 - Enterprise - Physical Locations View