Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 30 Next »

Please be aware of a limitation when importing applications that, if an existing Community ID is used, that information will be used rather than the detail in the online application.

We are currently reviewing this implementation to revise this to allow user selection around which information to keep if there is an existing record.

This has been further discussed on Discourse.


Should you experience any unexpected results as part of the import process please let us know via our support desk.

Attachments are unable to be imported with the XML import process.

Attachments can only be imported with the use of application forms created via the Online Form Builder

How Online Import Application works

 

  1. Either type or use the  button to select an XML file for importing.
  2. Press the  button to begin the import.
  3. The top grid displays the header section of the Application
  4. The middle grid displays the student information associated with the application
  5. The bottom grid displays the contact information associated with the application
  6. Select a student in the middle grid and either press one of the transfer buttons or right click on the grid select one of the transfer options.
    The transfer will
    1. Pre fill the required wizard and allow the user to process the  data accordingly
    2. After the wizard is finished, if Transfer To Future student had been selected, then the application fee if any will be processed using the Enrolment Deposit Wizard
    3. After either the Enquiry wizard or Future Student wizard has completed  either the Enquiry Student Maintenance screen or Future Student Maintenance screen will display

 

 Enrolment Deposit Wizard

 

There is a Config key OnlineApplications|StudentTransferMode that has 3 possible values.

Student Transfer Mode:

  1. Allow transfer to Future Students
  2. Allow transfer to Enquiry Students
  3. Allow transfer to both Future Students and Enquiry Students

Student Contacts

It is important to note that student contacts have some fields that need to be considered, per contact, when being included for an XML import.

For example. if there is no ParentFlag set, the contact will be considered an other contact (constituency @SFOC) rather than a future parent (@FP).

  • PrimaryOnlyFlag
  • NormalMailFlag
  • ReportsFlag
  • ParentFlag
  • LivesWithFlag

When using the Synergetic online application import these can be defaulted via configuration maintenance options that can be found via OnlineApplications|Defaults


Custom Nodes

XML Format for Custom Node

       <Custom>
            <CustomFields>
                <CustomField>
                    <FieldName>AppCustomField</FieldName>
                    <FieldData>AppCustomData</FieldData>
                </CustomField>
                 <CustomField>
                    <FieldName>AppCustomField</FieldName>
                    <FieldData>AppCustomData</FieldData>
                </CustomField>
           </CustomFields>
        </Custom>

Custom nodes can appear at the Application level, the Contact level or the Student level.

The format for the Custom tag is as above with multiple CustomField tags containing FieldNane and FieldData pairs.

The stored procedure uspiOnlineImportApplicationCustomNodes takes the parameter ‘@OnlineImportApplicationsSeq’ and is a template for processing user custom data.

The first section of the stored procedure fills the temporary table #CustomNodes with any data found in custom nodes.

NodeTypeFieldNameFieldData
ApplicationNodeAppCustomFieldAppCustomData
ContactNodeContactCustomFieldContactCustomData
StudentNodeStudentCustomFieldStudentCustomData

Supported Fields

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

The table is being loaded. Please wait for a bit ...

Please note that the fields names are Case Sensitive. For example Postcode will not work, but PostCode will.

InformationNewFieldNameNewFieldTypeluTableLookup Procedure (if exists)FuturesEnquiriesCommentIntroducedTemplate
OnlineImportStudentsIDINT  YesYesWill be blankv3.0 
OnlineImportStudentsContactEnquiryIDINT  YesYesNot requiredv3.0 
OnlineImportStudentsTitleVARCHAR(30)luTitleLookupTitleYesYes

Can be defaulted when transferring using:

  • Config Key FutureStudents|Applications|DefaultTitle|Male
  • Config Key FutureStudents|Applications|DefaultTitle|Female
v3.0Yes
OnlineImportStudentsSuffixVARCHAR(20)  YesYes v3.0 
OnlineImportStudentsSurnameVARCHAR(30)  YesYes v3.0Yes
OnlineImportStudentsPreferredVARCHAR(20)  YesYes v3.0Yes
OnlineImportStudentsGiven1VARCHAR(20)  YesYes v3.0Yes
OnlineImportStudentsGiven2VARCHAR(50)  YesYes v3.0Yes
OnlineImportStudentsBirthDateDATETIME  YesYes v3.0Yes
OnlineImportStudentsGenderVARCHAR(1)  YesYesHard-coded values : M, Fv3.0Yes
OnlineImportStudentsCountryOfBirthCodeVARCHAR(15)luCountryLookupCountryYesNo v3.2Yes
OnlineImportStudentsCategoryVARCHAR(5)  YesYes v3.0 
OnlineImportStudentsEnquiryDateDATETIME  YesYes

Not required.

Propagated via the OnlineImportApplication > EnquiryDate

v3.0Default to today
OnlineImportStudentsApplicationDateDATETIME  YesNo v3.0Default to today
OnlineImportStudentsEnrolDateDATETIME  YesYesDefaults to 01/01/{next year} during creation process if not suppliedv3.0Yes
OnlineImportStudentsStatusVARCHAR(5)luFutureStatusLookupFutureStatus YesNo v3.0 
OnlineImportStudentsPriorityVARCHAR(3)luFuturePriorityLookupFuturePriorityYesYes v3.0 
OnlineImportStudentsCampusVARCHAR(3)luCampusLookupCampus YesYes v3.0Yes
OnlineImportStudentsYearLevelINTluYearLevelLookupYearLevel YesYes v3.0Yes
OnlineImportStudentsHouseVARCHAR(5)luHouseLookupHouse YesYes v3.0 
OnlineImportStudentsFormVARCHAR(15)luFormLookupForm YesYes v3.0 
OnlineImportStudentsTutorVARCHAR(15)luTutorLookupTutor YesYes v3.0 
OnlineImportStudentsSuppEnrolDate1DATETIMEluCampusLookupCampus YesYes v3.0 
OnlineImportStudentsSuppCampus1VARCHAR(3)  YesYes v3.0 
OnlineImportStudentsSuppYearLevel1INTluYearLevelLookupYearLevel YesYes v3.0 
OnlineImportStudentsSuppEnrolDate2DATETIMEApplicationID YesYes v3.0 
OnlineImportStudentsSuppCampus2VARCHAR(3)luCampusLookupCampus YesYes v3.0 
OnlineImportStudentsSuppYearLevel2INTluYearLevelLookupYearLevel YesYes v3.0 
OnlineImportStudentsBoarderVARCHAR(3)luBoarderLookupBoarder YesYes v3.0 
OnlineImportStudentsOperatorVARCHAR(30)  YesNo v3.0 
OnlineImportStudentsCourseClassificationCodeVARCHAR(8)luCourseClassificationLookupCourseClassificationYesNo v3.0 
OnlineImportStudentsEnquirySourceVARCHAR(10)luEnquirySourceLookupEnquirySourceYesYes v3.0Yes
OnlineImportStudentsEnquirySourceCommentVARCHAR(50)  YesYes v3.0Yes
OnlineImportStudentsEnquiryCampaignCodeVARCHAR(15)luEnquiryCampaignLookupEnquiryCampaignYesYes v3.0 
OnlineImportStudentsPreviousSchoolVARCHAR(15)luSchoolLookupSchool YesYes v3.0Yes
OnlineImportStudentsMedicalAlertVARCHAR(2000)  YesNo v3.0 
OnlineImportStudentsExternalStudentFlagBIT  YesNo v3.0 
OnlineImportStudentsEnquirerIsContactFlagBIT  YesYes v3.0 
OnlineImportStudentsEnglishSecondFlagBIT  YesNo v3.0 
OnlineImportStudentsDisabilityFlagBIT  YesNo v3.0 
OnlineImportStudentsFullFeeFlagBIT  YesNo v3.0 
OnlineImportStudentsTuitionVariationTypeVARCHAR(3)luTuitionVariationLookupTuitionVariation YesNo v3.0 
OnlineImportStudentsTuitionNoSibFlagBIT  YesNo v3.0 
OnlineImportStudentsPhotoSubmittedFlagBIT  YesNo v3.0 
OnlineImportStudentsBirthCertificateFlagBIT  YesNo v3.0 
OnlineImportStudentsNonResidentFlagBIT  YesNo v3.0 
OnlineImportStudentsImmunisedFlagBIT  YesNo v3.0 
OnlineImportStudentsCrecheFlagBIT  YesNo v3.0 
OnlineImportStudentsBeforeSchoolCareFlagBIT  YesNo v3.0 
OnlineImportStudentsAfterSchoolCareFlagBIT  YesNo v3.0 
OnlineImportStudentsVisaTypeVARCHAR(5)luVisaLookupVisaYesNo v3.0 
OnlineImportStudentsVisaExpiryDateDATETIME  YesNo v3.0 
OnlineImportStudentsPassportNoVARCHAR(15)  YesNo v3.0 
OnlineImportStudentsCommentVARCHAR(MAX)  YesNo v3.0 
OnlineImportStudentsCommentWarningFlagBIT  YesNo v3.0 
OnlineImportStudentsDebtorPrimaryOnlyFlagBIT  YesNo v3.0 
OnlineImportStudentsStudentBillingFlagBIT  YesNo v3.0 
OnlineImportStudentsIBFlagBIT  NoNoDeprecated, now reference the LearningPathway field n/a 
OnlineImportStudentsLearningPathwayVARCHAR(30)luLearningPathwayLookupLearningPathwayYesYes
v69
OnlineImportStudentsVisaNumberVARCHAR(20)  YesNo v3.0Yes
OnlineImportStudentsPassportCountryCodeVARCHAR(5)luCountryLookupCountryYesNo v3.0Yes
OnlineImportStudentsPassportExpiryDateDATETIME  YesNo v3.0Yes
OnlineImportStudentsBaptismFlagBIT  YesNo v3.0 
OnlineImportStudentsBaptismDateDATETIME  YesNo v3.0 
OnlineImportStudentsReconciliationFlagBIT  YesNo v3.0 
OnlineImportStudentsReconciliationDateDATETIME  YesNo v3.0 
OnlineImportStudentsCommunionFlagBIT  YesNo v3.0 
OnlineImportStudentsCommunionDateDATETIME  YesNo v3.0 
OnlineImportStudentsConfirmationFlagBIT  YesNo v3.0 
OnlineImportStudentsConfirmationDateDATETIME  YesNo v3.0 
OnlineImportStudentsAllowAutoChargesFlagBIT  YesNo v3.0 
OnlineImportStudentsAllowAutoTuitionFlagBIT  YesNo v3.0 
OnlineImportStudentsAltCodeVARCHAR(15)  YesNo v3.0 
OnlineImportStudentsAustudyFlagBIT  YesNo v3.0 
OnlineImportStudentsLockerBookVARCHAR(15)luLockerLookupLockerYesNo v3.0 
OnlineImportStudentsLockerOtherVARCHAR(15)luLockerLookupLockerYesNo v3.0 
OnlineImportStudentsDoctorNameVARCHAR(80)  YesNo v3.0 
OnlineImportStudentsDoctorPhoneVARCHAR(15)  YesNo v3.0 
OnlineImportStudentsDoctorPhoneAltVARCHAR(15)  YesNo v3.0 
OnlineImportStudentsDoctorAddressVARCHAR(200)  YesNo v3.0 
OnlineImportStudentsDoctorSpecialisationVARCHAR(50)  YesNo v3.0 
OnlineImportStudentsDoctor2NameVARCHAR(80)  YesNo v3.0 
OnlineImportStudentsDoctor2PhoneVARCHAR(15)  YesNo v3.0 
OnlineImportStudentsDoctor2PhoneAltVARCHAR(15)  YesNo v3.0 
OnlineImportStudentsDoctor2AddressVARCHAR(200)  YesNo v3.0 
OnlineImportStudentsDoctor2SpecialisationVARCHAR(50)  YesNo v3.0 
OnlineImportStudentsDentistNameVARCHAR(80)  YesNo v3.0 
OnlineImportStudentsDentistPhoneVARCHAR(15)  YesNo v3.0 
OnlineImportStudentsDentistPhoneAltVARCHAR(15)  YesNo v3.0 
OnlineImportStudentsDentistAddressVARCHAR(200)  YesNo v3.0 
OnlineImportStudentsEmergencyNameVARCHAR(80)  YesNo v3.0 
OnlineImportStudentsEmergencyAddressVARCHAR(200)  YesNo v3.0 
OnlineImportStudentsEmergencyPhoneVARCHAR(15)  YesNo v3.0 
OnlineImportStudentsEmergencyPhoneAltVARCHAR(15)  YesNo v3.0 
OnlineImportStudentsEmergencyRelatVARCHAR(5)luRelationshipLookupRelationshipYesNo v3.0 
OnlineImportStudentsEmergency2NameVARCHAR(80)  YesNo v3.0 
OnlineImportStudentsEmergency2AddressVARCHAR(200)  YesNo v3.0 
OnlineImportStudentsEmergency2PhoneVARCHAR(15)  YesNo v3.0 
OnlineImportStudentsEmergency2PhoneAltVARCHAR(15)  YesNo v3.0 
OnlineImportStudentsEmergency2RelatVARCHAR(5)luRelationshipLookupRelationshipYesNo v3.0 
OnlineImportStudentsEmergency3NameVARCHAR(80)  YesNo v3.0 
OnlineImportStudentsEmergency3AddressVARCHAR(200)  YesNo v3.0 
OnlineImportStudentsEmergency3PhoneVARCHAR(15)  YesNo v3.0 
OnlineImportStudentsEmergency3PhoneAltVARCHAR(15)  YesNo v3.0 
OnlineImportStudentsEmergency3RelatVARCHAR(5)luRelationshipLookupRelationshipYesNo v3.0 
OnlineImportStudentsIndigenousFlagBIT  YesNo v3.0 
OnlineImportStudentsNaturalisationDateDATETIME  YesNo v3.0 
OnlineImportStudentsStudiesCodeVARCHAR(15)  YesNo v3.0 
OnlineImportStudentsTimetableCodeVARCHAR(15)  YesNo v3.0 
OnlineImportStudentsMedicalAlertFlagBIT  YesNo v3.0 
OnlineImportStudentsSpecialNeedsFlagBIT  YesNo v3.0 
OnlineImportStudentsSpecialBillingTypeVARCHAR(5)  YesNo v3.0 
OnlineImportStudentsStudyAtHomeFlagBIT  YesNo v3.0 
OnlineImportStudentsTSIFlagBIT  YesNo v3.0 
OnlineImportStudentsESLProficiencyLevelVARCHAR(15)luESLProficiencyLevelLookupESLProficiencyLevelYesNo v3.0 
OnlineImportStudentsTertiaryRegistrationCodeVARCHAR(15)  YesNo v3.0 
OnlineImportStudentsPreEntryCommentVARCHAR(MAX)  YesNo v3.0 
OnlineImportStudentsBoardingHouseVARCHAR(15)luBoardingHouseLookupBoardingHouseYesNo v3.0 
OnlineImportStudentsIntendsTertiaryFlagBIT  YesNo v3.0 
OnlineImportStudentsPassportIssuedDateDATETIME  YesNo v3.0 
OnlineImportStudentsVisaIssuedDateDATETIME  YesNo v3.0 
OnlineImportStudentsPriorityOverrideFlagBIT  YesNo v3.0 
OnlineImportStudentsTravelAllowanceFlagBIT  YesNo v3.0 
OnlineImportStudentsFundingApplicationFlagBIT  YesNo v3.0 
OnlineImportStudentsStudentXMLVARCHAR(MAX)  YesNoLegacy storage for custom values - now placed in OnlineImportStudentsCustomv3.0 
OnlineImportStudentsApplicationIDINT  n/an/aManufacturedv3.0 
OnlineImportStudentsStudentStatusVARCHAR(15)luEnquiryStudentStatusLookupEnquiryStudentStatusYesYes v3.0 
OnlineImportStudentsIntendedTertiaryCourseCodeVARCHAR(15)luTertiaryCourseLookupTertiaryCourseYesNo v3.3 
OnlineImportStudentsCountryOfApplicationCode VARCHAR(5)luCountryLookupCountryYesNo v3.3Yes
OnlineImportStudentsDebtorIDINT  YesNo v3.3 
OnlineImportStudentsReligionCodeVARCHAR(5)luReligionLookupReligionYesYes v3.4 
OnlineImportStudentsParishCodeVARCHAR(5)luParishLookupParishYesYes v3.4 
OnlineImportStudentsNationalityCodeVARCHAR(5)luNationalityLookupNationalityYesNo
v68
OnlineImportStudentsHomeLanguageCodeVARCHAR(5)luLanguageLookupLanguageYesNo
v68
OnlineImportStudents> CustomFieldFieldNameVARCHAR(50)    *NOTE* Any data here needs to be managed within a user stored procedurev3.3 
OnlineImportStudents > CustomFieldFieldDataVARCHAR(MAX)     v3.3 
OnlineImportContactsApplicationIDINT  n/an/aManufacturedv3.0 
OnlineImportContactsContactTypeCodeVARCHAR(3)luContactLookupContactYesNoCan be predefined or generated on insert (SC1, SC2, etc)v3.3 
OnlineImportContactsCommunityIDINT  YesYesOptional, if populated will use existing community record informationv3.3 
OnlineImportContactsSurnameVARCHAR(30)  YesYes v3.0Yes
OnlineImportContactsTitleVARCHAR(30)luTitleLookupTitleYesYes v3.0Yes
OnlineImportContactsSuffixVARCHAR(20)  YesNo v3.0 
OnlineImportContactsPreferredVARCHAR(20)  YesYes v3.0Yes
OnlineImportContactsGiven1VARCHAR(20)  YesYes v3.0Yes
OnlineImportContactsGiven2VARCHAR(50)  YesYes v3.0Yes
OnlineImportContactsGenderVARCHAR(1)  YesYesHard-coded values : M, Fv3.0Yes
OnlineImportContactsCountryOfBirthCodeVARCHAR(15)luCountryLookupCountryYesYes v3.2Yes
OnlineImportContactsMobilePhoneVARCHAR(15)  YesYesIs mapped to MobilePhoneActualv3.0Yes
OnlineImportContactsSilentMobilePhoneFlagBIT  YesNo v3.3 
OnlineImportContactsEmailVARCHAR(100)  YesYes v3.0Yes
OnlineImportContactsOccupPhoneVARCHAR(15)  YesYes v3.0Yes
OnlineImportContactsOccupCodeVARCHAR(8)luOccupationLookupOccupationYesNo v3.3 
OnlineImportContactsOccupCompanyVARCHAR(50)  YesNo v3.0Yes
OnlineImportContactsOccupDescVARCHAR(50)  YesNo v3.0 
OnlineImportContactsOccupIndustryCodeVARCHAR(8)luIndustryLookupIndustryYesNo v3.3 
OnlineImportContactsOccupPositionCodeVARCHAR(8)luOccupationPositionLookupOccupationPositionYesNo v3.3 
OnlineImportContactsOccupFaxVARCHAR(15)  YesNo v3.3 
OnlineImportContactsOccupEmailVARCHAR(100)  YesNo v3.3 
OnlineImportContactsOccupMobilePhoneActualVARCHAR(15)  YesNo v3.3 
OnlineImportContactsSilentOccupMobilePhoneFlagBIT  YesNo v3.3 
OnlineImportContactsRelationshipToStudentVARCHAR(5)luRelationshipLookupRelationshipYesYesNeeded to establish relationship with student, inferred when manually importedv3.3 
OnlineImportContactsRelationshipToSpouseVARCHAR(5)luRelationshipLookupRelationshipYesYesNeeded to establish relationship with spouse, inferred when manually importedv3.3 
OnlineImportContactsReligionCodeVARCHAR(5)luReligionLookupReligionYesYes v3.4 
OnlineImportContactsParishVARCHAR(5)luParishLookupParishYesNo v3.4 
OnlineImportContactsBirthdateDATETIME  YesNo v3.4 
OnlineImportContactsSpouseIDINT  YesYesOptional, if populated will use existing community record informationv3.0 
OnlineImportContactsSpouseSurnameVARCHAR(30)  YesYes v3.0Yes
OnlineImportContactsSpouseTitleVARCHAR(30)luTitleLookupTitleYesYes v3.0Yes
OnlineImportContactsSpouseSuffixVARCHAR(20)  YesYes v3.0 
OnlineImportContactsSpousePreferredVARCHAR(20)  YesYes v3.0Yes
OnlineImportContactsSpouseGiven1VARCHAR(20)  YesYes v3.0Yes
OnlineImportContactsSpouseGiven2VARCHAR(50)  YesYes v3.0Yes
OnlineImportContactsSpouseGenderVARCHAR(1)  YesYesHard-coded values : M, Fv3.0Yes
OnlineImportContactsSpouseCountryOfBirthCodeVARCHAR(15)luCountryLookupCountryYesNo v3.2Yes
OnlineImportContactsSpouseMobilePhoneVARCHAR(15)  YesYesIs mapped to MobilePhoneActualv3.0Yes
OnlineImportContactsSpouseSilentMobilePhoneFlagBIT  YesNo v3.3 
OnlineImportContactsSpouseEmailVARCHAR(100)  YesYes v3.0Yes
OnlineImportContactsSpouseOccupPhoneVARCHAR(15)  YesYes v3.0Yes
OnlineImportContactsSpouseOccupCodeVARCHAR(8)luOccupationLookupOccupationYesNo v3.3 
OnlineImportContactsSpouseOccupCompanyVARCHAR(50)  YesNo v3.3Yes
OnlineImportContactsSpouseOccupDescVARCHAR(50)  YesNo v3.3 
OnlineImportContactsSpouseOccupIndustryCodeVARCHAR(8)luIndustryLookupIndustryYesNo v3.3 
OnlineImportContactsSpouseOccupPositionCodeVARCHAR(8)luOccupationPositionLookupOccupationPositionYesNo v3.3 
OnlineImportContactsSpouseOccupFaxVARCHAR(15)  YesNo v3.3 
OnlineImportContactsSpouseOccupEmailVARCHAR(100)  YesNo v3.3 
OnlineImportContactsSpouseOccupMobilePhoneActualVARCHAR(15)  YesNo v3.3 
OnlineImportContactsSpouseSilentOccupMobilePhoneFlagBIT  YesNo v3.3 
OnlineImportContactsSpouseRelationshipToStudentVARCHAR(5)luRelationshipLookupRelationshipYesYesNeeded to establish relationship with student, inferred when manually importedv3.3 
OnlineImportContactsSpouseRelationshipToSpouseVARCHAR(5)luRelationshipLookupRelationshipYesYesNeeded to establish relationship with spouse, inferred when manually importedv3.3 
OnlineImportContactsSpouseReligionVARCHAR(5)luReligionLookupReligionYesYes v3.4 
OnlineImportContactsSpouseParishVARCHAR(5)luParishLookupParishYesNo v3.4 
OnlineImportContactsSpouseDOBDATETIME  YesNo v3.4 
OnlineImportContactsAddressIDINT  YesYesNot requiredv3.0 
OnlineImportContacts > AddressAddressTypeVARCHAR  YesYes

P = Postal, H = Home, O = Occupation [Please use 'P' as a default]

NOTE Having a H value here will automatically set the HomeAddressSameFlag to false

v3.3Yes
OnlineImportContacts > AddressAddressContactVARCHAR  YesYes

P = Primary, S = Spouse [Please use 'P' as a default]

NOTE Spouse address will always be inferred as the same address of the primary contact and does not need to be passed separately- The only requirement to pass the 'S' value here is for a spousal occupation address ONLY

v3.3Yes
OnlineImportContacts > AddressAddress1VARCHAR(40)  YesYes v3.0Yes
OnlineImportContacts > AddressAddress2VARCHAR(40)  YesYes v3.0Yes
OnlineImportContacts > AddressAddress3VARCHAR(40)  YesYes v3.0Yes
OnlineImportContacts > AddressSuburbVARCHAR(40)  YesYes v3.0Yes
OnlineImportContacts > AddressStateVARCHAR(5)luStateLookupStateYesYes v3.0Yes
OnlineImportContacts > AddressCountryCodeVARCHAR(5)luCountryLookupCountryYesYes v3.0Yes
OnlineImportContacts > AddressPostCodeVARCHAR(5)  YesYes v3.0Yes
OnlineImportContacts > AddressPhoneVARCHAR(15)  YesYesNOTE Valid for AddressType = HomeAddress onlyv3.0Yes
OnlineImportContacts > AddressPhoneAltVARCHAR(15)  YesYesNOTE Valid for AddressType = HomeAddress onlyv3.0Yes
OnlineImportContacts > AddressFaxVARCHAR(15)  YesYesNOTE Valid for AddressType = HomeAddress onlyv3.0Yes
OnlineImportContactsPrimaryOnlyFlagBIT  YesNo

Can be defaulted on transfer using:

  • OnlineApplications|Defaults|PrimaryOnlyFlag (default True)
v3.3 
OnlineImportContactsNormalMailFlagBIT  YesNo

Can be defaulted on transfer using:

  • OnlineApplications|Defaults|NormalMailFlag (default True)
v3.3 
OnlineImportContactsReportsFlagBIT  YesNo

Can be defaulted on transfer using:

  • OnlineApplications|Defaults|ReportsFlag (default True)
v3.3 
OnlineImportContactsParentFlagBIT  YesNo

Can be defaulted on transfer using:

  • OnlineApplications|Defaults|ParentFlag (default True)
v3.3 
OnlineImportContactsLivesWithFlagBIT  YesNo

Can be defaulted on transfer using:

  • OnlineApplications|Defaults|LivesWithFlag (default True)
v3.3 
OnlineImportContactsIsDebtorFlagBIT  YesNoOptional, set if contact is the student debtor. Default debtor is the first student contact if not set.v3.3 
OnlineImportContacts > CustomFieldFieldNameVARCHAR(50)    *NOTE* Any data here needs to be managed within a user stored procedurev3.3 
OnlineImportContacts > CustomFieldFieldDataVARCHAR(MAX)     v3.3 
OnlineImportContactsContactXMLVARCHAR(MAX)  NoYesLegacy storage for custom values v3.0 
OnlineImportApplicationsApplicationID   INT  YesYesOptional application number from source datav3.0 
OnlineImportApplicationsApplicationTypeCodeVARCHAR  YesYesRequired, used to determine what buttons show for a given record

Hard-coded values : ENQ, FUT, {blank}
v3.1 
OnlineImportApplicationsApplicationDateDATETIME  YesYes v3.0 
OnlineImportApplicationsEnquiryDateDATETIME

YesYesWill propagate to all student nodes
Default to today
OnlineImportApplicationsBillingEmailAddressVARCHAR(100)  YesYesNon functional, can be optionally importedv3.0 
OnlineImportApplicationsApplicationAmountMONEY  YesYes v3.0 
OnlineImportApplicationsPaymentTransactionCodeVARCHAR(1000)  YesYesNon functional, can be optionally importedv3.0 
OnlineImportApplicationsPaymentResponseCodeVARCHAR(1000)  YesYesNon functional, can be optionally importedv3.0 
OnlineImportApplicationsPaymentResponseTextVARCHAR(1000)  YesYesNon functional, can be optionally importedv3.0 
OnlineImportApplicationsPaymentErrorVARCHAR(1000)  YesYesNon functional, can be optionally importedv3.0 
OnlineImportApplicationsAgentIDINT  YesYes v3.1 
OnlineImportApplicationsApplicationStatusVARCHAR(15)luOnlineApplicationStatus YesYesDefault this to record where SynergyMeaning is 'Pending'v3.0 
OnlineImportApplications > CustomFieldFieldNameVARCHAR(50)    *NOTE* Any data here needs to be managed within a user stored procedurev3.3 
OnlineImportApplications > CustomFieldFieldDataVARCHAR(MAX)     v3.3 
OnlineImportApplicationsApplicationDocumentXMLVARCHAR(MAX)  n/an/aStorage of application XML for achival purposesv3.0 
OnlineImportApplicationsFamilyBasedFeeFlagBIT  YesNoRequired to show as TRUE if transacting an amount per application vs per studentv3.3

Sample XML Import Data

  • No labels