TracCloud: Rosetta: Difference between revisions

From Redrock Wiki

← Older edit
VisualWikitext
No edit summary
No edit summary
 
(79 intermediate revisions by the same user not shown)
Line 1: Line 1:
<div class="mw-customtoggle-1 mw-customtoggle-2 mw-customtoggle-3" style="float: right; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px">'''Invert Visibility'''</div>
<div style="width:50%; float:left">
<div class="tcWidgetPage" style="margin:1%;">
<b>TracCloud: Table and Field List</b>
<div class="line"></div>


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 [[TracCloud:_Twig|Twig]], the [[TracCloud:_API|API]], as well as how it displays in the [[TracCloud:_Data_Export|SFTP data export]].
</div>
<div class="tcWidgetPage" style="margin:1%;">
<b>Tips</b>
<div class="line"></div>
* Hover over the field name to see an example value.
* Click the header to sort by that column, shift-click to sort by multiple.
</div>
</div>
<div style="width:50%; float:right;">
<div class="tcWidgetPage" style="margin:1%;">
<div style="float: left; margin-top: 0em; margin-bottom: 1em"><b>Type Definitions</b></div><div class="mw-collapsible mw-collapsed">
<br><br>
<br><br>
{| class="wikitable" style="margin:auto;"
!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).
|}
</div>
<br>
</div>
<div class="tcWidgetPage" style="margin:1%;">
<div class="mw-customtoggle-1 mw-customtoggle-2 mw-customtoggle-3 mw-customtoggle-4 mw-customtoggle-5 mw-customtoggle-6 mw-customtoggle-7 mw-customtoggle-8 mw-customtoggle-9 mw-customtoggle-10 mw-customtoggle-11 mw-customtoggle-12 mw-customtoggle-13 mw-customtoggle-14 mw-customtoggle-15" style="float: left; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px">'''Invert All Visibility'''</div><br>
</div>
</div>


<div class="tcWidgetPage" style="width:100%">
<hr>
<!------------------------------------------------------- Students ------------------------------------------------------>
<div class="tcWidgetPage">
<div style="float: left;"><big><b>Students</b></big></div><div style="float: right; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px" class="mw-customtoggle-1">Toggle Visibility</div>
<div style="float: left;"><big><b>Students</b></big></div><div style="float: right; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px" class="mw-customtoggle-1">Toggle Visibility</div>
<div class="mw-collapsible" id="mw-customcollapsible-1">
<div class="mw-collapsible mw-collapsed" id="mw-customcollapsible-1">
{| class="wikitable"
<br><br>
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b> !! <b>SFTP Export</b>
|-
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig Tag</b> !! <b>API</b> !! <b>SFTP Export Column</b> !! <b>Example</b>
| <span title="1234567">Sequence</span>||bigint ||Static identifier for students, unrelated to ID. || || Students.Sequence ||
|-
|-
| ID || bigint || The student's ID number. Should be unique. || <nowiki>{{Student.ID}}</nowiki> || Students.ID || ID || 1234567
| <span title="1a23b4c5-6789-01d2-ef3g-456h78901ijk">UUID</span> || varchar(36) || Unique identifier for this user. || || Students.UUID ||
|-
|-
| First Name || varchar(80) || The student's preferred first name. || <nowiki>{{Student.First_Name}}</nowiki> || Students.First_Name || FirstName || Sam
| <span title="1234567">ID</span> || bigint || The student's ID number. Should be unique.|| <nowiki>{{Student.ID}}</nowiki> || Students.ID || StudentID
|-
|-
| Last Name || varchar(80) || The student's last name || <nowiki>{{Student.Last_Name}}</nowiki> || Students.Last_Name || LastName || Smith
| <span title="A1234567">Other_ID</span>||varchar(40) || Alternative identifier for the student.|| <nowiki>{{Student.Other_ID}}</nowiki> || Students.Other_ID || OtherID
|-
| <span title="ssmith1234">Other_ID2</span>|| varchar(40) || Another alternative identifier for the student. || <nowiki>{{Student.Other_ID2}}</nowiki>|| Students.Other_ID2 || OtherID2
|-
|<span title="87654321">Barcode</span>|| varchar(80) || The student's [[TracCloud:_General_Kiosk_Login_Options_/_Barcode_Scanners|barcode]]. || <nowiki>{{Student.Barcode}}</nowiki> || Students.Barcode || Barcode
|-
| <span title="ACTIVE">Status</span> || varchar(80) || Whether the student is Active or Inactive. || <nowiki>{{Student.Status}}</nowiki> || Students.Status || Status
|-
| <span title="Enrolled">OtherStatus</span> || varchar(80) || Alternative/custom status. || || Students.OtherStatus || StudentOtherStatus
|-
| <span title="Samantha">Legal_First</span> || varchar(80) || The student's legal first name. || <nowiki>{{Student.Legal_First}}</nowiki> || Students.Legal_First || LegalFirst
|-
| <span title="Sam">First Name</span> || varchar(80) || The student's preferred first name.|| <nowiki>{{Student.First_Name}}</nowiki> || Students.First_Name || FirstName
|-
| <span title="Smith">Last Name</span> || varchar(80) || The student's last name. || <nowiki>{{Student.Last_Name}}</nowiki> || Students.Last_Name || LastName
|-
| <span title="Jane">Middle</span> || varchar(80) || The student's middle name. || <nowiki>{{Student.Middle}}</nowiki> || Students.Middle || Middle
|-
| <span title="Smith, Sam J.">Full_Name</span> || varchar(255) || The student's full name, formatted as "Last, First M.". || <nowiki>{{Student.Full_Name}}</nowiki> || Students.Full_Name ||
|-
| <span title="Smith, Sam J">LastFirst</span> || varchar(255) || The student's full name, formatted as "Last, First M". || <nowiki>{{Student.LastFirst}}</nowiki> || ||
|-
| <span title="Sam J. Smith">Full_Name2</span>|| varchar(255) || The student's full name, formatted as "First M. Last". || <nowiki>{{Student.Full_Name2}}</nowiki> || Students.Full_Name2 ||
|-
| <span title="Sam Smith">FirstLast</span>|| varchar(255) || The student's full name, formatted as "First Last". || <nowiki>{{Student.FirstLast}}</nowiki> || ||
|-
| <span title="1234 W Example St">Street</span>|| varchar(250) || The student's street address. || || Students.Street || Street
|-
| <span title="123">Apt</span>|| varchar(80) || The student's apartment number. || || Students.Apt ||
|-
| <span title="Tempe">City</span>|| varchar(120) || The student's city. || || Students.City || City
|-
| <span title="Arizona">State</span>|| varchar(80) || The student's state. || || Students.State || State
|-
| <span title="85210">Zip</span>|| varchar(20) || The student's zip code. || || Students.Zip || ZIP
|-
| <span title="555-555-5555">Home_Phone</span>|| varchar(80) || The student's home phone number. || <nowiki>{{Student.Home_Phone}}</nowiki> || Students.Home_Phone || HomePhone
|-
| <span title="555-555-5555">Work_Phone</span>|| varchar(80) || The student's work phone number. || <nowiki>{{Student.Work_Phone}}</nowiki> || Students.Work_Phone || WorkPhone
|-
| <span title="555-555-5555">Cell_Phone</span>|| varchar(80) || The student's cell phone number. || <nowiki>{{Student.Cell_Phone}}</nowiki> || Students.Cell_Phone || CellPhone
|-
| <span title="ssmith1234@example.edu">Email</span> || varchar(120) || The student's email address, typically their campus email. || <nowiki>{{Student.Email}}</nowiki> || Students.Email || Email
|-
| <span title="Email">Preferred</span>||varchar(80) || The student's preferred contact method. Possible values are listed below.<p style="line-height: 95%; font-size: 15px"><br>1 = Home<br>2 = Work<br>3 = Cell<br>4 = Email<br>5 = Verbal</p>|| <nowiki>{{Student.Preferred}}</nowiki> || Students.Preferred ||
|-
| <span title="2025-01-31">LastDateIn</span>|| date || Date of the student's last visit. || || Students.LastDateIn ||
|-
| <span title="ssmith1234">UserName</span>|| varchar(120) || The student's username for authentication. || <nowiki>{{Student.UserName}}</nowiki> || Students.UserName || StudentUserName
|-
| <span title="1999-12-31">Birthdate</span>||date || The student's birthdate. || || Students.Birthdate || Birthdate
|-
| <span title="He/Him">Pronouns</span>|| varchar(80) || The student's preferred pronouns. || <nowiki>{{Student.Pronouns}}</nowiki> || Students.Pronouns || StudentPronouns
|-
| <span title="Male">Gender</span>|| varchar(80) || The student's gender. || <nowiki>{{Student.Gender}}</nowiki> || Students.Gender || Gender
|-
| <span title="Asian-American">Ethnicity</span>|| varchar(150) || The student's ethnicity. || <nowiki>{{Student.Ethnicity}}</nowiki> || Students.Ethnicity|| Ethnicity
|-
| <span title="Mathematics">Major</span>|| varchar(120) || The student's major. || <nowiki>{{Student.Major}}</nowiki> || Students.Major|| Major
|-
| <span title="Senior">Class</span>||varchar(80) || The student's class. || <nowiki>{{Student.Class}}</nowiki> || Students.Class|| Class
|-
| <span title="BS">DegreeGoal</span>||varchar(80) || The student's degree goal. || <nowiki>{{Student.DegreeGoal}}</nowiki> || Students.DegreeGoal|| DegreeGoal
|-
| <span title="XYZ 2025">Cohort</span>||varchar(80) || The student's cohort. || <nowiki>{{Student.Cohort}}</nowiki> || Students.Cohort|| Cohort
|-
| <span title="Example University">College</span>||varchar(80) || The student's college. || <nowiki>{{Student.College}}</nowiki> || Students.College|| College
|-
| <span title="Grad">Grad_Und</span>||varchar(80) || The student's graduate status. || <nowiki>{{Student.Grad_Und}}</nowiki> || Students.Grad_Und|| GradUndergrad
|-
| <span title="3.4">GPA</span>||double || The student's GPA. || <nowiki>{{Student.GPA}}</nowiki> || Students.GPA || GPA
|-
| <span title="37">AccumHours</span>||double || The student's accumulated hours. || || Students.AccumHours || Hours
|-
| <span title="FWS">Fund</span>|| varchar(80) || The student's fund. || || Students.Fund || StudentFund
|-
| <span title="1234">PrimaryConsultantID</span> || bigint || Relates to Staff.Sequence. || || Students.PrimaryConsultantID ||
|-
| <span title="Men's Tennis SP2024">FlagText</span>|| varchar(80) || The contents of the student's [[TracCloud:_Student_Entry_Choices|"Flag Information" field.]] || || Students.FlagText ||
|-
| <span title="This can be anything.">CustomData</span> || json || All [[TracCloud:_Custom_Fields|custom fields]] are stored in this field. Specify a custom field with its sequence number after "cf_".|| <nowiki>{{Student.CustomData.cf_123}}</nowiki> || Students.CustomData->>``$.cf_123`` || [Field Name]
|-
| <span title="true">WatchLists</span> || json || Returns a true or false value based on whether or not the student is on the specified [[TracCloud:_Student_Lists|watch list.]] Hover over the name of your watch list to find its sequence number (e.g., wl_9) || <nowiki>{{Student.WatchLists.wl_0}}</nowiki> || ||
|-
| <span title="1">gen_BIOConfirmed</span>|| varchar(2) || Whether or not the student has [[TracCloud:_Confirm_Bio|confirmed their bio.]] || || Students.gen_BIOConfirmed ||
|-
| <span title="2025-03-11 08:59:44">gen_BIOConfirmedDT</span>|| varchar(20) || When the student last confirmed their bio. || || Students.gen_BIOConfirmedDT ||
|-
| <span title="2025-03-11 08:53:11">CreatedDT</span>|| timestamp || When this student record was initially created in TracCloud. || || Students.CreatedDT ||
|-
| <span title="2025-01-07 03:48:16">_LastImportedDT</span>|| datetime || The last time this student record was [[TracCloud:_Student_Data_Import|imported]] into TracCloud. || || Students._LastImportedDT ||
|}
|}
</div>
</div>
<br>
<br>
</div>
</div>
 
<!------------------------------------------------------- Visits ------------------------------------------------------>
<div class="tcWidgetPage" style="width:100%">
<div class="tcWidgetPage">
<div style="float: left;"><big><b>Visits</b></big></div><div style="float: right; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px" class="mw-customtoggle-2">Toggle Visibility</div>
<div style="float: left;"><big><b>Visits</b></big></div><div style="float: right; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px" class="mw-customtoggle-2">Toggle Visibility</div>
<div class="mw-collapsible" id="mw-customcollapsible-2">
<div class="mw-collapsible mw-collapsed" id="mw-customcollapsible-2">
{| class="wikitable"
<br><br>
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b> !! <b>SFTP Export</b>
|-
| <span title="1234">Sequence</span> || bigint || A unique identifier for every visit record. || || Visits.Sequence || VisitID
|-
| <span title="2025-03-07 08:45:00">EnteredDT</span> || datetime || The date and time the student entered the center. This will only differ from TimeIn if your center tracks wait time.|| <nowiki>{{Visit.EnteredDT}}</nowiki> || Visits.EnteredDT ||
|-
| <span title="09:45am">EnteredTime</span> || time || The time the student entered, formatted as "09:45am." || <nowiki>{{Visit.EnteredTime}}</nowiki> || ||
|-
| <span title="01/31/25">EnteredDate</span> || time || The date the student entered. || <nowiki>{{Visit.EnteredDate}}</nowiki> || ||
|-
| <span title="2025-03-07 09:00:00">TimeIn</span> || datetime || The date and time the student's visit began. || <nowiki>{{Visit.TimeIn}}</nowiki> || Visits.TimeIn || DateIn <b>and</b> TimeIn
|-
| <span title="09:45am">StartTime</span> || time || The time the student's visit began, formatted as "09:45am." || <nowiki>{{Visit.StartTime}}</nowiki> || ||
|-
| <span title="01/31/25">StartDate</span> || time || The datethe student's visit began. || <nowiki>{{Visit.StartDate}}</nowiki> || ||
|-
| <span title="2025-03-07 10:00:00">TimeOut</span> || datetime || The date and time the student's visit ended. || <nowiki>{{Visit.TimeOut}}</nowiki> || Visits.TimeOut || TimeOut
|-
| <span title="10:45am">EndTime</span> || time || The time the student's visit ended, formatted as "09:45am."  || <nowiki>{{Visit.EndTime}}</nowiki> || ||
|-
| <span title="01/31/25">EndDate</span> || time || The datethe student's visit ended. || <nowiki>{{Visit.EndDate}}</nowiki> || ||
|-
| <span title="0">isWork</span> || tinyint || Whether or not this visit is a work visit. || <nowiki>{{Visit.isWork}}</nowiki> || Visits.isWork ||
|-
| <span title="1234">StudentID</span> || bigint || Relates to Students.Sequence (not Students.ID). || || Visits.StudentID ||
|-
| <span title="1234">CenterID</span> || bigint || Relates to Centers.Sequence || || Visits.CenterID ||
|-
| <span title="1234">ConsultantID</span> || bigint || Relates to Staff.Sequence || || Visits.ConsultantID ||
|-
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig Tag</b> !! <b>API</b> !! <b>SFTP Export Column</b> !! <b>Example</b>
| <span title="1234">RegistrationID</span> || bigint || Relates to Registrations.Sequence || || Visits.RegistrationID ||
|-
|-
| example || example || example || <nowiki>{{example.example}}</nowiki> || example.example || example || example
| <span title="1234">ReasonID</span> || bigint || Relates to Reasons.Sequence || || Visits.ReasonID ||
|-
| <span title="1">isWaiting</span> || tinyint || Whether or not the student is currently waiting to be seen (i.e., TimeIn not yet started). || || Visits.isWaiting ||
|-
| <span title="15">WaitTime</span> || double || How long the student waited to start their visit in minutes (TimeIn - EnteredDT). || <nowiki>{{Visit.WaitTime}}</nowiki> || Visits.WaitTime || WaitTime
|-
| <span title="60">Duration</span> || int || The length of the student's visit in minutes. || <nowiki>{{Visit.Duration}}</nowiki> || Visits.Duration || Duration
|-
| <span title="75">TotalTime</span> || double  || The total visit time (WaitTime + Duration). || <nowiki>{{Visit.TotalTime}}</nowiki> || Visits.TotalTime || TotalTime
|-
| <span title="This can be anything.">CustomData</span> || json || All [[TracCloud:_Custom_Fields|custom fields]] are stored in this field. Specify a custom field with its sequence number after "cf_".|| <nowiki>{{Visit.CustomData.cf_123}}</nowiki> || Visits.CustomData->>``$.cf_123`` || [Field Name]
|-
| <span title="1">isTerminated</span> || tinyint || Whether or not this visit was automatically [[TracCloud:_Log_Listing_Message,_KIOSK_Notices,_and_Custom_KIOSKs|terminated]] by TracCloud. || || Visits.isTerminated ||
|-
| <span title="FWS">Fund</span> || varchar(80) || The fund for this visit. || <nowiki>{{Visit.Fund}}</nowiki> || Visits.Fund || Fund
|-
| <span title="During this visit, we covered X, Y, and an introduction to Z.">CtrNotes</span> || text || The notes field filled in by staff/consultants in TracCloud. || <nowiki>{{Visit.CtrNotes}}</nowiki> || Visits.CtrNotes || VisitNotes
|-
| <span title="1234">SurveyRespID</span> || bigint || Relates to Responses.Sequence. || || Visits.SurveyRespID ||
|-
| <span title="1234">TermID</span> || bigint || Relates to Terms.Sequence. || || Visits.TermID || VisitTermCode (displays Terms.TermCode)
|-
| <span title="1234">SectionID</span> || bigint || Relates to Sections.Sequence. || || Visits.SectionID ||
|-
| <span title="Library">Location</span> || varchar(512) || The location of the visit. || <nowiki>{{Visit.Location}}</nowiki> || Visits.Location || Location
|-
| <span title="0">Online</span> || tinyint || Whether or not the visit was online. || <nowiki>{{Visit.Online}}</nowiki> || Visits.Online|| Online
|-
| <span title="America/Phoenix">TimeZone</span> || varchar(120) || The time zone of this visit's time. || || Visits.TimeZone ||
|-
| <span title="Friday">VisitDay</span> || varchar(20) || The day of week the visit took place. || <nowiki>{{Visit.Day}}</nowiki> || Visits.VisitDay ||Weekday
|}
|}
</div>
</div>
Line 33: Line 237:
</div>
</div>


<div class="tcWidgetPage" style="width:100%">
<!------------------------------------------------------- Appointments ------------------------------------------------------>
<div class="tcWidgetPage">
<div style="float: left;"><big><b>Appointments</b></big></div><div style="float: right; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px" class="mw-customtoggle-3">Toggle Visibility</div>
<div style="float: left;"><big><b>Appointments</b></big></div><div style="float: right; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px" class="mw-customtoggle-3">Toggle Visibility</div>
<div class="mw-collapsible" id="mw-customcollapsible-3">
<div class="mw-collapsible mw-collapsed" id="mw-customcollapsible-3">
{| class="wikitable"
<br><br>
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b> !! <b>SFTP Export</b>
|-
| <span title="1234">Sequence</span> || bigint || A unique identifier for each appointment record. || || Appointments.Sequence || ApptID
|-
| <span title="2025-01-31 14:00:00">StartDT</span> || datetime || The appointment start date and time. || <nowiki>{{Appointment.StartDT}}</nowiki> || Appointments.StartDT || DateIn <b>and</b> TimeIn
|-
| <span title="02:00pm">StartTime</span> || time || The appointment start time, formatted as "02:00pm". || <nowiki>{{Appointment.StartTime}}</nowiki> || ||
|-
| <span title="200pm">DisplayTime</span> || time || The appointment start time, formatted as 2<small>00p</small>. || <nowiki>{{Appointment.DisplayTime|raw}}</nowiki> || ||
|-
| <span title="01/31/25">StartDate</span> || date || The appointment start date, formatted as "01/31/25". || <nowiki>{{Appointment.StartDate}}</nowiki> || ||
|-
| <span title="Fri, Jan 31">DisplayDate</span> || date || The appointment start date, formatted as "Fri, Jan 31" or "Today" for same-day appointments. || <nowiki>{{Appointment.DisplayDate}}</nowiki> || ||
|-
| <span title="60">Duration</span> || double || The length of the appointment in minutes. || <nowiki>{{Appointment.Duration}}</nowiki> || Appointments.Duration || Duration
|-
| <span title="2025-01-31 15:00:00">EndDT</span> || datetime || The appointment end date and time. || <nowiki>{{Appointment.EndDT}}</nowiki> || Appointments.EndDT || TimeOut
|-
| <span title="03:00pm">EndTime</span> || time || The appointment end time. || <nowiki>{{Appointment.EndTime}}</nowiki> || ||
|-
| <span title="01/31/25">EndDate</span> || date || The appointment end date. || <nowiki>{{Appointment.EndDate}}</nowiki> || ||
|-
| <span title="Monday">Day</span> || varchar || The appointment day of week. || <nowiki>{{Appointment.Day}}</nowiki> || || Weekday
|-
| <span title="https://traccloud.go-redrock.com/example/trac/entryinc.php?res=example&_ttoken=example">Link</span> || varchar || A link to the appointment record in TracCloud. || <nowiki>{{Appointment.Link}}</nowiki> || ||
|-
| <span title="1234">StudentID</span> || bigint || Relates to Students.Sequence (not Students.ID). || || Appointments.StudentID ||
|-
| <span title="1234">ConsultantID</span> || bigint || Relates to Staff.Sequence. || || Appointments.ConsultantID ||
|-
| <span title="1234">VisitID</span> || bigint || Relates to Visits.Sequence. || || Appointments.VisitID ||
|-
| <span title="1234">CenterID</span> || bigint || Relates to Centers.Sequence. || || Appointments.CenterID ||
|-
| <span title="1234">ReasonID</span> || bigint || Relates to Reasons.Sequence. || || Appointments.ReasonID ||
|-
| <span title="1234">SectionID</span> || bigint || Relates to Sections.Sequence. || || Appointments.SectionID ||
|-
| <span title="1234">AvailRecID</span> || bigint || Relates to AvailBlocks.Sequence. || || Appointments.AvailRecID ||
|-
| <span title="1234">RecurID</span> || bigint || Recurring appointments that are part of the same series (e.g., weekly at 2pm) will have a matching RecurID. || || Appointments.RecurID ||
|-
| <span title="Attended">Status</span> || varchar(80) || The status of the appointment. || <nowiki>{{Appointment.Status}}</nowiki> || Appointments.Status || ApptStatus
|-
| <span title="Room 15">Location</span> || 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.|| <nowiki>{{Appointment.Location}}</nowiki> || Appointments.Location || Location
|-
| <span title="FWS">Fund</span> || varchar(80) || The appointment fund. || <nowiki>{{Appointment.Fund}}</nowiki> || Appointments.Fund || Fund
|-
| <span title="0">Online</span> || int || Whether or not the appointment is online. Possible values are listed below.<p style="line-height: 95%; font-size: 15px"><br>0 = In-person<br>1 = Online<br>2 = Asynchronous<br>3 = Phone</p> || <nowiki>{{Appointment.Online}}</nowiki> || Appointments.Online || Appointment Meeting Type<br><br>Online (displays as "Yes" or blank)
|-
| <span title="https://zoom.us/example">OnlineURL</span> || 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. || <nowiki>{{Appointment.OnlineLink}}</nowiki> || Appointments.OnlineURL || ApptOnlineURL
|-
| <span title="Schedule conflict.">OtherNotes</span> || text || Student cancellation reason. || <nowiki>{{Appointment.OtherNotes}}</nowiki> || Appointments.OtherNotes || OtherNotes
|-
| <span title="Online 1-on-1">Type</span> || varchar || The type of appointment. 1-on-1 or Group. || <nowiki>{{Appointment.Type}}</nowiki> || || ApptType
|-
| <span title="N/A">Icon</span> || || An icon that indicates the appointment type. {{#fas:user-group}} for in-person and {{#fas:wifi}} for online.  || <nowiki>{{Appointment.Icon|raw}}</nowiki> || ||
|-
| <span title="false">hasDocument</span> || varchar || Whether or not the appointment has a document uploaded, displayed as "true" or "false". || <nowiki>{{Appointment.hasDocument}}</nowiki> || ||
|-
| <span title="Online">OnlineText</span> || varchar || If the appointment is online, this tag will display as "Online", otherwise it will be blank. || <nowiki>{{Appointment.OnlineText}}</nowiki> || ||
|-
| <span title="false">isRecurring</span> || varchar || Whether or not the appointment is recurring, displayed as "true" or "false". || <nowiki>{{Appointment.isRecurring}}</nowiki> || ||
|-
| <span title='<nowiki>["Mar 13, 10:00 am <br/>","Mar 14, 10:00 am <br/>","Mar 15, 10:00 am <br/>"]</nowiki>'>RecurringDates</span> || varchar || An <b>array</b> of recurring appointments in the series. || <nowiki>{{Appointment.RecurringDates}}</nowiki> || ||
|-
| <span title="2025-01-31">recurFirstDate</span> || date || The first date of a recurring appointment series. || <nowiki>{{Appointment.recurFirstDate}}</nowiki> || ||
|-
| <span title="2025-02-28">recurLastDate</span> || date || The last date of a recurring appointment series. || <nowiki>{{Appointment.recurLastDate}}</nowiki> || ||
|-
| <span title="false">isCancelled</span> || varchar || Whether or not the appointment is currently canceled, displayed as "true" or "false". || <nowiki>{{Appointment.isCanceled}}</nowiki> || ||
|-
| <span title="false">isMissed</span> || varchar || Whether or not the appointment is currently missed, displayed as "true" or "false". || <nowiki>{{Appointment.isMissed}}</nowiki> || ||
|-
| <span title="false">autoCanceled</span> || varchar || Whether or not the appointment was automatically canceled due to max cancel/missed in recurring series rules, displayed as "true" or "false". || <nowiki>{{Appointment.autoCanceled}}</nowiki> || ||
|-
| <span title="2024-01-31 14:00:00">SchedDT</span> || datetime || The date and time this appointment was scheduled. || <nowiki>{{Appointment.SchedDT}}</nowiki> || Appointments.SchedDT || ApptScheduledDT
|-
| <span title="2024-01-31 14:00:00">SchedModDT</span> || datetime || The date and time this appointment was last modified || <nowiki>{{Appointment.SchedModDT}}</nowiki> || Appointments.SchedModDT || ApptModifiedDT
|-
| <span title="Student Sam Smith">SchedUser</span> || varchar(80) || The user who originally scheduled this appointment. || <nowiki>{{Appointment.SchedUser}}</nowiki> || Appointments.SchedUser || ScheduledBy
|-
| <span title="N/A">SchedNotes || text || Unused. || || || SchedNotes
|-
| <span title="1234">SurveyRespID</span> || bigint || Relates to Responses.Sequence. || || Appointments.SurveyRespID ||
|-
| <span title="This can be anything.">CustomData</span> || json || All [[TracCloud:_Custom_Fields|custom fields]] are stored in this field. Specify a custom field with its sequence number after "cf_".|| <nowiki>{{Appointment.CustomData.cf_123}}</nowiki> || Appointments.CustomData->>``$.cf_123`` || [Field Name]
|-
| <span title="SysAdmin jdoe">SchedModBy</span> || varchar(80) || The user who last edited the appointment. || <nowiki>{{Appointment.SchedModBy}}</nowiki> || Appointments.SchedModBy || ApptModifiedBy
|}
</div>
<br>
</div>
 
<!------------------------------------------------------- AvailBlocks------------------------------------------------------>
<div class="tcWidgetPage">
<div style="float: left;"><big><b>Availabilities</b></big></div><div style="float: right; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px" class="mw-customtoggle-4">Toggle Visibility</div>
<div class="mw-collapsible mw-collapsed" id="mw-customcollapsible-4">
<br><br>
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || A unique identifier for every availability record. || || AvailBlocks.Sequence
|-
| <span title="2025-03-11 09:30:00">FromDT</span> || datetime || The starting date and time of this availability block. || || AvailBlocks.FromDT
|-
| <span title="2025-04-12 11:30:00">ToDT</span> || datetime || The ending date and time of this availability block. || || AvailBlocks.ToDT
|-
| <span title="45">Increments</span> || varchar(5) || The increment duration in minutes. || || AvailBlocks.Increments
|-
| <span title="15">Breaks</span> || varchar(5) || The delay between increments in minutes. || || AvailBlocks.Breaks
|-
| <span title="MONWEDFRI">DAYS</span> || varchar(30) || Which days of the week this availability is available on. || || AvailBlocks.Days
|-
| <span title="1">isAvail</span> || int || 0 = Reserve block, 1 = Regular availability, 2 = Stacked availability. || <nowiki>{{AvailBlock.isAvail}}</nowiki> || AvailBlocks.isAvail
|-
| <span title="Scheduled off for Holiday.">BlockType</span> || varchar(256) || Reserve block description. || || AvailBlocks.BlockType
|-
| <span title="Canceled - Holiday">BlockStatus</span> || varchar(80) || Reserve block appointment status. || || AvailBlocks.BlockStatus
|-
| <span title="3">MaxStudents</span> || int || The number of available slots at this time. || <nowiki>{{AvailBlock.MaxStudents}}</nowiki> || AvailBlocks.MaxStudents
|-
| <span title="1234">ConsultantID</span> || bigint || Relates to Staff.Sequence. || || AvailBlocks.ConsultantID
|-
| <span title="1234">CenterID</span> || bigint || Relates to Centers.Sequence. || || AvailBlocks.CenterID
|-
| <span title="1234">ReasonID</span> || bigint || Relates to Reasons.Sequence. || || AvailBlocks.ReasonID
|-
| <span title="1234">SectionID</span> || bigint || Relates to Sections.Sequence. || || AvailBlocks.SectionID
|-
| <span title="ACTG100*">AvailSubj</span> || varchar(256) || The availability subject, including wildcard entries. || || AvailBlocks.AvailSubj
|-
| <span title="Optional Weekly Chosen">RecurType</span> || || The type of recurring appointment. The possible options are listed below.<p style="line-height: 95%; font-size: 15px"><br>None<br>Daily<br>Weekly<br>Bi-Weekly<br>Optional Daily<br>Optional Weekly<br>Optional Bi-Weekly<br>Optional Daily Chosen<br>Optional Weekly Chosen<br>Optional Bi-Weekly Chosen</p> || || AvailBlocks.RecurType
|-
| <span title="Room 15">Location</span> || varchar(512) || The in-person location for this availability. || || AvailBlocks.Location
|-
| <span title="https://zoom.us/example">OnlineURL</span> || varchar(512) || The online location for this availability. || || AvailBlocks.OnlineURL
|-
| <span title="FWS">Fund || varchar(80) || The availability fund. || || AvailBlocks.Fund
|-
| <span title="1">isInperson</span> || tinyint || Whether or not the availability is in-person. || || AvailBlocks.isInperson
|-
| <span title="1">isOnline</span> || tinyint || Whether or not the availability is online. || || AvailBlocks.isOnline
|-
| <span title="0">isAsynch</span> || tinyint || Whether or not the availability is asynchronous. || || AvailBlocks.isAsync
|-
| <span title="2">defLocChoice</span> || int || The default location choice. 0 = in-person, 1 = online, 2 = asynchronous. || || AvailBlocks.defLocChoice
|-
| <span title="0">isMeeting || tinyint || Whether or not a reserve block is designated as as meeting block. || || AvailBlocks.isMeeting
|}
</div>
<br>
</div>
 
<!------------------------------------------------------- Course Related  ------------------------------------------------------>
<div class="tcWidgetPage">
<div style="float: left;"><big><b>Course Related</b> (Courses, Sections, Terms, Registrations, Faculty, SectionSchedule)</big></div><div style="float: right; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px" class="mw-customtoggle-5">Toggle Visibility</div>
<div class="mw-collapsible mw-collapsed" id="mw-customcollapsible-5">
<br><br>
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ Courses
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b> !! <b>SFTP Export</b>
|-
| <span title="1234">Sequence</span> || bigint || A unique identifier for every course. ||  || ||
|-
| <span title="BIOL">Subject</span> || varchar(40) || The subject. || <nowiki>{{Course.Subject}}</nowiki> || Courses.Subject || Subject
|-
| <span title="101">Course</span> || varchar(20) || The course number. || <nowiki>{{Course.Course}}</nowiki> || Courses.Course || Course
|-
| <span title="Introduction to Biology">Title</span> || varchar(120) || The course title. || <nowiki>{{Course.Title}}</nowiki> || Courses.Title || Title
|-
| <span title="0">ExcludeFromCharts</span> || tinyint || Whether or not this course is configured to be excluded from charts. || || Courses.ExcludeFromCharts ||
|-
| <span title="Computer Science">Dept</span> || varchar(40) || The assigned department for this course. || || Courses.Dept ||
|-
| <span title="BIOL101">SubjectCourse</span> || varchar(200) || Combination of Subject and Course in one field. ||  <nowiki>{{Course.SubjectCourse}}</nowiki> || Courses.SubjectCourse ||
|-
| <span title="BIOL101 Introduction to Biology">SubjectCourseTitle</span> || varchar || Combination of Subject, Course, and Title in one field. || <nowiki>{{Course.SubjectCourseTitle}}</nowiki> || ||
|-
| <span title="2025-01-31 02:00:00">_LastImportedDT</span> || datetime || The date and time this record was last imported. || || Courses._LastImportedDT ||
|-
| <span title="This can be anything.">CustomData</span> || json || All [[TracCloud:_Custom_Fields|custom fields]] are stored in this field. Specify a custom field with its sequence number after "cf_".|| <nowiki>{{Course.CustomData.cf_123}}</nowiki> || Courses.CustomData->>``$.cf_123`` || [Field Name]
|-
| <span title="A123B456C">RelatedCoursesID</span> || varchar(20) || The course family identifer. || || Courses.RelatedCoursesID ||
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ Sections
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b> !! <b>SFTP Export</b>
|-
| <span title="1234">Sequence</span> || bigint || A unique identifier for each section. || || Sections.Sequence ||
|-
| <span title="0">Inactive</span> || tinyint || Whether or not this section is currently inactive. || || Sections.Inactive ||
|-
| <span title="A01">Code</span> || varchar(80) || The section code/number. || <nowiki>{{Section.Code}}</nowiki> || Sections.Code || Section
|-
| <span title="1234">CourseID</span> || bigint || Relates to Courses.Sequence. || || Sections.CourseID ||
|-
| <span title="1234">GradeGroupID</span> || bigint || Relates to GradeGroups.Sequence. || || Sections.GradeGroupID ||
|-
| <span title="12345">CRN</span> || varchar(80) || The CRN of this section record. || <nowiki>{{Section.CRN}}</nowiki> || Sections.CRN || CRN
|-
| <span title="1234">TermID</span> || bigint || Relates to Terms.Sequence (not Terms.TermCode). || || Sections.TermID ||
|-
| <span title="1234">FacultyID</span> || bigint || Relates to Sections.FacultyID (not Faculty.UserID). || || Sections.FacultyID ||
|-
| <span title="0">nonEnrolled</span> || tinyint || Whether or not this is a [[TracCloud:_Non-Enrolled_Courses|non-enrolled course]]. || || Sections.nonEnrolled ||
|-
| <span title="This can be anything.">CustomData</span> || json || All [[TracCloud:_Custom_Fields|custom fields]] are stored in this field. Specify a custom field with its sequence number after "cf_".|| <nowiki>{{Section.CustomData.cf_123}}</nowiki> || Sections.CustomData->>``$.cf_123`` || [Field Name]
|-
| <span title="2025-01-31 02:00:00">CreatedDT</span> || timestamp || When this section record was initially created. || || Sections.CreatedDT ||
|-
| <span title="0">ignoreRegImportDeactivate</span> || tinyint || Whether or not this section is configured to ignore deactivations. || || Sections.ignoreRegImportDeactivate ||
|-
| <span title="100">Credits</span> || double || The potential credits for this section. || || Sections.Credits ||
|-
| <span title="2025-01-31 02:00:00">_LastImportedDT</span> || datetime || The latest date and time this record was imported into TracCloud. || || Sections._LastImportedDT ||
|-
| <span title="Introduction to Biology">Title</span> || varchar(120) || This optional field overrides Courses.Title if present. || <nowiki>{{Section.Title}}</nowiki> || Sections.Title ||
|-
| <span title="MAT350 2025SP">SubjectTermCode</span> || || Combination of Courses.SubjectCourse and Terms.TermCode. || <nowiki>{{Section.SubjectTermCode}}</nowiki> || ||
|-
| <span title="MAT300 Introduction to Calculus">SubjectTitle</span> || || Combination of Courses.SubjectCourse and Courses.Title. || <nowiki>{{Section.SubjectTitle}}</nowiki> || ||
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ Terms
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b> !! <b>SFTP Export</b>
|-
| <span title="1234">Sequence</span> || bigint || A unique identifer for this term record. || || Terms.Sequence ||
|-
| <span title="1">Active</span> || tinyint || Whether or not this term is currently active. || || Terms.Active ||
|-
| <span title="2025SP">TermCode</span> || varchar(80) || The term/semester code. || <nowiki>{{Term.TermCode}}</nowiki> || Terms.TermCode || Term
|-
| <span title="2025-01-31">ActiveFrom</span> || date || The start date of this term. || || Terms.ActiveFrom ||
|-
| <span title="2025-03-31">ActiveTo</span> || date || The end date of this term. || || Terms.ActiveTo ||
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ Registrations
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b> !! <b>SFTP Export</b>
|-
| <span title="1234">Sequence</span>|| bigint || A unique identifier for this registration record. || || Registrations.Sequence ||
|-
| <span title="0">Inactive</span> || tinyint || Whether or not this registration is currently inactive. || || Registrations.Inactive ||
|-
| <span title="0">OverrideDate</span> || tinyint || Whether or not this registration is configured with a date override. || || Registrations.OverrideDate ||
|-
| <span title="1234">SectionID</span> || bigint || Relates to Sections.Sequence. || || Registrations.SectionID ||
|-
| <span title="1234">StudentID</span> || bigint || Relates to Students.Sequence (not Students.ID). || || Registrations.StudentID ||
|-
| <span title="B+">Grade</span> || varchar(40) || The registration grade. || || Registrations.Grade ||
|-
| <span title="2025-01-31 02:00:00">ValidFromDT</span> || datetime || The start date of this registration. || || Registrations.ValidFromDT ||
|-
| <span title="2025-03-31 02:00:00">ValidToDT</span> || datetime || The end date of this registration. || || Registrations.ValidToDT ||
|-
| <span title="This can be anything.">Notes</span> || text || The registration notes field. || || Registrations.Notes ||
|-
| <span title="This can be anything.">CustomData</span> || json || All [[TracCloud:_Custom_Fields|custom fields]] are stored in this field. Specify a custom field with its sequence number after "cf_".|| <nowiki>{{Registration.CustomData.cf_123}}</nowiki> || Registrations.CustomData->>``$.cf_123`` || [Field Name]
|-
| <span title="2025-01-31 02:00:00">_LastImportedDT</span> || datetime || The latest date and time this record was imported into TracCloud. || || Registrations._LastImportedDT ||
|-
| <span title="Dropped">RegStatus</span> || varchar(40) || The registration status (dropped, withdrawn, enrolled, etc). || || Registrations.RegStatus ||RegistrationStatus
|-
| <span title="100">EarnedCredits</span> || double || The student's earned credits in this enrollment. || || Registrations.EarnedCredits ||
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ Faculty
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b> !! <b>SFTP Export</b>
|-
| <span title="1234">Sequence</span> ||  bigint || Static identifier for faculty, unrelated to UserID. || || Faculty.Sequence ||
|-
| <span title="1a23b4c5-6789-01d2-ef3g-456h78901ijk">UUID</span> || varchar(36) || Unique identifer for faculty records. || || Faculty.UUID ||
|-
| <span title="Jane">FirstName</span> || varchar(80) || The faculty member's first name. || <nowiki>{{Faculty.FirstName}}</nowiki>* || Faculty.FirstName || FacultyFirst
|-
| <span title="Doe">LastName</span> || varchar(80) || The faculty member's last name. || <nowiki>{{Faculty.LastName}}</nowiki>* || Faculty.LastName || FacultyLast
|-
| <span title="A1234">UserID</span> || varchar(80) || The faculty member's ID number. || <nowiki>{{Faculty.UserID}}</nowiki>* || Faculty.UserID || FacultyUserID
|-
| <span title="jdoe123">UserName</span> || varchar(80) || The faculty member's username for authentication. || <nowiki>{{Faculty.UserName}}</nowiki>* || Faculty.UserName || FacultyUserName
|-
| <span title="Dr.">Salutation</span> || varchar(40) || The faculty member's salutation (e.g., Dr.). || <nowiki>{{Faculty.Salutation}}</nowiki>* || Faculty.Salutation || Salutation
|-
| <span title="Dr. Jane Doe">SalutationFullName</span> ||  || Combination of salutation and full name. || <nowiki>{{Faculty.SalutationFullName}}</nowiki>* || ||
|-
| <span title="Dr. Doe">SalutationLastName</span> ||  || Combination of salutation and last name. || <nowiki>{{Faculty.SalutationLastName}}</nowiki>* || ||
|-
| <span title="Computer Science">Department</span> || varchar(60) || The faculty member's department. || <nowiki>{{Faculty.Department}}</nowiki>* || Faculty.Department || FacultyDepartment
|-
| <span title="0">Inactive</span> || tinyint || Whether or not this faculty is currently inactive. || || Faculty.Inactive ||
|-
| <span title="555-555-5555">Phone</span> || varchar(80) || The faculty member's phone number. || <nowiki>{{Faculty.Phone}}</nowiki>* || Faculty.Phone ||
|-
| <span title="jdoe@example.edu">Email</span> || varchar(120) || The faculty member's email address. || <nowiki>{{Faculty.Email}}</nowiki>* || Faculty.Email || FacultyEmail
|-
| <span title="This can be anything.">CustomData</span> || json || All [[TracCloud:_Custom_Fields|custom fields]] are stored in this field. Specify a custom field with its sequence number after "cf_".|| <nowiki>{{Faculty.CustomData.cf_123}}</nowiki>* || Faculty.CustomData->>``$.cf_123`` || [Field Name]
|-
| <span title="A1234567">OtherID</span> || varchar(80) || An alternate hidden identifier for faculty. This is typically left blank. || || Faculty.OtherID ||
|-
| <span title="Jane Doe Dr.">FullName</span> || varchar(255) || Combination of FirstName, LastName, and Saltuation in one field. || <nowiki>{{Faculty.FullName}}</nowiki>* || Faculty.FullName ||
|-
| <span title="2025-01-31 02:00:00">_LastImportedDT</span> || datetime || The latest date and time this record was imported into TracCloud. || || Faculty._LastImportedDT ||
|}
* To reference the STEP faculty in [[TracCloud:_Work_Plans|work plans]] with Twig, the "StepFaculty" prefix should be used instead (e.g., <nowiki>{{StepFaculty.FirstName}}</nowiki>). The regular "Faculty" prefix shown above should be used everywhere else.
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ SectionSchedule
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || A unique identifer for this section schedule record. || SectionSchedule.Sequence
|-
| <span title="1234">SectionID</span> || bigint || Relates to Sections.Sequence (not Sections.Code). || SectionSchedule.SectionID
|-
| <span title="MONTUEFRI">Days</span> || varchar(30) || Which days this class takes place on. || SectionSchedule.Days
|-
| <span title="09:00:00">Time</span> || time || What time the class starts. || SectionSchedule.Time
|-
| <span title="120">Duration</span> || int || The duration of the class in minutes. ||  SectionSchedule.Duration
|-
| <span title="This can be anything.">Description</span> || text || The description for this class. || SectionSchedule.Description
|-
| <span title="North Campus">Campus</span> || varchar(80) || The campus. || SectionSchedule.Campus
|-
| <span title="Building 3">Bldg</span> || varchar(80) || The building. || SectionSchedule.Bldg
|-
| <span title="Room 2">Room</span> || varchar(80) || The room. || SectionSchedule.Room
|}
</div>
<br>
</div>
 
<!------------------------------------------------------- Staff/Consultants------------------------------------------------------>
<div class="tcWidgetPage">
<div style="float: left;"><big><b>Staff/Consultants</b></big></div><div style="float: right; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px" class="mw-customtoggle-6">Toggle Visibility</div>
<div class="mw-collapsible mw-collapsed" id="mw-customcollapsible-6">
<br><br>
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b> !! <b>SFTP Export</b>
|-
| <span title="1234">Sequence</span> || bigint || Static identifer for staff. || || Staff.Sequence ||
|-
| <span title="1a23b4c5-6789-01d2-ef3g-456h78901ijk">UUID</span> || varchar(36) || Unique Identifer for each user. || || Staff.UUID ||
|-
| <span title="Jane">First_Name</span> || varchar(80) || The staff member's first name. || <nowiki>{{Consultant.First_Name}}</nowiki>* || Staff.First_Name || ConsultantFirst
|-
| <span title="Doe">Last_Name</span> || varchar(80) || The staff member's last name. || <nowiki>{{Consultant.Last_Name}}</nowiki>* || Staff.Last_Name || ConsultantLast
|-
| <span title="Doe, Jane">LastFirst</span> || varchar(255) || The staff member's full name, formatted as "Last, First". || <nowiki>{{Consultant.LastFirst}}</nowiki>* || Staff.LastFirst ||
|-
| <span title="Jane Doe">FirstLast</span> || varchar(255) || The staff member's full name, formatted as "First Last". || <nowiki>{{Consultant.FirstLast}}</nowiki>* || Staff.FirstLast ||
|-
| <span title="Jan">Alias</span> || varchar(120) || The staff member's alias/alternative name. || <nowiki>{{Consultant.Alias}}</nowiki>* || Staff.Alias || ConsultantAlias
|-
| <span title="jdoe123@example.edu">Email</span> || varchar(120) || The staff member's email address. || <nowiki>{{Consultant.Email}}</nowiki>* || Staff.Email || ConsultantEmail
|-
| <span title="jdoe123">UserName</span> || varchar(80) || The staff member's username. This typically matches Students.Username if the user has both account types. || <nowiki>{{Consultant.UserName}}</nowiki>* || Staff.UserName || ConsultantUserName
|-
| <span title="2">UserLevel</span> || int || The staff member's [[TracCloud:_Staff_User_Level|user level]]. The possible options are listed below. <p style="line-height: 95%; font-size: 15px"><br>0 = Staff<br>1 = SysAdmin<br>2 = Profile Admin</p> || || Staff.UserLevel ||
|-
| <span title="2025-03-17 10:21:34">LastAccess</span> || datetime || Date and time this staff member last logged into TracCloud. || || Staff.LastAccess ||
|-
| <span title="1234">GroupID</span> || bigint || The staff member's permission group, relates to Groups.Sequence. || || Staff.GroupID ||
|-
| <span title="0">isKiosk</span> || tinyint || Whether or not this staff account is configured to be a kiosk account. || || Staff.isKiosk ||
|-
| <span title="1">isConsultant</span> || tinyint || Whether or not this staff account is configured to be a consultant account. || || Staff.isConsultant ||
|-
| <span title="0">Inactive</span> || tinyint || Whether or not this account is inactive. || || Staff.Inactive ||
|-
| <span title="555-555-5555">Phone</span> || varchar(30) || The staff member's phone number. || <nowiki>{{Consultant.Phone}}</nowiki>* || Staff.Phone ||
|-
| <span title="555-555-5555">CellPhone</span> || varchar(80) || The staff member's cell phone number. || <nowiki>{{Consultant.CellPhone}}</nowiki>* || Staff.CellPhone ||
|-
| <span title="555-555-5555">WorkPhone</span> || varchar(80) || The staff member's work phone number. || <nowiki>{{Consultant.WorkPhone}}</nowiki>* || Staff.WorkPhone ||
|-
| <span title="1234 E Example St.">Address</span> || varchar(80) || The staff member's street address. || || Staff.Address ||
|-
| <span title="Tempe">City</span> || varchar(120) || The staff member's city. || || Staff.City ||
|-
| <span title="AZ">State</span> || varchar(80) || The staff member's state. || || Staff.State ||
|-
| <span title="85210">Zip</span> || varchar(20) || The staff member's zip/post code. || || Staff.Zip ||
|-
| <span title="1234">CourseListID</span> || bigint || Relates to CourseList.Sequence || || Staff.CourseListID ||
|-
| <span title="Room 201">Location</span> || varchar(512) || The staff member's assigned in-person location. || || Staff.Location || ConsultantLocation
|-
| <span title="https://zoom.us/example">OnlineLink</span> || varchar(512) || The staff member's assigned online URL. || || Staff.OnlineLink || ConsultantOnlineLink
|-
| <span title="FWS">Fund</span> || varchar(80) || The staff member's assigned fund. || || Staff.Fund || ConsultantFund
|-
| <span title="1234">PayCodeID</span> || bigint || Relates to PayCodes.Sequence. || || Staff.PayCodeID ||
|-
| <span title="2025-01-31">Hired</span> || date || The date this staff member was hired. || || Staff.Hired || ConsultantHired
|-
| <span title="2025-02-01">Terminated</span> || date || The date this staff member's employment was terminated. || || Staff.Terminated || ConsultantTerminated
|-
| <span title="Gave notice due to leaving state.">ReasonQuit</span> || varchar(220) || The reason for employment termination. || || Staff.ReasonQuit || ConsultantReasonQuit
|-
| <span title="201">Mailbox</span> || varchar(80) || The staff member's mailbox. || || Staff.Mailbox ||
|-
| <span title="1234">CenterID</span> || bigint || The staff member's default center. Relates to Centers.Sequence. || || Staff.CenterID || Mailbox
|-
| <span title="0">noShowOnSched</span> || tinyint || Whether or not this staff member has been configured to not show on the schedule. || || Staff.noShowOnSched ||
|-
| <span title="Peer tutor referal from Dave Smith.">Notes</span> || text || The staff member's notes field. || <nowiki>{{Consultant.Notes}}</nowiki>* || Staff.Notes ||
|-
| <span title="This can be anything.">CustomData</span> || json || All [[TracCloud:_Custom_Fields|custom fields]] are stored in this field. Specify a custom field with its sequence number after "cf_".|| <nowiki>{{Consultant.CustomData.cf_123}}*</nowiki> || Staff.CustomData->>``$.cf_123`` || [Field Name]
|-
| <span title="A12345">OtherID</span> || varchar(80) || The staff member's alternate/other ID. || || Staff.OtherID || ConsultantOtherID
|-
| <span title="Jane Doe is a Peer Tutor who specializes in...">StaffBIO</span> || text || The staff member's bio text. || <nowiki>{{Consultant.StaffBIO|raw}}</nowiki>* || Staff.StaffBIO ||
|-
| <span title="She/Her">Pronouns</span> || varchar(80) || The staff member's preferred pronouns. || <nowiki>{{Consultant.Pronouns}}</nowiki>* || Staff.Pronouns || ConsultantPronouns
|-
| <span title="2025-01-31 14:30:26">CreatedDT</span> || datetime || The date that this staff record was created. || || Staff.CreatedDT ||
|-
| <span title="2025-03-15 04:30:01">_LastImportedDT</span> || datetime || The date that this staff record was last imported (only applicable if importing staff). || || Staff._LastImportedDT ||
|-
| <span title="AAA">KioskSort</span> || varchar(10) || The staff member's sort code. || || Staff.KioskSort ||
|-
| <span title="1234">SupervisorID</span> || int || The staff member's assigned supervisor. Relates to Staff.Sequence. || || Staff.SupervisorID ||
|-
| <span title="Peer Tutor">TitleOrPosition</span> || varchar(80) || The staff member's title/position. || || Staff.TitleOrPosition ||
|-
| <span title="N/A">Photo</span> || || The staff member's photo. || <nowiki>{{Consultant.Photo|raw}}</nowiki>* || ||
|}
 
<b><nowiki>*</nowiki></b> 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.<br>
* "Staff" (e.g., <nowiki>{{Staff.First_Name}}</nowiki>) should be used in: [[TracCloud:_Workshops|Workshop descriptions and notifications]], [[TracCloud:_Announcements|announcements]], [[TracCloud:_Confirm_Bio|staff bio on search availability]], [[TracCloud:_Work_Plans|Work Plan assignees]], and the [[TracCloud:_Welcome_Messages|staff welcome message]]
* "Supervisor" (e.g., <nowiki>{{Supervisor.First_Name}}</nowiki>) should be used when referencing the assigned supervisor in [[TracCloud:_Work_Plans|Work Plan]] fields.
* "StepSupervisor" (e.g., <nowiki>{{StepSupervisor.First_Name}}</nowiki>) should be used when referencing the STEP supervisor in [[TracCloud:_Work_Plans|Work Plan]] fields.
</div>
<br>
</div>
 
<!------------------------------------------------------- Centers, Profiles, Groups, Reasons ------------------------------------------------------>
<div class="tcWidgetPage">
<div style="float: left;"><big><b>Profile Related</b> (Profiles, Centers, Reasons, Groups)</big></div><div style="float: right; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px" class="mw-customtoggle-7">Toggle Visibility</div>
<div class="mw-collapsible mw-collapsed" id="mw-customcollapsible-7">
<br><br>
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ Profiles
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each profile. || Profiles.Sequence
|-
| <span title="1">Type</span> || int || The type of profile. Possible values are listed below.<p style="line-height: 95%; font-size: 15px"><br>1 = TutorTrac<br>2 = AdvisorTrac<br>3 = FitnessTrac</p> || Profiles.Type
|-
| <span title="Redrock University">Name</span> || varchar(80) || The name of the profile. || Profiles.Name
|-
| <span title="0">Inactive</span> || tinyint || Whether or not this profile is currently inactive. || Profiles.Inactive
|-
| <span title="1234">ContactID</span> || bigint || The main contact for this profile. Relates to Staff.Sequence. || Profiles.ContactID
|-
| <span title="Tutors">NameForConsultant</span> || varchar(80) || The name of the "consultant" user type in TracCloud. || Profiles.NameForConsultant
|-
| <span title="America/Phoenix">TimeZone</span> || varchar(120) || This profile's time zone. Uses system time zone if blank (which is common). || Profiles.TimeZone
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ Centers
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b> !! <b>SFTP Export</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifier for each center. || || Centers.Sequence ||
|-
| <span title="Writing Center">Name</span> || varchar(80) || The name of the center. || <nowiki>{{Center.Name}}</nowiki> || Centers.Name || Centers
|-
| <span title="1234">CourseListID</span> || bigint || The center's linked course list, relates to CourseList.Sequence. || || Centers.CourseListID ||
|-
| <span title="1234">ProfileID</span> || bigint || Which profile this center is linked to, relates to Profiles.Sequence. || || Centers.ProfileID ||
|-
| <span title="0">Inactive</span> || tinyint || Whether or not this center is currently inactive. || || Centers.Inactive ||
|-
| <span title="2025-03-11 10:40:47">UpdatedDT</span> || datetime || The last time this center record was modified. || || Centers.UpdatedDT ||
|-
| <span title="1">IsWritingCenter</span> || tinyint || Whether or not this center has been configured to ignore consultant specialties. || || Centers.IsWritingCenter ||
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ Reasons
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b> !! <b>SFTP Export</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifier for each reason. || || Reasons.Sequence ||
|-
| <span title="1234">ProfileID</span> || bigint || Which profile this reason is linked to, relates to Profiles.Sequence. || || Reasons.ProfileID ||
|-
| <span title="Essay Help">Reason</span> || varchar(80) || The name of the reason. || <nowiki>{{Reason.ReasonName}}</nowiki><br><nowiki>{{Reason.Reason}}</nowiki> || Reasons.Reason || Reason
|-
| <span title="0">Inactive</span> || tinyint || Whether or not this reason is inactive. || || Reasons.Inactive ||
|-
| <span title="0">isWork</span> || tinyint || Whether or not this reason is a [[TracCloud:_Payroll|work reason.]] || || Reasons.isWork ||
|-
| <span title="AAA">SortCode</span> || varchar(40) || The sort code for this reason to override alphabetical sorting. || || Reasons.SortCode ||
|-
| <span title="Writing">Category</span> || varchar(80) || The reason's category. || <nowiki>{{Reason.Category}}</nowiki> || Reasons.Category ||
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ Groups
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifier for each group. || Groups.Sequence
|-
| <span title="Peer Tutors">GroupName</span> || varchar(80) || The name of the group. || Groups.GroupName
|-
| <span title="1234">ProfileID</span> || bigint || Which profile this group is assigned to, relates to Profiles.Sequence. || Groups.ProfileiD
|}
</div>
<br>
</div>
 
<!------------------------------------------------------- SurveyTrac ------------------------------------------------------>
<div class="tcWidgetPage">
<div style="float: left;"><big><b>SurveyTrac Related</b> (Surveys, SrvyQuestions, Responses, SrvyRespAnswers)</big></div><div style="float: right; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px" class="mw-customtoggle-8">Toggle Visibility</div>
<div class="mw-collapsible mw-collapsed" id="mw-customcollapsible-8">
<br><br>
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ Surveys
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each survey. || || Surveys.Sequence
|-
| <span title="Writing Center Survey">Name</span> || varchar(80) || The title of the survey. || <nowiki>{{Survey.Name}}</nowiki> || Surveys.Name
|-
| <span title="1234">CreatedBy</span> || bigint || The user who created the survey, relates to Staff.Sequence. || || Surveys.CreatedBy
|-
| <span title="1234">ProfileID</span> || bigint || Which profile this survey is linked to, relates to Profiles.Sequence. || || Surveys.ProfileID
|-
| <span title="Email after visit">AutoSend</span> || varchar(80) || The chosen "Initiated Via" option. || || Surveys.AutoSend
|-
| <span title="1">Active</span> || tinyint || Whether or not this survey is currently active. || || Surveys.Active
|-
| <span title="2025-01-31">ActiveFrom</span> || date || The start date of the survey period. || || Surveys.ActiveFrom
|-
| <span title="2025-02-15">ActiveTo</span> || date || The end date of the survey period. || || Surveys.ActiveTo
|-
| <span title="Please fill out the questions below.">Instructions</span> || text || The instructions displayed to the recipient when filling out the survey. || || Surveys.Instructions
|-
| <span title="Thanks for responding!">Confirmation</span> || text || The text shown to the recipient after submitting a response. || || Surveys.Confirmation
|-
| <span title="Writing Survey">HeadText</span> || text || The survey title shown to the recipient above the questions. || || Surveys.HeadText
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ SrvyQuestions
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each survey question. || SrvyQuestions.Sequence
|-
| <span title="How was your visit today?">Question || text || The question text. || SrvyQuestions.Question
|-
| <span title="1234">SurveyID</span> || bigint || Which survey the question is assigned to, relates to Surveys.Sequence. || SrvyQuestions.SurveyID
|-
| <span title="100">Points</span> || double || How many points a correct answer is worth ([[TracCloud:_Grade_Groups_%26_Potential_Assignments|more info.]] || SrvyQuestions.Points
|-
| <span title="Strongly Agree\nAgree\nDisagree\nStrongly Disagree">AnswerChoices || text || The available answers students can select from. || SrvyQuestions.AnswerChoices
|-
| <span title="multi-check">Type</span> || varchar(80) || The format/type of question. || SrvyQuestions.Type
|-
| <span title="3">Number</span> || int || The question number; the value that determines question order. || SrvyQuestions.Number
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ Responses
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each survey response. || Responses.Sequence
|-
| <span title="1234">SurveyID</span> || bigint || Which survey this response is linked to, relates to Surveys.Sequence. || Responses.Sequence
|-
| <span title="1a23b4c5-6789-01d2-ef3g-456h78901ijk">linkedUID</span> || varchar(36) || The UUID of the person who answered this survey. || Responses.linkedUID
|-
| <span title="Dashboard">SentByID</span> || 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
|-
| <span title="1234">StudentID</span> || bigint || The student recipient, relates to Students.Sequence (not Students.ID). || Responses.StudentID
|-
| <span title="Dashboard">SentBy</span> || varchar(80) || Same as SentByID, except in the case of surveys sent by staff this field will display username instead of UUID. || Responses.SentBy
|-
| <span title="2025-01-31 14:00:00">SentDate</span> || datetime || The date and time this survey was sent to the recipient. || Responses.SentDate
|-
| <span title="2025-01-31 15:30:00">AnsweredDate</span> || datetime || The date and time the recipient responded to the survey. This will be null if no response has been received. || Responses.AnsweredDate
|-
| <span title="1234">StaffID</span> || bigint || The staff recipient, relates to Staff.Sequence. || Responses.StaffID
|-
| <span title="1234">FacultyID</span> || bigint || The faculty recipient, relates to Faculty.Sequence. || Responses.FacultyID
|-
| <span title="0">SentManually</span> || tinyint || Whether or not this survey was manually sent to the recipient. || Responses.SentManually
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ SrvyRespAnswers
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each question response. || SrvyRespAnswers.Sequence
|-
| <span title="1234">QuestionID</span> || bigint || Which question this response relates to, relates to SrvyQuestions.Sequence. || SrvyRespAnswers.QuestionID
|-
| <span title="1234">ResponseID</span> || bigint || Which survey response this question response relates to, relates to Responses.Sequence. || SrvyRespAnswers.ResponseID
|-
| <span title="Strongly Agree">tAnswer</span> || varchar(80) || The recipient's answer to the question || SrvyRespAnswers.tAnswer
|}
</div>
<br>
</div>
 
<!------------------------------------------------------- Documents ------------------------------------------------------>
<div class="tcWidgetPage">
<div style="float: left;"><big><b>Document Related</b> (Documents, DocTypes)</big></div><div style="float: right; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px" class="mw-customtoggle-9">Toggle Visibility</div>
<div class="mw-collapsible mw-collapsed" id="mw-customcollapsible-9">
<br><br>
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ Documents
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each document. || || Documents.Sequence
|-
| <span title="1a23b4c5-6789-01d2-ef3g-456h78901ijk">linkedUID</span> || varchar(36) || The UUID of the user account this document is upload to, for Student/Staff documents. || || Documents.linkedUID
|-
| <span title="appointment">Usage</span> || varchar(255) || Where this document is uploaded. Possible values are listed below.<p style="line-height: 95%; font-size: 15px"><br>student<br>staff<br>appointment<br>visit<br>availability<br>group<br>survey</p> || <nowiki>{{Document.Usage}}</nowiki> || Documents.Usage
|-
| <span title="1234">StudentID</span> || bigint || Which student record this document is related to, relates to Students.Sequence (not Students.ID). || || Documents.StudentID
|-
| <span title="1234">StaffID</span> || bigint || Which staff record this document is related to, relates to Staff.Sequence. || || Documents.StaffID
|-
| <span title="1234">DocTypeID</span> || bigint || Which document type this document is related to, relates to DocTypes.Sequence. || || Documents.DocTypeID
|-
| <span title="2025-01-31 14:30:00">Date</span> || datetime || The date and time this document was uploaded. || || Documents.Date
|-
| <span title="This can be anything.">Notes</span> || text || The document notes. || <nowiki>{{Document.Notes}}</nowiki> || Documents.Notes
|-
| <span title="1a23b4c5-6789-01d2-ef3g-456h78901ijk">PostedBy</span> || varchar(255) || The UUID of the user who uploaded the document. || <nowiki>{{Document.PostedBy}}</nowiki> || Documents.PostedBy
|-
| <span title="Student #1931 Smith, Sam T.">PostedByName</span> || || The user type, sequence, and name of the user who uploaded this document. || <nowiki>{{Document.PostedByName}}</nowiki> ||
|-
| <span title="draft-2025-02-12.docx">OrigName</span> || varchar(512) || The name of the document. || <nowiki>{{Document.OrigName}}</nowiki> || Documents.OrigName
|-
| <span title="1234">LinkedApptID</span> || bigint || Which appointment record this document is related to, relates to Appointments.Sequence. || || Documents.LinkedApptID
|-
| <span title="application/vnd.openxmlformats-officedocument.wordprocessingml.document">Type</span> || varchar(255) || The document type. || || Documents.Type
|-
| <span title="43.45">SizeK</span> || double || The file size (in KiB) || || Documents.SizeK
|-
| <span title="0">Inactive</span> || tinyint || Whether or not this document is marked as inactive. || || Documents.Inactive
|-
| <span title="1234">LinkedAvailRecID</span> || bigint ||  Which availability record this document is related to, relates to AvailBlocks.Sequence. || || Documents.LinkedAvailRecID
|-
| <span title="1234">LinkedVisitID</span> || bigint ||  Which visit record this document is related to, relates to Visits.Sequence. || || Documents.LinkedVisitID
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ DocTypes
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each document type. || || DocTypes.Sequence
|-
| <span title="Essay">Name</span> || varchar(255) || The name of the document type. || <nowiki>{{DocType.Name}}</nowiki> || DocTypes.Name
|-
| <span title="0">Inactive</span> || tinyint || Whether or not this document type is inactive. || || DocTypes.Inactive
|-
|}
</div>
<br>
</div>
 
<!------------------------------------------------------- Resources ------------------------------------------------------>
<div class="tcWidgetPage">
<div style="float: left;"><big><b>Resource Related</b> (Resources, ResourceTypes, Checkouts)</big></div><div style="float: right; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px" class="mw-customtoggle-10">Toggle Visibility</div>
<div class="mw-collapsible mw-collapsed" id="mw-customcollapsible-10">
<br><br>
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ Resources
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each resource. || || Resources.Sequence
|-
| <span title="Dell Laptop #5">Title</span> || varchar(80) || The name of the resource. || <nowiki>{{Resource.Title}}</nowiki>
|-
| <span title="ABC123">BarCode</span> || varchar(20) || The barcode value of the resource. || <nowiki>{{Resource.BarCode}}</nowiki> || Resources.BarCode
|-
| <span title="Dell laptop with an Intel i5, 8gb of ram, and a 14 inch screen.">Description</span> || text || The description of the resource. || <nowiki>{{Resource.Description}}</nowiki> || Resources.Description
|-
| <span title="Laptop, Computer, PC">Keywords</span> || varchar(80) || The keywords for thsi resource, used to find the resource during checkout. || <nowiki>{{Resource.Keywords}}</nowiki> || Resources.Keywords
|-
| <span title="1">Status</span> || int || The status of this resource, possible values are listed below.<p style="line-height: 95%; font-size: 15px"><br>-1 = Inactive<br>0 = Checked out<br>1 = Available<br>2 = Always available</p> || <nowiki>{{Resource.Status}}</nowiki> || Resources.Status
|-
| <span title="14">MaxDaysOut</span> || int || The maximum number of days that an item can be checked out. || <nowiki>{{Resource.MaxDaysOut}}</nowiki> || Resources.MaxDaysOut
|-
| <span title="2025-01-31 15:16:18">LastDTOut</span> || datetime || The date an time this item was last checked out. || || Resources.LastDTOut
|-
| <span title="05:00:00">MaxTimeOut</span> || time || The maximum amount of time that an item can be checked out. || <nowiki>{{Resource.MaxTimeOut}}</nowiki> || Resources.MaxTimeOut
|-
| <span title="2024-06-25 15:16:18">DueDT</span> || datetime || The date and time this item is due to be returned. This will match Checkouts.DueDT of the most recent checkout. || || Resources.DueDT
|-
| <span title="1234">Type</span> || int || The resource type, relates to ResourceTypes.Sequence. || || Resources.Type
|-
| <span title="0">Inactive</span> || tinyint || Whether or not this resource is currently inactive. || || Resources.Inactive
|-
|<span title="1234">ProfileID</span> || bigint || Which profile this resource is assigned to, relates to Profiles.Sequence. || || Resources.ProfileID
|-
| <span title="0">AlwaysAvailable</span> || tinyint || Whether or not this resource is designated as always available. || || Resources.AlwaysAvailable
|-
| <span title="2">MaxRenews</span> || int || The maximum number of times a checkout for this resource can be renewed. || || Resources.MaxRenews
|-
| <span title="1">CollateralLogic</span> || tinyint || Whether or not this resource requires collateral to be checked out. || || Resources.CollateralLogic
|-
| <span title="1a23b4c5-6789-01d2-ef3g-456h78901ijk">LastOutToUUID</span> || varchar(46) || The UUID of the last user to check this resource out. || || Resources.LastOutToUUID
|-
| <span title="Pickup at the front desk.">PickupInstructions</span> || || Instructions for resource pickup. || <nowiki>{{Resource.CustomData.PickupInstructions}}</nowiki> ||
|-
| <span title="Return at the front desk.">ReturnInstructions</span> || || Instructions for resource return. || <nowiki>{{Resource.CustomData.ReturnInstructions}}</nowiki> ||
|-
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ ResourceTypes
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each resource type. || || ResourceTypes.Sequence
|-
| <span title="Computers">Name</span> || varchar(80) || The name of the resource type/category that resources are assigned to. || <nowiki>{{ResourceType.Name}}</nowiki> || ResourceTypes.Name
|-
| <span title="Desktops, Laptops, and Tablets.">Description</span> || varchar(255) || The description of the resource type. || <nowiki>{{ResourceType.Description}}</nowiki> || ResourceTypes.Description
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ Checkouts
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each checkout. || || Checkouts.Sequence
|-
| <span title="1234">ResourceID</span> || bigint || Which resource this checkout is for, relates to Resources.Sequence. || || Checkouts.ResourceID
|-
| <span title="2024-03-01 08:33:27">Date</span> || datetime || The date and time of the checkout. || <nowiki>{{Checkout.Date}}</nowiki> || Checkouts.Date
|-
| <span title="2024-03-01 08:40:27">ReturnedDT</span> || datetime || The date and time the checkout was returned. || || Checkouts.ReturnedDT
|-
| <span title="678.5075">TotalTimeHrs</span> || double || The total number of hours the resource was checked out for. || || Checkouts.TotalTimeHrs
|-
| <span title="(Sam Smith) Student ID Card">Collateral</span> || varchar(80) ||  The collateral for checkout.  || <nowiki>{{Checkout.Collateral}}</nowiki> || Checkouts.Collateral
|-
| <span title="This can be anything.">Notes</span> || text || The notes in the checkout record. || || Checkouts.Notes
|-
| <span title="0">Overdue</span> || tinyint || Whether or not this checkout is overdue. || <nowiki>{{Checkout.Overdue}}</nowiki> || Checkouts.Overdue
|-
| <span title="2025-03-20 09:05:12">DueDT</span> || datetime || The date and time the checkout is due to be returned. || <nowiki>{{Checkout.DueDT}}</nowiki> || Checkouts.DueDT
|-
| <span title="1a23b4c5-6789-01d2-ef3g-456h78901ijk">CheckedOutToUUID</span> || varchar(46) || The UUID of the user who checked out this resource. || || Checkouts.CheckedOutToUUID
|-
| <span title="Student">CheckedOutToType</span> || varchar(80) || What type of user checked out this resource (Student or Staff). ||  || Checkouts.CheckedOutToType
|}
</div>
<br>
</div>
 
<!------------------------------------------------------- Workshops ------------------------------------------------------>
<div class="tcWidgetPage">
<div style="float: left;"><big><b>Workshops</b></big></div><div style="float: right; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px" class="mw-customtoggle-11">Toggle Visibility</div>
<div class="mw-collapsible mw-collapsed" id="mw-customcollapsible-11">
<br><br>
<section begin="workshops" />
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each workshop. || || Workshops.Sequence
|-
| <span title="1234">CenterID</span> || bigint || Which center this workshop is assigned to, relates to Centers.Sequence. || || Workshops.CenterID
|-
| <span title="1234">ReasonID</span> || bigint || Which reason this workshop is assigned to, relates to Reasons.Sequence. ||  || Workshops.ReasonID
|-
| <span title="Accounting Workshop">Name</span> || varchar(255) || The name of the workshop. || <nowiki>{{Workshop.Name}}</nowiki> || Workshops.Name
|-
| <span title="Jane Doe">Instructor</span> || varchar(255) || The instructor of the workshop. || <nowiki>{{Workshop.Instructor}}</nowiki> || Workshops.Instructor
|-
| <span title='<nowiki>{"Course": "100", "Section": "01", "Subject": "ACTG"}</nowiki>'>RosterSubject</span> || json || Contains the subject, course, and section code of the workshop.  ||  || Workshops.RosterSubject
|-
| <span title="ACTG">RosterSubject.Subject</span> || varchar(40) || The workshop subject. || <nowiki>{{Workshop.RosterSubject.Subject}}</nowiki> ||
|-
| <span title="100">RosterSubject.Course</span> || varchar(20) || The workshop course. || <nowiki>{{Workshop.RosterSubject.Course}}</nowiki> ||
|-
| <span title="01">RosterSubject.Section</span> || varchar(80) || The workshop section code. || <nowiki>{{Workshop.RosterSubject.Section}}</nowiki> ||
|-
| <span title="1234">StudentLinkedListID</span> || bigint || The list of students this workshop is restricted to, relates to Lists.Sequence. ||  || Workshops.StudentLinkedListID
|-
| <span title="This workshop is for students in Accounting courses.">Description</span> || text || The description of the workshop. || <nowiki>{{Workshop.Description}}</nowiki> || Workshops.Description
|-
| <span title="1234">AssignmentID</span> || bigint || Which [[TracCloud:_Grade_Groups_%26_Potential_Assignments|potential assignment]] this workshop is assigned to, relates to Assignments.Sequence. || || Workshops.AssignmentID
|-
| <span title="2024-10-21 11:14:44">CreatedDT</span> || datetime || The date and time this workshop was created. || <nowiki>{{Workshop.CreatedDT}}</nowiki> || Workshops.CreatedDT
|-
| <span title="2025-03-31 11:00:00">DateFrom</span> || datetime || The start date and time of the workshop. || <nowiki>{{Workshop.DateFrom}}</nowiki> || Workshops.DateFrom
|-
| <span title="03/31/25">StartDate</span> || || The start date of the workshop. || <nowiki>{{Workshop.StartDate}}</nowiki> ||
|-
| <span title="11:00am">StartTime</span> || || The start time of the workshop. || <nowiki>{{Workshop.StartTime}}</nowiki> ||
|-
| <span title="2025-03-31 12:00:00">DateTo</span> || datetime || The end date and time of the workshop. || <nowiki>{{Workshop.DateTo}}</nowiki> || Workshops.DateTo
|-
| <span title="03/31/25">EndDate</span> || || The end date of the workshop. || <nowiki>{{Workshop.EndDate}}</nowiki> || Workshops.EndDate
|-
| <span title="12:00pm">EndTime</span> || || The end time of the workshop. || <nowiki>{{Workshop.EndTime}}</nowiki> || Workshops.EndTime
|-
| <span title="2025-03-20">EnrolledDate</span> || || The date of student enrollment. || <nowiki>{{WorkshopsRoster.EnrolledDate}}</nowiki> ||
|}
<section end="workshops" />
</div>
<br>
</div>
 
<!------------------------------------------------------- CustomDataTypes ------------------------------------------------------>
<div class="tcWidgetPage">
<div style="float: left;"><big><b>Custom Fields</b></big></div><div style="float: right; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px" class="mw-customtoggle-12">Toggle Visibility</div>
<div class="mw-collapsible mw-collapsed" id="mw-customcollapsible-12">
<br><br>
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ Replace '123' in the Twig examples with the sequence of your custom field.
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each workshop. || || CustomDataTypes.Sequence
|-
| <span title="StudentApptNotes">DataName</span> || varchar(80) || The internal name of the custom field (different than prompt). || <nowiki>CustomFields.cf_123.DataName</nowiki> || CustomDataTypes.DataName
|-
| <span title="Student - Custom1">Location</span> || varchar(80) || Where the custom field is located. Possible values are listed below.<p style="line-height: 95%; font-size: 15px"><br>Appointment - Consultant<br>Appointment - Student<br>Availability<br>Certification<br>Consultant<br>Document<br>Faculty<br>Reason<br>Registration<br>Resource<br>Section<br>SI_Session<br>Student - Campus<br>Student - Custom1<br>Student - Custom2<br>Student - Custom3<br>Student - Custom4<br>Student - Custom5<br>Student - Other Info<br>Student - QuickStudent<br>Visit - Consultant<br>Visit - Q2 Raise Hand<br>Visit - Student</p> || || CustomDataTypes.Location
|-
| <span title="What do you need help with in this appointment?">Prompt</span> || text || The visible name of the custom field (what students see). || <nowiki>CustomFields.cf_123.Prompt</nowiki> || CustomDataTypes.Prompt
|-
| <span title="<nowiki>Yes\r\nNo</nowiki>">Choices</span> || text || The available list of choices for custom fields with predefined answers. || <nowiki>CustomFields.cf_123.Choices</nowiki> || CustomDataTypes.Choices
|-
| <span title="menufield">InputType</span> || varchar(80) || What type of custom field this is. Possible values are listed below.<p style="line-height: 95%; font-size: 15px"><br>field<br>areafield<br>leftcheckfield<br>multicheckfield<br>radiofield<br>radioimagefield<br>toggle<br>menufield<br>imagemenufield<br>imagepopfield<br>signaturefield<br>uploaddocfield<br>popfield<br>labeledhtml<br>infohtml<br>headerhtml<br>group</p> ||  || CustomDataTypes.InputType
|-
| <span title="1234">ProfileID</span> || bigint || Which profile this custom field is linked to, 0 is all. Relates to Profiles.Sequence. ||  || CustomDataTypes.ProfileID
|}
</div>
<br>
</div>
 
<!------------------------------------------------------- Success Plans ------------------------------------------------------>
<div class="tcWidgetPage">
<div style="float: left;"><big><b>Success Plan Related</b> (SuccessPlan, SPSteps, SPAssigned, SPAssignedSteps)</big></div><div style="float: right; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px" class="mw-customtoggle-13">Toggle Visibility</div>
<div class="mw-collapsible mw-collapsed" id="mw-customcollapsible-13">
<br><br>
<section begin="SPTags" />
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ SuccessPlan
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each success plan. || || SuccessPlan.Sequence
|-
| <span title="Academic Coaching Plan">Name</span> || varchar(120) || The name of the success plan. || <nowiki>{{SuccessPlan.Name}}</nowiki> || SuccessPlan.Name
|-
| <span title="1234">ProfileID</span> || bigint || Which profile this success plan is assigned to, relates to Profiles.Sequence. || || SuccessPlan.ProfileID
|-
| <span title="0">Inactive</span> || tinyint || Whether or not this success plan is currently inactive. || || SuccessPlan.Inactive
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ SPSteps
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each success plan step. || <nowiki>{{SPStep.Sequence}}</nowiki> || SPSteps.Sequence
|-
| <span title="1234">SuccessPlanID</span> || bigint || Which success plan this step is assgined to. || <nowiki>{{SPStep.}}</nowiki> || SPSteps.SuccessPlanID
|-
| <span title="Visit">Type</span> || varchar(120) || What type of step this is. Possible values are listed below.<p style="line-height: 95%; font-size: 15px"><br>Visit<br>Survey<br>Document<br>Task<br>Checkout<br>Notification<br>Prompt</p>|| <nowiki>{{SPStep.Type}}</nowiki> || SPSteps.Type
|-
| <span title="14">DateOrOffset</span> || varchar(36) || When this Step needs to be completed (number of days or static date based on Plan type) || <nowiki>{{SPStep.DateOrOffset}}</nowiki> || SPSteps.DateOrOffset
|-
| <span title="1">isOptional</span> || tinyint || Whether or not the step is optional. || <nowiki>{{SPStep.isOptional}}</nowiki> || SPSteps.isOptional
|-
| <span title="0">isNoSendEmails</span> || tinyint || Whether or not emails are disabled for this step. || <nowiki>{{SPStep.isNoSendEmails}}</nowiki> || SPSteps.isNoSendEmails
|-
| <span title="0">isPromptOnDash</span> || tinyint || Whether or not the prompt is set to display on the dashboard. || <nowiki>{{SPStep.isPromptOnDash}}</nowiki> || SPSteps.isPromptOnDash
|-
| <span title="1">DirectedTo</span> || int || Who the confirmation is directed to. Possible values are listed below.<p style="line-height: 95%; font-size: 15px"><br>0 = Student<br>1 = Plan Staff<br>2 = Plan Faculty<br>3 = Step Staff<br>4 = Step Faculty</p> || <nowiki>{{SPStep.DirectedTo}}</nowiki> || SPSteps.DirectedTo
|-
| <span title="1">OverrideRequireConfirmation</span> || int || Whether or not this step has been overridden to allow/disallow confirmation. || <nowiki>{{SPStep.OverrideRequireConfirmation}}</nowiki> || SPSteps.OverrideRequireConfirmation
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ SPAssigned
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each assigned success plan. || || SPAssigned.Sequence
|-
| <span title="1234">SuccessPlanID</span> || bigint || What type of success plan this is, relates to SuccessPlan.Sequence || || SPAssigned.SuccessPlanID
|-
| <span title="1234">StudentID</span> || bigint || Which student this plan is assigned to, relates to Students.Sequence (not Students.ID). || || SPAssigned.StudentID
|-
| <span title="1234">ConsultantID</span> || bigint || The assigned plan consultant, relates to Staff.Sequence. || || SPAssigned.ConsultantID
|-
| <span title="2025-01-14">DateStarted</span> || date || The date the plan began. || <nowiki>{{SPAssigned.DateStarted}}</nowiki> || SPAssigned.DateStarted
|-
| <span title="2025-01-25">DateCompleted</span> || date || The date the plan was completed. || <nowiki>{{SPAssigned.DateCompleted}}</nowiki> || SPAssigned.DateCompleted
|-
| <span title="2025-02-14">DueDate</span> || date || The date the plan is due for completion. || <nowiki>{{SPAssigned.DueDate}}</nowiki> || SPAssigned.DueDate
|-
| <span title="1234">TermID</span> || bigint || The term this plan is linked to, relates to Terms.Sequence. || || SPAssigned.TermID
|-
| <span title="0">Inactive</span> || tinyint || Whether or not this plan is inactive. || || SPAssigned.Inactive
|-
| <span title="Overdue">Status</span> || varchar(120) || The status of the plan. Possible values are listed below.<p style="line-height: 95%; font-size: 15px"><br>In Progress<br>Complete<br>Overdue</p> || <nowiki>{{SPAssigned.Status}}</nowiki> || SPAssigned.Status
|-
| <span title="75">Percent</span> || int || The completion percentage of the plan. || <nowiki>{{SPAssigned.Percent}}</nowiki> || SPAssigned.Percent
|-
| <span title="1234">FacultyID</span> || bigint || The faculty assigned to the plan, relates to Faculty.Sequence (not Faculty.UserID). ||  || SPAssigned.FacultyID
|-
| <span title="N/A">DashboardStatus</span> || || The HTML text that would appear on the student's main menu showing their progress in the plan. || <nowiki>{{SPAssigned.DashboardStatus|raw}}</nowiki> ||
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ SPAssignedSteps
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each assigned success plan step. || || SPAssignedSteps.Sequence
|-
| <span title="1234">SPAssignedID</span> || bigint || Which assigned success plan this is assigned to, relates to SPAssigned.Sequence. || || SPAssignedSteps.SPAssignedID
|-
| <span title="1234">StudentID</span> || bigint || Which student this is assigned to, relates to Students.Sequence (not Students.ID). || || SPAssignedSteps.StudentID
|-
| <span title="1234">SPStepID</span> || bigint || Which success plan step this relates to, relates to SPSteps.Sequence ||  || SPAssignedSteps.SPStepID
|-
| <span title="2023-01-09">CompletedDate</span> || date || The date this step was completed. || <nowiki>{{SPAssignedStep.CompletedDate}}</nowiki> || SPAssignedSteps.CompletedDate
|-
| <span title="2023-01-09">DueDate</span> || date || The date this step was due to be completed. || <nowiki>{{SPAssignedStep.DueDate}}</nowiki> || SPAssignedSteps.DueDate
|-
| <span title="1">CompletionOverride</span> || tinyint || Whether or not the completion override option is enabled for this step. || <nowiki>{{SPAssignedStep.CompletionOverride}}</nowiki> || SPAssignedSteps.CompletionOverride
|-
| <span title="This can be anything.">StaffNotes</span> || text || Any notes entered by the staff for this step. || <nowiki>{{SPAssignedStep.StaffNotes}}</nowiki> || SPAssignedSteps.StaffNotes
|-
| <span title="1">Confirmed</span> || tinyint || Whether or not this step has been confirmed. || <nowiki>{{SPAssignedStep.Confirmed}}</nowiki> || SPAssignedSteps.Confirmed
|-
| <span title="1234">StepFacultyID</span> || bigint || Which faculty this step is assigned to, relates to Faculty.Sequence (not Faculty.UserID). || <nowiki>{{SPAssignedStep.StepFacultyID}}</nowiki> || SPAssignedSteps.StepFacultyID
|-
| <span title="1234">StepConsultantID</span> || bigint || Which staff record this step is assigned to, relates to Staff.Sequence. || <nowiki>{{SPAssignedStep.StepConsultantID}}</nowiki> || SPAssignedSteps.StepConsultantID
|-
| <span title="3">Index</span> || || The number of the step, based on the order they were created in. || <nowiki>{{SPAssignedStep.Index}}</nowiki> ||
|-
| <span title="2">PartialStepValue</span> || || 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. || <nowiki>{{SPAssignedStep.CustomData|json_decode.PartialStepValue}}</nowiki> ||
|}
<section end="SPTags" />
</div>
<br>
</div>
 
<!------------------------------------------------------- Work Plans ------------------------------------------------------>
<div class="tcWidgetPage">
<div style="float: left;"><big><b>Work Plan Related</b> (WorkPlan, WPSteps, WPAssigned, WPAssignedSteps)</big></div><div style="float: right; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px" class="mw-customtoggle-14">Toggle Visibility</div>
<div class="mw-collapsible mw-collapsed" id="mw-customcollapsible-14">
<br><br>
<section begin="WPTags" />
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ WorkPlan
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each work plan. || || WorkPlan.Sequence
|-
| <span title="Certification Plan">Name</span> || varchar(120) || The name of the work plan. || <nowiki>{{WorkPlan.Name}}</nowiki> || WorkPlan.Name
|-
| <span title="1234">ProfileID</span> || bigint || Which profile this work plan is assigned to, relates to Profiles.Sequence. || || WorkPlan.ProfileID
|-
| <span title="0">Inactive</span> || tinyint || Whether or not this work plan is currently inactive. || || WorkPlan.Inactive
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ WPSteps
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each work plan step. || <nowiki>{{WPStep.Sequence}}</nowiki> || WPSteps.Sequence
|-
| <span title="1234">WorkPlanID</span> || bigint || Which work plan this step is assgined to. || <nowiki>{{WPStep.WorkPlanID}}</nowiki> || WPSteps.WorkPlanID
|-
| <span title="Work Visit">Type</span> || varchar(120) || What type of step this is. Possible values are listed below.<p style="line-height: 95%; font-size: 15px"><br>Work Visit<br>Consultation Visit<br>Appointment<br>Survey<br>Document<br>Task<br>Checkout<br>Notification<br>Prompt</p>|| <nowiki>{{WPStep.Type}}</nowiki> || WPSteps.Type
|-
| <span title="14">DateOrOffset</span> || varchar(36) || When this Step needs to be completed (number of days or static date based on Plan type) || <nowiki>{{WPStep.DateOrOffset}}</nowiki> || WPSteps.DateOrOffset
|-
| <span title="1">isOptional</span> || tinyint || Whether or not the step is optional. || <nowiki>{{WPStep.isOptional}}</nowiki> || WPSteps.isOptional
|-
| <span title="0">isNoSendEmails</span> || tinyint || Whether or not emails are disabled for this step. || <nowiki>{{WPStep.isNoSendEmails}}</nowiki> || WPSteps.isNoSendEmails
|-
| <span title="0">isPromptOnDash</span> || tinyint || Whether or not the prompt is set to display on the dashboard. || <nowiki>{{WPStep.isPromptOnDash}}</nowiki> || WPSteps.isPromptOnDash
|-
| <span title="1">DirectedTo</span> || int || Who the confirmation is directed to. Possible values are listed below.<p style="line-height: 95%; font-size: 15px"><br>0 = Consultant<br>1 = Plan Supervisor<br>3 = No Prompt</p> || <nowiki>{{WPStep.DirectedTo}}</nowiki> || WPSteps.DirectedTo
|-
| <span title="1">OverrideRequireConfirmation</span> || int || Whether or not this step has been overridden to allow/disallow confirmation. || <nowiki>{{WPStep.OverrideRequireConfirmation}}</nowiki> || WPSteps.OverrideRequireConfirmation
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ WPAssigned
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each assigned work plan. || || WPAssigned.Sequence
|-
| <span title="1234">WorkPlanID</span> || bigint || What type of work plan this is, relates to WorkPlan.Sequence || || WPAssigned.WorkPlanID
|-
| <span title="1234">ConsultantID</span> || bigint || The assigned plan consultant, relates to Staff.Sequence. || || WPAssigned.ConsultantID
|-
| <span title="1234">SupervisorID</span> || bigint || The assigned supervisor for this work plan, relates to Staff.Sequence. || || WPAssigned.SupervisorID
|-
| <span title="2025-01-14">DateStarted</span> || date || The date the plan began. || <nowiki>{{WPAssigned.DateStarted}}</nowiki> || WPAssigned.DateStarted
|-
| <span title="2025-01-25">DateCompleted</span> || date || The date the plan was completed. || <nowiki>{{WPAssigned.DateCompleted}}</nowiki> || WPAssigned.DateCompleted
|-
| <span title="2025-02-14">DueDate</span> || date || The date the plan is due for completion. || <nowiki>{{WPAssigned.DueDate}}</nowiki> || WPAssigned.DueDate
|-
| <span title="1234">TermID</span> || bigint || The term this plan is linked to, relates to Terms.Sequence. || || WPAssigned.TermID
|-
| <span title="0">Inactive</span> || tinyint || Whether or not this plan is inactive. || || WPAssigned.Inactive
|-
| <span title="Overdue">Status</span> || varchar(120) || The status of the plan. Possible values are listed below.<p style="line-height: 95%; font-size: 15px"><br>In Progress<br>Complete<br>Overdue</p> || <nowiki>{{WPAssigned.Status}}</nowiki> || WPAssigned.Status
|-
| <span title="75">Percent</span> || int || The completion percentage of the plan. || <nowiki>{{WPAssigned.Percent}}</nowiki> || WPAssigned.Percent
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ WPAssignedSteps
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each assigned work plan step. || || WPAssignedSteps.Sequence
|-
| <span title="1234">WPAssignedID</span> || bigint || Which assigned work plan this is assigned to, relates to WPAssigned.Sequence. || || WPAssignedSteps.WPAssignedID
|-
| <span title="1234">ConsultantID</span> || bigint || Which consultant this is assigned to, relates to Staff.Sequence. || || WPAssignedSteps.ConsultantID
|-
| <span title="1234">WPStepID</span> || bigint || Which work plan step this relates to, relates to WPSteps.Sequence ||  || WPAssignedSteps.WPStepID
|-
| <span title="2023-01-09">CompletedDate</span> || date || The date this step was completed. || <nowiki>{{WPAssignedStep.CompletedDate}}</nowiki> || WPAssignedSteps.CompletedDate
|-
| <span title="2023-01-09">DueDate</span> || date || The date this step was due to be completed. || <nowiki>{{WPAssignedStep.DueDate}}</nowiki> || WPAssignedSteps.DueDate
|-
| <span title="1">CompletionOverride</span> || tinyint || Whether or not the completion override option is enabled for this step. || <nowiki>{{WPAssignedStep.CompletionOverride}}</nowiki> || WPAssignedSteps.CompletionOverride
|-
| <span title="This can be anything.">StaffNotes</span> || text || Any notes entered by the staff for this step. || <nowiki>{{WPAssignedStep.StaffNotes}}</nowiki> || WPAssignedSteps.StaffNotes
|-
| <span title="1">Confirmed</span> || tinyint || Whether or not this step has been confirmed. || <nowiki>{{WPAssignedStep.Confirmed}}</nowiki> || WPAssignedSteps.Confirmed
|-
| <span title="1234">StepSupervisorID</span> || bigint || Which supervisor this step is assigned to, relates to Staff.Sequence. || <nowiki>{{WPAssignedStep.StepSupervisorID}}</nowiki> || WPAssignedSteps.StepSupervisorID
|}
<section end="WPTags" />
</div>
<br>
</div>
 
<!------------------------------------------------------- SAGE ------------------------------------------------------>
<div class="tcWidgetPage">
<div style="float: left;"><big><b>SAGE Related</b> (ReferralType, Referrals)</big></div><div style="float: right; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px" class="mw-customtoggle-15">Toggle Visibility</div>
<div class="mw-collapsible mw-collapsed" id="mw-customcollapsible-15">
<br><br>
<section begin="SAGE" />
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ ReferralType
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each referral type. || || ReferralType.Sequence
|-
| <span title="Academic Performance Alert">Name</span> || varchar(255) || The name of the referral type. || <nowiki>{{ReferralType.Name}}</nowiki> || ReferralType.Name
|-
| <span title='<nowiki>{"Course": "101", "Section": "01", "Subject": "MATH", "CourseList": "", "useCourseList": "0"}</nowiki>'>RosterSubject</span> || json || This <b>array</b> contains information about what subject(s) this referral type is linked to. || || ReferralType.RosterSubject
|-
| <span title="1234">StudentLinkedListID</span> || bigint || Which student list this referral type is limited to, relates to Lists.Sequence.  || || ReferralType.StudentLinkedListID
|-
| <span title="1">Active</span> || tinyint || Whether or not this referral type is currently active. || || ReferralType.Active
|-
| <span title="This can be anything.">NotesInstructions</span> || text || The contents of the notes instructions field. || <nowiki>{{ReferralType.NotesInstructions}}</nowiki> || ReferralType.NotesInstructions
|-
| <span title='<nowiki>[{"key": "abcdefg12345678", "label": true, "value": "Pick a reason", "active": true}, {"key": "abcdefg12345679", "label": false, "value": "Reason A", "active": true}, {"key": "abcdefg12345680", "label": false, "value": "Reason B", "active": true}, {"key": "abcdefg12345681", "label": false, "value": "Reason C", "active": true}]</nowiki>'>Reasons</span> || json || An <b>array</b> of all of this referral type's reasons. || <nowiki>{{ReferralType.Reasons}}</nowiki> || ReferralType.Reasons
|-
| <span title='<nowiki>[{"key": "abcdefg12345678", "label": true, "value": "Pick a Recommendation", "active": true}, {"key": "abcdefg12345679", "label": false, "value": "Recommendation A", "active": true}, {"key": "abcdefg12345680", "label": false, "value": "Recommendation B", "active": true}, {"key": "abcdefg12345681", "label": false, "value": "Recommendation C", "active": true}]</nowiki>'>Recommend</span> || json || An <b>array</b> of all of this referral type's recommendations. || <nowiki>{{ReferralType.Recommend}}</nowiki> || ReferralType.Recommend
|-
| <span title="This can be anything.">AdditionalNotesInstr</span> || text|| The contents of the additional notes instrucitons field. || <nowiki>{{ReferralType.AdditionalNotesInstr}}</nowiki> || ReferralType.AdditionalNotesInstr
|-
| <span title="This can be anything.">OtherInstructions</span> || text || The contents of the other instructions field. || <nowiki>{{ReferralType.OtherInstructions}}</nowiki> || ReferralType.OtherInstructions
|}
 
{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ Referrals
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
| <span title="1234">Sequence</span> || bigint || Unique identifer for each referral. || || Referrals.Sequence
|-
| <span title="1234">RefTypeID</span> || bigint || Which referral type this referral is linked to, relates to ReferralType.Sequence || || Referrals.RefTypeID
|-
| <span title="1234">StudentID</span> || bigint || Which student this referral is assigned to, relates to Students.Sequence (not Students.ID). || || Referrals.StudentID
|-
| <span title="1234">FacultyID</span> || bigint || Which faculty this referral is linked to, relates to Faculty.Sequence (not Faculty.UserID). ||  || Referrals.FacultyID
|-
| <span title="1234">SectionID</span> || bigint || Which section this referral is linked to, relates to Sections.Sequence. || || Referrals.SectionID
|-
| <span title="1234">ConsultantID</span> || bigint || Which consultant this referral is linked to, relates to Staff.Sequence. || || Referrals.ConsultantID
|-
| <span title="1234">CenterID</span> || bigint || Which center this referral is linked to, relates to Centers.Sequence. || || Referrals.CenterID
|-
| <span title="2024-01-31 08:00:00">CreatedDT</span> || datetime || The date and time this referral was created. || <nowiki>{{Referrals.CreatedDT}}</nowiki> || Referrals.CreatedDT
|-
| <span title="Jeff Daniels, Dr">CreatedBy</span> || varchar(255) || Who created this referral, either a faculty or staff member. || <nowiki>{{Referrals.CreatedBy}}</nowiki> || Referrals.CreatedBy
|-
| <span title="This can be anything.">NotesInstrData</span> || text || Notes entered while the referral is being submitted. || <nowiki>{{Referrals.NotesInstrData}}</nowiki> || Referrals.NotesInstrData
|-
| <span title='<nowiki>[{"key": "abddefgh12345678", "reason": "Submitted work is acceptable"}, {"key": "abddefgh12345679", "reason": "Attendance is unacceptable"}]</nowiki>'>ReasonsData</span> || json || An <b>array</b> of chosen reasons in this referral. || [[TracCloud:_Twig|<span title="Requires specific formatting due to this field being an array. Click to learn more.">Reasons*</span>]] || Referrals.ReasonsData
|-
| <span title= '<nowiki>[{"key": "abddefgh12345678", "reason": "Attendance and Coursework Reasons"}, {"key": "abddefgh12345678", "reason": "Submitted work is acceptable"}, {"key": "abddefgh12345679", "reason": "Attendance is unacceptable"}]</nowiki>'>ReasonsAndLabels</span> || || Same as above, but this <b>array</b> will also include the reason labels. || [[TracCloud:_Twig|<span title="Requires specific formatting due to this field being an array. Click to learn more.">ReasonsAndLabels*</span>]] ||
|-
| <span title='<nowiki>[{"key": "abddefgh12345678", "recommend": "Meet with Advisor"}, {"key": "abddefgh12345679", "recommend": "Meet with Instructor"}]</nowiki>'>RecommendData</span> || json || An <b>array</b> of chosen recommendations in this referral. || [[TracCloud:_Twig|<span title="Requires specific formatting due to this field being an array. Click to learn more.">Recommendations*</span>]] || Referrals.RecommendData
|-
| <span title= '<nowiki>[{"key": "abddefgh12345678", "recommend": "Meet with..."}, {"key": "abddefgh12345678", "recommend": "Meet with Advisor"}, {"key": "abddefgh12345679", "recommend": "Meet with Instructor"}]</nowiki>'>RecommendationsAndLabels</span> || || Same as above, but this <b>array</b> will also include the recommendation labels. || [[TracCloud:_Twig|<span title="Requires specific formatting due to this field being an array. Click to learn more.">RecommendationsAndLabels*</span>]] ||
|-
| <span title="This can be anything.">AdditionalNotes</span> || text || Additional notes entered during referral submission.|| <nowiki>{{Referrals.AdditionalNotes}}</nowiki> || Referrals.AdditionalNotes
|-
| <span title="2025-03-25">FollowUpDate</span> || date || The specified follow-up date from the referral. || <nowiki>{{Referrals.FollowUpDate}}</nowiki> || Referrals.FollowUpDate
|-
| <span title="Jane Doe">FollowUpBy</span> || varchar(255) || The name of the user who followed up on this referral. || <nowiki>{{Referrals.FollowUpBy}}</nowiki> || Referrals.FollowUpBy
|-
| <span title="1">FollowedUp</span> || tinyint || Whether or not this referral has been followed up on.|| <nowiki>{{Referrals.FollowedUp}}</nowiki> || Referrals.FollowedUp
|-
| <span title="2025-03-25 08:19:34">FollowedUpDT</span> || datetime || The date and time this referral was followed up on. || <nowiki>{{Referrals.FollowedUpDT}}</nowiki> || Referrals.FollowedUpDT
|-
| <span title="1">Processed</span> || tinyint || Whether or not this referral has been processed (resolved). || <nowiki>{{Referrals.Processed}}</nowiki> || Referrals.Processed
|-
| <span title="2025-03-25 08:23:39">ProcessedDT</span> || datetime || The date and time this referral was processed. || <nowiki>{{Referrals.ProcessedDT}}</nowiki> || Referrals.ProcessedDT
|-
| <span title="Jane Doe">ProcessedBy</span> || varchar(255) || The user who processed this referral. || <nowiki>{{Referrals.ProcessedBy}}</nowiki> || Referrals.ProcessedBy
|-
| <span title="This can be anything.">ProcessedNotes</span> || text || Notes entered while the referral was being processed. || <nowiki>{{Referrals.ProcessedNotes}}</nowiki> || Referrals.ProcessedNotes
|-
| <span title="2025-03-25">StudentContacted</span> || date || The date the student was contacted about this referral. || <nowiki>{{Referrals.StudentContacted}}</nowiki> || Referrals.StudentContacted
|-
| <span title="1">OverrideResend</span> || tinyint || Whether or not the 'Override and resend' feature has been used. || || Referrals.OverrideResend
|-
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig Tag</b> !! <b>API</b> !! <b>SFTP Export Column</b> !! <b>Example</b>
| <span title="Jane Doe">AssignedConsultant</span> || varchar(255) || The name of the consultant or advisor assigned to this referral. || <nowiki>{{Referrals.AssignedConsultant}}</nowiki> || Referrals.AssignedConsultant
|-
|-
| example || example || example || <nowiki>{{example.example}}</nowiki> || example.example || example || example
| <span title="1234">AssignedConsultantID</span> || varchar(255) || The sequence number of the assigned consultant, relates to Staff.Sequence. || <nowiki>{{Referral.CustomData.AssignedConsultantID}}</nowiki> ||
|}
|}
<section end="SAGE" />
</div>
</div>
<br>
<br>
</div>
</div>

Latest revision as of 15:14, 6 August 2025

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



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.


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}}


Retrieved from "https://wiki.go-redrock.com/index.php?title=TracCloud:_Rosetta&oldid=13167"