Entity Definition

Logical Name : FuelServiceLevel
Physical Name : CO_LV_SV

A collection of service levels, which are merely parameters to the ITEM PRICE structure for fuel prices. Examples are "Full Service" & "Self Service"

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ServiceLevelID (PK) A unique identifier for the service level ID_LV_SV Identity integer
Name A human readable name for the service level NM_LV_SV Name varchar(40)


Parent Entity Verb Phrase Child Entity
FuelServiceLevel uses FuelItemPrice
FuelServiceLevel is summarized to NozzleFuelingTransactionHistory

Logical Views containing FuelServiceLevel

Logical View
Logical 20000 - Forecourt Macro View
Logical 20020 - Forecourt Pricing View