| Appendix B-3 - Non-Central Campus Databases | ||||||||
| Unit | Database | Use | Users | Contact Person | Contact Info | website | ||
| Financial Systems and Databases | ||||||||
| BAS | Mr. Cash | Cash deposit system confirmation and tracking system. | Richard Andrea | Lois White | 642.1855 dolphin@uclink.berkeley.edu | |||
| BAS | Wanda | Executing wire transfers | Disbursements | Shannon Thorn | 643.0264 sthorn@uclink4.berkeley.edu | |||
| BAS | General Accounting Apps | Query old ledgers before GL Access | Disbursements | Shannon Thorn | 643.0264 sthorn@uclink4.berkeley.edu | |||
| BAS | Bank Ameritec | Sales and use for federal and state taxes | Disbursements | Shannon Thorn | 643.0264 sthorn@uclink4.berkeley.edu | |||
| BAS | 1042S | Functional taxable payments to foreign individuals | Marcia Johnson | Lois White | 642.1855 dolphin@uclink.berkeley.edu | |||
| BAS | LTLRS | Maintain long-term loans and receivables | Loans and Receivables | Steven Slawson | 642.6893 stephens@uclink.berkeley.edu | 642.6893 stephens@uclink.berkeley.edu | ||
| GRAD | GradLink-Graduate Student Fellowships Awarding and Track | Tracks awarding of student awards and fee payments from over 800 funds per year (over $30 million). Detailed data from 1998 on. Prior years graduate division data stored as summary. | Fellowships and GOP | Chris Hoffman | 643.2534 chris_h@uclink4.berkeley.edu | |||
| GRAD | Student Employment and Graduate Student Instructor-Employment-Based Fee Remissions | Based on type and level of appointment, students are eligible for a reduction in fees; system generates fee remission transactions, calculates amounts, tracks what student has been paid. | Dennis Andersen | 642.6418 dla@uclink4.berkeley.edu | ||||
| Human Resources Systems and Databases | ||||||||
| Human Resources | Berkeley Affirmative Action System | reporting system for staff and applicant affirmative action data | Human Resources | Deborah Flagg-Parker | 643.1025 debfp@uclink4.berkeley.edu | |||
| Human Resources | Berkeley Campus Title and Pay Plan | maintains central information regarding title codes | Human Resources | Deborah Flagg-Parker | 643.1025 debfp@uclink4.berkeley.edu | |||
| ASD | Personnel Activity Reporting/A21 | Extramural Fund Accounting | Deborah Flagg-Parker | 643.1025 debfp@uclink4.berkeley.edu | ||||
| BAS | Employee Database (Access/SQL) | Payroll's shadow system for querying payroll data outside of the main system. The system includes employee payroll information and allows Payroll to query information for reporting purposes and provide duplicate checks. | Peter Young | Liz Church | 643.6589 church@uclink4.berkeley.edu | |||
| HR-Benefits | Unemployment Insurance System | Calculates unemployment benefits & eligibility | Lupe Vanderburg | Simon Litvak | 643.0549 lsimon@uclink.berkeley.edu | |||
| HR-Benefits | Death Claim Log | Tracks deaths & applicable benefits of employees, retirees, and covered dependents | Marie Johnson | Janice Yee |
||||
| HR-Benefits | Disability Log | Tracks disability leaves & benefits | Disability Counselors | Susan Gutierrez Janice Yee |
||||
| HR-Benefits | Retirement Log | Tracks retirees | Retirement & Savings team | Susan Gutierrez Janice Yee |
||||
| HR-Benefits | Department Benefits Counselors | Tracks Dept. Benefits Counselors locations, benefits responsibilities, and % of job | Marie Johnson | Craig Long Amelia Brown |
642.0926 clong@uclink4.berkeley.edu | |||
| HR-Comp | Old Comp System | Historical--record of Comp. transactions | Robin Scott | Ken Dicks,Ed Griffith,C. Long, temp. | ||||
| HR-Comp | New Comp System | Tracks Compensation Unit transactions | Robin Scott | Sara Golemon | 643.6802 saramg@uclink.berkeley.edu | |||
| HR-Comp | Title Code System | Master record of Title Codes and approved pay rates; VFP module produces pages for the web | Kathy Uyeno | Ben Choate | ||||
| HR-EDT | CALS | Tracks student and tutor participation in CALS | Jane Griswold | Jeff King Craig Long | 642.0926 clong@uclink4.berkeley.edu | |||
| HR-Employment | Layoff Log | Tracks rehire rights of people laid off | Barry Warren | Craig Long | 642.0926 clong@uclink4.berkeley.edu | |||
| HR-Employment | Applicant Tracking | Collects & reports on basic personal data of applicants for jobs. Master database for employment services. | Applicant Assts, Personnel Assts | Intec Resources | ||||
| HR-Employment | AA Mailing Labels | Creates mailing labels to query applicants who do not submit Affirmative Action data, as required by Federal audit. | Employment Assistants | Jeff King | ||||
| HR-Employment | Department Mailing Labels | Creates a data file for departments of mailing information for all applicants to their posted jobs. | Employment Assistants | Craig Long | 642.0926 clong@uclink4.berkeley.edu | |||
| HR-ER | Salary History Database | Tracks salary actions & reasons for career staff | Personnel Assts | Janice Yee Craig Long |
642.0926 clong@uclink4.berkeley.edu | |||
| HR-ER | Salary History Cards Images | Historical record of images of old cardineer cards with salary history | Personnel Assts | 800-Scan | proprietary | |||
| HR-ER | APS count | Tracks special contracts, typically for coaches | Sandy Tupou | Craig Long | 642.0926 clong@uclink4.berkeley.edu | |||
| HR-ER | Entrance/Exit Surveys | Results of new employee & departing employee surveys to determine why people work here & why they leave | ER / SAAO | Staff, Affirmative Action Office | ||||
| LR | Grievance Log | Tracks formal employee grievances. | Labor Relations Assistant | Bev Terlep | 642.0398 bterlep@uclink4.berkeley.edu | |||
| Decision Support Systems and Databases | ||||||||
| All Decision Support Systems found the University of California, Berkeley are considered central campus systems | ||||||||
| Administrative Systems and Databases | ||||||||
| ASD | Barcode System for Out-Going Mail | This system is used to print and distribute barcode labels for outgoing mail | Mail Services | Lingte Liao- IST-ASD:DTS | 643.8784 jasper@uclink4.berkeley.edu | |||
| Chancellor's Office | CalMail | A web-based email system that will serve as the official medium for sending authorized announcements to targeted campus groups. This system is restricted to official university business. | Chancellor’s Office Communications Resource Center | Cindy Major | 642.3115 cmajor@uclink4.berkeley.edu | colt.berkeley.edu/calmail | ||
| Chancellor's Office | Chancellor’s Correspondence Mgmt. System | Maintains scanned images of the Chancellor's incoming correspondence and allows access to various units across campus | Chancellor’s Office Communications Resource Center | Gary Thackeray | ||||
| University Relations | E-Giving | Site provides information on the fundraising efforts of Cal. In addition to information on donations, the site allows interested parties to donate using a credit card online. | University Relations | Rosemary Kim | 643.9050 rmk@dev.urel.berkeley.edu | www.urel.berkeley.edu/e-giving | ||
| AVC-IST | CalNet ID Database (formerly Community Profile Dataset | Maintains information about the campus community and can be used via Kerberos to authenticate and authorize access to online services | IST-CCS | Jann Fong | 642.9815 jann@socrates.berkeley.edu | calnet.berkeley.edu | ||
| BAS | Authorized Signature | Documents signature authorization | Disbursements | Lois White | 642.1855 dolphin@uclink.berkeley.edu | |||
| Parking and Transportation | PowerPark | Catalogues Citations, Citation Payments, etc. | Stan Cheung | Stan Cheung | 642.0952 stanc@uclink4.berkeley.edu | |||
| Student Systems and Databases | ||||||||
| SIS | Transfer Credit System | TCS records and processes any undergaduate transfer credit and is separate from UGA. | Campus | JR Schulden | 642.1618 schulden@socrates.berkeley.edu | |||
| OSR | UG Longitudinal Surveys | Longitudinal data file for enrolled undergraduate students containing enrollment history and degrees for time to degree and completion analysis. | ||||||
| GRAD | Grad Majors | Provides summary aggregate statistics by major for graduate student applicants, admits, enrollments, financial support, and degree information for each department. Moved to OP/CMS; contains summary information for each department . Currently there are data since 1983. | ||||||
| GRAD | Grad Monster | Longitudinal data file for enrolled graduate students containing enrollment history and degrees for time to degree and completion analysis. | ||||||
| GRAD | Grad Placement | Doctoral degree placements one-year after graduation starting with Fall 1995 PhD recipients. | ||||||