Skip to end of banner
Go to start of banner

Online Application XML Import

Skip to end of metadata
Go to start of metadata

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

Compare with Current View Version History

« Previous Version 4 Next »

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

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

InformationNewFieldNameNewFieldTypeluTableLookup Procedure (if exists)FuturesEnquiriesCommentIntroducedTemplate
OnlineImportStudentsIDINT  YesYesWill be blankv3.0 
OnlineImportStudentsContactEnquiryIDINT  YesYesNot requiredv3.0 
OnlineImportStudentsTitleVARCHAR(30)luTitleLookupTitleYesYes 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 v3.0Default to today
OnlineImportStudentsApplicationDateDATETIME  YesNo v3.0Default to today
OnlineImportStudentsEnrolDateDATETIME  YesYes v3.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  YesNo v3.0 
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 
OnlineImportStudentsReligionVARCHAR(5)luParishLookupReligionYesYes v3.4 
OnlineImportStudentsParishVARCHAR(5)luParishLookupParishYesYes v3.4 
 ApplicationFee        
 ApplicationAmount        
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 
OnlineImportContactsReligionVARCHAR(5)luParishLookupReligionYesYes 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)luParishLookupReligionYesYes v3.4 
OnlineImportContactsSpouseParishVARCHAR(5)luParishLookupParishYesNo v3.4 
OnlineImportContactsSpouseDOBDATETIME  YesNo v3.4 
OnlineImportContactsAddressIDINT  YesYesNot requiredv3.0 
OnlineImportContacts > AddressAddressTypeVARCHAR  YesYesP = Postal, H = Home, O = Occupation [DEFAULT P]
NOTE Having a H value here will automatically set the HomeAddressSameFlag to false		v3.3Yes
OnlineImportContacts > AddressAddressContactVARCHAR  YesYesP = Primary, S = Spouse [DEFAULT P]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 v3.3 
OnlineImportContactsNormalMailFlagBIT  YesNo v3.3 
OnlineImportContactsReportsFlagBIT  YesNo v3.3 
OnlineImportContactsParentFlagBIT  YesNo v3.3 
OnlineImportContactsLivesWithFlagBIT  YesNo 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 
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  YesNo v3.3 

Sample XML Import Data

  • No labels