Click for Index

Section 11
Department Codes

The department codes table stores information about the departments that are using the QSI RAS WIN program.

Each field in the table is listed, along with a short description, below:
  1. DEPT_CODE This code defines a unique department. For example, FIN for Finance, BLD for Building, PD for Police Department, etc. The code can be up to 15 characters long.

    See also: DEPARTMENT TRANSACTIONS.
  2. DEPT_NAME The Department Name, e.g., FINANCE DEPARTMENT, POLICE DEPARTMENT, etc.
  3. DIVISION The Division name, if applicable.
  4. PHONE_NUMBER The Department phone number.
  5. FAX_NUMBER The Department fax number.
  6. ADDRESS_1 The Department Address Line 1
  7. ADDRESS_2 The Department Address Line 2
  8. ADDRESS_3 The Department Address Line 3
  9. ADDRESS_4 The Department Address Line 4