View source for TracCloud: Rosetta

<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>
{| 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" 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>

<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 class="mw-collapsible" id="mw-customcollapsible-1">
<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="1234567">Sequence</span>||bigint ||Static identifier for students, unrelated to ID. || || Students.Sequence || 
|-
| <span title="1a23b4c5-6789-01d2-ef3g-456h78901ijk">UUID</span> || varchar(36) || Unique identifier for this user. || || Students.UUID ||
|-
| <span title="1234567">ID</span> || bigint || The student's ID number. Should be unique.|| <nowiki>{{Student.ID}}</nowiki> || Students.ID || StudentID
|-
| <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>
<br>
</div>
<!------------------------------------------------------- Visits ------------------------------------------------------>
<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 class="mw-collapsible" id="mw-customcollapsible-2">
<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 || 
|-
| <span title="1234">RegistrationID</span> || bigint || Relates to Registrations.Sequence || || Visits.RegistrationID || 
|-
| <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>
<br>
</div>

<!------------------------------------------------------- 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 class="mw-collapsible" id="mw-customcollapsible-3">
<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". || <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, can either be an in-person location or an online link. || <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. || <nowiki>{{Appointment.Online}}</nowiki> || Appointments.Online || 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, Group, etc. || <nowiki>{{Appointment.Type}}</nowiki> || || ApptType
|-
| <span title="N/A">Icon</span> || || An icon that indicates the appointment type, such as {{#fas:user-group}}.  || <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</a> || 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" 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</a> || tinyint || Whether or not a reserve block is designated as as meeting block. || || AvailBlocks.isMeeting
|}
</div>
<br>
</div>

<!------------------------------------------------------- Subject Related  ------------------------------------------------------>
<!--
<div class="tcWidgetPage">
<div style="float: left;"><big><b>Subject 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" 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="2025-01-31 02:00:00">_LastImportedDT</span> || datetime || The date and time this record was last imported. || || Courses._LastImportedDT ||
CustomData json 
RelatedCoursesID varchar(20)
|}

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

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

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

{| 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>
|-
| Sequence ||  bigint AI PK 
UUID varchar(36) 
FirstName varchar(80) 
LastName varchar(80) 
Password varchar(128) 
UserID varchar(80) 
UserName varchar(80) 
Custom2 text 
Custom1 text 
Salutation varchar(40) 
Department varchar(60) 
Inactive tinyint 
Phone varchar(80) 
Email varchar(120) 
CustomData json 
OtherID varchar(80) 
FullName varchar(255) 
facultyBIO text 
Pronouns varchar(80) 
_LastImportedDT datetime 
PassLastDateChanged date 
PassFailedAttempts int 
AccountLocked tinyint 
AccountLockDateTime datetime
|}

{| class="wikitable sortable" style="min-width: 100%; font-size: 15px"
|+ SectionSchedule
|-
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig</b> !! <b>API</b>
|-
|}
</div>
<br>
</div>
-->
<div class="tcWidgetPage">
<big><i>More coming soon!</i></big>
</div>