Parent Data Requirements

parents.csv contains information about each parent who will be making payments. Each person in this file will be setup as a user in Xplor, and they will be able to login and make payments.

 

parents.csv

This is a list of all parents at a school, with their associated address details and Debtor ID

RULES: Email address identifies a unique person in Xplor.  Therefore we cannot have duplicate email addresses.   

 

Field Name

Comments

Data Type

Mandatory

ext_ref

 

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

 

Multiple Parents can be associated with a single debtor_ref (refer to below)

 

This could be the debtor_ref if that is used. 

Varchar(25)

Y

debtor_ref

 

Debtor ID or customer reference/Number held within the SMS that relates to an Debtor Account.

Varchar (255

Y

title

The title associated with the parent (eg. Mr, Miss, Mrs, Ms, Dr etc)

Varchar(25)

Y

first_name

Parents first name, and will be used to personalise the experience.

Varchar (255

Y

last_name

Parents family name, and will be used to personalise the experience.

Varchar (255

Y

email (UNIQUE ID)

Email address will be used to invite the parent s to xplor for schools.  It will also be the default username for the parent to access Xplor for schools.  If a parent doesn’t have an email address, they should not be in this file

Varchar (255)

Y

street_address

Parent residential address, which will be used on downloadable invoices and receipts. 

Varchar (255)

N

suburb

Suburb, as part of their address

Varchar (255)

N

postcode

Postcode associated with their address

 

Varchar (10)

N

country

Country of the address

Varchar(25)

N

state

State of the address

Varchar(25)

 

N