All the fields in Student Manager are contained in tables. In most of the tables, the first two letters of the field denote the table in which they are stored. For example, all fields which start with 'Nm' are from the Names table. The Names table stores all the personal information about the individuals participating in your programs (e.g. name, address, occupation code, etc.).
Here’s a quick guide to the Table Naming protocols within Student Manager:
| Bu = Budget Builder | Loc = Location (e.g. locinfo: location info) |
| Ca = Catalog (e.g. cacode: catalog code) | Nm = Name (e.g. nmname1: first name) |
| Co = Course (e.g. cocrse: course code) | Py = Pay (e.g. pydate: payment date) |
| Fe = Course Fees (e.g. fedesc: fee desc.) | Rf = Reg. Additional Charges (e.g. rffee: fee amount) |
| Fai = Individual Financial Aid (e.g. faid, faiexpect) | Rg = Register (e.g. rgaddate: reg add date) |
| Fam = Master Financial Aid (e.g. famid, famcrse) | Rs = Room Splits (e.g. rsparent, rschild) |
| Fm = Firm (e.g. fmfirm: firm title) | Te = Credentials (e.g. teid, tetitle) |
| In = Instructor (e.g. inname3: inst. last name) | Wi = Individual's workshops/lessons (e.g. wigrade: grade) |
| Li = Instructor Pay (e.g. lipayrate: pay rate) | Wm = Master Workshop/Lessons (e.g. wmtitle: workshop/lesson title) |
| Le = Pocket Ledger (e.g. leclass: expense class) |
|
Note: the standard naming technique applies to all tables/fields--except user-defined fields. All user-defined fields consist of the first letter of the table (e.g. N=Name, C=Course, etc.), the letters 'UDF', letter denoting the type of field (c=character, l=logical, n=number, d=date), and the number of the field. For example, Nudfc1 is Name character field # 1.
Data Tables/Fields Structure
View the Student Manager tables/fields in list format. Or view field names by screen in the Screen Layout section.
Related Topics