| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPPerformance Assessment Workbench |
1 | SLS_CPET | PAW -Comments for an event / test / participant assignment | 2 | PETID | PAW identifier | nvarchar | 8 | 0 | | |
2 | SLS_CRITEM | PAW - Comments for an item from a participant | 2 | PETID | PAW identifier | nvarchar | 8 | 0 | | |
3 | SLS_PET | PAW - Person/Event/Test Relationship Table | 2 | PETID | PAW identifier | nvarchar | 8 | 0 | | |
4 | SLS_PRES | PAW - Person Results Structure | 6 | PETID | PAW - Test Result ID | nvarchar | 8 | 0 | | |
5 | SLS_PRINT | PAW - Print Information | 3 | PETID | PAW identifier | nvarchar | 8 | 0 | | |
6 | SLS_RESS1 | PAW - Result for Item Essay 1 | 2 | PETID | PAW identifier | nvarchar | 8 | 0 | | |
7 | SLS_RESS2 | PAW - Result for Item Essay 2 | 2 | PETID | PAW identifier | nvarchar | 8 | 0 | | |
8 | SLS_RFILL | PAW - Result Item Fillin | 2 | PETID | PAW identifier | nvarchar | 8 | 0 | | |
9 | SLS_RITEM | PAW - Result on Item | 2 | PETID | PAW identifier | nvarchar | 8 | 0 | | |
10 | SLS_RLC | PAW - Result for Item Listchoice | 2 | PETID | PAW identifier | nvarchar | 8 | 0 | | |
11 | SLS_RMC | PAW - Result for Item Multiple Choice | 2 | PETID | PAW identifier | nvarchar | 8 | 0 | | |
12 | SLS_RRATE | PAW - Result for Item RATE | 2 | PETID | PAW identifier | nvarchar | 8 | 0 | | |
13 | SLS_RTEST | PAW - Participant's Aggregated Test Results | 2 | PETID | PAW identifier | nvarchar | 8 | 0 | | |
14 | SLS_YESS1 | PAW - Result for Item Essay 1 | 2 | PETID | PAW identifier | nvarchar | 8 | 0 | | |
15 | SLS_YESS2 | PAW - Result for Item Essay 2 | 2 | PETID | PAW identifier | nvarchar | 8 | 0 | | |
16 | SLS_YFILL | PAW - Result Item Fillin | 2 | PETID | PAW identifier | nvarchar | 8 | 0 | | |
17 | SLS_YITEM | PAW - Result on Item | 2 | PETID | PAW identifier | nvarchar | 8 | 0 | | |
18 | SLS_YLC | PAW - Result for Item Listchoice | 2 | PETID | PAW identifier | nvarchar | 8 | 0 | | |
19 | SLS_YMC | PAW - Result for Item Multiple Choice | 2 | PETID | PAW identifier | nvarchar | 8 | 0 | | |
20 | SLS_YRATE | PAW - Result for Item RATE | 2 | PETID | PAW identifier | nvarchar | 8 | 0 | | |
21 | SLS_YTEST | PAW - Participant's Aggregated Test Results | 2 | PETID | PAW identifier | nvarchar | 8 | 0 | | |