View source for Where Things Are Stored

[[:File:Addendum 29 Map of Where Things are Stored.docx]]

When you design a query, do a report or just want to look at what is in the database in a raw state, you have to find where things are stored. Everything in Prime is stored in Tables. These tables have a naming convention.

If you go into the Navigation Pane and look at the list of tables, they are named following the below conventions.

{| class="wikitable"
|-
! Table Naming !! Example !! What it Means
|-
| Begins with Z || zTitleIII || Special Program
|-
| No prefix || ClientsW || Main Tables - Hold Clients Information
|-
| sub || subCCity || Supporting Table - usually pulldowns, City list
|-
| yy (except yyIM) || yyQuestions || Interview system - List of Questions
|-
| yyIM || yyIMessages || Internal Messaging - Messages
|-
| _Deleted || ClientsW_deleted || Automatic backup of deleted records (you might not be able to see these)
|-
| Ypj || ypjProblems || Project Management - problems in project
|-
| ScreeningX || ScreeningXsubProbType || Web Online Intake - problem code list
|}