TracCloud: Rosetta

    This page is still in progress! Come back later to learn more.

Todo: notes on excluded twig tags

TracCloud: Table and Field List

---

Relevant wiki articles:

• Visits/Appts SFTP Export

• API

• Twig

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 Visibility

Students

Toggle Visibility

Field	Type	Description/Example	Twig Tag	API	SFTP Export Column
Sequence	bigint AI PK	Static identifier for students, unrelated to ID.
UUID	varchar(36)	Unique identifier for this user. 1a23b4c5-6789-01d2-ef3g-456h78901ijk		Students.UUID
ID	bigint	The student's ID number. Should be unique. 1234567	{{Student.ID}}	Students.ID	StudentID
Other_ID	varchar(40)	Alternative identifier for the student. A1234567	{{Student.Other_ID}}	Students.Other_ID	OtherID
Other_ID2	varchar(40)	Another alternative identifier for the student. SSMITH00	{{Student.Other_ID2}}	OtherID2
Barcode	varchar(80)
Status	varchar(80)
OtherStatus	varchar(80)
Legal_First	varchar(80)
First Name	varchar(80)	The student's preferred first name. Sam	{{Student.First_Name}}	Students.First_Name	FirstName
Last Name	varchar(80)	The student's last name. Smith	{{Student.Last_Name}}	Students.Last_Name	LastName
Middle	varchar(80)
Street	varchar(250)
Apt	varchar(80)
City	varchar(120)
State	varchar(80)
Zip	varchar(20)
Country	varchar(80)
Home_Phone	varchar(80)
Work_Phone	varchar(80)
Cell_Phone	varchar(80)
Email	varchar(120)
Preferred	varchar(80)
passhash	varchar(128)	Unused.
Attempts	bigint
resetCode	varchar(80)
lockedOut	int
TextAddr	varchar(120)
LastDateIn	date
Notes	text
UserName	varchar(120)
Password	varchar(128)	Unused.
Prefs	text
Birthdate	date
Gender	varchar(80)
Ethnicity	varchar(150)
Major	varchar(120)
Class	varchar(80)
DegreeGoal	varchar(80)
Cohort	varchar(80)
College	varchar(80)
Grad_Und	varchar(80)
DateStarted	date
DateWithdrawn	date
ReasonWithdrawn	varchar(128)
GradDate	date
GradDegree	varchar(128)
GPA	double
AccumHours	double
PrimaryConsultantID	bigint	Relates to Staff.Sequence.
FlagText	varchar(80)
CustomData	json
WatchLists	json
CreatedDT	timestamp
ModifiedDT	timestamp
Fund	varchar(80)
gen_BIOConfirmed	varchar(2)
gen_BIOConfirmedDT	varchar(20)
Pronouns	varchar(80)
Full_Name	varchar(255)
Full_Name2	varchar(255)
_LastImportedDT	datetime
PassLastDateChanged	date
PassFailedAttempts	int
AccountLocked	tinyint
AccountLockDateTime	datetime

Visits

Toggle Visibility

Field	Type	Description	Twig Tag	API	SFTP Export Column	Example
example	example	example	{{example.example}}	example.example	example	example

Appointments

Toggle Visibility

---

Field	Type	Description/Example	Twig Tag
example	example	example	{{example.example}}

API	SFTP Export
example.example	example