Views [dbo].[al_aud_contact_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
contact_uuid
middle_name
alias
last_name
first_name
pri_phone_number
alt_phone_number
fax_number
mobile_phone_number
pager_number
email_address
location_uuid
floor_location
pager_email_address
room_location
contact_type
inactive
creation_user
creation_date
last_update_user
last_update_date
version_number
department
comments
company_uuid
organization_uuid
admin_organization_uuid
alternate_identifier
job_title
job_function
mail_stop
cost_center
userid
supervisor_contact_uuid
exclude_registration
delete_time
inrdid
tenant
tenant_group
audit_trail_id
audit_trail_user
audit_trail_type
audit_trail_date
audit_trail_product
SQL Script
CREATE VIEW dbo.al_aud_contact_view AS select audittable.* from dbo.aud_ca_contact audittable WITH(READPAST) left outer join dbo.al_aud_contact_potr audpointer on (audittable.contact_uuid = audpointer.contact_uuid ) where ( audpointer.audit_trail_id is null or  ( audittable.audit_trail_id >= audpointer.audit_trail_id and audpointer.is_deleted != 1 ))
GO
Uses