Entity Definition

Logical Name : WorkstationSiteAssignment
Physical Name : CO_ASGMT_WS_STE

Record of a Workstation's assignment to a particular Site; includes a WorkstationNumber which (in combination with SiteID) acts as an alternate key.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
WorkstationID (FK)(PK) The unique identifier for the WORKSTATION, typically the serial number. ID_WS Identity integer Workstation(AS_WS)
EffectiveDate (PK) The date from which this assignment applies. DC_EF EffectiveDate date
SiteID (FK)(PK) Token ID for a Site ID_STE Identity integer Site(LO_STE)
WorkstationNumber An alternate key for the Workstation (while it is assigned to the Site) NO_WS Identity integer
ExpirationDate The date until which this assignment applies. DC_EP ExpirationDate date


Parent Entity Verb Phrase Child Entity
Site is assigned WorkstationSiteAssignment
Workstation is housed WorkstationSiteAssignment

Logical Views containing WorkstationSiteAssignment

Logical View
Logical 06400 - Store Equipment View
Logical 10100 - Enterprise - Locations Macro View
Logical 11130 - Worker - Access Control View
Logical 11130 - Worker - Access Control View