Views [dbo].[al_aud_location_view]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created10:37:16 PM Thursday, February 10, 2011
Last Modified10:37:16 PM Thursday, February 10, 2011
Columns
Name
location_uuid
location_name
inactive
pri_phone_number
fax_number
address_1
address_2
mail_address_1
mail_address_2
mail_address_3
city
state
address_3
mail_address_6
mail_address_5
mail_address_4
address_6
address_5
address_4
primary_contact_uuid
zip
country
county
geo_coord_type
geo_coords
contact_address_flag
creation_user
site_id
creation_date
comments
last_update_user
last_update_date
version_number
exclude_registration
delete_time
location_type_id
parent_location_uuid
organization_uuid
tenant
region_id
audit_trail_id
audit_trail_user
audit_trail_type
audit_trail_date
audit_trail_product
SQL Script
CREATE VIEW dbo.al_aud_location_view AS select audittable.* from dbo.aud_ca_location audittable WITH(READPAST) left outer join dbo.al_aud_location_potr audpointer on (audittable.location_uuid = audpointer.location_uuid ) where ( audpointer.audit_trail_id is null or  ( audittable.audit_trail_id >= audpointer.audit_trail_id and audpointer.is_deleted != 1 ))
GO
Uses