Entity Definition

Logical Name : WorkerAvailability
Physical Name : CO_WRKR_AVLB

A set of consecutive hours on a set of days of the week, that a particular Worker is available to work at a particular WorkLocation, during a nominated period of time. e.g. Worker is available 10am - 2pm Mon, Wed & Fri, to work at a particular Outlet, during the period 1-April-2004 to 30-April-2004

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
WorkerID (FK)(PK) A unique system-assigned identifier for the Worker whose availability is being recorded. ID_WRKR Identity integer Worker(PA_WRKR)
TimeGroupID (FK)(PK) A unique identifier for a set of consecutive hours on a set of days of the week on which the Worker will be available to work at the nominated WorkLocation. ID_GP_TM Identity integer TimeGroup(CO_GP_TM)
LocationID (FK)(PK) A unique system assigned identifier for the Location. ID_LCN Identity integer WorkLocation(LO_LCN_WRK)
EffectiveDate The date from which the Worker availability record applies. DC_EF EffectiveDate date
ExpirationDate The date until which the Worker availability record applies. DC_EP ExpirationDate date
ReasonCode (FK) A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query CD_RSN Code varchar(20) Reason(CO_CD_RSN)


Parent Entity Verb Phrase Child Entity
Worker has WorkerAvailability
WorkLocation defines WorkerAvailability
Reason classifies WorkerAvailability
TimeGroup is part of WorkerAvailability

Logical Views containing WorkerAvailability

Logical View
Logical 06500 - Time Groups View
Logical 11100 - Worker - Macro View