Skip to main content
Skip table of contents

Templates

eBECAS/EDMISS uses Microsoft Word templates for the generation of pdf documents for students, agents and accommodation providers.

Templates are customised word documents with several embedded “bookmarks” (each bookmark displays a single item text or number) and “table bookmarks” (a single bookmark placed at the top left of a table to display a grid containing columns of data).

Each bookmark references data from the eBECAS/EDMISS database and places the data referenced by the bookmarks in the template to produce a new Microsoft Word document.

Colleges can register any number of templates and customise and edit the Microsoft Word templates with your branding and styling for re-use multiple times, without re-typing. This provides significant efficiencies and a common look and feel.

Microsoft Word documents generated from templates can be attached to emails and sent from within eBECAS/EDMISS and carbon copies sent and can be kept for reference.

Templates can be generated with student details including fees both nett and gross for agents and can include homestay details and airport transfer details.

Templates can be generated individually (for single student using a standard template) or in bulk for multiple selected students (using a template with AutoText area defined). Please see here for details about sending documents to multiple students using Autotext.

Where are the eBECAS/EDMISS templates located?

Multiple College staff members will likely need access to the same templates, all templates are stored in the supplied Document Repository for your College. The templates can be downloaded and uploaded after editing and accessed via the internet whether you are in the office or elsewhere.

How do I create an eBECAS/EDMISS template?

A new template can be created from within Microsoft Word or an existing template can be copied and modified. Make sure you place the created template in the folder you have already specified. A template can only have the extension .dot or .dotx, if it has a file name other than this, it is not a template.

Hint:  A template can only be opened after initially opening Microsoft Word, do not simply click on the template from Windows Explorer without first opening Microsoft Word, or the template will be converted into a document. Look at the top line in blue, it should show the file name and end in .dot or .dotx Only a file name ending in .dot or .dotx is a template

templates02

Registering a template in eBECAS/EDMISS

After a template has been created you must register the template name and the area in the menu you want to access and use the template.

eBECAS/EDMISS provides many areas in the application that templates can be used. The registration of the template specifies where in eBECAS/EDMISS menu the template will be available and also what group of data you want to display in the template.

2

In the above screen, you will see that you can register templates within eBECAS/EDMISS under Student, Enrolment, Enrolment fees, Receipt, Academic Results, Language Results, Accommodation Student, Accommodation Provider, Transfers, Group, Group Quote, Agent, Bulk Enrolment Statement and Offer. These locations refer to different menu options available in eBECAS/EDMISS.

If I register a templates in the Offer area, then Offer details screen shows:

By selecting Print – Word Merge – the choice of registered templates under Offers is displayed:

4

Selecting the relevant template name and pressing the merge button will generate a document from the template. The bookmarks in this template will be filled in with the Offer details.

Note: When emailing a document, it is best not to send the Microsoft Word document as an attachment but convert the document to a PDF and then attach it to the email. This ensures the document attached to the email cannot be changed.

While you are able to register any template under any menu option, the information and bookmarks available change depending on the part of eBECAS/EDMISS you are in. This is an important concept. The location the template is registered in determines what data you want to display in eBECAS/EDMISS.

For example: A student can have many offers and many enrolments (accepted offers for courses). It is only by going to the Offer, and selecting the offer does eBECAS/EDMISS know what offer out of potentially many for the student, you want printed.

This is also true for printing homestay placements (a student can have many homestay placements), a student can have many Airport transfers. It is important to register the templates where the details can be found for the bookmarks used.

Can I register a template under any menu option?

While you are able to register any template under any menu option, the information and bookmarks available will change depending on the part of EDMISS you are in. This is an important concept, I will detail further. The location the template is registered in determines what data you want to display in EDMISS.

For example: A student can have many offers and many enrolments (accepted offers for courses). Only by going to the Offer details, does EDMISS know what offer you want printed.

This is also relevant to printing homestay placements (a student can have many homestay placements), a student can have many Airport transfers. It is important to register the templates where the details can be found for the bookmarks used.

What are the available bookmarks?

Every Template Merge option has a corresponding Export option, which lists all the bookmark names and what data will be output for the bookmark. We do not provide a complete document that lists all the bookmarks that are available in each area on this website. As the bookmarks change depending on where the template is registered, we have provided you with the facility to display the bookmarks and the actual data that will be returned when the bookmarks are used, on the screen from your workstation.

To display all the available bookmarks for Offers, go to the Offer detail screen 1.61, press Print – Word Merge – and the registered templates will be displayed. Now press Export – Bookmarks, a new screen will appear asking you to save a file with the bookmarks, simply press the Save button, and then you can open the file and see the bookmarks and data for each bookmark.

templates08

At first this looks confusing, but the bookmarks follow a very simple naming convention that is easy to read and understand. All the bookmark names are displayed on the left, and the bookmark returned values for the particular Offer, are displayed on the right. For example:

templates08b

In the file I have extracted one simple bookmark, the image above shows that the bookmark name is O_OFFER_DATEE. If that bookmark is used in your Offer template, the value displayed will be 3 December 2007

Note: There can many many situations where you want to use the same bookmark. Microsoft, in their wisdom, do not allow a bookmark name in a template to be used more than once. We have therefore provided duplicates of the same bookmark. For example, you may want to use the Student’s first name several times in the template, we provide several different bookmark names displaying the same data, for example: S_FNAME, S_FNAME_1, S_FNAME_2, S_FNAME_3 and S_FNAME4 all display the student first name.

Table Bookmarks

A table bookmark is a grid, where columns and rows of data are displayed. For example the table bookmark OFFER_TABLE_1 is one of the available offer Table Bookmarks

templates09

To interpret what the table bookmark is displaying, there are 2 columns and 5 rows, for the above table bookmark OFFER_TABLE_1, the column descriptions are: description, commission amount and total amount:

Homestay Accommodation 17 Dec 2007 to 11 Feb 2008 (8 weeks 0 days)

$0.00

$1,520.00

Airport Greeting – One Way

$0.00

$80.00

Homestay Placement

$0.00

$160.00

Enrolment Fee

$0.00

$150.00

Intensive General English 17 Dec 2007 – 15 Feb 2008 8 weeks

$570.00

$2,280.00

There are several different Table Bookmarks that can be used, displaying different combinations of data for the offer.

Using bookmarks in a template

Open a registered template, making sure that you open the template from within Microsoft Word and then go to File – Open, or File – New – Template. It generally is easier to use the demonstration templates we supply and edit and save them as a new template name (ending in .dot or .dotx).

To demonstrate the use of bookmarks in a template, I will use one of the demonstration templates we supply and edit it, then add new bookmark. I am using the template named Demo_Offer_Gross_Student_Overseas_Address.dot. The template opened in Word will look like this:

templates10

Notice that you have all the standard options within Microsoft Word. You can embed images and personalize the document. You will see grey “block” areas in the document – these are the bookmarks.

Using the right button on your mouse, move over to and right click on the grey bookmark. A list of options will be displayed, select the property option. The following screen will be displayed.

templates11

The important information in this screen is the Field settings and the Bookmark (name), which is S_FNAME

This is where you specify the name of the eBECAS/EDMISS bookmark you want to use, to extract and display the bookmark returned value from eBECAS/EDMISS.

Adding bookmarks to a template

There are 2 ways to create a new bookmark. The simplest is just cut and paste an existing bookmark. Using this method, it is important to check that you have not removed the original bookmark name, if you have pasted the new bookmark before the exiting bookmark in the document. Have you thought about why this happens? As I said earlier, using Ms Word you cannot have more than one bookmark with the same name, so if the original bookmark was in the document below where you pasted the new bookmark, the name will have been removed. From the list of bookmarks, I showed you above to how to display, right click and select the new bookmark, and enter the bookmark name.

To use Microsoft Word to enter a new bookmark, without cutting and pasting, you first need to have the Form Toolbar enabled. In Microsoft Word, go to – View – Toolbars – Forms. On the image below, the bottom toolbar is the Form Toolbar.

templates12

The far left button is the Bookmark button, click on the location in the template you want the bookmark to be located, and then press the Bookmark button on the Form Toolbar, a new bookmark is entered, now just specify the bookmark name.

templates13

Adding a Table Bookmark in a template

A table bookmark enables you to display a grid. In eBECAS/EDMISS we support many different types of grids with different combinations of data displayed. You can enter headings for the columns and you only need to use one bookmark in the table. Be sure to look at the Table bookmark you want to use and generate the table with the correct number of columns for the table bookmark that you are using.

For example, in the template, I only want to display the offer item and the price, as I use offers to send “Invoices” to students. The price for the offer items are gross, so I don’t need or want to display the agent commission. Looking at the export from the offer area, I can see that the table bookmark OFFER_TABLE_3, has two columns.

templates14

This is the grid I want to use in the Offer for the student, so I insert a table and reference the Table Bookmark.

Open the template, click in the template where you want the table to be located, and then in Microsoft Word, click on Table – Insert – Table, you will then have the following screen displayed:

templates15

For OFFER_TABLE_3, we only need 2 columns and all tables only need 2 rows (rows will be autogenerated as required). We also only need the top row for the column headings. Enter in the column headings as you would like them to appear, and enter a new bookmark in the second row, with the bookmark name as OFFER_TABLE_3 and you should have something like this:

templates16

In this template, I have also added a single bookmark to display the total. The bookmark I used for this was O_TOTAL_AMOUNT.

Bookmarks

Student bookmarks

All student based bookmarks start with S_ for example S_CODE represents student code (student number), S_FNAME represents student first name, S_PHOTO represents student photo, S_LANGUAGE_DESC represents student language (mother tongue) and S_NOTES represents student notes etc.

Because of Microsoft design, you cannot re-use a bookmark. Therefore, we provide four additional bookmarks that contain the same information. So as an example, to display the Student Code you can use the bookmarks S_CODE, S_CODE_1, S_CODE_2, S_CODE_3 and S_CODE_4. This works the same for all bookmarks throughout eBECAS/EDMISS.

If there are any homestay placement requests or homestay placement information for the student, the homestay bookmarks start with a H_. For example, H_FROM_DATE is for homestay placement from date, H_TO_DATE is for homestay placement to date and H_NOTES is for homestay notes.

If there is any family homestay placement for the student, the family bookmarks start with a F_. F_CODE is for family homestay placement code, F_NAME is for family homestay placement name is for F_NOTES for family homestay notes.

If there is any Airport Transfer information for the student, the airport transfer bookmarks start with the T_. For example, T_APU_DATE for the airport pickup date and time, T_FLIGHT for the flight number, T_PU_BY for who is making the pickup, T_PU_FROM for where the pickup is from and T_PU_TO is where the student is going to.

Student financial bookmarks: Students can have many enrolments, the student financial bookmarks are a representative total of all enrolments and all fees. Fee total bookmarks include S_GROSS_TOTAL, being student gross total, which includes agent fees, S_RECEIPT_TOTAL, being student receipt total, S_CREDIT_TOTAL being student credit total and S_BALANCE being student balance (outstanding).

Student financial grid/table bookmarks: These grids display all enrolments for the student.

  • GRID_SN1 – Student NETT grid 1 separately lists the agent commissions, so is not for student use or display – the grid is 7 columns wide, and has column details of: edate (transaction date), activity (Invoice, receipt, credit), reference (reference number of the invoice, receipt, credit), amount (value of transaction), inv_amount (invoice amount), credit_amount and balance_amount.

  • GRID_SN2 – Student NETT grid 2 separately lists the agent commissions, so is not for student use or display – the grid is 7 columns wide, and has column details of: edate (transaction date), activity (Invoice, receipt, credit), reference (reference number of the invoice, receipt, credit), amount (value of transaction), inv_amount (invoice amount), credit_amount and balance_amount.

  • GRID_SN3 – Student NETT grid 3 separately lists the agent commissions, so is not for student use or display – the grid is 6 columns wide, and has column details of: edate (transaction date), activity (Invoice, receipt, credit), reference (reference number of the invoice, receipt, credit), amount (value of transaction), inv_amount (invoice amount) and credit_amount

  • GRID_SG1 – Student GROSS grid 1 lists tuition (does not list the agent commissions), so IS for student use or display – the grid is 7 columns wide and has column details of: edate (transaction date), activity (Invoice, receipt, credit), reference (reference number of the invoice, receipt, credit), amount (value of transaction), inv_amount (invoice amount), credit_amount and balance_amount.

  • GRID_SG2 – Student GROSS grid 2 lists tuition (does not list the agent commissions), so IS for student use or display – the grid is 7 columns wide, and has column details of: edate (transaction date), activity (Invoice, receipt, credit), reference (reference number of the invoice, receipt, credit), amount (value of transaction), inv_amount (invoice amount), credit_amount and balance_amount.

  • GRID_SG3 – Student GROSS grid 3 which lists tuition (does not list the agent commissions), so IS for student use or display – the grid is 6 columns wide, and has column details of: edate (transaction date), activity (Invoice, receipt, credit), reference (reference number of the invoice, receipt, credit), amount (value of transaction), inv_amount (invoice amount) and credit_amount.

Offer bookmarks

All offer-based bookmarks start with O_, for example the bookmark O_OFFER_NO is offer number and the bookmark O_OFFER_DATE is offer date. All the student bookmarks that start with S_ are available, if the offer is for an agent all the agent bookmarks that start with A_ are available. If the student has airport transfer transfer details, all transfer details that start with T_ are available. If the student has a homestay request, all homestay details that start with H_ are available.

Offer financial bookmarks: Offers can include several courses and other offer items. Offer fee totals include O_COMMISSION_AMOUN (offer commission amount), O_DISC_AMOUNT (offer discount amount), O_TAX_AMOUNT (offer tax amount), O_SUB_AMOUNT (offer total amount less the discount, exclusive of tax), O_NETT_AMOUNT (offer total amount less commission less discount, less tax) and O_TOTAL_AMOUNT (offer total).

Offer financial grid/table bookmarks:  Please use these grids to comprehensively display multiple courses, homestays and transfers. By using single bookmarks and not grids you can only display one enrolment whereas offers are designed to display multiple courses and details in a grid. The offer items text can be configured by the College to display the details. There are bookmarks and grids/tables to list offer items, totals and also to list offer instalment plans. Please do not use single bookmarks to display course offers … please use the grids ….

  • OFFER_TABLE_1 – Offer table grid 1 lists the agent commissions, so is not for student use or display. The grid is 3 columns wide and has column details of: description, commission_amount, and total_amount. It is suggested that the single bookmarks of O_COMMISSION_AMOUN, and O_NETT_AMOUNT should be used with this grid to be presented to an agent.

  • OFFER_TABLE_2 – Offer table grid 2 lists the agent commissions, so is not for student use or display. The grid is 4 columns wide and has column details of: description, commission_amount, disc_amount and total_amount. It is suggested that you use the single bookmarks of O_COMMISSION_AMOUN, O_DISC_AMOUNT and O_NETT_AMOUNT with this grid to present to an agent.

  • OFFER_TABLE_3 – Offer table grid 3 lists the offer items gross, so IS designed for student use and display. The grid is 2 columns wide and has column details of: description and total_amount. It is suggested that you use the single bookmark of O_TOTAL_AMOUNT.

  • OFFER_TABLE_4 – Offer table grid 4 lists the offer items gross, so IS designed for student use and display. The grid is 3 columns wide and has column details of: description, disc_amount and total_amount. It is suggested that you use the bookmarks of O_DISC_AMOUNT and O_TOTAL_AMOUNT.

  • OFFER_TABLE_5 – Offer table grid 5 lists the offer items gross, so IS designed for student use and display. The grid is 3 columns wide and has column details of: description, disc_amount, tax_amount and total_amount. It is suggested that you use the single bookmarks of O_TAX_AMOUNT, and O_TOTAL_AMOUNT.

  • OFFER_TABLE_6 – Offer table grid 6 lists the offer items gross, so IS designed for student use and display. The grid is 4 columns wide and has column details of: description, disc_amount, tax_amount and total_amount. It is suggested that you use the single bookmarks of O_DISC_AMOUNT, O_TAX_AMOUNT, and O_TOTAL_AMOUNT.

  • OFFER_TABLE_11 – Offer table grid 11 lists the agent commissions, so is not for student use or display. The grid is 4 columns wide and has column details of: product_type_name, description, commission_amount, and total_amount. It is suggested that the single bookmarks of O_COMMISSION_AMOUN, and O_NETT_AMOUNT is used with this grid to be presented to an agent.

  • OFFER_TABLE_12 – Offer table grid 12 lists the agent commissions, so is not for student use or display. The grid is 5 columns wide and has column details of: product_type_name, description, commission_amount, disc_amount and total_amount. It is suggested that you use the single bookmarks of O_COMMISSION_AMOUN, O_DISC_AMOUNT and O_NETT_AMOUNT with this grid to present to an agent.

  • OFFER_TABLE_13 – Offer table grid 13 lists the offer items gross, so IS designed for student use and display. The grid is 3 columns wide and has column details of: product_type_desc, description and total_amount. It is suggested that you use the single bookmark of O_TOTAL_AMOUNT.

  • OFFER_TABLE_14 – Offer table grid 14 lists the offer items gross, so IS designed for student use and display. The grid is 4 columns wide and has column details of: product_type_desc, description, disc_amount and total_amount. It is suggested that you use the single bookmarks of O_DISC_AMOUNT and O_TOTAL_AMOUNT.

  • OFFER_TABLE_15 – Offer table grid 15 lists the offer items gross, so IS designed for student use and display. The grid is 4 columns wide and has column details of: product_type_desc, description, disc_amount, tax_amount and total_amount. It is suggested that you use the single bookmarks of O_TAX_AMOUNT, and O_TOTAL_AMOUNT.

  • OFFER_TABLE_16 – Offer table grid 16 lists the offer items gross, so IS designed for student use and display. The grid is 4 columns wide and has column details of: product_type_desc, description, disc_amount, tax_amount and total_amount. It is suggested that you use the single bookmarks of O_DISC_AMOUNT, O_TAX_AMOUNT, and O_TOTAL_AMOUNT.

  • OFFER_TABLE_21 – Offer table grid 21 lists the agent commissions, so is not for student use or display. The grid is 5 columns wide and has column details of: product_type_name, code, description, commission_amount, and total_amount. It is suggested that the single bookmarks of O_COMMISSION_AMOUN, and O_NETT_AMOUNT be used with this grid when presenting it to an agent.

  • OFFER_TABLE_22 – Offer table grid 22 lists the agent commissions, so is not for student use or display. The grid is 6 columns wide and has column details of: product_type_name, code, description, commission_amount, disc_amount and total_amount. It is suggested that you use the single bookmarks of O_COMMISSION_AMOUN, O_DISC_AMOUNT and O_NETT_AMOUNT with this grid when presenting it to an agent.

  • OFFER_TABLE_23 – Offer table grid 23 lists the offer items gross, so IS designed for student use and display. The grid is 4 columns wide and has column details of: product_type_desc, code, description and total_amount. It is suggested that you use the single bookmark of O_TOTAL_AMOUNT.

  • OFFER_TABLE_24 – Offer table grid 24 lists the offer items gross, so IS designed for student use and display. The grid is 5 columns wide and has column details of: product_type_desc, code, description, disc_amount and total_amount. It is suggested that you use the single bookmarks of O_DISC_AMOUNT and O_TOTAL_AMOUNT.

  • OFFER_TABLE_25 – Offer table grid 25 lists the offer items gross, so IS designed for student use and display. The grid is 5 columns wide and has column details of: product_type_desc, code, description, disc_amount, tax_amount and total_amount. It is suggested that you use the single bookmarks of O_TAX_AMOUNT, and O_TOTAL_AMOUNT.

  • OFFER_TABLE_26 – Offer table grid 26 lists the offer items gross, so IS designed for student use and display. The grid is 5 columns wide and has column details of: product_type_desc, code, description, disc_amount, tax_amount and total_amount. It is suggested that you use the single bookmarks of O_DISC_AMOUNT, O_TAX_AMOUNT, and O_TOTAL_AMOUNT.

  • OFFER_INSTALL_1 – Offer instalment plan 1 table grid lists the amount and when the amount is due. The instalment plan is listed gross, so it IS designed for student use and display. The grid is 3 columns wide and has column details of: instalment number, due_date and amount. It is suggested that you use the single bookmark O_TOTAL_AMOUNT.

  • OFFER_INSTALL_2 – Offer instalment plan 2 table grid which lists the amount and when the amount is due. The instalment plan is listed gross, so IS designed for student use and display. The grid is 2 columns wide and has column details of: due_date and amount. It is suggested that you use the single bookmark O_TOTAL_AMOUNT.

Enrolment and Enrolment fee bookmarks

Enrolment bookmarks include all the student bookmarks that start with S_, all the homestay bookmarks that start with H_ and also all the Airport transfer bookmarks that start with T_.

Enrolment bookmarks start with E_, there are many enrolment bookmarks. Below is a list of the enrolment bookmarks and what each bookmark represents

  • E_ENROL_NO – Enrolment number

  • E_ST_DATE – Enrolment start date

  • E_END_DATE – Enrolment end date

  • E_CUR_WK – Enrolment current week

  • E_CRSE_LEN – Enrolment course length

  • E_CUR_ATT – Current enrolment attendance as of the current week

  • E_OVR_ATT – Overall enrolment attendance

  • E_CLASS_1 to _8 up to 8 classes that the student enrolment is currently enrolled in

  • E_COURSE_NAME – Course enrolment name

  • E_COURSE_LEN – Course length

  • E_C_HRS_WEEK – Course hours attendance required per week

Additional bookmarks include…

E_FACULTY_NAME, E_F_PROVIDER_CODE, E_F_PROVIDER_NAME, E_LOCATION_CODE, E_LOCATION_NAME, E_COMPANY_CODE, E_COMPANY_NAME, E_COY_PROVIDER_CODE, E_COY_PROVIDER_NAME, E_PROGRESS_STATUS (several start date formats) and E_LENGTH_NAME in weeks.

Every enrolment can be sent by an agent, if this is the case, the agent details start with A_. Agent fields include: A_CODE, A_NAME, A_NOTES, A_CUSTOM_1 to _10, which are user definable agent custom fields, A_TAX_CODE, A_PER_TITLE, A_PER_LAST_NAME, which is for several agent primary contact details, A_COUNTRY_NAME, A_ADDRESS_1 to _4 address details, A_PHONE, A_FAX, A_EMAIL, A_WWW and A_MOBILE.

Enrolment financial bookmarks: Students can have many enrolments, there are student financial bookmarks as well as the enrolment financial totals. Enrolment fee totals include ENROL_GROSS_TOTAL (enrolment gross total which includes agent fees), ENROL_AGENT_TOTAL (enrolment total agent fees), ENROL_NET_TOTAL (enrolment fees not including agent fees), E_GROSS_TOTAL (enrolment gross total including agent fees), E_RECEIPT_TOTAL (enrolment receipt total), E_CREDIT_TOTAL (enrolment credit total), E_BALANCE (outstanding enrolment balance).

Enrolment grid/table bookmarks: As well as the Student financial grid/tables, we also include:

  • GRID_FAMILY_MEM_1 – Family Homestay members – the grid is 2 columns wide, and has column details of: name (family member name) and fam_position (position in family).

  • GRID_FAMILY_MEM_2 – Family Homestay members – the grid is 3 columns wide, and has column details of: name (family member name), fam_position (position in family) and comments.

  • GRID_FAMILY_MEM_3 – Family Homestay members – the grid is 2 columns wide, and has column details of: fam_position (position in family) and name (family member name).

  • GRID_FAMILY_MEM_4 – Family Homestay members – the grid is 3 columns wide, and has column details of: fam_position (position in family), name (family member name) and comments.

  • GRID_INVOICE_NET – Enrolment NETT grid, which lists only outstanding fees. This grid lists commissions, so is not for student use or display. The grid is 2 columns wide and has column details of: fee_name, and amount.

  • GRID_INVOICE_GROSS – Enrolment GROSS grid, which lists only outstanding fees. This grid includes the agent commissions with the tuition fee, so IS designed for student use or display – the grid is 2 columns wide, and has column details of: fee_name, and amount.

  • GRID_INV_DUE_NET – Enrolment NETT grid, which lists only outstanding fees and when they are due to be paid (designed for part-payment). This grid lists commissions, so is not for student use or display. The grid is 3 columns wide and has column details of: fee_name, due date and amount.

  • GRID_INV_DUE_GROSS – Enrolment GROSS grid, which lists only outstanding fees and when they are due to be paid (designed for part-payment). This grid includes the agent commissions with the tuition fee, so IS designed for student use or display – the grid is 3 columns wide and has column details of: fee_name, due date and amount.

  • GRID_EN1 – Enrolment NETT grid 1, which lists the agent commissions, so is not for student use or display. The grid is 7 columns wide, and has column details of: edate (transaction date), activity (Invoice, receipt, credit), reference (reference number of the invoice, receipt, credit), amount (value of transaction), inv_amount (invoice amount), credit_amount and balance_amount.

  • GRID_EN2 – Enrolment NETT grid 2, which lists the agent commissions, so is not for student use or display – the grid is 7 columns wide, and has column details of: edate (transaction date), activity (Invoice, receipt, credit), reference (reference number of the invoice, receipt, credit), amount (value of transaction), inv_amount (invoice amount), credit_amount and balance_amount.

  • GRID_EN3 – Enrolment NETT grid 3, which lists the agent commissions, so is not for student use or display. The grid is 6 columns wide, and has column details of: edate (transaction date), activity (Invoice, receipt, credit), reference (reference number of the invoice, receipt, credit), amount (value of transaction), inv_amount (invoice amount) and credit_amount.

  • GRID_EG1 – Enrolment GROSS grid 1, which lists tuition (does not list the agent commissions), so IS for student use or display. The grid is 7 columns wide, and has column details of: edate (transaction date), activity (Invoice, receipt, credit), reference (reference number of the invoice, receipt, credit), amount (value of transaction), inv_amount (invoice amount), credit_amount and balance_amount.

  • GRID_EG2 – Enrolment GROSS grid 2, which lists tuition (does not list the agent commissions), so IS for student use or display. The grid is 7 columns wide, and has column details of: edate (transaction date), activity (Invoice, receipt, credit), reference (reference number of the invoice, receipt, credit), amount (value of transaction), inv_amount (invoice amount), credit_amount and balance_amount.

  • GRID_EG3 – Enrolment GROSS grid 3, which lists tuition (does not list the agent commissions), so IS for student use or display. The grid is 6 columns wide, and has column details of: edate (transaction date), activity (Invoice, receipt, credit), reference (reference number of the invoice, receipt, credit), amount (value of transaction), inv_amount (invoice amount) and credit_amount.

  • GRID_ENETT_CREDIT – Enrolment NETT credit grid, which lists credited / receipted fees including agents commissions, so is not for student use or display. The grid is 4 columns wide, and has column details of: edate (transaction date), activity (Invoice, receipt, credit), reference (reference number of the invoice, receipt, credit) and amount (value of transaction).

  • GRID_EGROSS_CREDIT – Enrolment GROSS credit grid, which lists tuition (does not list the agent commissions), so IS for student use or display. The grid is 4 columns wide, and has column details of: edate (transaction date), activity (Invoice, receipt, credit), reference (reference number of the invoice, receipt, credit) and amount (value of transaction).

Receipt bookmarks

To be able to print a receipt, you must be in the enrolment fees screen and first highlight the receipt. On the left Print panel, you will find an option ‘Receipt Merge’.

Receipt bookmarks include all the aforementioned student bookmarks that start with S_, all the homestay bookmarks that start with H_, all the Airport transfer bookmarks that start with T_, all the enrolment bookmarks that E_ and all the agent bookmarks that start with A_.

Receipt bookmarks start with R_. Below is a list of the receipt bookmarks and a short description detailing what each bookmark represents.

  • R_RECEIPT_NO – Receipt number

  • R_RECEIPT_DATE – Date the receipt was entered in the system

  • R_AMOUNT – Receipt amount

  • R_REFERENCE_ID – Which user entered the receipt

  • R_REFERENCE_DATE – Date actually receipted rather than date receipt was entered in system

  • R_STATION_NAME – Receipting station/Receipt book location/Name

  • R_BANK_NAME – Receipt bank account name

Receipt grid/table bookmarks:

  • GRID_RECEIPTS – Receipt grid which lists only receipted fees. This grid is 3 columns wide and has column details of: invoice_no, fee_name, and amount.

  • GRID_REC_DET – Receipt detail grid which lists only receipted fees. This grid is 3 columns wide, and has column details of: pay_type_name, detail and amount.

VET and HE Result bookmarks

  1. student bookmarks that start with S_

  2. homestay bookmarks that start with H_

  3. airport transfer all the Airport transfer bookmarks that start with T_

  4. enrolment bookmarks that E_ and if the student enrolment was sent by the agent –

  5. agent bookmarks that start with A_.

VET and HE Result grid/table bookmarks:

T table result bookmarks (the selected enrolment results (non VET listing marks and grades)

  • Nothing appended e.g. T1 – Lists all subjects/modules.

  • Appended with _1 e.g. T1_1 – Lists all modules excluding marks or result codes that are not filled in.

  • Appended with _2 e.g. T1_2 – Lists all modules excluding modules that have both no marks and no result codes filled in.

  • Appended with _A e.g. T1_A – Lists all modules and includes module assessment item results.

  • Appended _1_A e.g. T1_1_A – Lists all modules and includes module assessment item results. Excludes modules or assessment items that have either marks or result codes that are not filled in.

  • Appended _2_A e.g. T1_2_A – Lists all modules and includes module assessment item results. Excludes modules or assessment items that have both no marks and no result codes filled in.

G table of result bookmarks for the enrolment grouping of results (non VET listing marks and grades) as above for extensions
V table of result bookmarks for the VET listing of outcomes as above for extensions
TP table of Training plan listing start date and end date for module with weeks and hours

Language Result bookmarks

Language results are very flexible in layout and use. Instead of immediately reading through the list of exported bookmarks, it would be useful for your understanding to read about how the templates and bookmarks are meant to be used and referenced.

Please click/reference here to see a typical Language Results setup.

To be able to print language results, you must be in the results tab of the enrolment details. On the left Print panel, you will find an option Word Merge.

Language Results bookmarks include all the above detailed student bookmarks that start with S_. If there is a homestay placement, all the homestay bookmarks that start with H_ will be included. If there is an airport transfer, all the Airport transfer bookmarks that start with T_ will be included. All the enrolment bookmarks that E_ and all the agent bookmarks that start with A_ will also be included.

The result single bookmarks are for the highlighted / selected result.
The results bookmarks start with LR_. Below is a list of the language results bookmarks:

  • LR_DATE – Result date

  • LR_LEVEL
    LR_TEACHER

  • LR_EFFORT

  • LR_ATTENDANCE

  • LR_GRP_NAME_1 (to 10)

  • LR_GRP_CODE_1 (to 10)

  • LR_GRP_DESC_1 (to 10)

  • LR_CUST_NAME_1 (to 5)

  • LR_CUST_DESC_1 (to 5)

Language Result grid/table bookmarks:

  • LC_CLASS_x1

  • GRID_RESULT – Lists all result group results. The grid is 3 columns wide, with column details: result_group_desc, result_code and result_desc

  • GRID_CUSTOM – Lists all custom results. The grid is 2 columns wide, with column details: result_group_desc result group description and custom_score.

Accommodation Student bookmarks:

  • Normally Student accommodation details are printed when the student is placed in a homestay. If the student has more than one homestay placement, you need to go to the Student – Homestay details and select the placement details that you want to print.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.