SIMS 7 - R&A Enquiry format - Overview

Tag

Mandatory / Optional

Comment

<?xml version="1.0" encoding="UTF-8"?>

<EnquiryImport>

     <Header>

M

          <DocumentName/>

M

“Enquiry Import File”

          <Version/>

M

“1.0”

          <DateTime/>

M

YYYY-MM-DD or YYYY-MM-DDTHH:MM:SS

          <DestSchool>

M

               <SchoolID/>

M

SIMS School (School No + LA No), 7 characters. This must match to be imported.

          </DestSchool>

-

     </Header>

-

     <EnquiryCollection>

M

          <Enquiry>

MR

               <EnquiryID/>

M

Unique ID number within this file, 32bit integer

            <MarketingSource/>

O

Match on Code within ‘Marketing Source’ lookup

               <Comments/>

O

512 characters max

               <Enquirer>

M

                    <Title/>

O

Match on Code within ‘Title’ lookup

                    <Surname/>

M

60 characters max, 1 character min

                    <Forename/>

M

60 characters max, 1 character min

                    <Address>

O

                         <HouseName/>

O

40 characters max

                         <HouseNumber/>

O

40 characters max

                         <StreetDescription/>

O

40 characters max

                         <District/>

O

40 characters max

                         <Town/>

O

40 characters max

                         <County/>

O

40 characters max

                         <Postcode/>

O

8 characters max

                         <Country/>

O

40 characters max

                    </Address>

-

                    <Relationship/>

O

Match on Description within ‘Contact Relationship to Student’ lookup

                    <Contact>

O

                         <HomeEmailAddress/>

O

60 characters max

                         <HomeTelephoneNumber/>

O

20 characters max

                         <WorkTelephoneNumber/>

O

20 characters max

                         <MobileTelephoneNumber/>

O

20 characters max

                    </Contact>

-

               </Enquirer>

-

               <ProspectivePupilCollection>

O

                    <ProspectivePupil>

MR

                         <Title/>

O

Match on Code within ‘Title’ lookup

                         <Surname/>

M

60 characters max, 1 character min

                         <Middlename/>

O

60 characters max

                         <Forename/>

M

60 characters max, 1 character min

                         <Gender/>

M

1 character, value = M or F

                         <DOB/>

M

YYYY-MM-DD

                         <EnquiryReason>

O

Match on Code within ‘Enquiry Reason’ lookup

                         <CurrentSchool>

O

Match on School Name within Other Schools. If more than one school exists with the same name the current school will not be imported.

                         <ProposedYearOfEntry/>

O

Blank or YYYY

                         <ProposedSeasonOfEntry/>

O

Match on Description within ‘Admission Season’ lookup

                         <ProposedYearGroup/>

O

Match on Shortname for a yeargroup within Pastoral structure

                         <BoarderStatus/>

O

Match on Code for Boarder Status Lookup

                         <Religion/>

O

Match on Code for Home Religion Lookup

                         <Tier4/>

O

‘T’ for True or

‘F’ or Null for False

                    </ProspectivePupil>

-

               </ProspectivePupilCollection>

-

          <Visits>

O

               <Visit>

MR

                    <Type/>

M

Match on Description within ‘Visit Type’ lookup

                    <Date/>

M

YYYY-MM-DD

                    <Time/>

O

HH:MM

                    <Comment/>

O

Upto 250 Characters

               </Visit>

-

          </Visits>

-

          </Enquiry>

-

     </EnquiryCollection>

-

</EnquiryImport>

-