Skip to end of metadata
Go to start of metadata

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)luOnlineApplicationStudentStatusLookupEnquiryStudentStatusYesYesThe lookup table values in Synergetic have a ‘SynergyMeaning’ so the code against the ‘Pending’ value will be inferred on loadv3.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