if exists(select 1 from sys.views where name='institutional_claim_row_num' and type='v')
    drop view institutional_claim_row_num;
go

create view institutional_claim_row_num
as
    select row_number() over (order by dvc.last_updated_date desc) as row_num, dvc.claim_key
    from dim_va_claim dvc
    join dim_claim_form_type form_type on dvc.form_type_key=form_type.form_type_key
    join dim_institutional_claim dic on dvc.claim_key=dic.claim_key
    where form_code='837I' and dvc.is_current='Y'
go

if exists(select 1 from sys.views where name='professional_claim_row_num' and type='v')
    drop view professional_claim_row_num;
go
create view professional_claim_row_num
as
    select row_number() over (order by dvc.last_updated_date desc) as row_num, dvc.claim_key
    from dim_va_claim dvc
    join dim_claim_form_type form_type on dvc.form_type_key=form_type.form_type_key
    where form_code='837P' and dvc.is_current='Y'
go

if exists(select 1 from sys.views where name='dental_claim_row_num' and type='v')
    drop view dental_claim_row_num;
go
create view dental_claim_row_num
as
    select row_number() over (order by dvc.last_updated_date desc) as row_num, dvc.claim_key
    from dim_va_claim dvc
    join dim_claim_form_type form_type on dvc.form_type_key=form_type.form_type_key
    where form_code='837D' and dvc.is_current='Y'
go
