View: dbo.State_View
View definition
-- This view exists to provide an integer key on state information that can be used in filters.
-- It also adds the id and description columns to ease other aspects of the system that automate
-- features based on the standard of having kan id-type column.
-- This is really a kind of type table, so it follows those rules.
-- Yeah, we'll end up with an oddball key for Federal (zero), but that's life. At this point
-- it's more important that we get something easy to deal with - it'll match the ste_state_code_KEY.
create view dbo.State_View
as
select
state_KEY = convert(int, convert(decimal, S.ste_state_code_KEY))
, ste_state_code_KEY = S.ste_state_code_KEY
, state_id = S.postal_code
, description = S.name
from
dbo.Ste_State_Code S