Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

How Online Import Application works

 Image RemovedImage Added

  1. Either type or use the Image Removed Image Added button to select an XML file for importing.
  2. Press the Image Removed Image Added 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

 Image RemovedImage Added

 Enrolment Deposit Wizard 


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

...

Table Filter
inversefalse,false,false
default,,
cell-width150,150,150
sparkNameSparkline
userfilterNewFieldName,NewFieldType
columnInformation
datepatterndd/mm/yy
id1494912324168_1888693738
isORAND
separatorPoint (.)
labelsInformation‚NewFieldName‚NewFieldType
order0,1,2


Note

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

 Yes 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)luEnquiryStudentStatusluOnlineApplicationStudentStatusLookupEnquiryStudentStatusYesYes The 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  BIT

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


...