TracCloud: Rosetta

From Redrock Wiki

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". {{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, can either be an in-person location or an online link. {{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. {{Appointment.Online}} Appointments.Online 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, Group, etc. {{Appointment.Type}} ApptType
Icon An icon that indicates the appointment type, such as . {{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
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
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
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



In the table below you will notice that there are two Twig tags available for each field. Depending on where you are using these tags, one or the other needs to be used. Tags with the "Staff" prefix should be used in Workshop descriptions and notifications, announcements, staff bio on search availability, and the staff welcome message. The tags with the "Consultant" prefix should be used everywhere else.

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}}		 Staff.First_Name ConsultantFirst
Last_Name varchar(80) The staff member's last name. {{Consultant.Last_Name}}
{{Staff.Last_Name}}		 Staff.Last_Name ConsultantLast
LastFirst varchar(255) The staff member's full name, formatted as "Last, First". {{Consultant.LastFirst}}
{{Staff.LastFirst}}		 Staff.LastFirst
FirstLast varchar(255) The staff member's full name, formatted as "First Last". {{Consultant.FirstLast}}
{{Staff.FirstLast}}		 Staff.FirstLast
Alias varchar(120) The staff member's alias/alternative name. {{Consultant.Alias}}
{{Staff.Alias}}		 Staff.Alias ConsultantAlias
Email varchar(120) The staff member's email address. {{Consultant.Email}}
{{Staff.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}}		 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}}		 Staff.Phone
CellPhone varchar(80) The staff member's cell phone number. {{Consultant.CellPhone}}
{{Staff.CellPhone}}		 Staff.CellPhone
WorkPhone varchar(80) The staff member's work phone number. {{Consultant.WorkPhone}}
{{Staff.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. 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}}		 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|raw}}		 Staff.StaffBIO
Pronouns varchar(80) The staff member's preferred pronouns. {{Consultant.Pronouns}}
{{Staff.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.StaffBIO|raw}}


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}} Reasons.Name 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



More coming soon!

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