Table: external_student_test
Description: (needs imrovement, clarification, detail) Notes from any system can be saved in the table for display in SSP. Notes can originate from any system and will be displayed to the user in chronological order.
Any other information that is necessary - put it here.
Tool: Main
Tab: Placement
The Main Tool displays academic information about the student normally stored in the student information system (SIS).
The Placement tab from the Main Tool displays student placement test information obtained from the SIS.
Attachments:
...
| Parameter | External Table | Location | Field Name | Description | Example | |
|---|---|---|---|---|---|---|
| test_name | external_student_test | Main-Placement | Type | Name of test | American College Testing COMP | |
| test_codescore | external_student_test | Main-Placement | N/A | Code give to the test | NOT DISPLAYED IN UI | |
| sub_test_code * | external_student_test | Main-Placement | N/A | The sub-test or test component | NOT DISPLAYED IN UI | |
| sub_test_name | Score | The score the student earned on the test | 18; 3000 | |||
| status | external_student_test | Main-Placement | N/A | NameStatus | This field indicates the status of the sub- test submitted | NOT DISPLAYED IN UI Accepted |
| test_date | external_student_test | Main-Placement | Test Date | The date the Date student completed the test (, Format YYYY-MM-DD format). | 01/28/2011 | |
| score | external_student_test | Main-Placement | Score | The score the student earned on the test | 18; 3000 | |
| status | 2012-01-01 | |||||
| outcome | external_student_test | Main-Placement | Status | This field indicates the status of the test submitted | Accepted | |
| discriminator ** | external_student_test | Main-Placement | N/A | This field uniquely identifies a test taken two or more times on the same day | NOT DISPLAYED IN UI |
- *sub_test_code: As of version 2.0.0, will only allow nulls if natural keys on external tables are disabled. Previously always allowed nulls.
- **discriminator: New field since version 2.0.0.
...
| Outcome | A description of any outcome or recommendation based on the test score. These are generally placement into courses. | Take MATH 098 and ENGL 099 |