v_DIM_INSTALLMENTSTATUS
The installment status dimension describes when an installment is due relative to the current date.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| INSTALLMENTSTATUSDIMID | int | Contains values 0 - 3 | |
| INSTALLMENTSTATUS | varchar(12) | 0 = Past Due, 1 = Up to 1 year, 2 = 1 - 5 years, 3 = 5+ years |
Definition
Copy
create view [BBDW].[v_DIM_INSTALLMENTSTATUS] as
select 0 as [INSTALLMENTSTATUSDIMID], 'Past Due' as [INSTALLMENTSTATUS]
union all
select 1, 'Up to 1 year'
union all
select 2, '1 - 5 years'
union all
select 3, '5+ years'