Entity Definition

Logical Name : JobAllocation
Physical Name : CO_PST_ALCT

The allotment of Jobs that have been approved for a specific WorkLocation. (RetailStore, AdministrativeCenter, DistributionCenter, SellingLocation, Site)

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
JobID (FK)(PK) A unique retailer assigned identifier for a particular Job. ID_JOB Identity integer Job(CO_JOB)
LocationID (FK)(PK) A unique system assigned identifier for the Location. ID_LCN Identity integer WorkLocation(LO_LCN_WRK)
EffectiveDate (PK) The starting date for an allotment of positions to a BusinessUnit DC_EF EffectiveDate date
AllocationCount The number of instances of Position that are allocated to the BusinessUnit. QU_ALCT QuantityShortCount decimal(3,0)
ExpirationDate The ending date for an allotment of positions to a BusinessUnit DC_EP ExpirationDate date


Parent Entity Verb Phrase Child Entity
Job is allocated to JobAllocation
WorkLocation is location for JobAllocation

Logical Views containing JobAllocation

Logical View
Logical 11100 - Worker - Macro View
Logical 11120 - Worker - Job Definition View