aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_plantype_name
Parameters
Name
Type
Mode
plan_type
integer
IN
Definition
select case when plan_type = 1 then 'Manual Rate' when plan_type = 2 then 'Dynamic adjust (link rate)' when plan_type = 3 then 'Earlybird' -- deprecated when plan_type = 4 then 'Last minute' -- deprecated when plan_type = 5 then 'Complimentary' --when p.plan_type = 6 then 'House Used' when plan_type = 9 then 'Open Rate' when plan_type = 999 then 'Join Rate' end