Many functions require the individual’s ID and/or the Course Code. These fields exist in several databases and are named according to their respective database. The following lists the Name ID and Course Code fields from the various tables:
|
ID |
Course Code |
||
| Table | Field | Table | Field |
|
NAMES |
nmid |
COURSES |
cocrse |
|
REGISTER |
rgid |
REGISTER |
rgcrse |
|
PAY |
pyid |
PAY |
pycrse |
|
WKSHPIND (Individual Workshop table) |
wiid |
WKSHPMST (Master Workshops/Lessons) |
wmcrse |
|
|
|
LEDGER (Pocket Ledger table) |
lecode |
The report area determines which of the Name ID and Course Code fields are available in the cursor. For example, COCRSE is the available course code field in the Reports > Courses report area. But in the Reports > Registrations report area, RGCRSE is the available course code field.
In your functions, you may use whichever field is available in the report cursor. To see the list of available fields in your report cursor, click the Data Environment button on the Report Designer Toolbar. Then you can scroll down the list of available fields to see which one is available.
Related Topics