Export Student Addresses

Column	Heading	Description
A	DFKey	Synergetic 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_Phone	Home 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	Silent	Whether 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_Fax	Home 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_Email	Home 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_Building	Building type of the home address of the student.
		Configuration
		Optional
		This field is defined using the Line 1 field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab. This field has a maximum length of 40 characters. Note: Synergetic does not store specific building, number and street values, but derives them from the Line 1 and Line 2 fields.
G	Home_Number	Street 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_Street	Street 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_Suburb	Suburb of the home address of the student.
		Configuration
		Mandatory
		This field is defined using the Suburb field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab. This field has a maximum length of 30 characters.
J	Home_State	State where the home address of the student is located.
		Configuration
		Mandatory
		This field is defined using the State field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab. This field has a maximum length of 3 characters.
K	Home_PCode	Postcode of the home address of the student.
		Configuration
		Mandatory
		This field is defined using the Postcode field on the Home Address tab of Community Maintenance. See Community Maintenance - Home Address tab. This field has a maximum length of 4 characters.
L	Mail_Building	Building type of the postal address of the student.
		Configuration
		Optional
		This field is defined using the Line 1 field on the Postal Address tab of Community Maintenance. See Community Maintenance - Postal Address tab. This field has a maximum length of 40 characters. Note: Synergetic does not store specific building, number and street values, but derives them from the Line 1 and Line 2 fields.
M	Mail_Number	Street number of the postal address of the student.
		Configuration
		Optional
		This field is defined using the Line 1 and Line 2 fields on the Postal Address tab of Community Maintenance. See Community Maintenance - Postal 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.
N	Mail_Street	Street of the postal address of the student.
		Configuration
		Optional
		This field is defined using the Line 1 and Line 2 fields on the Postal Address tab of Community Maintenance. See Community Maintenance - Postal 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.
O	Mail_Suburb	Suburb of the postal address of the student.
		Configuration
		Optional
		This field is defined using the Suburb field on the Postal Address tab of Community Maintenance. See Community Maintenance - Postal Address tab. This field has a maximum length of 30 characters.
P	Mail_State	State where the postal address of the student is located.
		Configuration
		Optional
		This field is defined using the State field on the Postal Address tab of Community Maintenance. See Community Maintenance - Postal Address tab. This field has a maximum length of 3 characters.
Q	Mail_PCode	Postcode of the postal address of the student.
		Configuration
		Optional
		This field is defined using the Postcode field on the Postal Address tab of Community Maintenance. See Community Maintenance - Postal Address tab. This field has a maximum length of 4 characters.
R	LastGetDate	Current date and time.