Every term, information about CEL examination candidates needs to be imported into the system. This is usually done by CEL IT staff, and consists of the following steps:
- Populate the cel_temp_load_candidates table;
- Run cel_load_candidates ();
- Check and fulfill the accommodation request using the usual accommodation interface (skipping the numbered steps on that page because they are done in the previous two steps).
When populating cel_temp_load_candidates it is preferable if the barcode column is loaded along with the remaining columns, but if necessary the barcodes can be left NULL. Later when the barcodes are available, the temporary table can be re-populated and a subset of the operations in cel_load_candidates () run. CSCF assistance would be required for this, as explained in ST#92000.
Once the seat assignments are complete, the packing list which indicates how many of each examination are required in each line of seats can be obtained by querying cel_packlist for all rows with term_id corresponding to current term.