TracCloud: Rosetta - Revision history

Redrock at 21:56, 21 April 2026

2026-04-21T21:56:14Z

← Older revision		Revision as of 21:56, 21 April 2026
Line 945:		Line 945:
	\| <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="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="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 = Reserved<br>2 = Available<br>3 = 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="14">MaxDaysOut</span> \|\| int \|\| The maximum number of days that an item can be checked out. \|\| <nowiki>{{Resource.MaxDaysOut}}</nowiki> \|\| Resources.MaxDaysOut

Redrock at 17:32, 15 April 2026

2026-04-15T17:32:00Z

← Older revision		Revision as of 17:32, 15 April 2026
Line 1:		Line 1:
	<div class="~~tcWidget~~">		<div class="tcWidgetPage">
	<b>TracCloud: Table and Field List</b>		<b>TracCloud: Table and Field List</b>

Redrock at 16:44, 10 April 2026

2026-04-10T16:44:59Z

← Older revision		Revision as of 16:44, 10 April 2026
Line 1,435:		Line 1,435:
	<br>		<br>
	</div>		</div>
			[[Category:TracCloud Manual]]

Redrock at 19:49, 7 April 2026

2026-04-07T19:49:59Z

← Older revision		Revision as of 19:49, 7 April 2026
Line 11:		Line 11:

	<hr>		<hr>
	<div ~~style~~='collapsible'>Type Definitions</div><div class="mw-collapsible mw-collapsed">
			<div class='collapsible'>Type Definitions</div><div class="mw-collapsible mw-collapsed">
	<br><br>		<br><br>
	{\| class="wikitable" style="margin:auto;"		{\| class="wikitable" style="margin:auto;"
Line 34:		Line 35:
	\|json\|\|JSON-formatted field that contains multiple fields and values (e.g., custom fields).		\|json\|\|JSON-formatted field that contains multiple fields and values (e.g., custom fields).
	\|}		\|}

	</div>		</div>
	<hr>		<hr>

Redrock at 19:40, 7 April 2026

2026-04-07T19:40:17Z

← Older revision		Revision as of 19:40, 7 April 2026
Line 1:		Line 1:
	~~<div style="width:50%; float:left">~~		<div class="tcWidget">
	<div class="~~tcWidgetPage" style="margin:1%;~~">
	<b>TracCloud: Table and Field List</b>		<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]].		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>		<b>Tips</b>
	~~<div class="line"></div>~~

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

	* Click the header to sort by that column, shift-click to sort by multiple.		* Click the header to sort by that column, shift-click to sort by multiple.
	~~</div>~~
	~~</div>~~

	<~~div style="width:50%; float:right;">~~		<hr>
	~~<div class="tcWidgetPage" style="margin:1%;"~~>		<div style='collapsible'>Type Definitions</div><div class="mw-collapsible mw-collapsed">
	<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;"		{\| class="wikitable" style="margin:auto;"
Line 43:		Line 35:
	\|}		\|}
	</div>		</div>
	<~~br>~~		<hr>
	~~</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 mw-customtoggle-16" style="float: left; color: white; background-color: grey; border: 3px solid grey; font-weight: bold; border-radius: 5px">'''Invert All Visibility'''</div><br>		<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 mw-customtoggle-16" 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>

Redrock at 22:25, 6 April 2026

2026-04-06T22:25:06Z

@@ Line 47: / Line 47: @@
 <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 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 mw-customtoggle-16" 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>
@@ Line 1,416: / Line 1,416: @@
 |}
 <section end="SAGE" />
 </div>
 <br>
 </div>

Redrock at 15:11, 17 March 2026

2026-03-17T15:11:06Z

← Older revision		Revision as of 15:11, 17 March 2026
Line 227:		Line 227:
	\| <span title="Library">Location</span> \|\| varchar(512) \|\| The location of the visit. \|\| <nowiki>{{Visit.Location}}</nowiki> \|\| Visits.Location \|\| Location		\| <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="0">Online</span> \|\| tinyint \|\| The modality of the visit. 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>{{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="America/Phoenix">TimeZone</span> \|\| varchar(120) \|\| The time zone of this visit's time. \|\| \|\| Visits.TimeZone \|\|

Redrock at 15:54, 3 February 2026

2026-02-03T15:54:48Z

← Older revision		Revision as of 15:54, 3 February 2026
Line 690:		Line 690:
	* "Supervisor" (e.g., <nowiki>{{Supervisor.First_Name}}</nowiki>) should be used when referencing the assigned supervisor in [[TracCloud:_Work_Plans\|Work Plan]] fields.		* "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.		* "StepSupervisor" (e.g., <nowiki>{{StepSupervisor.First_Name}}</nowiki>) should be used when referencing the STEP supervisor in [[TracCloud:_Work_Plans\|Work Plan]] fields.
			* "CreatedBy" (e.g., <nowiki>{{CreatedBy.First_Name}}</nowiki>) can be used to reference the staff member who created a referral in [[TracCloud:_SAGE\|SAGE emails]].
	</div>		</div>
	<br>		<br>

Redrock at 22:46, 23 September 2025

2025-09-23T22:46:08Z

← Older revision		Revision as of 22:46, 23 September 2025
Line 75:		Line 75:
	\| <span title="ACTIVE">Status</span> \|\| varchar(80) \|\| Whether the student is Active or Inactive. \|\| <nowiki>{{Student.Status}}</nowiki> \|\| Students.Status \|\| Status		\| <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="Enrolled">OtherStatus</span> \|\| varchar(80) \|\| Alternative/custom status. There are 3 unique statuses that can prevent deactivation:<br>Prospect<br>Alumni<br>Staff\|\| \|\| 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="Samantha">Legal_First</span> \|\| varchar(80) \|\| The student's legal first name. \|\| <nowiki>{{Student.Legal_First}}</nowiki> \|\| Students.Legal_First \|\| LegalFirst

Redrock at 15:14, 6 August 2025

2025-08-06T15:14:05Z

← Older revision		Revision as of 15:14, 6 August 2025
Line 687:		Line 687:

	<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>		<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]], and the [[TracCloud:_Welcome_Messages\|staff welcome message]]		* "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.		* "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.		* "StepSupervisor" (e.g., <nowiki>{{StepSupervisor.First_Name}}</nowiki>) should be used when referencing the STEP supervisor in [[TracCloud:_Work_Plans\|Work Plan]] fields.