Views [dbo].[al_aud_company_view]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created10:37:15 PM Thursday, February 10, 2011
Last Modified10:37:15 PM Thursday, February 10, 2011
Columns
Name
company_uuid
parent_company_uuid
company_name
inactive
description
company_type
alias
month_fiscal_year_ends
web_address
bbs
creation_user
creation_date
last_update_user
location_uuid
primary_contact_uuid
version_number
last_update_date
exclude_registration
delete_time
authentication_user_name
authentication_password
source_type_id
auto_rep_version
domain_uuid
tenant
bsa_flag
siia_flag
fast_flag
user_priority_flag
employee_count
desktop_count
asset_count
authoritative
duplicate_with_uuid
audit_trail_id
audit_trail_user
audit_trail_type
audit_trail_date
audit_trail_product
SQL Script
CREATE VIEW dbo.al_aud_company_view AS select audittable.* from dbo.aud_ca_company audittable WITH(READPAST) left outer join dbo.al_aud_company_potr audpointer on (audittable.company_uuid = audpointer.company_uuid ) where ( audpointer.audit_trail_id is null or  ( audittable.audit_trail_id >= audpointer.audit_trail_id and audpointer.is_deleted != 1 ))
GO
Uses