|
|
| (11 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| {{WIP}}
| | #REDIRECT [[TracCloud: API]] |
| | |
| ==TracCloud Table List==
| |
| | |
| This is a list of TracCloud data tables, primarily for reference in regards to [[TracCloudTechAPI|API access]].
| |
| | |
| <hr>
| |
| <div style="float: left; margin-top: 0em; margin-bottom: 1em"><big><b>SurveyTrac</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)
| |
| |}
| |
| <hr>
| |
| | |
| <!--
| |
| </div>
| |
| <hr>
| |
| <span style="color:red">Entries beyond this point are placeholders and will be expanded on later.</span>
| |
| <hr>
| |
| | |
| Staff
| |
| Students
| |
| Announcements
| |
| Appointments
| |
| Assignments
| |
| AutoEmailBlock
| |
| AutoEmails
| |
| AutoEmailsHasRefTypeEmailRecipients
| |
| AvailBlocks
| |
| AvailSlots
| |
| Centers
| |
| CenterStaff
| |
| Certifications
| |
| CertTypes
| |
| Checkouts
| |
| Courses
| |
| cron_scripts
| |
| CustomData
| |
| CustomDataTypes
| |
| Dates
| |
| DocTemplates
| |
| DocTypes
| |
| Documents
| |
| Events
| |
| Faculty
| |
| Favorites
| |
| GoalsTasks
| |
| GradeGroups
| |
| Groups
| |
| Lists
| |
| NotAvail
| |
| Notifications
| |
| NotificationTypes
| |
| OutstandingApptRequests
| |
| PayCodeRates
| |
| PayCodes
| |
| PotentialAssignments
| |
| PotentialAssignmentsSections
| |
| ProfileExtraGroups
| |
| Profiles
| |
| Programs
| |
| ProgsListsAssigned
| |
| ProspectRequests
| |
| Reasons
| |
| Registrations
| |
| Reservations
| |
| Resources
| |
| ResourceTypes
| |
| SageAutomations
| |
| SageEmailType
| |
| SageEventType
| |
| Sections
| |
| SectionSchedule
| |
| SpecialNeeds
| |
| StudentSearchAvails
| |
| SystemLogs
| |
| Tasks
| |
| TaskTriggers
| |
| TaskTypes
| |
| Terms
| |
| TermsAndConditions
| |
| WatchLists
| |
| WorkRecords
| |
| WorkTypes
| |
| | |
| ==SAGE==
| |
| Referrals
| |
| ReferralType
| |
| RefTypeCustomAnswers
| |
| RefTypeCustomQuestions
| |
| RefTypeEmailRecipients
| |
| | |
| ==Success Plans==
| |
| SPAssigned
| |
| SPAssignedSteps
| |
| SPEmails
| |
| SPSteps
| |
| SuccessPlan
| |
| | |
| ==Work Plans==
| |
| WorkPlan
| |
| WPAssigned
| |
| WPAssignedSteps
| |
| WPEmails
| |
| WPSteps
| |
| | |
| ==Resources==
| |
| -->
| |
| | |
| __NOTOC__
| |