Listing of each report area in the Reports menu with the report area name, TABLES the report access, and query designation.
- Tables with an * - fields are only included if your query references the table. For example, fields from Grouping aren't included in the Enrollment & Income Summary report unless your query includes a reference to the Grouping table (e.g. “Grouping Code contains” element).
- Fields in Table – only selected fields are included in most reports. E.g. only the instructor last name, first name and ID fields are included in Room Use reports. If you want to display a field that is not included in the report, you must use a report function.
ACCOUNTING
| REPORT | NAME | TABLES | QUERY |
| Cash Box Receipt Listing Refund Listing Cash Box Reconciliation |
Augusta1 Augusta2 Augusta3 |
All 3 Report areas: Names, Course, Crseudfs, Pay |
None None None |
| Daily Income X Source (by Date) | Daiinc | Course, Names, Pay, Register | BF |
| Daily Income X Source (by Course) | Daiincc | Course, Names, Pay, Register | BF |
| Income & Enrollment Summary | Enrinc | Course, Grouping* | BC |
| Income Detail By Registrant | Increg | Course, Names, Regfees, Pay, Register | BE |
| Gift Cards | Giftcard | Course, Names, Register, Pay, Giftcard | BG |
| Special 1 Reg/1 Line | Deadbeat |
Course, Location, Names, Nameudfs, Register, Crseudfs* |
CE |
* Indicated table is included in the cursor IF the query contains a reference to it.
DEMOGRAPHICS
| REPORT | NAME | TABLES | QUERY |
| Names (with Codes) | Namewcdc | Names, Firm, Nameudfs, Namecode | AB |
| Names (with Registrations) | Namewrg | Course, Names, Nameudfs, Register, RegFees | AC |
| CRM Info | Namecrm | Names, CRM, Firm, Course | AM |
| Mailing Labels | Label | Names, Firm, Nameudfs, Register*, Testing*, Course* | AH |
| Firms (include Employees) | Firmwem | Firm, Names, Namecode, Nameudfs, Register | AD |
| Firms (without Names) | Firmwoe | Firm | AE |
| Firms (with Registrations) | Firmwrg | Course, Register, Firm, Names, Regfees |
AF |
| Credential | Credentl | Names, Testing, Firm, Nameudfs |
CR |
* Indicated table is included in the cursor IF the query contains a reference to it.
COURSES
| REPORT | NAME | TABLES | QUERY |
| CEU Reporting (by Course) | Ceugeoc | Course, Crseudfs, Location | GC |
| Course Details (with Fees) | Crsewfee | Course, Location, Grouping, Fees, Crseudfs | BA |
| Room Use Date Sort Location Sort |
Roomuse RoomuseL |
Both report areas: Course, Instruct*, Location, Crsroom |
BJ BJ |
| Waitlists | Waitlst | Register, Names, Course | BH |
| Income Summary | Incsum | Course, Grouping, Location, Crseudfs, Linkinst, Instruct, Fees* | CC |
| Generate Catalog Copy | Catalog | Catalog, Course, Location, Crseudfs, Instruct |
CZ |
| Attendance | Attrept | Attend, Course, Names, Register | AT |
* Indicated table is included in the cursor IF the query contains a reference to it.
REGISTRATIONS
| REPORT | NAME | TABLES | QUERY |
| Registrations (w/Fees & Payments) | Regwall | Register, Course, Pay, Names, Regudfs, Regfees | CA |
| Counts of Optional Fees | Optscnt | Register, Regfees, Names, Course | CG |
| Receipts | Mreceipt | Register, Regfees, Pay, Course, Names, Location, Firm | CF |
| Rosters Name Roster Attendance Roster |
Namerosc Attros |
Both report areas: Names, Nameudfs, Firm, Register, Course, Regfees, Location, Regudfs,*Instruct |
CB CB |
| Transcripts | Transct | Names, Nameudfs, Register, Course, *Grouping | AG |
| Name Tags | Nametag | Names, Nameudfs, Register, Course | AJ |
| Certificates | Certif | Names, Nameudfs, Register, Course, Location | CE |
| Tabletents | Tabltent | Names, Nameudfs, Register, Course | AJ |
| Course Packages | CrsePack | Names, CrsePack, Course, Register, Regudfs, Pay | CP |
* Indicated table is included in the cursor IF the query contains a reference to it.
FACULTY
| REPORT | NAME | TABLES | QUERY |
| Contract Agreements | Fmcontr | Instruct, Course, Linkinst, Firm, Location, Crseudfs | FA |
| Instructor List | Fmlist | Instruct, Course, Linkinst, Firm, Location | FA |
| 1099 Form | Fm1099 | Instruct, Course, Linkinst, Firm, Location | FB |
| Performance Data | Fmperf | Instruct, Course, Linkinst, Firm, Location | FA |
| Check Request | Fmcheck | Instruct, Course, Linkinst, Firm, Location | FA |
| Faculty Only Reports | Fmonly | Instruct, Course, Linkinst, Firm, Location | FA |
| Faculty CRM | FACCRM | Instruct, Course, CRM, Firm, Linkinst, Namecode | FC |
INVOICES
| REPORT | NAME | TABLES | QUERY |
| Run Invoices | Invoic | Names, Course, Pay | IV |
| Run Aging REPORT | Invoic | Names, Course, Pay | None |
POCKET LEDGER
| REPORT | NAME | TABLES | QUERY |
| Expense Listing Cost Center Grouping Expense Class Grouping Account # Grouping Vendor Grouping |
Expcost Expclass Expacc Expvend |
Course, Ledgentr, Leddesc, Location, Firm Course, Ledgentr, Leddesc, Location, Firm Course, Ledgentr, Leddesc, Location, Firm Course, Ledgentr, Leddesc, Location, Firm |
LG LG LG LG |
| Income/Expense Balances Detail Summary Snapshot |
Baldet Balsum Snapshot |
Course, Ledgentr, Leddesc, Location, Firm Course, Ledgentr, Leddesc, Location, Firm Course, Ledgentr, Leddesc |
LG LG LG |
| Budget Reports | Budgmass | Course, Ledgentr, Budget | BU |
WORKSHOP
| REPORT | NAME | TABLES | QUERY |
| Rosters | Workrosc | Names, Register, Wkshpind, Wkshpmst, Course | WR |
| Enrollment Summary | Workcnt | Wkshpmst, Course | WC |
STATISTICS
| REPORT | NAME | TABLES | QUERY |
| Names Demographic Summary Performance Sorting |
Statnmsn Statwght |
Both report areas: Names, Register, Namecode, Nameudfs |
SA |
| Firms Represented | Distfirm | Firm, Register | SB |
| Tracking Codes | Trcksumt | Names, Register | SD |
| Course Course Data Summary Performance Review |
Statcosm Statcowt |
Both report areas: Course |
SE SE |
CODES
| REPORT | NAME | TABLES | QUERY |
| Course Grouping Codes Course Subject/Interest Codes Catalog Codes/Descr Occupational Codes Organizational Codes List Source/Tracking Codes Account Codes Registrant Status Ledger Expense Codes Coordinator Names Registration Fees (Descr) Demographic Codes Department Codes Adjustment Fees Additional ID Codes Inventory Items |
Codes Codes Cata Codes Codes Srce Codes Codes Codes Codes Codes Codes Codes Codes Codes Codes |
The Codes Report area is for maintenance purposes only. These reports will only give you a list of codes and their descriptions--you can't get data such as which codes have been assigned to records. For this kind of information, you'll need to run a report in an area which accesses the module information (e.g. for name codes, Demographics report area; for course codes, Courses report area). | None None CY None None None None None None None None None None None None None |
Related Topics
