View source for TracCloudTables

{{WIP}}

==TracCloud Table List==

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

<hr>
'''Types''' 
{| class="wikitable" border="1" style="margin:auto"
!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).
|}

<hr>
<div style="float: left; margin-top: 0em; margin-bottom: 1em"><big><b>SurveyTrac Related</b></big></div><div class="mw-collapsible mw-collapsed">
<br><br>

{| class="wikitable"
|+ 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||
|}

{| class="wikitable"
|+ 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||
|}

{| class="wikitable"
|+ 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||
|}

{| class="wikitable"
|+ 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||
|}
</div>
<hr>
<div style="float: left; margin-top: 0em; margin-bottom: 1em"><big><b>Visits</b></big></div><div class="mw-collapsible mw-collapsed">
<br><br>

{| class="wikitable"
|+ 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)
|}
</div>
<hr>
<div style="float: left; margin-top: 0em; margin-bottom: 1em"><big><b>Students</b></big></div><div class="mw-collapsible mw-collapsed">
<br><br>

{| class="wikitable"
|+ Students
|-
! Column !! Type !! Notes
|-
|Sequence||bigint AI PK ||Static identifier for students, unrelated to ID.
|-
|UUID||varchar(36) ||
|-
|ID||bigint ||
|-
|Other_ID||varchar(40) ||
|-
|Other_ID2||varchar(40) ||
|-
|Barcode||varchar(80) ||
|-
|Status||varchar(80) ||
|-
|OtherStatus||varchar(80) ||
|-
|Legal_First||varchar(80) ||
|-
|First_Name||varchar(80) ||
|-
|Last_Name||varchar(80) ||
|-
|Middle||varchar(80) ||
|-
|Street||varchar(250) ||
|-
|Apt||varchar(80) ||
|-
|City||varchar(120) ||
|-
|State||varchar(80) ||
|-
|Zip||varchar(20) ||
|-
|Country||varchar(80) ||
|-
|Home_Phone||varchar(80) ||
|-
|Work_Phone||varchar(80) ||
|-
|Cell_Phone||varchar(80) ||
|-
|Email||varchar(120) ||
|-
|Preferred||varchar(80) ||
|-
|passhash||varchar(128) || Unused.
|-
|Attempts||bigint ||
|-
|resetCode||varchar(80) ||
|-
|lockedOut||int ||
|-
|TextAddr||varchar(120) ||
|-
|LastDateIn||date ||
|-
|Notes||text ||
|-
|UserName||varchar(120) ||
|-
|Password||varchar(128) || Unused.
|-
|Prefs||text ||
|-
|Birthdate||date ||
|-
|Gender||varchar(80) ||
|-
|Ethnicity||varchar(150) ||
|-
|Major||varchar(120) ||
|-
|Class||varchar(80) ||
|-
|DegreeGoal||varchar(80) ||
|-
|Cohort||varchar(80) ||
|-
|College||varchar(80) ||
|-
|Grad_Und||varchar(80) ||
|-
|DateStarted||date ||
|-
|DateWithdrawn||date ||
|-
|ReasonWithdrawn||varchar(128) ||
|-
|GradDate||date ||
|-
|GradDegree||varchar(128) ||
|-
|GPA||double ||
|-
|AccumHours||double ||
|-
|PrimaryConsultantID||bigint || Relates to Staff.Sequence.
|-
|FlagText||varchar(80) ||
|-
|CustomData||json ||
|-
|WatchLists||json ||
|-
|CreatedDT||timestamp ||
|-
|ModifiedDT||timestamp ||
|-
|Fund||varchar(80) ||
|-
|gen_BIOConfirmed||varchar(2) ||
|-
|gen_BIOConfirmedDT||varchar(20) ||
|-
|Pronouns||varchar(80) ||
|-
|Full_Name||varchar(255) ||
|-
|Full_Name2||varchar(255) ||
|-
|_LastImportedDT||datetime ||
|-
|PassLastDateChanged||date ||
|-
|PassFailedAttempts||int ||
|-
|AccountLocked||tinyint ||
|-
|AccountLockDateTime||datetime
|}

</div>
<hr>
<div style="float: left; margin-top: 0em; margin-bottom: 1em"><big><b>Subject Related</b></big></div><div class="mw-collapsible mw-collapsed">
<br><br>

{| class="wikitable"
|+ Courses
|-
! Column !! Type !! Notes
|-
|Sequence||bigint AI PK ||Unique identifier for each course.
|-
|Subject||varchar(40) ||
|-
|Course||varchar(20) ||
|-
|Title||varchar(120) ||
|-
|ExcludeFromCharts||tinyint || 
|-
|Dept||varchar(40) ||
|-
|SubjectCourse||varchar(200) || 
|-
|_LastImportedDT||datetime ||
|-
|CustomData||json||
|}

{| class="wikitable"
|+ Sections
|-
! Column !! Type !! Notes
|-
|Sequence||bigint AI PK ||Unique identifier for each section.
|-
|Inactive||tinyint ||
|-
|Code||varchar(80) ||
|-
|CourseID||bigint || Relates to Courses.Sequence
|-
|GradeGroupID||bigint ||
|-
|CRN||varchar(80) ||
|-
|TermID||bigint || Relates to Terms.Sequence
|-
|FacultyID||bigint || Relates to Faculty.Sequence
|-
|nonEnrolled||tinyint ||
|-
|CustomData||json ||
|-
|CreatedDT||timestamp ||
|-
|ignoreRegImportDeactivate||tinyint ||
|-
|Credits||double ||
|-
|_LastImportedDT||datetime ||
|-
|Title||varchar(120)||
|}

{| class="wikitable"
|+ Terms
|-
! Column !! Type !! Notes
|-
|Sequence||bigint AI PK ||Unique identifier for terms.
|-
|Active||tinyint ||
|-
|TermCode||varchar(80) ||
|-
|OrderIdx||int ||
|-
|ActiveFrom||date ||
|-
|ActiveTo||date ||
|-
|CustomData||json|| Unused.
|}

{| class="wikitable"
|+ Registrations
|-
! Column !! Type !! Notes
|-
|Sequence||bigint AI PK ||Unique identifier for registrations.
|-
|Inactive||tinyint ||
|-
|OverrideDate||tinyint ||
|-
|SectionID||bigint ||Relates to Sections.Sequence.
|-
|StudentID||bigint ||Relates to Students.Sequence (not Students.ID).
|-
|Grade||varchar(40) ||
|-
|ValidFromDT||datetime ||
|-
|ValidToDT||datetime ||
|-
|Notes||text ||
|-
|CustomData||json ||
|-
|_LastImportedDT||datetime ||
|-
|RegStatus||varchar(40) ||
|-
|EarnedCredits||double ||
|}

</div>
<hr>

More coming soon...

<!--
<span style="color:red">Entries beyond this point are placeholders and will be expanded on later.</span>
<hr>

Staff
Appointments
Assignments
AvailBlocks
AvailSlots
Centers
Certifications
CertTypes
CustomDataTypes
DocTypes
Documents
Events
Faculty
GradeGroups
Groups
Lists
NotificationTypes
OutstandingApptRequests
PayCodes
PotentialAssignments
ProfileExtraGroups
Profiles
ProgsListsAssigned
ProspectRequests
Reasons
Resources
ResourceTypes
SageAutomations
SageEmailType
SageEventType
SectionSchedule
SpecialNeeds
Tasks
TaskTypes
TermsAndConditions
WatchLists
WorkTypes

==SAGE==
Referrals
ReferralType
RefTypeCustomAnswers
RefTypeCustomQuestions
RefTypeEmailRecipients

==Success Plans==
SPAssigned
SPAssignedSteps
SPEmails
SPSteps
SuccessPlan

==Work Plans==
WorkPlan
WPAssigned
WPAssignedSteps
WPEmails
WPSteps

==Resources==
Reservations
Checkouts
-->

__NOTOC__