| OnlineImportStudents> CustomField | FieldName | VARCHAR(50) | | | | | *NOTE* Any data here needs to be managed within a user stored procedure | v3.3 | |
| OnlineImportStudents > CustomField | FieldData | VARCHAR(MAX) | | | | | | v3.3 | |
| OnlineImportContacts | ApplicationID | INT | | | n/a | n/a | Manufactured | v3.0 | |
| OnlineImportContacts | ContactTypeCode | VARCHAR(3) | luContact | LookupContact | Yes | No | Can be predefined or generated on insert (SC1, SC2, etc) | v3.3 | |
| OnlineImportContacts | CommunityID | INT | | | Yes | Yes | Optional, if populated will use existing community record information | v3.3 | |
| OnlineImportContacts | Surname | VARCHAR(30) | | | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts | Title | VARCHAR(30) | luTitle | LookupTitle | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts | Suffix | VARCHAR(20) | | | Yes | No | | v3.0 | |
| OnlineImportContacts | Preferred | VARCHAR(20) | | | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts | Given1 | VARCHAR(20) | | | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts | Given2 | VARCHAR(50) | | | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts | Gender | VARCHAR(1) | | | Yes | Yes | Hard-coded values : M, F | v3.0 | Yes |
| OnlineImportContacts | CountryOfBirthCode | VARCHAR(15) | luCountry | LookupCountry | Yes | Yes | | v3.2 | Yes |
| OnlineImportContacts | MobilePhone | VARCHAR(15) | | | Yes | Yes | Is mapped to MobilePhoneActual | v3.0 | Yes |
| OnlineImportContacts | SilentMobilePhoneFlag | BIT | | | Yes | No | | v3.3 | |
| OnlineImportContacts | Email | VARCHAR(100) | | | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts | OccupPhone | VARCHAR(15) | | | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts | OccupCode | VARCHAR(8) | luOccupation | LookupOccupation | Yes | No | | v3.3 | |
| OnlineImportContacts | OccupCompany | VARCHAR(50) | | | Yes | No | | v3.0 | Yes |
| OnlineImportContacts | OccupDesc | VARCHAR(50) | | | Yes | No | | v3.0 | |
| OnlineImportContacts | OccupIndustryCode | VARCHAR(8) | luIndustry | LookupIndustry | Yes | No | | v3.3 | |
| OnlineImportContacts | OccupPositionCode | VARCHAR(8) | luOccupationPosition | LookupOccupationPosition | Yes | No | | v3.3 | |
| OnlineImportContacts | OccupFax | VARCHAR(15) | | | Yes | No | | v3.3 | |
| OnlineImportContacts | OccupEmail | VARCHAR(100) | | | Yes | No | | v3.3 | |
| OnlineImportContacts | OccupMobilePhoneActual | VARCHAR(15) | | | Yes | No | | v3.3 | |
| OnlineImportContacts | SilentOccupMobilePhoneFlag | BIT | | | Yes | No | | v3.3 | |
| OnlineImportContacts | RelationshipToStudent | VARCHAR(5) | luRelationship | LookupRelationship | Yes | Yes | Needed to establish relationship with student, inferred when manually imported | v3.3 | |
| OnlineImportContacts | RelationshipToSpouse | VARCHAR(5) | luRelationship | LookupRelationship | Yes | Yes | Needed to establish relationship with spouse, inferred when manually imported | v3.3 | |
| OnlineImportContacts | Religion | VARCHAR(5) | luParish | LookupReligion | Yes | Yes | | v3.4 | |
| OnlineImportContacts | Parish | VARCHAR(5) | luParish | LookupParish | Yes | No | | v3.4 | |
| OnlineImportContacts | Birthdate | DATETIME | | | Yes | No | | v3.4 | |
| OnlineImportContacts | SpouseID | INT | | | Yes | Yes | Optional, if populated will use existing community record information | v3.0 | |
| OnlineImportContacts | SpouseSurname | VARCHAR(30) | | | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts | SpouseTitle | VARCHAR(30) | luTitle | LookupTitle | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts | SpouseSuffix | VARCHAR(20) | | | Yes | Yes | | v3.0 | |
| OnlineImportContacts | SpousePreferred | VARCHAR(20) | | | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts | SpouseGiven1 | VARCHAR(20) | | | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts | SpouseGiven2 | VARCHAR(50) | | | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts | SpouseGender | VARCHAR(1) | | | Yes | Yes | Hard-coded values : M, F | v3.0 | Yes |
| OnlineImportContacts | SpouseCountryOfBirthCode | VARCHAR(15) | luCountry | LookupCountry | Yes | No | | v3.2 | Yes |
| OnlineImportContacts | SpouseMobilePhone | VARCHAR(15) | | | Yes | Yes | Is mapped to MobilePhoneActual | v3.0 | Yes |
| OnlineImportContacts | SpouseSilentMobilePhoneFlag | BIT | | | Yes | No | | v3.3 | |
| OnlineImportContacts | SpouseEmail | VARCHAR(100) | | | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts | SpouseOccupPhone | VARCHAR(15) | | | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts | SpouseOccupCode | VARCHAR(8) | luOccupation | LookupOccupation | Yes | No | | v3.3 | |
| OnlineImportContacts | SpouseOccupCompany | VARCHAR(50) | | | Yes | No | | v3.3 | Yes |
| OnlineImportContacts | SpouseOccupDesc | VARCHAR(50) | | | Yes | No | | v3.3 | |
| OnlineImportContacts | SpouseOccupIndustryCode | VARCHAR(8) | luIndustry | LookupIndustry | Yes | No | | v3.3 | |
| OnlineImportContacts | SpouseOccupPositionCode | VARCHAR(8) | luOccupationPosition | LookupOccupationPosition | Yes | No | | v3.3 | |
| OnlineImportContacts | SpouseOccupFax | VARCHAR(15) | | | Yes | No | | v3.3 | |
| OnlineImportContacts | SpouseOccupEmail | VARCHAR(100) | | | Yes | No | | v3.3 | |
| OnlineImportContacts | SpouseOccupMobilePhoneActual | VARCHAR(15) | | | Yes | No | | v3.3 | |
| OnlineImportContacts | SpouseSilentOccupMobilePhoneFlag | BIT | | | Yes | No | | v3.3 | |
| OnlineImportContacts | SpouseRelationshipToStudent | VARCHAR(5) | luRelationship | LookupRelationship | Yes | Yes | Needed to establish relationship with student, inferred when manually imported | v3.3 | |
| OnlineImportContacts | SpouseRelationshipToSpouse | VARCHAR(5) | luRelationship | LookupRelationship | Yes | Yes | Needed to establish relationship with spouse, inferred when manually imported | v3.3 | |
| OnlineImportContacts | SpouseReligion | VARCHAR(5) | luParish | LookupReligion | Yes | Yes | | v3.4 | |
| OnlineImportContacts | SpouseParish | VARCHAR(5) | luParish | LookupParish | Yes | No | | v3.4 | |
| OnlineImportContacts | SpouseDOB | DATETIME | | | Yes | No | | v3.4 | |
| OnlineImportContacts | AddressID | INT | | | Yes | Yes | Not required | v3.0 | |
| OnlineImportContacts > Address | AddressType | VARCHAR | | | Yes | Yes | P = Postal, H = Home, O = Occupation [DEFAULT P]
NOTE Having a H value here will automatically set the HomeAddressSameFlag to false | v3.3 | Yes |
| OnlineImportContacts > Address | AddressContact | VARCHAR | | | Yes | Yes | P = Primary, S = Spouse [DEFAULT P] | v3.3 | Yes |
| OnlineImportContacts > Address | Address1 | VARCHAR(40) | | | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts > Address | Address2 | VARCHAR(40) | | | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts > Address | Address3 | VARCHAR(40) | | | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts > Address | Suburb | VARCHAR(40) | | | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts > Address | State | VARCHAR(5) | luState | LookupState | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts > Address | CountryCode | VARCHAR(5) | luCountry | LookupCountry | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts > Address | PostCode | VARCHAR(5) | | | Yes | Yes | | v3.0 | Yes |
| OnlineImportContacts > Address | Phone | VARCHAR(15) | | | Yes | Yes | NOTE Valid for AddressType = HomeAddress only | v3.0 | Yes |
| OnlineImportContacts > Address | PhoneAlt | VARCHAR(15) | | | Yes | Yes | NOTE Valid for AddressType = HomeAddress only | v3.0 | Yes |
| OnlineImportContacts > Address | Fax | VARCHAR(15) | | | Yes | Yes | NOTE Valid for AddressType = HomeAddress only | v3.0 | Yes |
| OnlineImportContacts | PrimaryOnlyFlag | BIT | | | Yes | No | | v3.3 | |
| OnlineImportContacts | NormalMailFlag | BIT | | | Yes | No | | v3.3 | |
| OnlineImportContacts | ReportsFlag | BIT | | | Yes | No | | v3.3 | |
| OnlineImportContacts | ParentFlag | BIT | | | Yes | No | | v3.3 | |
| OnlineImportContacts | LivesWithFlag | BIT | | | Yes | No | | v3.3 | |
| OnlineImportContacts | IsDebtorFlag | BIT | | | Yes | No | Optional, set if contact is the student debtor. Default debtor is the first student contact if not set. | v3.3 | |
| OnlineImportContacts > CustomField | FieldName | VARCHAR(50) | | | | | *NOTE* Any data here needs to be managed within a user stored procedure | v3.3 | |
| OnlineImportContacts > CustomField | FieldData | VARCHAR(MAX) | | | | | | v3.3 | |
| OnlineImportContacts | ContactXML | VARCHAR(MAX) | | | No | Yes | Legacy storage for custom values | v3.0 | |
| OnlineImportApplications | ApplicationID | INT | | | Yes | Yes | Optional application number from source data | v3.0 | |
| OnlineImportApplications | ApplicationTypeCode | VARCHAR | | | Yes | Yes | Required, used to determine what buttons show for a given record
Hard-coded values : ENQ, FUT, {blank} | v3.1 | |
| OnlineImportApplications | ApplicationDate | DATETIME | | | Yes | Yes | | v3.0 | |
| OnlineImportApplications | BillingEmailAddress | VARCHAR(100) | | | Yes | Yes | Non functional, can be optionally imported | v3.0 | |
| OnlineImportApplications | ApplicationAmount | MONEY | | | Yes | Yes | | v3.0 | |
| OnlineImportApplications | PaymentTransactionCode | VARCHAR(1000) | | | Yes | Yes | Non functional, can be optionally imported | v3.0 | |
| OnlineImportApplications | PaymentResponseCode | VARCHAR(1000) | | | Yes | Yes | Non functional, can be optionally imported | v3.0 | |
| OnlineImportApplications | PaymentResponseText | VARCHAR(1000) | | | Yes | Yes | Non functional, can be optionally imported | v3.0 | |
| OnlineImportApplications | PaymentError | VARCHAR(1000) | | | Yes | Yes | Non functional, can be optionally imported | v3.0 | |
| OnlineImportApplications | AgentID | INT | | | Yes | Yes | | v3.1 | |
| OnlineImportApplications | ApplicationStatus | VARCHAR(15) | luOnlineApplicationStatus | | Yes | Yes | Default this to record where SynergyMeaning is 'Pending' | v3.0 | |
| OnlineImportApplications > CustomField | FieldName | VARCHAR(50) | | | | | *NOTE* Any data here needs to be managed within a user stored procedure | v3.3 | |
| OnlineImportApplications > CustomField | FieldData | VARCHAR(MAX) | | | | | | v3.3 | |
| OnlineImportApplications | ApplicationDocumentXML | VARCHAR(MAX) | | | n/a | n/a | Storage of application XML for achival purposes | v3.0 | |
| OnlineImportApplications | FamilyBasedFeeFlag | BIT | | | Yes | No |