Database: accounts
Date: 2009-10-23
Purpose:
- maintain a list of active PHAS ledgers/speed-charts for billing
purposes (eg. for Stores, Shops, Printing)
Contact Person(s):
(name, email, phone#)
- technical: Mary Ann, map@phas.ubc.ca, 2-6913
- end-user: Kim, kim@phas.ubc.ca, 2-6414
Maintained by:
(URLs, users, scripts, cronjobs)
- web form: https://www.phas.ubc.ca/forms/accounts/admin/index.php
- current user list: kim, finasst
Data Accessed by:
(URLs, users, scripts)
- other databases that require Speedchart information for billing
purposes
includes: shops, stores (incl. waterjet), sysadmin.printing
Dependencies/Effects:
(databases, files, cronjobs)
- program can update shops and stores databases:
- when an account is set to InActive and a Xfer_Acct code is
given, the program will search shops and stores databases and ask user
to confirm update of speedchart info. in those tables
Code Notes:
(development history, code review, wishlist)
- not a large application - just a simple form to allow maintenance
of speed-chart data
- also produces a table of speed-charts with typical
select/sort/print functions
- uses a javascript function (matchDDMenu) to auto-fill one form
field (account info) from another (speed-chart code)
- method originally used by co-op students for stores database
- Kim, Amy (and predecessors) seem to use this without problem,
complaint or need for more ...
- should get Kim to contact UBC Finance to co-ordinate
auto-downloading of charges
- may be able to download information from FMIS system instead of
duplicating maintenance on our system(?)
Tables:
CREATE TABLE
`main` (
`row_id` int(11) NOT NULL
auto_increment,
`Name` varchar(50) default
NULL,
`Speedchart` varchar(4)
default NULL,
`Ledger` varchar(8)
default NULL,
`Dept` char(1) default 'D',
`Rate` char(1) default 'D',
`Active` char(1) default
'0',
`Manager` varchar(30)
default NULL,
`xfer_acct` varchar(4)
default NULL,
`ptr_acct` varchar(20)
default NULL,
PRIMARY KEY
(`row_id`)
) ENGINE=MyISAM DEFAULT
CHARSET=latin1 AUTO_INCREMENT=824 ;
CREATE TABLE
`users` (
`username` varchar(8) NOT NULL
default '',
`firstname` varchar(30)
NOT NULL default '',
`lastname` varchar(30) NOT
NULL default '',
`access`
enum('ADMIN','READ') NOT NULL default 'READ',
UNIQUE KEY `username`
(`username`)
) ENGINE=MyISAM DEFAULT
CHARSET=latin1;