Export Student Addresses

Owned by Richard Kennedy (Unlicensed)
Last updated: Jan 10, 2024 by Graham Kidd
4 min read

ColumnHeadingDescription
A

DFKeySynergetic ID assigned to the primary student contact.
Configuration
Mandatory
  • This field is defined using the ID field of the SC1 contact on the Contacts tab of Current Student Maintenance. See Current Student Maintenance - Contacts tab.
  • This field has a maximum field length of 7 characters.

Note: A single row in the export student addresses table may contain the address of more than one student. For instance, siblings living with the same Primary Contact (eg parent) will all use the address of the parent.

To allow identifying the address of a student across the Export Students and Export Student Addresses tables, a join across xeACT_ST_TFR (Export Students) and xeACT_ST_TFR (Export Student Addresses) is made on the fields xeACT_ST_TFR.Family to xeACT_Student_Address_TFR.DFKey.

B

Home_PhoneHome phone number of the student.
Configuration
Optional
  • This field is defined using the Phone field in the Household area on the Phone tab of Community Maintenance. See Community Maintenance - Phone tab.
  • This field has a maximum length of 20 characters.
C

SilentWhether the phone number is not to be listed or made available to other parties.
Configuration
Optional
  • This field is defined using the Silent Phone field in the Household area on the Phone tab of Community Maintenance. See Community Maintenance - Phone tab.
  • This field has a maximum length of 1 character.
  • This field has a value of:

    - Y when the Silent Phone field is selected
    - N when the Silent Phone field is not selected.
D

Home_FaxHome fax number of the student.
Configuration
Optional
  • This field is defined using the Fax field in the Household area on the Phone tab of Community Maintenance. See Community Maintenance - Phone tab.
  • This field has a maximum length of 20 characters.
E

Home_EmailHome email address of the student.Ā 
Configuration
Optional
  • This field is defined using the Email and Default Email fields in the Personal area on the Phone tab of Community Maintenance. See Community Maintenance - Phone tab.
  • This field has a maximum length of 100 characters.
F

Home_BuildingBuilding type of the home address of the student.
Configuration
Optional

Note: Synergetic does not store specific building, number and street values, but derives them from the Line 1 and Line 2 fields.

G

Home_NumberStreet number of the home address of the student.
Configuration
Mandatory
  • This field is defined using the Line 1 and Line 2 fields on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.
  • This field has a maximum length of 7 characters.

Note: Synergetic does not store specific building, number and street values, but derives them from the Line 1 and Line 2 fields.

H

Home_StreetStreet of the home address of the student.
Configuration
Mandatory
  • This field is defined using the Line 1 and Line 2 fields on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab.
  • This field has a maximum length of 44 characters.

Note: Synergetic does not store specific building, number and street values, but derives them from the Line 1 and Line 2 fields.

I

Home_SuburbSuburb of the home address of the student.
Configuration
Mandatory
J

Home_StateState where the home address of the student is located.
Configuration
Mandatory
K

Home_PCodePostcode of the home address of the student.
Configuration
Mandatory
L

Mail_BuildingBuilding type of the postal address of the student.
Configuration
Optional

Note: Synergetic does not store specific building, number and street values, but derives them from the Line 1 and Line 2 fields.

M

Mail_NumberStreet number of the postal address of the student.
Configuration
Optional

Note: Synergetic does not store specific building, number and street values, but derives them from the Line 1 and Line 2 fields.

N

Mail_StreetStreet of the postal address of the student.
Configuration
Optional

Note: Synergetic does not store specific building, number and street values, but derives them from the Line 1 and Line 2 fields.

O

Mail_SuburbSuburb of the postal address of the student.
Configuration
Optional
P

Mail_StateState where the postal address of the student is located.
Configuration
Optional
Q

Mail_PCodePostcode of the postal address of the student.
Configuration
Optional
RLastGetDateCurrent date and time.