Everything in between the pound signs will be replaced with the appropriate data.
Student Fields
Student Full Name (last, first) -------------------------------- #student#
Student Full Name (first last) --------------------------------- #firstlast#
Student First Name --------------------------------------------- #first#
Student Last Name ---------------------------------------------- #last#
Student ID ----------------------------------------------------- #studentID#
Student Formatted ID ------------------------------------------- #formattedID#
Student Other ID ----------------------------------------------- #barcode#
Student Handle ------------------------------------------------- #Account#
Student Street ------------------------------------------------- #Address#
Student City --------------------------------------------------- #City#
Student State -------------------------------------------------- #State#
Student Zip ---------------------------------------------------- #Zip#
Student Street, City, State, Zip ------------------------------- #fullAddress#
Student Email -------------------------------------------------- #studentEmail#
Student Home Phone --------------------------------------------- #phone#
Student Work Phone --------------------------------------------- #phone2#
Student Text Message Address ---------------------------------- #txtMsgAddress#
Student Gender ------------------------------------------------- #gender#
Student Birthdate ---------------------------------------------- #birthdate#
Student Ethnicity ---------------------------------------------- #ethnicity#
Student Class -------------------------------------------------- #class#
Student College ------------------------------------------------ #college#
Student Cohort ------------------------------------------------- #cohort#
Student Major -------------------------------------------------- #major#
Student Grad_Und ----------------------------------------------- #gradund#
Student GPA ---------------------------------------------------- #GPA#
Student Accumulated Hours -------------------------------------- #TotalHours#
Student Graduation Date ---------------------------------------- #GradDate#
Student Graduation Degree -------------------------------------- #GradDegree#
Student Condition Code ----------------------------------------- #CondCode#
Student Flag Text ---------------------------------------------- #FlagText#
Student Special Status ----------------------------------------- #status#
Student ReferredBy --------------------------------------------- #referredby#
Student HS Name ------------------------------------------------ #HSName#
Student Degree Goal -------------------------------------------- #degree#
Student Custom Field1 ------------------------------------------ #Field1#
Student Custom Field2 ------------------------------------------ #Field2#
Student Custom Field3 ------------------------------------------ #Field3#
Student Custom Field4 ------------------------------------------ #Field4#
Student Custom Field5 ------------------------------------------ #Field5#
Student Custom Field6 ------------------------------------------ #Field6#
Student Custom Field7 ------------------------------------------ #Field7#
Student Custom Field8 ------------------------------------------ #Field8#
Student Custom Field9 ------------------------------------------ #Field9#
Student Custom Field10 ----------------------------------------- #Field10#
Consultant Fields
Consultant Full Name ------------------------------------------- #tutor#
Consultant Full Name ------------------------------------------- #advisor#
Consultant Full Name ------------------------------------------- #counselor#
Consultant Full Name ------------------------------------------- #Staff#
Consultant First Name ------------------------------------------ #afirst#
Consultant First Name ------------------------------------------ #tfirst#
Consultant Last Name ------------------------------------------- #alast#
Consultant Last Name ------------------------------------------- #tlast#
Consultant Alternate Name -------------------------------------- #AltName#
Consultant Email ----------------------------------------------- #tutoremail#
Consultant Email ----------------------------------------------- #advisoremail#
Consultant Email ----------------------------------------------- #staffemail#
Consultant Phone ----------------------------------------------- #tutorPhone#
Consultant Phone ----------------------------------------------- #advisorPhone#
Consultant Phone ----------------------------------------------- #staffPhone#
Consultant CellPhone ------------------------------------------- #tutorPhone2#
Consultant CellPhone ------------------------------------------- #tutorCellPhone#
Consultant CellPhone ------------------------------------------- #advisorCellPhone#
Consultant CellPhone ------------------------------------------- #staffCellPhone#
Consultant WorkPhone ------------------------------------------- #tutorWorkPhone#
Consultant WorkPhone ------------------------------------------- #advisorWorkPhone#
Consultant Pager ----------------------------------------------- #tutorPager#
Consultant Pager ----------------------------------------------- #advisorPager#
Consultant Pager ----------------------------------------------- #staffPager#
Consultant Location -------------------------------------------- #tLocation#
Consultant Location -------------------------------------------- #aLocation#
Consultant Location -------------------------------------------- #sLocation#
Consultant Notes2 ---------------------------------------------- #tutorNotes#
Consultant Notes2 ---------------------------------------------- #advisorNotes#
Consultant Notes2 ---------------------------------------------- #staffNotes#
Current Date Fields
Current Date --------------------------------------------------- #date#
Current Time --------------------------------------------------- #time#
Current Day of Week -------------------------------------------- #apptday#
Appointment Fields
Appointment Location ------------------------------------------- #apptlocation#
Appointment Status --------------------------------------------- #ApptStatus#
Appointment Full Date ------------------------------------------ #apptfulldate#
Appointment Date ----------------------------------------------- #apptdate#
Appointment Time ----------------------------------------------- #appttime#
Recurring Appointment Start Date ------------------------------- #firstApptDate#
Recurring Appointment End Date --------------------------------- #lastApptDate#
Appointment Start Time ----------------------------------------- #apptstarttime#
Appointment End Time ------------------------------------------- #apptendtime#
Appointment Day of Week ---------------------------------------- #apptday#
Appointment Center --------------------------------------------- #apptcenter#
Appointment Subject -------------------------------------------- #apptsubject#
Appointment Reason -------------------------------------------- #apptreason#
Appointment Notes ---------------------------------------------- #apptnotes#
Appointment Duration ------------------------------------------- #apptduration#
Appointment Custom Field --------------------------------------- #apptCust1#
Appointment Fund ----------------------------------------------- #apptfund#
Appointment Total Missed --------------------------------------- #missedApptTotal#
Availability Fields
Availability Location ------------------------------------------ #availlocation#
Center Fields
Center Name ---------------------------------------------------- #center#
Center Sequence ------------------------------------------------ #centerID#
Profile Name --------------------------------------------------- #profileCenter#
Survey Fields
Survey Response Sequence --------------------------------------- #responseID#
Survey Sequence ------------------------------------------------ #surveyID#
Visits Fields
Visit Date In -------------------------------------------------- #dateIn#
Visit Date Out ------------------------------------------------- #dateOut#
Visit Time In -------------------------------------------------- #visitTime#
Visit Time Out ------------------------------------------------- #timeOut#
Visit Total Time ----------------------------------------------- #duration#
Visit Day of Week ---------------------------------------------- #visitday#
Visit Subject -------------------------------------------------- #subject#
Visit Reason --------------------------------------------------- #reason#
Visit Custom Field1 -------------------------------------------- #Custom1#
Visit Custom Field2 -------------------------------------------- #Custom2#
Visit Custom Field3 -------------------------------------------- #Custom3#
Visit Custom Field4 -------------------------------------------- #Custom4#
Visit Custom Field5 -------------------------------------------- #Custom5#
Visit Custom Field6 -------------------------------------------- #Custom6#
Visit Custom Field7 -------------------------------------------- #Custom7#
Visit Custom Field8 -------------------------------------------- #Custom8#
Visit Notes ---------------------------------------------------- #visitnotes#
Visit Student Remarks ------------------------------------------ #visitStudRemarks#
Resources
Resource Barcode ----------------------------------------------- #resID#
Resource Title ------------------------------------------------- #resTitle#
Resource Description ------------------------------------------- #resDescrioon#
Resource Due Date ---------------------------------------------- #resDueDate#
Resource LastDateOut ------------------------------------------- #resDateOut#
Resource LastTimeOut ------------------------------------------- #resTimeOut#
|