| Database
Name |
Brief
Description
(and/or)
Table(s) |
Commisioned
By
/ Written For / Purpose in Life |
Code
Location
(www:/wwws/ unless otherwise specified) |
Uses
Database(s)
/ Databases Used By |
The
Good,
Bad
and
Ugly |
|---|---|---|---|---|---|
| db_esessions |
db_esessions.eSessions |
PHAS
Intranet
session
handling |
auth.php functions.php /usr/local/lib/php/config.DB_eSession.php |
-
used
by
all
other
databases
listed
here |
- uses
3rd party
class (in /usr/local/lib/php/) config.DB_eSession.php - good PEAR alternative? |
| db_esessions.cwlSessions |
CWL
authenticated
session
handling - used by Carchive and PhasLabs (obsolete) for student authentication |
ubc_cwl/ /usr/local/lib/php/cwl_config.DB_eSession.php |
- used by Carchive and PhasLabs(obsolete) | ||
| BPS (on omega) |
Brownie Point System |
used by head and designates to make faculty
teaching and
committee
assignments |
forms/bps/ teach/committee reports at: /docs/deptdir/ faculty BPS reports at: /docs/faculty/ |
uses: directory.department used by Carchive (maybe) |
- hard to imagine an off-the-shelf solution - code recently rewritten using MVC/Classes |
| SMS (on omega) |
Student
Machine
Shop
course
registration |
machine
shop
supervisor(s)
and
students |
forms/sms/ |
none |
-
other
solutions? |
| accounts (on omega) |
speedchart admin |
financial admin staff - for stores, shops,
waterjet, printing
charges |
forms/accounts/ |
- will modify stores and shops tables if
speedchart becomes
inactive - used by many other databases - hyper:/opt/sysadmin/common/passwd/addusr |
- not directly related, but should
investigate automatic
upload to UBC Finance of billing charges |
| directory (on omega) |
directory.department |
a)
defines "everyone" - dept. member info, eg. names, phone#, office# - updated by admin and hr staff - used for web directory, email lists, Intranet access, etc. |
forms/deptdir/ |
used
by many other databases and scripts - upload to Drupal: omega:/opt/sysadmin/drupal/gen_department_csv.pl - hyper:/opt/sysadmin/common/passwd/addusr |
- should
be two separate
tables - very old code |
| b)
bio/research
info
for
faculty - faculty self-service update of public web page |
forms/research/ 2011-10-27: disabled, using Drupal now |
none |
|||
| directory.grads |
grad
students
self-serve
update
of
public
web
page |
forms/grads/ 2011-11-10: disabled; not moving to new website |
uses: gradstudents.students (for current list of students) |
-
very
limited
fields |
|
| directory.review |
faculty
-
CVs
for
2008
dept.
review |
forms/research/review/ |
uses: directory.department |
- continuing project or one-time event? (last update Mar 25, 2010) | |
| directory.space |
office
staff
to assign desks in Hennings/Hebb |
forms/space/ |
|||
| gradstudents (on omega) |
gradstudents.applicants |
graduate program coordinator |
forms/graddb/ |
uses: directory.department - for potential supervisors gradstudents.students is used by several other applications to define current students |
- code has better structure than some - outgrowing it's original purpose (esp. committee features) |
| gradstudents.applicant_docs gradstudents.applicant_files gradstudents.cmte_comments gradstudents.cmte_scores |
graduate admissions committee - upload of all appl. forms and letters of reference to make viewable by all potential grad supervisors |
||||
| gradstudents.students |
graduate program coordinator |
||||
| network (on omega) |
PHAS
hosts
|
sysadmins
use
to
build
DNS/DHCP
tables |
forms/sysadmin/network/ |
uses: directory.department gradstudents.students - to check for valid email contact used by: dns:/var/named/chroot/domain/create_dns.pl |
-
extremely
useful |
| shared_docs (on omega) |
upload of non-public docs to Intranet |
for use by head and other admin staff |
upload/admin code at: forms/shared_docs/ viewing code at: docs/shared_docs.php, view_document.php |
uses: directory.department gradstudents.students - to check user access |
- not fully integrated with office staff needs - not a solution for non-restricted doc uploads |
| shops (on omega) |
shop
work
order
admin
and
billing |
shop
supervisor(s)
financial admin staff for billing |
forms/shops/ |
uses: accounts.main |
- recently re-written using MVC/Classes |
| sis (on omega) |
sis.{session}_sections sis.{session}_meetings sis.{session}_instructors |
PHAS courses downloaded from SIS web site |
XML file download script: www:/opt/sysadmin/sis/get_sis.pl upload to MySQL script: www:/opt/sysadmin/sis/parse_sis.pl |
used by Carchive, PhasLabs (obsloete),
bps.courses,
sis.tas Carchive code location: /var/www/lib/perl/sql_lib/ |
|
| sis.{session}_students |
PHAS classlists downloaded by
SIS to /home/regi/PHAS_classlists.csv |
script to upload to MySQL: omega:/opt/sysadmin/common/sis/students.pl |
used by Carchive, PhasLabs (obsolete) |
||
| sis.exam_dutes sis.exam_schedule |
Fran Bates - to help with
assignment of TAs to exam duties |
forms/tas/ |
uses: tas.ta_applications exam_schedule.csv file |
||
| stores (on omega) |
stores
inventory
maintenance
and
kiosk (incl. waterjet cutter usage) |
storesman,
shop
supervisor(s) financial admin staff for billing |
forms/stores/ /www/stores/storeswd/swinc.php - kiosk code |
uses: accounts.main |
-
not
sure
how
much
of
reports,
etc.
are still useful |
| sysadmin (on omega) |
sysadmin.printing sysadmin.acctstatus |
financial admin staff for printer billing |
forms/printing/ script to save page counts each month: delta:/opt/sysadmin/printing/monthend.pl |
uses: pykota database accounts.main |
- shares features but not code with
shops/stores billing |
| sysadmin.phasusers - user account meta data |
DB version of flat file:
hyper:/opt/sysadmin/common/passwd/users.db - for user account admin |
upload from flat file: omega:/opt/sysadmin/common/passwd/phas_users.pl generic SQL viewing tool at: forms/sysadmin/userids_report.php |
used by sysadmin scripts on various servers, eg. for email list maintenance | - LDAP server might replace the need for this |
|
| tas (on omega) |
-
inputs
are
current
courses,
TA
and instructor requests - pulls TA data from gradstudents db - tries to prioritize TAs for user based on requests, experience, ratings, etc |
Undergraduate
Assistant
-
to
enter
TAs
and assign to courses Instructors - to determine their TAs TAs - to determine their assignments |
forms/tas/ |
uses:
gradstudents.students
to
get
background
info.
for TAs |
-
written
using
MVC/Classes
|
| timesheets (on omega) |
vacation/sick
time
tracking
for
staff |
staff
members
-
various
levels
of
access
-
admin vs edit vs view only |
forms/timesheets/ |
uses: directory.dept (for staff list) |
-
code
is
a
mess;
inhibits
further
development - should give option to add arbitrary staff member |
| WebCal100 |
web
calendar - see notes at: https://www.phas.ubc.ca/sysadmin/WWW-admin/WebCalendar/ |
dept.
shared
calendar - used for room bookings |
WebCalendar-1.0.2 |
-
replace
with
Exchange
server
calendaring?? |