[dbo].[personview]

(local) > mdb > Views > dbo.personview

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	12:32:10 PM Sunday, December 05, 2010
Last Modified	12:32:10 PM Sunday, December 05, 2010

Columns

Name
name
id
fullname
rating
ratingtime
starttime
endtime
createdby
lastupdated
badgeresid
firstname
lastname
department
address
phone
email
title
officeno
dateofhire
source

SQL Script

CREATE VIEW personview as select a.name, b.*, c.screenname as "source" from personalias a, secure_person b, datasource c where a.personid = b.id and a.createdby = c.id
GO

Uses

[dbo].[datasource]
[dbo].[personalias]
[dbo].[secure_person]
dbo