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 | 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). |
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 |
varchar(120) | The student's email address, typically their campus email. | {{Student.Email}} | Students.Email | ||
Preferred | varchar(80) | The student's preferred contact method. Possible values are listed below.
|
{{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 |
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 |
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.
|
{{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 |
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.
|
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 |
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 |
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}} |
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 |
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 |
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 | |
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.
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 |
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 |
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.
|
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. | 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}}*CustomData.cf_123}}</nowiki> | 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.
- "Staff" (e.g., {{Staff.First_Name}}) should be used in: Workshop descriptions and notifications, announcements, staff bio on search availability, and the staff welcome message
- "Supervisor" (e.g., {{Supervisor.First_Name}}) should be used when referencing the assigned supervisor in Work Plan fields.
- "StepSupervisor" (e.g., {{StepSupervisor.First_Name}}) should be used when referencing the STEP supervisor in Work Plan fields.
Field | Type | Description | API |
---|---|---|---|
Sequence | bigint | Unique identifer for each profile. | Profiles.Sequence |
Type | int | The type of profile. Possible values are listed below.
|
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 |
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 |
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.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 |
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 |
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 |
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 |
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 |
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 |
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.
|
{{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 |
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 |
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.
|
{{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}} |
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 |
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 |
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}} |
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.
|
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.
|
CustomDataTypes.InputType | |
ProfileID | bigint | Which profile this custom field is linked to, 0 is all. Relates to Profiles.Sequence. | CustomDataTypes.ProfileID |
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 |
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.
|
{{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.
|
{{SPStep.DirectedTo}} | SPSteps.DirectedTo |
OverrideRequireConfirmation | int | Whether or not this step has been overridden to allow/disallow confirmation. | {{SPStep.OverrideRequireConfirmation}} | SPSteps.OverrideRequireConfirmation |
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.
|
{{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}} |
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}} |
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 |
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.}} | WPSteps.WorkPlanID |
Type | varchar(120) | What type of step this is. Possible values are listed below.
|
{{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.
|
{{WPStep.DirectedTo}} | WPSteps.DirectedTo |
OverrideRequireConfirmation | int | Whether or not this step has been overridden to allow/disallow confirmation. | {{WPStep.OverrideRequireConfirmation}} | WPSteps.OverrideRequireConfirmation |
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.
|
{{WPAssigned.Status}} | WPAssigned.Status |
Percent | int | The completion percentage of the plan. | {{WPAssigned.Percent}} | WPAssigned.Percent |
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 |
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 |
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}} |