[dbo].[al_aud_usp_owned_resource

[dbo].[al_aud_usp_owned_resource_view]

(local) > mdb > Views > dbo.al_aud_usp_owned_resource_view

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	10:37:18 PM Thursday, February 10, 2011
Last Modified	10:37:18 PM Thursday, February 10, 2011

Columns

Name
owned_resource_uuid
nr_prim_skt_id
nr_pr_id
nr_wrty_st_dt
nr_wrty_end_dt
nr_exp_dt
nr_sla_id
nr_nx_string1
nr_nx_string2
nr_nx_string3
nr_nx_string4
nr_nx_string5
nr_nx_string6
nr_nx_ref_1
nr_nx_ref_2
nr_nx_ref_3
nr_financial_id
nr_service_type
nr_argis_id
nr_bms
nr_bmlabel
nr_bm_rep
baseline_uuid
service_impact
zbusiness_approver_group
zstakeholders_group
ztechnical_approver_group
CREATION_USER
CREATION_DATE
LAST_UPDATE_USER
LAST_UPDATE_DATE
VERSION_NUMBER
audit_trail_id
audit_trail_user
audit_trail_type
audit_trail_date
audit_trail_product

SQL Script

CREATE VIEW dbo.al_aud_usp_owned_resource_view AS select audittable.* from dbo.aud_usp_owned_resource audittable WITH(READPAST) left outer join dbo.al_aud_usp_owned_resource_potr audpointer on (audittable.owned_resource_uuid = audpointer.owned_resource_uuid ) where ( audpointer.audit_trail_id is null or ( audittable.audit_trail_id >= audpointer.audit_trail_id and audpointer.is_deleted != 1 ))
GO

Uses