TracCloud: Rosetta

TracCloud: Table and Field List

This article lists fields in TracCloud grouped by table. For each field, it will show the data type, description, how the field is accessible in Twig, the API, as well as how it displays in the SFTP data export.

Tips

• Hover over the field name to see an example value.

• Click the header to sort by that column, shift-click to sort by multiple.

Type Definitions

Expand

Type	Description
varchar(#)	Alphanumeric field with a specified maximum length.
int	Integer, maximum value of about 4 billion, or a 10-digit numeric value.
bigint	Big integer, maximum value of about 9 quintillion, or a 16-digit numeric value.
tinyint	Tiny integer, typically used to store a 1 or 0 as true or false.
date	Date, formatted as YYYY-MM-DD
time	A specific time using a 24-hour format (HH:MM:SS), e.g., 13:45:00
datetime	Date and time, YYYY-MM-DD HH:MM:SS
double	Decimal # with up to 12 digits precision
json	JSON-formatted field that contains multiple fields and values (e.g., custom fields).

Invert All Visibility

---

Students

Toggle Visibility

Field	Type	Description	Twig	API	SFTP Export
Sequence	bigint	Static identifier for students, unrelated to ID.		Students.Sequence
UUID	varchar(36)	Unique identifier for this user.		Students.UUID
ID	bigint	The student's ID number. Should be unique.	{{Student.ID}}	Students.ID	StudentID
Other_ID	varchar(40)	Alternative identifier for the student.	{{Student.Other_ID}}	Students.Other_ID	OtherID
Other_ID2	varchar(40)	Another alternative identifier for the student.	{{Student.Other_ID2}}	Students.Other_ID2	OtherID2
Barcode	varchar(80)	The student's barcode.	{{Student.Barcode}}	Students.Barcode	Barcode
Status	varchar(80)	Whether the student is Active or Inactive.	{{Student.Status}}	Students.Status	Status
OtherStatus	varchar(80)	Alternative/custom status.		Students.OtherStatus	StudentOtherStatus
Legal_First	varchar(80)	The student's legal first name.	{{Student.Legal_First}}	Students.Legal_First	LegalFirst
First Name	varchar(80)	The student's preferred first name.	{{Student.First_Name}}	Students.First_Name	FirstName
Last Name	varchar(80)	The student's last name.	{{Student.Last_Name}}	Students.Last_Name	LastName
Middle	varchar(80)	The student's middle name.	{{Student.Middle}}	Students.Middle	Middle
Full_Name	varchar(255)	The student's full name, formatted as "Last, First M.".	{{Student.Full_Name}}	Students.Full_Name
LastFirst	varchar(255)	The student's full name, formatted as "Last, First M".	{{Student.LastFirst}}
Full_Name2	varchar(255)	The student's full name, formatted as "First M. Last".	{{Student.Full_Name2}}	Students.Full_Name2
FirstLast	varchar(255)	The student's full name, formatted as "First Last".	{{Student.FirstLast}}
Street	varchar(250)	The student's street address.		Students.Street	Street
Apt	varchar(80)	The student's apartment number.		Students.Apt
City	varchar(120)	The student's city.		Students.City	City
State	varchar(80)	The student's state.		Students.State	State
Zip	varchar(20)	The student's zip code.		Students.Zip	ZIP
Home_Phone	varchar(80)	The student's home phone number.	{{Student.Home_Phone}}	Students.Home_Phone	HomePhone
Work_Phone	varchar(80)	The student's work phone number.	{{Student.Work_Phone}}	Students.Work_Phone	WorkPhone
Cell_Phone	varchar(80)	The student's cell phone number.	{{Student.Cell_Phone}}	Students.Cell_Phone	CellPhone
Email	varchar(120)	The student's email address, typically their campus email.	{{Student.Email}}	Students.Email	Email
Preferred	varchar(80)	The student's preferred contact method. Possible values are listed below. 1 = Home 2 = Work 3 = Cell 4 = Email 5 = Verbal	{{Student.Preferred}}	Students.Preferred
LastDateIn	date	Date of the student's last visit.		Students.LastDateIn
UserName	varchar(120)	The student's username for authentication.	{{Student.UserName}}	Students.UserName	StudentUserName
Birthdate	date	The student's birthdate.		Students.Birthdate	Birthdate
Pronouns	varchar(80)	The student's preferred pronouns.	{{Student.Pronouns}}	Students.Pronouns	StudentPronouns
Gender	varchar(80)	The student's gender.	{{Student.Gender}}	Students.Gender	Gender
Ethnicity	varchar(150)	The student's ethnicity.	{{Student.Ethnicity}}	Students.Ethnicity	Ethnicity
Major	varchar(120)	The student's major.	{{Student.Major}}	Students.Major	Major
Class	varchar(80)	The student's class.	{{Student.Class}}	Students.Class	Class
DegreeGoal	varchar(80)	The student's degree goal.	{{Student.DegreeGoal}}	Students.DegreeGoal	DegreeGoal
Cohort	varchar(80)	The student's cohort.	{{Student.Cohort}}	Students.Cohort	Cohort
College	varchar(80)	The student's college.	{{Student.College}}	Students.College	College
Grad_Und	varchar(80)	The student's graduate status.	{{Student.Grad_Und}}	Students.Grad_Und	GradUndergrad
GPA	double	The student's GPA.	{{Student.GPA}}	Students.GPA	GPA
AccumHours	double	The student's accumulated hours.		Students.AccumHours	Hours
Fund	varchar(80)	The student's fund.		Students.Fund	StudentFund
PrimaryConsultantID	bigint	Relates to Staff.Sequence.		Students.PrimaryConsultantID
FlagText	varchar(80)	The contents of the student's "Flag Information" field.		Students.FlagText
CustomData	json	All custom fields are stored in this field. Specify a custom field with its sequence number after "cf_".	{{Student.CustomData.cf_123}}	Students.CustomData->>``$.cf_123``	[Field Name]
WatchLists	json	Returns a true or false value based on whether or not the student is on the specified watch list. Hover over the name of your watch list to find its sequence number (e.g., wl_9)	{{Student.WatchLists.wl_0}}
gen_BIOConfirmed	varchar(2)	Whether or not the student has confirmed their bio.		Students.gen_BIOConfirmed
gen_BIOConfirmedDT	varchar(20)	When the student last confirmed their bio.		Students.gen_BIOConfirmedDT
CreatedDT	timestamp	When this student record was initially created in TracCloud.		Students.CreatedDT
_LastImportedDT	datetime	The last time this student record was imported into TracCloud.		Students._LastImportedDT

Visits

Toggle Visibility

Field	Type	Description	Twig	API	SFTP Export
Sequence	bigint	A unique identifier for every visit record.		Visits.Sequence	VisitID
EnteredDT	datetime	The date and time the student entered the center. This will only differ from TimeIn if your center tracks wait time.	{{Visit.EnteredDT}}	Visits.EnteredDT
EnteredTime	time	The time the student entered, formatted as "09:45am."	{{Visit.EnteredTime}}
EnteredDate	time	The date the student entered.	{{Visit.EnteredDate}}
TimeIn	datetime	The date and time the student's visit began.	{{Visit.TimeIn}}	Visits.TimeIn	DateIn and TimeIn
StartTime	time	The time the student's visit began, formatted as "09:45am."	{{Visit.StartTime}}
StartDate	time	The datethe student's visit began.	{{Visit.StartDate}}
TimeOut	datetime	The date and time the student's visit ended.	{{Visit.TimeOut}}	Visits.TimeOut	TimeOut
EndTime	time	The time the student's visit ended, formatted as "09:45am."	{{Visit.EndTime}}
EndDate	time	The datethe student's visit ended.	{{Visit.EndDate}}
isWork	tinyint	Whether or not this visit is a work visit.	{{Visit.isWork}}	Visits.isWork
StudentID	bigint	Relates to Students.Sequence (not Students.ID).		Visits.StudentID
CenterID	bigint	Relates to Centers.Sequence		Visits.CenterID
ConsultantID	bigint	Relates to Staff.Sequence		Visits.ConsultantID
RegistrationID	bigint	Relates to Registrations.Sequence		Visits.RegistrationID
ReasonID	bigint	Relates to Reasons.Sequence		Visits.ReasonID
isWaiting	tinyint	Whether or not the student is currently waiting to be seen (i.e., TimeIn not yet started).		Visits.isWaiting
WaitTime	double	How long the student waited to start their visit in minutes (TimeIn - EnteredDT).	{{Visit.WaitTime}}	Visits.WaitTime	WaitTime
Duration	int	The length of the student's visit in minutes.	{{Visit.Duration}}	Visits.Duration	Duration
TotalTime	double	The total visit time (WaitTime + Duration).	{{Visit.TotalTime}}	Visits.TotalTime	TotalTime
CustomData	json	All custom fields are stored in this field. Specify a custom field with its sequence number after "cf_".	{{Visit.CustomData.cf_123}}	Visits.CustomData->>``$.cf_123``	[Field Name]
isTerminated	tinyint	Whether or not this visit was automatically terminated by TracCloud.		Visits.isTerminated
Fund	varchar(80)	The fund for this visit.	{{Visit.Fund}}	Visits.Fund	Fund
CtrNotes	text	The notes field filled in by staff/consultants in TracCloud.	{{Visit.CtrNotes}}	Visits.CtrNotes	VisitNotes
SurveyRespID	bigint	Relates to Responses.Sequence.		Visits.SurveyRespID
TermID	bigint	Relates to Terms.Sequence.		Visits.TermID	VisitTermCode (displays Terms.TermCode)
SectionID	bigint	Relates to Sections.Sequence.		Visits.SectionID
Location	varchar(512)	The location of the visit.	{{Visit.Location}}	Visits.Location	Location
Online	tinyint	Whether or not the visit was online.	{{Visit.Online}}	Visits.Online	Online
TimeZone	varchar(120)	The time zone of this visit's time.		Visits.TimeZone
VisitDay	varchar(20)	The day of week the visit took place.	{{Visit.Day}}	Visits.VisitDay	Weekday

Appointments

Toggle Visibility

Field	Type	Description	Twig	API	SFTP Export
Sequence	bigint	A unique identifier for each appointment record.		Appointments.Sequence	ApptID
StartDT	datetime	The appointment start date and time.	{{Appointment.StartDT}}	Appointments.StartDT	DateIn and TimeIn
StartTime	time	The appointment start time, formatted as "02:00pm".	{{Appointment.StartTime}}
DisplayTime	time	The appointment start time, formatted as 200p.	{{Appointment.DisplayTime|raw}}
StartDate	date	The appointment start date, formatted as "01/31/25".	{{Appointment.StartDate}}
DisplayDate	date	The appointment start date, formatted as "Fri, Jan 31" or "Today" for same-day appointments.	{{Appointment.DisplayDate}}
Duration	double	The length of the appointment in minutes.	{{Appointment.Duration}}	Appointments.Duration	Duration
EndDT	datetime	The appointment end date and time.	{{Appointment.EndDT}}	Appointments.EndDT	TimeOut
EndTime	time	The appointment end time.	{{Appointment.EndTime}}
EndDate	date	The appointment end date.	{{Appointment.EndDate}}
Day	varchar	The appointment day of week.	{{Appointment.Day}}		Weekday
Link	varchar	A link to the appointment record in TracCloud.	{{Appointment.Link}}
StudentID	bigint	Relates to Students.Sequence (not Students.ID).		Appointments.StudentID
ConsultantID	bigint	Relates to Staff.Sequence.		Appointments.ConsultantID
VisitID	bigint	Relates to Visits.Sequence.		Appointments.VisitID
CenterID	bigint	Relates to Centers.Sequence.		Appointments.CenterID
ReasonID	bigint	Relates to Reasons.Sequence.		Appointments.ReasonID
SectionID	bigint	Relates to Sections.Sequence.		Appointments.SectionID
AvailRecID	bigint	Relates to AvailBlocks.Sequence.		Appointments.AvailRecID
RecurID	bigint	Recurring appointments that are part of the same series (e.g., weekly at 2pm) will have a matching RecurID.		Appointments.RecurID
Status	varchar(80)	The status of the appointment.	{{Appointment.Status}}	Appointments.Status	ApptStatus
Location	varchar(512)	The location of the appointment. This will be the in-person location if in-person or the availability's meeting link if online. For online sessions, you may want to use "OnlineLink" instead so TracCloud can track attendance.	{{Appointment.Location}}	Appointments.Location	Location
Fund	varchar(80)	The appointment fund.	{{Appointment.Fund}}	Appointments.Fund	Fund
Online	int	Whether or not the appointment is online. Possible values are listed below. 0 = In-person 1 = Online 2 = Asynchronous 3 = Phone	{{Appointment.Online}}	Appointments.Online	Appointment Meeting Type Online (displays as "Yes" or blank)
OnlineURL	varchar(512)	The online meeting link for the appointment. This will be blank for in-person appointments. The Twig tag will contain a TracCloud link that tracks attendance when the student joins rather than a direct link to the meeting room.	{{Appointment.OnlineLink}}	Appointments.OnlineURL	ApptOnlineURL
OtherNotes	text	Student cancellation reason.	{{Appointment.OtherNotes}}	Appointments.OtherNotes	OtherNotes
Type	varchar	The type of appointment. 1-on-1 or Group.	{{Appointment.Type}}		ApptType
Icon		An icon that indicates the appointment type. for in-person and for online.	{{Appointment.Icon|raw}}
hasDocument	varchar	Whether or not the appointment has a document uploaded, displayed as "true" or "false".	{{Appointment.hasDocument}}
OnlineText	varchar	If the appointment is online, this tag will display as "Online", otherwise it will be blank.	{{Appointment.OnlineText}}
isRecurring	varchar	Whether or not the appointment is recurring, displayed as "true" or "false".	{{Appointment.isRecurring}}
RecurringDates	varchar	An array of recurring appointments in the series.	{{Appointment.RecurringDates}}
recurFirstDate	date	The first date of a recurring appointment series.	{{Appointment.recurFirstDate}}
recurLastDate	date	The last date of a recurring appointment series.	{{Appointment.recurLastDate}}
isCancelled	varchar	Whether or not the appointment is currently canceled, displayed as "true" or "false".	{{Appointment.isCanceled}}
isMissed	varchar	Whether or not the appointment is currently missed, displayed as "true" or "false".	{{Appointment.isMissed}}
autoCanceled	varchar	Whether or not the appointment was automatically canceled due to max cancel/missed in recurring series rules, displayed as "true" or "false".	{{Appointment.autoCanceled}}
SchedDT	datetime	The date and time this appointment was scheduled.	{{Appointment.SchedDT}}	Appointments.SchedDT	ApptScheduledDT
SchedModDT	datetime	The date and time this appointment was last modified	{{Appointment.SchedModDT}}	Appointments.SchedModDT	ApptModifiedDT
SchedUser	varchar(80)	The user who originally scheduled this appointment.	{{Appointment.SchedUser}}	Appointments.SchedUser	ScheduledBy
SchedNotes	text	Unused.			SchedNotes
SurveyRespID	bigint	Relates to Responses.Sequence.		Appointments.SurveyRespID
CustomData	json	All custom fields are stored in this field. Specify a custom field with its sequence number after "cf_".	{{Appointment.CustomData.cf_123}}	Appointments.CustomData->>``$.cf_123``	[Field Name]
SchedModBy	varchar(80)	The user who last edited the appointment.	{{Appointment.SchedModBy}}	Appointments.SchedModBy	ApptModifiedBy

Availabilities

Toggle Visibility

Field	Type	Description	Twig	API
Sequence	bigint	A unique identifier for every availability record.		AvailBlocks.Sequence
FromDT	datetime	The starting date and time of this availability block.		AvailBlocks.FromDT
ToDT	datetime	The ending date and time of this availability block.		AvailBlocks.ToDT
Increments	varchar(5)	The increment duration in minutes.		AvailBlocks.Increments
Breaks	varchar(5)	The delay between increments in minutes.		AvailBlocks.Breaks
DAYS	varchar(30)	Which days of the week this availability is available on.		AvailBlocks.Days
isAvail	int	0 = Reserve block, 1 = Regular availability, 2 = Stacked availability.	{{AvailBlock.isAvail}}	AvailBlocks.isAvail
BlockType	varchar(256)	Reserve block description.		AvailBlocks.BlockType
BlockStatus	varchar(80)	Reserve block appointment status.		AvailBlocks.BlockStatus
MaxStudents	int	The number of available slots at this time.	{{AvailBlock.MaxStudents}}	AvailBlocks.MaxStudents
ConsultantID	bigint	Relates to Staff.Sequence.		AvailBlocks.ConsultantID
CenterID	bigint	Relates to Centers.Sequence.		AvailBlocks.CenterID
ReasonID	bigint	Relates to Reasons.Sequence.		AvailBlocks.ReasonID
SectionID	bigint	Relates to Sections.Sequence.		AvailBlocks.SectionID
AvailSubj	varchar(256)	The availability subject, including wildcard entries.		AvailBlocks.AvailSubj
RecurType		The type of recurring appointment. The possible options are listed below. None Daily Weekly Bi-Weekly Optional Daily Optional Weekly Optional Bi-Weekly Optional Daily Chosen Optional Weekly Chosen Optional Bi-Weekly Chosen		AvailBlocks.RecurType
Location	varchar(512)	The in-person location for this availability.		AvailBlocks.Location
OnlineURL	varchar(512)	The online location for this availability.		AvailBlocks.OnlineURL
Fund	varchar(80)	The availability fund.		AvailBlocks.Fund
isInperson	tinyint	Whether or not the availability is in-person.		AvailBlocks.isInperson
isOnline	tinyint	Whether or not the availability is online.		AvailBlocks.isOnline
isAsynch	tinyint	Whether or not the availability is asynchronous.		AvailBlocks.isAsync
defLocChoice	int	The default location choice. 0 = in-person, 1 = online, 2 = asynchronous.		AvailBlocks.defLocChoice
isMeeting	tinyint	Whether or not a reserve block is designated as as meeting block.		AvailBlocks.isMeeting

Course Related (Courses, Sections, Terms, Registrations, Faculty, SectionSchedule)

Toggle Visibility

Courses

Field	Type	Description	Twig	API	SFTP Export
Sequence	bigint	A unique identifier for every course.
Subject	varchar(40)	The subject.	{{Course.Subject}}	Courses.Subject	Subject
Course	varchar(20)	The course number.	{{Course.Course}}	Courses.Course	Course
Title	varchar(120)	The course title.	{{Course.Title}}	Courses.Title	Title
ExcludeFromCharts	tinyint	Whether or not this course is configured to be excluded from charts.		Courses.ExcludeFromCharts
Dept	varchar(40)	The assigned department for this course.		Courses.Dept
SubjectCourse	varchar(200)	Combination of Subject and Course in one field.	{{Course.SubjectCourse}}	Courses.SubjectCourse
SubjectCourseTitle	varchar	Combination of Subject, Course, and Title in one field.	{{Course.SubjectCourseTitle}}
_LastImportedDT	datetime	The date and time this record was last imported.		Courses._LastImportedDT
CustomData	json	All custom fields are stored in this field. Specify a custom field with its sequence number after "cf_".	{{Course.CustomData.cf_123}}	Courses.CustomData->>``$.cf_123``	[Field Name]
RelatedCoursesID	varchar(20)	The course family identifer.		Courses.RelatedCoursesID

Sections

Field	Type	Description	Twig	API	SFTP Export
Sequence	bigint	A unique identifier for each section.		Sections.Sequence
Inactive	tinyint	Whether or not this section is currently inactive.		Sections.Inactive
Code	varchar(80)	The section code/number.	{{Section.Code}}	Sections.Code	Section
CourseID	bigint	Relates to Courses.Sequence.		Sections.CourseID
GradeGroupID	bigint	Relates to GradeGroups.Sequence.		Sections.GradeGroupID
CRN	varchar(80)	The CRN of this section record.	{{Section.CRN}}	Sections.CRN	CRN
TermID	bigint	Relates to Terms.Sequence (not Terms.TermCode).		Sections.TermID
FacultyID	bigint	Relates to Sections.FacultyID (not Faculty.UserID).		Sections.FacultyID
nonEnrolled	tinyint	Whether or not this is a non-enrolled course.		Sections.nonEnrolled
CustomData	json	All custom fields are stored in this field. Specify a custom field with its sequence number after "cf_".	{{Section.CustomData.cf_123}}	Sections.CustomData->>``$.cf_123``	[Field Name]
CreatedDT	timestamp	When this section record was initially created.		Sections.CreatedDT
ignoreRegImportDeactivate	tinyint	Whether or not this section is configured to ignore deactivations.		Sections.ignoreRegImportDeactivate
Credits	double	The potential credits for this section.		Sections.Credits
_LastImportedDT	datetime	The latest date and time this record was imported into TracCloud.		Sections._LastImportedDT
Title	varchar(120)	This optional field overrides Courses.Title if present.	{{Section.Title}}	Sections.Title
SubjectTermCode		Combination of Courses.SubjectCourse and Terms.TermCode.	{{Section.SubjectTermCode}}
SubjectTitle		Combination of Courses.SubjectCourse and Courses.Title.	{{Section.SubjectTitle}}

Terms

Field	Type	Description	Twig	API	SFTP Export
Sequence	bigint	A unique identifer for this term record.		Terms.Sequence
Active	tinyint	Whether or not this term is currently active.		Terms.Active
TermCode	varchar(80)	The term/semester code.	{{Term.TermCode}}	Terms.TermCode	Term
ActiveFrom	date	The start date of this term.		Terms.ActiveFrom
ActiveTo	date	The end date of this term.		Terms.ActiveTo

Registrations

Field	Type	Description	Twig	API	SFTP Export
Sequence	bigint	A unique identifier for this registration record.		Registrations.Sequence
Inactive	tinyint	Whether or not this registration is currently inactive.		Registrations.Inactive
OverrideDate	tinyint	Whether or not this registration is configured with a date override.		Registrations.OverrideDate
SectionID	bigint	Relates to Sections.Sequence.		Registrations.SectionID
StudentID	bigint	Relates to Students.Sequence (not Students.ID).		Registrations.StudentID
Grade	varchar(40)	The registration grade.		Registrations.Grade
ValidFromDT	datetime	The start date of this registration.		Registrations.ValidFromDT
ValidToDT	datetime	The end date of this registration.		Registrations.ValidToDT
Notes	text	The registration notes field.		Registrations.Notes
CustomData	json	All custom fields are stored in this field. Specify a custom field with its sequence number after "cf_".	{{Registration.CustomData.cf_123}}	Registrations.CustomData->>``$.cf_123``	[Field Name]
_LastImportedDT	datetime	The latest date and time this record was imported into TracCloud.		Registrations._LastImportedDT
RegStatus	varchar(40)	The registration status (dropped, withdrawn, enrolled, etc).		Registrations.RegStatus	RegistrationStatus
EarnedCredits	double	The student's earned credits in this enrollment.		Registrations.EarnedCredits

Faculty

Field	Type	Description	Twig	API	SFTP Export
Sequence	bigint	Static identifier for faculty, unrelated to UserID.		Faculty.Sequence
UUID	varchar(36)	Unique identifer for faculty records.		Faculty.UUID
FirstName	varchar(80)	The faculty member's first name.	{{Faculty.FirstName}}*	Faculty.FirstName	FacultyFirst
LastName	varchar(80)	The faculty member's last name.	{{Faculty.LastName}}*	Faculty.LastName	FacultyLast
UserID	varchar(80)	The faculty member's ID number.	{{Faculty.UserID}}*	Faculty.UserID	FacultyUserID
UserName	varchar(80)	The faculty member's username for authentication.	{{Faculty.UserName}}*	Faculty.UserName	FacultyUserName
Salutation	varchar(40)	The faculty member's salutation (e.g., Dr.).	{{Faculty.Salutation}}*	Faculty.Salutation	Salutation
SalutationFullName		Combination of salutation and full name.	{{Faculty.SalutationFullName}}*
SalutationLastName		Combination of salutation and last name.	{{Faculty.SalutationLastName}}*
Department	varchar(60)	The faculty member's department.	{{Faculty.Department}}*	Faculty.Department	FacultyDepartment
Inactive	tinyint	Whether or not this faculty is currently inactive.		Faculty.Inactive
Phone	varchar(80)	The faculty member's phone number.	{{Faculty.Phone}}*	Faculty.Phone
Email	varchar(120)	The faculty member's email address.	{{Faculty.Email}}*	Faculty.Email	FacultyEmail
CustomData	json	All custom fields are stored in this field. Specify a custom field with its sequence number after "cf_".	{{Faculty.CustomData.cf_123}}*	Faculty.CustomData->>``$.cf_123``	[Field Name]
OtherID	varchar(80)	An alternate hidden identifier for faculty. This is typically left blank.		Faculty.OtherID
FullName	varchar(255)	Combination of FirstName, LastName, and Saltuation in one field.	{{Faculty.FullName}}*	Faculty.FullName
_LastImportedDT	datetime	The latest date and time this record was imported into TracCloud.		Faculty._LastImportedDT

• To reference the STEP faculty in work plans with Twig, the "StepFaculty" prefix should be used instead (e.g., {{StepFaculty.FirstName}}). The regular "Faculty" prefix shown above should be used everywhere else.

SectionSchedule

Field	Type	Description	API
Sequence	bigint	A unique identifer for this section schedule record.	SectionSchedule.Sequence
SectionID	bigint	Relates to Sections.Sequence (not Sections.Code).	SectionSchedule.SectionID
Days	varchar(30)	Which days this class takes place on.	SectionSchedule.Days
Time	time	What time the class starts.	SectionSchedule.Time
Duration	int	The duration of the class in minutes.	SectionSchedule.Duration
Description	text	The description for this class.	SectionSchedule.Description
Campus	varchar(80)	The campus.	SectionSchedule.Campus
Bldg	varchar(80)	The building.	SectionSchedule.Bldg
Room	varchar(80)	The room.	SectionSchedule.Room

Staff/Consultants

Toggle Visibility

Field	Type	Description	Twig	API	SFTP Export
Sequence	bigint	Static identifer for staff.		Staff.Sequence
UUID	varchar(36)	Unique Identifer for each user.		Staff.UUID
First_Name	varchar(80)	The staff member's first name.	{{Consultant.First_Name}}*	Staff.First_Name	ConsultantFirst
Last_Name	varchar(80)	The staff member's last name.	{{Consultant.Last_Name}}*	Staff.Last_Name	ConsultantLast
LastFirst	varchar(255)	The staff member's full name, formatted as "Last, First".	{{Consultant.LastFirst}}*	Staff.LastFirst
FirstLast	varchar(255)	The staff member's full name, formatted as "First Last".	{{Consultant.FirstLast}}*	Staff.FirstLast
Alias	varchar(120)	The staff member's alias/alternative name.	{{Consultant.Alias}}*	Staff.Alias	ConsultantAlias
Email	varchar(120)	The staff member's email address.	{{Consultant.Email}}*	Staff.Email	ConsultantEmail
UserName	varchar(80)	The staff member's username. This typically matches Students.Username if the user has both account types.	{{Consultant.UserName}}*	Staff.UserName	ConsultantUserName
UserLevel	int	The staff member's user level. The possible options are listed below. 0 = Staff 1 = SysAdmin 2 = Profile Admin		Staff.UserLevel
LastAccess	datetime	Date and time this staff member last logged into TracCloud.		Staff.LastAccess
GroupID	bigint	The staff member's permission group, relates to Groups.Sequence.		Staff.GroupID
isKiosk	tinyint	Whether or not this staff account is configured to be a kiosk account.		Staff.isKiosk
isConsultant	tinyint	Whether or not this staff account is configured to be a consultant account.		Staff.isConsultant
Inactive	tinyint	Whether or not this account is inactive.		Staff.Inactive
Phone	varchar(30)	The staff member's phone number.	{{Consultant.Phone}}*	Staff.Phone
CellPhone	varchar(80)	The staff member's cell phone number.	{{Consultant.CellPhone}}*	Staff.CellPhone
WorkPhone	varchar(80)	The staff member's work phone number.	{{Consultant.WorkPhone}}*	Staff.WorkPhone
Address	varchar(80)	The staff member's street address.		Staff.Address
City	varchar(120)	The staff member's city.		Staff.City
State	varchar(80)	The staff member's state.		Staff.State
Zip	varchar(20)	The staff member's zip/post code.		Staff.Zip
CourseListID	bigint	Relates to CourseList.Sequence		Staff.CourseListID
Location	varchar(512)	The staff member's assigned in-person location.		Staff.Location	ConsultantLocation
OnlineLink	varchar(512)	The staff member's assigned online URL.		Staff.OnlineLink	ConsultantOnlineLink
Fund	varchar(80)	The staff member's assigned fund.		Staff.Fund	ConsultantFund
PayCodeID	bigint	Relates to PayCodes.Sequence.		Staff.PayCodeID
Hired	date	The date this staff member was hired.		Staff.Hired	ConsultantHired
Terminated	date	The date this staff member's employment was terminated.		Staff.Terminated	ConsultantTerminated
ReasonQuit	varchar(220)	The reason for employment termination.		Staff.ReasonQuit	ConsultantReasonQuit
Mailbox	varchar(80)	The staff member's mailbox.		Staff.Mailbox
CenterID	bigint	The staff member's default center. Relates to Centers.Sequence.		Staff.CenterID	Mailbox
noShowOnSched	tinyint	Whether or not this staff member has been configured to not show on the schedule.		Staff.noShowOnSched
Notes	text	The staff member's notes field.	{{Consultant.Notes}}*	Staff.Notes
CustomData	json	All custom fields are stored in this field. Specify a custom field with its sequence number after "cf_".	{{Consultant.CustomData.cf_123}}*	Staff.CustomData->>``$.cf_123``	[Field Name]
OtherID	varchar(80)	The staff member's alternate/other ID.		Staff.OtherID	ConsultantOtherID
StaffBIO	text	The staff member's bio text.	{{Consultant.StaffBIO|raw}}*	Staff.StaffBIO
Pronouns	varchar(80)	The staff member's preferred pronouns.	{{Consultant.Pronouns}}*	Staff.Pronouns	ConsultantPronouns
CreatedDT	datetime	The date that this staff record was created.		Staff.CreatedDT
_LastImportedDT	datetime	The date that this staff record was last imported (only applicable if importing staff).		Staff._LastImportedDT
KioskSort	varchar(10)	The staff member's sort code.		Staff.KioskSort
SupervisorID	int	The staff member's assigned supervisor. Relates to Staff.Sequence.		Staff.SupervisorID
TitleOrPosition	varchar(80)	The staff member's title/position.		Staff.TitleOrPosition
Photo		The staff member's photo.	{{Consultant.Photo|raw}}*

* Depending on the context, different table prefixes must be used for Twig tags specifically. Most Twig-supported locations throughout TracCloud use the "Consultant" table prefix shown above. Exceptions are listed below.

• "Staff" (e.g., {{Staff.First_Name}}) should be used in: Workshop descriptions and notifications, announcements, staff bio on search availability, Work Plan assignees, and the staff welcome message
• "Supervisor" (e.g., {{Supervisor.First_Name}}) should be used when referencing the assigned supervisor in Work Plan fields.
• "StepSupervisor" (e.g., {{StepSupervisor.First_Name}}) should be used when referencing the STEP supervisor in Work Plan fields.

Profile Related (Profiles, Centers, Reasons, Groups)

Toggle Visibility

Profiles

Field	Type	Description	API
Sequence	bigint	Unique identifer for each profile.	Profiles.Sequence
Type	int	The type of profile. Possible values are listed below. 1 = TutorTrac 2 = AdvisorTrac 3 = FitnessTrac	Profiles.Type
Name	varchar(80)	The name of the profile.	Profiles.Name
Inactive	tinyint	Whether or not this profile is currently inactive.	Profiles.Inactive
ContactID	bigint	The main contact for this profile. Relates to Staff.Sequence.	Profiles.ContactID
NameForConsultant	varchar(80)	The name of the "consultant" user type in TracCloud.	Profiles.NameForConsultant
TimeZone	varchar(120)	This profile's time zone. Uses system time zone if blank (which is common).	Profiles.TimeZone

Centers

Field	Type	Description	Twig	API	SFTP Export
Sequence	bigint	Unique identifier for each center.		Centers.Sequence
Name	varchar(80)	The name of the center.	{{Center.Name}}	Centers.Name	Centers
CourseListID	bigint	The center's linked course list, relates to CourseList.Sequence.		Centers.CourseListID
ProfileID	bigint	Which profile this center is linked to, relates to Profiles.Sequence.		Centers.ProfileID
Inactive	tinyint	Whether or not this center is currently inactive.		Centers.Inactive
UpdatedDT	datetime	The last time this center record was modified.		Centers.UpdatedDT
IsWritingCenter	tinyint	Whether or not this center has been configured to ignore consultant specialties.		Centers.IsWritingCenter

Reasons

Field	Type	Description	Twig	API	SFTP Export
Sequence	bigint	Unique identifier for each reason.		Reasons.Sequence
ProfileID	bigint	Which profile this reason is linked to, relates to Profiles.Sequence.		Reasons.ProfileID
Reason	varchar(80)	The name of the reason.	{{Reason.ReasonName}} {{Reason.Reason}}	Reasons.Reason	Reason
Inactive	tinyint	Whether or not this reason is inactive.		Reasons.Inactive
isWork	tinyint	Whether or not this reason is a work reason.		Reasons.isWork
SortCode	varchar(40)	The sort code for this reason to override alphabetical sorting.		Reasons.SortCode
Category	varchar(80)	The reason's category.	{{Reason.Category}}	Reasons.Category

Groups

Field	Type	Description	API
Sequence	bigint	Unique identifier for each group.	Groups.Sequence
GroupName	varchar(80)	The name of the group.	Groups.GroupName
ProfileID	bigint	Which profile this group is assigned to, relates to Profiles.Sequence.	Groups.ProfileiD

SurveyTrac Related (Surveys, SrvyQuestions, Responses, SrvyRespAnswers)

Toggle Visibility

Surveys

Field	Type	Description	Twig	API
Sequence	bigint	Unique identifer for each survey.		Surveys.Sequence
Name	varchar(80)	The title of the survey.	{{Survey.Name}}	Surveys.Name
CreatedBy	bigint	The user who created the survey, relates to Staff.Sequence.		Surveys.CreatedBy
ProfileID	bigint	Which profile this survey is linked to, relates to Profiles.Sequence.		Surveys.ProfileID
AutoSend	varchar(80)	The chosen "Initiated Via" option.		Surveys.AutoSend
Active	tinyint	Whether or not this survey is currently active.		Surveys.Active
ActiveFrom	date	The start date of the survey period.		Surveys.ActiveFrom
ActiveTo	date	The end date of the survey period.		Surveys.ActiveTo
Instructions	text	The instructions displayed to the recipient when filling out the survey.		Surveys.Instructions
Confirmation	text	The text shown to the recipient after submitting a response.		Surveys.Confirmation
HeadText	text	The survey title shown to the recipient above the questions.		Surveys.HeadText

SrvyQuestions

Field	Type	Description	API
Sequence	bigint	Unique identifer for each survey question.	SrvyQuestions.Sequence
Question	text	The question text.	SrvyQuestions.Question
SurveyID	bigint	Which survey the question is assigned to, relates to Surveys.Sequence.	SrvyQuestions.SurveyID
Points	double	How many points a correct answer is worth (more info.	SrvyQuestions.Points
AnswerChoices	text	The available answers students can select from.	SrvyQuestions.AnswerChoices
Type	varchar(80)	The format/type of question.	SrvyQuestions.Type
Number	int	The question number; the value that determines question order.	SrvyQuestions.Number

Responses

Field	Type	Description	API
Sequence	bigint	Unique identifer for each survey response.	Responses.Sequence
SurveyID	bigint	Which survey this response is linked to, relates to Surveys.Sequence.	Responses.Sequence
linkedUID	varchar(36)	The UUID of the person who answered this survey.	Responses.linkedUID
SentByID	varchar(36)	Who/what sent the survey to the recipient. This can be "Dashboard" for dashboard surveys, the name of center for automated surveys, or the UUID of a staff member if manually sent.	Responses.SentByID
StudentID	bigint	The student recipient, relates to Students.Sequence (not Students.ID).	Responses.StudentID
SentBy	varchar(80)	Same as SentByID, except in the case of surveys sent by staff this field will display username instead of UUID.	Responses.SentBy
SentDate	datetime	The date and time this survey was sent to the recipient.	Responses.SentDate
AnsweredDate	datetime	The date and time the recipient responded to the survey. This will be null if no response has been received.	Responses.AnsweredDate
StaffID	bigint	The staff recipient, relates to Staff.Sequence.	Responses.StaffID
FacultyID	bigint	The faculty recipient, relates to Faculty.Sequence.	Responses.FacultyID
SentManually	tinyint	Whether or not this survey was manually sent to the recipient.	Responses.SentManually

SrvyRespAnswers

Field	Type	Description	API
Sequence	bigint	Unique identifer for each question response.	SrvyRespAnswers.Sequence
QuestionID	bigint	Which question this response relates to, relates to SrvyQuestions.Sequence.	SrvyRespAnswers.QuestionID
ResponseID	bigint	Which survey response this question response relates to, relates to Responses.Sequence.	SrvyRespAnswers.ResponseID
tAnswer	varchar(80)	The recipient's answer to the question	SrvyRespAnswers.tAnswer

Document Related (Documents, DocTypes)

Toggle Visibility

Documents

Field	Type	Description	Twig	API
Sequence	bigint	Unique identifer for each document.		Documents.Sequence
linkedUID	varchar(36)	The UUID of the user account this document is upload to, for Student/Staff documents.		Documents.linkedUID
Usage	varchar(255)	Where this document is uploaded. Possible values are listed below. student staff appointment visit availability group survey	{{Document.Usage}}	Documents.Usage
StudentID	bigint	Which student record this document is related to, relates to Students.Sequence (not Students.ID).		Documents.StudentID
StaffID	bigint	Which staff record this document is related to, relates to Staff.Sequence.		Documents.StaffID
DocTypeID	bigint	Which document type this document is related to, relates to DocTypes.Sequence.		Documents.DocTypeID
Date	datetime	The date and time this document was uploaded.		Documents.Date
Notes	text	The document notes.	{{Document.Notes}}	Documents.Notes
PostedBy	varchar(255)	The UUID of the user who uploaded the document.	{{Document.PostedBy}}	Documents.PostedBy
PostedByName		The user type, sequence, and name of the user who uploaded this document.	{{Document.PostedByName}}
OrigName	varchar(512)	The name of the document.	{{Document.OrigName}}	Documents.OrigName
LinkedApptID	bigint	Which appointment record this document is related to, relates to Appointments.Sequence.		Documents.LinkedApptID
Type	varchar(255)	The document type.		Documents.Type
SizeK	double	The file size (in KiB)		Documents.SizeK
Inactive	tinyint	Whether or not this document is marked as inactive.		Documents.Inactive
LinkedAvailRecID	bigint	Which availability record this document is related to, relates to AvailBlocks.Sequence.		Documents.LinkedAvailRecID
LinkedVisitID	bigint	Which visit record this document is related to, relates to Visits.Sequence.		Documents.LinkedVisitID

DocTypes

Field	Type	Description	Twig	API
Sequence	bigint	Unique identifer for each document type.		DocTypes.Sequence
Name	varchar(255)	The name of the document type.	{{DocType.Name}}	DocTypes.Name
Inactive	tinyint	Whether or not this document type is inactive.		DocTypes.Inactive

Resource Related (Resources, ResourceTypes, Checkouts)

Toggle Visibility

Resources

Field	Type	Description	Twig	API
Sequence	bigint	Unique identifer for each resource.		Resources.Sequence
Title	varchar(80)	The name of the resource.	{{Resource.Title}}
BarCode	varchar(20)	The barcode value of the resource.	{{Resource.BarCode}}	Resources.BarCode
Description	text	The description of the resource.	{{Resource.Description}}	Resources.Description
Keywords	varchar(80)	The keywords for thsi resource, used to find the resource during checkout.	{{Resource.Keywords}}	Resources.Keywords
Status	int	The status of this resource, possible values are listed below. -1 = Inactive 0 = Checked out 1 = Available 2 = Always available	{{Resource.Status}}	Resources.Status
MaxDaysOut	int	The maximum number of days that an item can be checked out.	{{Resource.MaxDaysOut}}	Resources.MaxDaysOut
LastDTOut	datetime	The date an time this item was last checked out.		Resources.LastDTOut
MaxTimeOut	time	The maximum amount of time that an item can be checked out.	{{Resource.MaxTimeOut}}	Resources.MaxTimeOut
DueDT	datetime	The date and time this item is due to be returned. This will match Checkouts.DueDT of the most recent checkout.		Resources.DueDT
Type	int	The resource type, relates to ResourceTypes.Sequence.		Resources.Type
Inactive	tinyint	Whether or not this resource is currently inactive.		Resources.Inactive
ProfileID	bigint	Which profile this resource is assigned to, relates to Profiles.Sequence.		Resources.ProfileID
AlwaysAvailable	tinyint	Whether or not this resource is designated as always available.		Resources.AlwaysAvailable
MaxRenews	int	The maximum number of times a checkout for this resource can be renewed.		Resources.MaxRenews
CollateralLogic	tinyint	Whether or not this resource requires collateral to be checked out.		Resources.CollateralLogic
LastOutToUUID	varchar(46)	The UUID of the last user to check this resource out.		Resources.LastOutToUUID
PickupInstructions		Instructions for resource pickup.	{{Resource.CustomData.PickupInstructions}}
ReturnInstructions		Instructions for resource return.	{{Resource.CustomData.ReturnInstructions}}

ResourceTypes

Field	Type	Description	Twig	API
Sequence	bigint	Unique identifer for each resource type.		ResourceTypes.Sequence
Name	varchar(80)	The name of the resource type/category that resources are assigned to.	{{ResourceType.Name}}	ResourceTypes.Name
Description	varchar(255)	The description of the resource type.	{{ResourceType.Description}}	ResourceTypes.Description

Checkouts

Field	Type	Description	Twig	API
Sequence	bigint	Unique identifer for each checkout.		Checkouts.Sequence
ResourceID	bigint	Which resource this checkout is for, relates to Resources.Sequence.		Checkouts.ResourceID
Date	datetime	The date and time of the checkout.	{{Checkout.Date}}	Checkouts.Date
ReturnedDT	datetime	The date and time the checkout was returned.		Checkouts.ReturnedDT
TotalTimeHrs	double	The total number of hours the resource was checked out for.		Checkouts.TotalTimeHrs
Collateral	varchar(80)	The collateral for checkout.	{{Checkout.Collateral}}	Checkouts.Collateral
Notes	text	The notes in the checkout record.		Checkouts.Notes
Overdue	tinyint	Whether or not this checkout is overdue.	{{Checkout.Overdue}}	Checkouts.Overdue
DueDT	datetime	The date and time the checkout is due to be returned.	{{Checkout.DueDT}}	Checkouts.DueDT
CheckedOutToUUID	varchar(46)	The UUID of the user who checked out this resource.		Checkouts.CheckedOutToUUID
CheckedOutToType	varchar(80)	What type of user checked out this resource (Student or Staff).		Checkouts.CheckedOutToType

Workshops

Toggle Visibility

Field	Type	Description	Twig	API
Sequence	bigint	Unique identifer for each workshop.		Workshops.Sequence
CenterID	bigint	Which center this workshop is assigned to, relates to Centers.Sequence.		Workshops.CenterID
ReasonID	bigint	Which reason this workshop is assigned to, relates to Reasons.Sequence.		Workshops.ReasonID
Name	varchar(255)	The name of the workshop.	{{Workshop.Name}}	Workshops.Name
Instructor	varchar(255)	The instructor of the workshop.	{{Workshop.Instructor}}	Workshops.Instructor
RosterSubject	json	Contains the subject, course, and section code of the workshop.		Workshops.RosterSubject
RosterSubject.Subject	varchar(40)	The workshop subject.	{{Workshop.RosterSubject.Subject}}
RosterSubject.Course	varchar(20)	The workshop course.	{{Workshop.RosterSubject.Course}}
RosterSubject.Section	varchar(80)	The workshop section code.	{{Workshop.RosterSubject.Section}}
StudentLinkedListID	bigint	The list of students this workshop is restricted to, relates to Lists.Sequence.		Workshops.StudentLinkedListID
Description	text	The description of the workshop.	{{Workshop.Description}}	Workshops.Description
AssignmentID	bigint	Which potential assignment this workshop is assigned to, relates to Assignments.Sequence.		Workshops.AssignmentID
CreatedDT	datetime	The date and time this workshop was created.	{{Workshop.CreatedDT}}	Workshops.CreatedDT
DateFrom	datetime	The start date and time of the workshop.	{{Workshop.DateFrom}}	Workshops.DateFrom
StartDate		The start date of the workshop.	{{Workshop.StartDate}}
StartTime		The start time of the workshop.	{{Workshop.StartTime}}
DateTo	datetime	The end date and time of the workshop.	{{Workshop.DateTo}}	Workshops.DateTo
EndDate		The end date of the workshop.	{{Workshop.EndDate}}	Workshops.EndDate
EndTime		The end time of the workshop.	{{Workshop.EndTime}}	Workshops.EndTime
EnrolledDate		The date of student enrollment.	{{WorkshopsRoster.EnrolledDate}}

Custom Fields

Toggle Visibility

Replace '123' in the Twig examples with the sequence of your custom field.

Field	Type	Description	Twig	API
Sequence	bigint	Unique identifer for each workshop.		CustomDataTypes.Sequence
DataName	varchar(80)	The internal name of the custom field (different than prompt).	CustomFields.cf_123.DataName	CustomDataTypes.DataName
Location	varchar(80)	Where the custom field is located. Possible values are listed below. Appointment - Consultant Appointment - Student Availability Certification Consultant Document Faculty Reason Registration Resource Section SI_Session Student - Campus Student - Custom1 Student - Custom2 Student - Custom3 Student - Custom4 Student - Custom5 Student - Other Info Student - QuickStudent Visit - Consultant Visit - Q2 Raise Hand Visit - Student		CustomDataTypes.Location
Prompt	text	The visible name of the custom field (what students see).	CustomFields.cf_123.Prompt	CustomDataTypes.Prompt
Choices	text	The available list of choices for custom fields with predefined answers.	CustomFields.cf_123.Choices	CustomDataTypes.Choices
InputType	varchar(80)	What type of custom field this is. Possible values are listed below. field areafield leftcheckfield multicheckfield radiofield radioimagefield toggle menufield imagemenufield imagepopfield signaturefield uploaddocfield popfield labeledhtml infohtml headerhtml group		CustomDataTypes.InputType
ProfileID	bigint	Which profile this custom field is linked to, 0 is all. Relates to Profiles.Sequence.		CustomDataTypes.ProfileID

Success Plan Related (SuccessPlan, SPSteps, SPAssigned, SPAssignedSteps)

Toggle Visibility

SuccessPlan

Field	Type	Description	Twig	API
Sequence	bigint	Unique identifer for each success plan.		SuccessPlan.Sequence
Name	varchar(120)	The name of the success plan.	{{SuccessPlan.Name}}	SuccessPlan.Name
ProfileID	bigint	Which profile this success plan is assigned to, relates to Profiles.Sequence.		SuccessPlan.ProfileID
Inactive	tinyint	Whether or not this success plan is currently inactive.		SuccessPlan.Inactive

SPSteps

Field	Type	Description	Twig	API
Sequence	bigint	Unique identifer for each success plan step.	{{SPStep.Sequence}}	SPSteps.Sequence
SuccessPlanID	bigint	Which success plan this step is assgined to.	{{SPStep.}}	SPSteps.SuccessPlanID
Type	varchar(120)	What type of step this is. Possible values are listed below. Visit Survey Document Task Checkout Notification Prompt	{{SPStep.Type}}	SPSteps.Type
DateOrOffset	varchar(36)	When this Step needs to be completed (number of days or static date based on Plan type)	{{SPStep.DateOrOffset}}	SPSteps.DateOrOffset
isOptional	tinyint	Whether or not the step is optional.	{{SPStep.isOptional}}	SPSteps.isOptional
isNoSendEmails	tinyint	Whether or not emails are disabled for this step.	{{SPStep.isNoSendEmails}}	SPSteps.isNoSendEmails
isPromptOnDash	tinyint	Whether or not the prompt is set to display on the dashboard.	{{SPStep.isPromptOnDash}}	SPSteps.isPromptOnDash
DirectedTo	int	Who the confirmation is directed to. Possible values are listed below. 0 = Student 1 = Plan Staff 2 = Plan Faculty 3 = Step Staff 4 = Step Faculty	{{SPStep.DirectedTo}}	SPSteps.DirectedTo
OverrideRequireConfirmation	int	Whether or not this step has been overridden to allow/disallow confirmation.	{{SPStep.OverrideRequireConfirmation}}	SPSteps.OverrideRequireConfirmation

SPAssigned

Field	Type	Description	Twig	API
Sequence	bigint	Unique identifer for each assigned success plan.		SPAssigned.Sequence
SuccessPlanID	bigint	What type of success plan this is, relates to SuccessPlan.Sequence		SPAssigned.SuccessPlanID
StudentID	bigint	Which student this plan is assigned to, relates to Students.Sequence (not Students.ID).		SPAssigned.StudentID
ConsultantID	bigint	The assigned plan consultant, relates to Staff.Sequence.		SPAssigned.ConsultantID
DateStarted	date	The date the plan began.	{{SPAssigned.DateStarted}}	SPAssigned.DateStarted
DateCompleted	date	The date the plan was completed.	{{SPAssigned.DateCompleted}}	SPAssigned.DateCompleted
DueDate	date	The date the plan is due for completion.	{{SPAssigned.DueDate}}	SPAssigned.DueDate
TermID	bigint	The term this plan is linked to, relates to Terms.Sequence.		SPAssigned.TermID
Inactive	tinyint	Whether or not this plan is inactive.		SPAssigned.Inactive
Status	varchar(120)	The status of the plan. Possible values are listed below. In Progress Complete Overdue	{{SPAssigned.Status}}	SPAssigned.Status
Percent	int	The completion percentage of the plan.	{{SPAssigned.Percent}}	SPAssigned.Percent
FacultyID	bigint	The faculty assigned to the plan, relates to Faculty.Sequence (not Faculty.UserID).		SPAssigned.FacultyID
DashboardStatus		The HTML text that would appear on the student's main menu showing their progress in the plan.	{{SPAssigned.DashboardStatus|raw}}

SPAssignedSteps

Field	Type	Description	Twig	API
Sequence	bigint	Unique identifer for each assigned success plan step.		SPAssignedSteps.Sequence
SPAssignedID	bigint	Which assigned success plan this is assigned to, relates to SPAssigned.Sequence.		SPAssignedSteps.SPAssignedID
StudentID	bigint	Which student this is assigned to, relates to Students.Sequence (not Students.ID).		SPAssignedSteps.StudentID
SPStepID	bigint	Which success plan step this relates to, relates to SPSteps.Sequence		SPAssignedSteps.SPStepID
CompletedDate	date	The date this step was completed.	{{SPAssignedStep.CompletedDate}}	SPAssignedSteps.CompletedDate
DueDate	date	The date this step was due to be completed.	{{SPAssignedStep.DueDate}}	SPAssignedSteps.DueDate
CompletionOverride	tinyint	Whether or not the completion override option is enabled for this step.	{{SPAssignedStep.CompletionOverride}}	SPAssignedSteps.CompletionOverride
StaffNotes	text	Any notes entered by the staff for this step.	{{SPAssignedStep.StaffNotes}}	SPAssignedSteps.StaffNotes
Confirmed	tinyint	Whether or not this step has been confirmed.	{{SPAssignedStep.Confirmed}}	SPAssignedSteps.Confirmed
StepFacultyID	bigint	Which faculty this step is assigned to, relates to Faculty.Sequence (not Faculty.UserID).	{{SPAssignedStep.StepFacultyID}}	SPAssignedSteps.StepFacultyID
StepConsultantID	bigint	Which staff record this step is assigned to, relates to Staff.Sequence.	{{SPAssignedStep.StepConsultantID}}	SPAssignedSteps.StepConsultantID
Index		The number of the step, based on the order they were created in.	{{SPAssignedStep.Index}}
PartialStepValue		The progress in the step. For example, you may want to show how many visits they've completed out of a step that requires they complete X visits.	{{SPAssignedStep.CustomData|json_decode.PartialStepValue}}

Work Plan Related (WorkPlan, WPSteps, WPAssigned, WPAssignedSteps)

Toggle Visibility

WorkPlan

Field	Type	Description	Twig	API
Sequence	bigint	Unique identifer for each work plan.		WorkPlan.Sequence
Name	varchar(120)	The name of the work plan.	{{WorkPlan.Name}}	WorkPlan.Name
ProfileID	bigint	Which profile this work plan is assigned to, relates to Profiles.Sequence.		WorkPlan.ProfileID
Inactive	tinyint	Whether or not this work plan is currently inactive.		WorkPlan.Inactive

WPSteps

Field	Type	Description	Twig	API
Sequence	bigint	Unique identifer for each work plan step.	{{WPStep.Sequence}}	WPSteps.Sequence
WorkPlanID	bigint	Which work plan this step is assgined to.	{{WPStep.WorkPlanID}}	WPSteps.WorkPlanID
Type	varchar(120)	What type of step this is. Possible values are listed below. Work Visit Consultation Visit Appointment Survey Document Task Checkout Notification Prompt	{{WPStep.Type}}	WPSteps.Type
DateOrOffset	varchar(36)	When this Step needs to be completed (number of days or static date based on Plan type)	{{WPStep.DateOrOffset}}	WPSteps.DateOrOffset
isOptional	tinyint	Whether or not the step is optional.	{{WPStep.isOptional}}	WPSteps.isOptional
isNoSendEmails	tinyint	Whether or not emails are disabled for this step.	{{WPStep.isNoSendEmails}}	WPSteps.isNoSendEmails
isPromptOnDash	tinyint	Whether or not the prompt is set to display on the dashboard.	{{WPStep.isPromptOnDash}}	WPSteps.isPromptOnDash
DirectedTo	int	Who the confirmation is directed to. Possible values are listed below. 0 = Consultant 1 = Plan Supervisor 3 = No Prompt	{{WPStep.DirectedTo}}	WPSteps.DirectedTo
OverrideRequireConfirmation	int	Whether or not this step has been overridden to allow/disallow confirmation.	{{WPStep.OverrideRequireConfirmation}}	WPSteps.OverrideRequireConfirmation

WPAssigned

Field	Type	Description	Twig	API
Sequence	bigint	Unique identifer for each assigned work plan.		WPAssigned.Sequence
WorkPlanID	bigint	What type of work plan this is, relates to WorkPlan.Sequence		WPAssigned.WorkPlanID
ConsultantID	bigint	The assigned plan consultant, relates to Staff.Sequence.		WPAssigned.ConsultantID
SupervisorID	bigint	The assigned supervisor for this work plan, relates to Staff.Sequence.		WPAssigned.SupervisorID
DateStarted	date	The date the plan began.	{{WPAssigned.DateStarted}}	WPAssigned.DateStarted
DateCompleted	date	The date the plan was completed.	{{WPAssigned.DateCompleted}}	WPAssigned.DateCompleted
DueDate	date	The date the plan is due for completion.	{{WPAssigned.DueDate}}	WPAssigned.DueDate
TermID	bigint	The term this plan is linked to, relates to Terms.Sequence.		WPAssigned.TermID
Inactive	tinyint	Whether or not this plan is inactive.		WPAssigned.Inactive
Status	varchar(120)	The status of the plan. Possible values are listed below. In Progress Complete Overdue	{{WPAssigned.Status}}	WPAssigned.Status
Percent	int	The completion percentage of the plan.	{{WPAssigned.Percent}}	WPAssigned.Percent

WPAssignedSteps

Field	Type	Description	Twig	API
Sequence	bigint	Unique identifer for each assigned work plan step.		WPAssignedSteps.Sequence
WPAssignedID	bigint	Which assigned work plan this is assigned to, relates to WPAssigned.Sequence.		WPAssignedSteps.WPAssignedID
ConsultantID	bigint	Which consultant this is assigned to, relates to Staff.Sequence.		WPAssignedSteps.ConsultantID
WPStepID	bigint	Which work plan step this relates to, relates to WPSteps.Sequence		WPAssignedSteps.WPStepID
CompletedDate	date	The date this step was completed.	{{WPAssignedStep.CompletedDate}}	WPAssignedSteps.CompletedDate
DueDate	date	The date this step was due to be completed.	{{WPAssignedStep.DueDate}}	WPAssignedSteps.DueDate
CompletionOverride	tinyint	Whether or not the completion override option is enabled for this step.	{{WPAssignedStep.CompletionOverride}}	WPAssignedSteps.CompletionOverride
StaffNotes	text	Any notes entered by the staff for this step.	{{WPAssignedStep.StaffNotes}}	WPAssignedSteps.StaffNotes
Confirmed	tinyint	Whether or not this step has been confirmed.	{{WPAssignedStep.Confirmed}}	WPAssignedSteps.Confirmed
StepSupervisorID	bigint	Which supervisor this step is assigned to, relates to Staff.Sequence.	{{WPAssignedStep.StepSupervisorID}}	WPAssignedSteps.StepSupervisorID

SAGE Related (ReferralType, Referrals)

Toggle Visibility

ReferralType

Field	Type	Description	Twig	API
Sequence	bigint	Unique identifer for each referral type.		ReferralType.Sequence
Name	varchar(255)	The name of the referral type.	{{ReferralType.Name}}	ReferralType.Name
RosterSubject	json	This array contains information about what subject(s) this referral type is linked to.		ReferralType.RosterSubject
StudentLinkedListID	bigint	Which student list this referral type is limited to, relates to Lists.Sequence.		ReferralType.StudentLinkedListID
Active	tinyint	Whether or not this referral type is currently active.		ReferralType.Active
NotesInstructions	text	The contents of the notes instructions field.	{{ReferralType.NotesInstructions}}	ReferralType.NotesInstructions
Reasons	json	An array of all of this referral type's reasons.	{{ReferralType.Reasons}}	ReferralType.Reasons
Recommend	json	An array of all of this referral type's recommendations.	{{ReferralType.Recommend}}	ReferralType.Recommend
AdditionalNotesInstr	text	The contents of the additional notes instrucitons field.	{{ReferralType.AdditionalNotesInstr}}	ReferralType.AdditionalNotesInstr
OtherInstructions	text	The contents of the other instructions field.	{{ReferralType.OtherInstructions}}	ReferralType.OtherInstructions

Referrals

Field	Type	Description	Twig	API
Sequence	bigint	Unique identifer for each referral.		Referrals.Sequence
RefTypeID	bigint	Which referral type this referral is linked to, relates to ReferralType.Sequence		Referrals.RefTypeID
StudentID	bigint	Which student this referral is assigned to, relates to Students.Sequence (not Students.ID).		Referrals.StudentID
FacultyID	bigint	Which faculty this referral is linked to, relates to Faculty.Sequence (not Faculty.UserID).		Referrals.FacultyID
SectionID	bigint	Which section this referral is linked to, relates to Sections.Sequence.		Referrals.SectionID
ConsultantID	bigint	Which consultant this referral is linked to, relates to Staff.Sequence.		Referrals.ConsultantID
CenterID	bigint	Which center this referral is linked to, relates to Centers.Sequence.		Referrals.CenterID
CreatedDT	datetime	The date and time this referral was created.	{{Referrals.CreatedDT}}	Referrals.CreatedDT
CreatedBy	varchar(255)	Who created this referral, either a faculty or staff member.	{{Referrals.CreatedBy}}	Referrals.CreatedBy
NotesInstrData	text	Notes entered while the referral is being submitted.	{{Referrals.NotesInstrData}}	Referrals.NotesInstrData
ReasonsData	json	An array of chosen reasons in this referral.	Reasons*	Referrals.ReasonsData
ReasonsAndLabels		Same as above, but this array will also include the reason labels.	ReasonsAndLabels*
RecommendData	json	An array of chosen recommendations in this referral.	Recommendations*	Referrals.RecommendData
RecommendationsAndLabels		Same as above, but this array will also include the recommendation labels.	RecommendationsAndLabels*
AdditionalNotes	text	Additional notes entered during referral submission.	{{Referrals.AdditionalNotes}}	Referrals.AdditionalNotes
FollowUpDate	date	The specified follow-up date from the referral.	{{Referrals.FollowUpDate}}	Referrals.FollowUpDate
FollowUpBy	varchar(255)	The name of the user who followed up on this referral.	{{Referrals.FollowUpBy}}	Referrals.FollowUpBy
FollowedUp	tinyint	Whether or not this referral has been followed up on.	{{Referrals.FollowedUp}}	Referrals.FollowedUp
FollowedUpDT	datetime	The date and time this referral was followed up on.	{{Referrals.FollowedUpDT}}	Referrals.FollowedUpDT
Processed	tinyint	Whether or not this referral has been processed (resolved).	{{Referrals.Processed}}	Referrals.Processed
ProcessedDT	datetime	The date and time this referral was processed.	{{Referrals.ProcessedDT}}	Referrals.ProcessedDT
ProcessedBy	varchar(255)	The user who processed this referral.	{{Referrals.ProcessedBy}}	Referrals.ProcessedBy
ProcessedNotes	text	Notes entered while the referral was being processed.	{{Referrals.ProcessedNotes}}	Referrals.ProcessedNotes
StudentContacted	date	The date the student was contacted about this referral.	{{Referrals.StudentContacted}}	Referrals.StudentContacted
OverrideResend	tinyint	Whether or not the 'Override and resend' feature has been used.		Referrals.OverrideResend
AssignedConsultant	varchar(255)	The name of the consultant or advisor assigned to this referral.	{{Referrals.AssignedConsultant}}	Referrals.AssignedConsultant
AssignedConsultantID	varchar(255)	The sequence number of the assigned consultant, relates to Staff.Sequence.	{{Referral.CustomData.AssignedConsultantID}}