Staff Directory by Rodney Middleton

Staff Directory

Goals

Provide Lookup on Web

Satisfy Regulartory Needs

Eliminate Re-entry

Provided Data

Name

Phone

Type

Department

E-mail

Title

Twitter

Facebook

LinkedIn

Process

Query Data from Jenzabar

Provide Override Data

Export to CSV

Import into Website

Tasks

Create Layout

Create Access Datbase

Where does this need to get put on the network?  Somewhere that Connie can access it to put in overrides.  So maybe HR. It is in hr, called staff.accd  

Link to Jenzabar

What information is needed so I know what tables need to be linkd. First, Last, ID, Phone, Extension, Title, E-Mail, Department, Photo, Flickr, Twitter, Facebook and LinkedIN (I know they are not all in jenzabar).

Create Override Tables

Create Query to Combine

Create Export

Write Instructions for Uploading to Web