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.
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_code | 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 | external_student_test | Main-Placement | N/A | Name of the sub-test | NOT DISPLAYED IN UI |
| test_date | external_student_test | Main-Placement | Date | The date the student completed the test (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 | 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.