|
|
| (12 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>
| |
| <span style="color:red">Entries beyond this point are placeholders, and will be expanded on later.</span>
| |
| <hr>
| |
| | |
| ==SAGE==
| |
| Referrals
| |
| ReferralType
| |
| RefTypeCustomAnswers
| |
| RefTypeCustomQuestions
| |
| RefTypeEmailRecipients
| |
| | |
| <hr>
| |
| ==Success Plans==
| |
| SPAssigned
| |
| SPAssignedSteps
| |
| SPEmails
| |
| SPSteps
| |
| SuccessPlan
| |
| | |
| <hr>
| |
| ==Work Plans==
| |
| WorkPlan
| |
| WPAssigned
| |
| WPAssignedSteps
| |
| WPEmails
| |
| WPSteps
| |
| | |
| <hr>
| |
| ==Resources==
| |
| | |
| | |
| __NOTOC__
| |