Student Data Requirements

students.csv contains basic information about students and their associations to parent or parents. 

 

Field Name

Comments

Data Type

Mandatory

ext_ref

 

External ID held in the SMS that is unique identifier for this student.

Varchar(25)

Y

debtor_ref

 

Debtor ID or customer reference/Number this student is associated with. 

Varchar (255

Y

first_name

First name of the student, this will be used to support grouping of invoices

Varchar(255)

Y

last_name

Family name of the student, this will be used to support grouping of invoices

Varchar(255)

Y

year_level

Used in Canteen  - The year that a student is in, eg 7 for year 7

Varchar(255)

 Y

class

optional - The class (or home class) that a student is in. Class usually precedes a year level, eg. 7a being the class.

Varchar(255) 

 Y