9.2 General Ledger Account List

Purpose:   The following provides the steps to view the active General Ledger Accounts or Chart of Accounts (COA) in ctcLink.

Audience:   Everyone within ctcLink.

You must have at least one of these local college managed security roles:

  • ZD_DS_QUERY_VIEWER

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

General Ledger Account List

Navigation:  Reporting Tools > Query > Query Viewer

  1. The Query Viewer page will display.
  2. Enter in QFS_GL_ACCOUNT_TBL_ACTIVE.
  3. Select Search.
  4. The query results will display.
  5. Select Run to HTML, Excel or XML to display query results.

Select the link Add to Favorites to add this query onto your own favorites list.

Query Viewer search
  1. For this example, the Run to HTML was selected and the query results are displayed below. Note the total number of Accounts. As new accounts are added/modified/archived, the query will be updated to reflect changes.
  2. Select the desired link; Download the results in; Excel Spreadsheet, CSV Text File, or XML File.

Note: all Active Accounts in ctcLink will display with the following fields/values:

  • SetID = WACTC (Accounts are Global and maintained by SBCTC).
  • Account = Each General Ledger Account has 7 digits.
  • Effective Date =  Date the Account was activated.
  • Status as Effective Date =  Active (excludes old COA).
  • Description =  Long description displayed.
  • Short Description =   Short description displayed.
  • Account Type =   Short Account Type Description.
  • Account Type Description =   Long Account Type Description:  A - Assets, E - Expenses, L - Liabilities, R - Revenue, Q - Equity.
  • Bud. Only =   Y or N (Budgetary Accounts Only. Note: only N or non-budgetary accounts can be used for Accounting Transactions).
download type
  1. Process complete.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.