TracCloudTables

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

TracCloud Table List

This is a list of TracCloud data tables, primarily for reference in regards to API access.

---

SurveyTrac Related

Surveys

Column	Type	Notes
Sequence	bigint AI PK	Static identifier for each Survey.
Name	varchar(80)
CreatedBy	bigint	Relates to Staff.Sequence.
Options	json	This field can be ignored for API purposes.
ProfileID	bigint	Relates to Profiles.Sequence.
CenterID	bigint
AutoSend	varchar(80)	The chosen "Initiated Via" option.
Active	tinyint
ActiveFrom	date
ActiveTo	date
Instructions	text
useXML	tinyint	Unused.
Assessment	tinyint	Unused.
Function	varchar(80)	Unused.
Confirmation	text
HeadText	text

SrvyQuestions

Column	Type	Notes
Sequence	bigint AI PK	Static identifier for each Question, sequences are not reused even across multiple surveys.
Question	text
SurveyID	bigint	Relates to Surveys.Sequence.
Points	double
Answer	varchar(80)
AnswerChoices	text
Options	json
LinkName	varchar(80)	Unused.
LinkURL	varchar(80)	Unused.
Type	varchar(80)
Number	int
CustomData	json

Responses

Column	Type	Notes
Sequence	bigint AI PK	Static identifier for each response.
SurveyID	bigint	Relates to Surveys.Sequence.
linkedUID	varchar(36)
SentByID	varchar(36)
StudentID	bigint	Relates to Students.Sequence (not Students.ID).
SentBy	varchar(80)
SentDate	datetime
AnsweredDate	datetime
StaffID	bigint	Relates to Staff.Sequence.
FacultyID	bigint	Relates to Faculty.Sequence.
SentManually	tinyint
CustomData	json

SrvyRespAnswers

Column	Type	Notes
Sequence	bigint AI PK	Static identifier for each question response.
QuestionID	bigint	Relates to SrvyQuestions.Sequence.
ResponseID	bigint	Relates to Responses.Sequence.
aAnswer	varchar(80)
nAnswer	double
tAnswer	text
CustomData	json

---

Visits

Visits

Column	Type	Notes
Sequence	bigint AI PK
EnteredDT	datetime
TimeIn	datetime
TimeOut	datetime
Duration	int
isWork	tinyint
StudentID	bigint	Relates to Students.Sequence (not Students.ID).
CenterID	bigint	Relates to Centers.Sequence.
ConsultantID	bigint	Relates to Staff.Sequence.
RegistrationID	bigint	Relates to Registrations.Sequence.
ReasonID	bigint	Relates to Reasons.Sequence.
TotalTime	double
isWaiting	tinyint
WaitTime	double
CustomData	json
NotificationDT	datetime
isTerminated	tinyint
PostPaid	tinyint
Posted1	tinyint
Posted2	tinyint
Posted3	tinyint
Fund	varchar(80)
CtrNotes	text
SchedNotes	text
StudNotes	text
tOptions	text
SurveyRespID	bigint	Relates to SrvyRespAnswers.Sequence
TermID	bigint	Relates to Terms.Sequence.
SectionID	bigint	Relates to Sections.Sequence.
Location	varchar(512)
Online	tinyint
TimeZone	varchar(120)
asynchVisitID	bigint
VisitDay2	varchar(80)
gen2_date_EnteredDT	date
gen2_date_TimeIn	date
gen2_date_TimeOut	date
VisitDay	varchar(20)

---

More coming soon...