return formats Please note that data’ shown in this section is for illustration only. ‘example 5.1 Available formats The EY return is to be submitted to the department in XML format as described in this section. There is provision to convert fixed format CSV data into the required XML format by using a provided CSV to XML converter which is available from the department on request. The department has provided a data entry spreadsheet which enables the input of file header and individual child record information. On completion of entry of the data the file is then converted to XML format, via the spreadsheet, to allow for uploading to COLLECT. The data entry spreadsheet will be made available on the . The following general points should be noted for either format. 5.1.1 Data items with no values are three scenarios when there may be no values for particular data items. These are: Standard header information that is not relevant to this census. The only data item that should not be present is: Establishment Values contingent on the content of other data items. These items are: (EY) setting type (EY) provider category other (EY) setting type other (EY) day care (EY) day care other funded spring hours Values which are described in this specification as optional are: ethnicity pupil / child preferred surname pupil / child middle names contact middle names
return formats Please note that ‘example data’ shown in this section is for illustration only. 5.1 Available formats The EY return is to be submitted to the department in XML format as described in this section. There is provision to convert fixed format CSV data into the required XML format by using a provided CSV to XML converter which is available from the department on request. The department has provided a data entry spreadsheet which enables the input of file header and individual child record information. On completion of entry of the data the file is then converted to XML format, via the spreadsheet, to allow for uploading to COLLECT. The data entry spreadsheet will be made available on the . The following general points should be noted for either format. 5.1.1 Data items with no values are three scenarios when there may be no values for particular data items. These are: Standard header information that is not relevant to this census. The only data item that should not be present is: Establishment Values contingent on the content of other data items. These items are: (EY) setting type (EY) provider category other (EY) setting type other (EY) day care (EY) day care other funded spring hours Values which are described in this specification as optional are: ethnicity pupil / child preferred surname pupil / child middle names contact middle names