Access Applications on CampusAccess Application	Job Run By	Frequency
Mailing/Event Tracking Application	President's Office
Parking Extract	Analyst	On request

---

Mailing/Event Tracking Application

This application allows the President's office to do the following:
Keep track of events on campus and who gets invited to each event as well as rsvp information Keep track of groups on campus who are invited to events Keep address & other important information about people Create reports using this information Create labels using this information Create lists (similar to reports) using this information

Important Notes:
The application database (PRESAPP.MDB) has been installed on the pc located on Pam Reeds desk in the presidents office along with the .LDB file. The application is located in the C:\presapp directory. A backup copy of it is located in the IS G:\ACCESS\PRODDB directory.

The data database (PRESDATA.MDB) is located on the presidents office G drive in a directory called DATABASE. There is a backup copy of the STRUCTURE of this database located in the IS G:\ACCESS\PRODDB directory. DO NOT REPLACE THE ONE ON THE PRESIDENTS G DRIVE WITH THE BACKUP - ALL DATA WILL BE LOST!! The data is backup up on the server.

The security file (PRESIDEN.MDA) is located on the presidents office G drive in a directory called G:\DATABASE. A backup copy of this file is located in the IS G:\ACCESS\PRODDB but this account DOES NOT contain the same security - it is only useful in the case that the other file is lost - the owner/administrator exists in both files. The username is ISADMIN.

More documenation can be found in the following files:
G:\ADMDOC\PRESAPP.DOC contains installation & user information (not up to date)
 
G:\ADMDOC\PRESAPP.MAN contains 2 documents - both user manuals
 
The Presidents Application manual contains detailed documentation of each stage of the development of this application including security.

Revised: November 24, 1997

---

Parking Extract

SYSTEM:
SIS/HRS

SUBSYSTEM:

JOB NAME:Parking

PROCEDURE NAME AND LOCATION:
PK$APP:PARKING.COM

PURPOSE:
This job extracts data from the SIS and HRS systems to create the parking extract. HRS and SIS data are always extracted together, as employees enrolled in classes must be indentifed and only their employee data extracted.

FREQUENCY AND TIMING:
Generally runs weekly. Frequency depends on how often the parking decal system needs to be updated with current SIS student and HRS employee data.

PREREQUISITES AND DEPENDENCIES:
None

OTHER RESOURCES:
Extract file is created using FOCUS.

REQUIRED INPUT:
Term - Extract students registered for this term.
Username - The email account of the person to notify when data has been extracted.

INPUT FORMATS:
Term (YYS) - example 96S
User name - example JSMITH

OUTPUT:
SI$DATA:PARKING.DAT

RELOAD/NORELOAD:
No reload

SPECIAL INSTRUCTIONS:
None