PHI stands for "Protected Health Information" (Y = Yes, N = No)
| Display | Field | Phi | Field type | Condition choices | Field note | Header | |
|---|---|---|---|---|---|---|---|
| Testing Year | wasitestyr | N | dropdown | 9, Baseline | 1, 1 Year | 5, 5 Year | 10, 10 Year | - | - | |
| Vocabulary Raw | wasivcbraw | N | text | - | - | WASI Vocabulary | |
| Vocabulary Scaled | wasivcbscl | N | text | - | - | - | |
| Vocabulary T-Score | wasivcbt | N | text | - | - | - | |
| Similarities Raw | wasisimraw | N | text | - | - | WASI Similarities | |
| Similarities Scaled | wasisimscl | N | text | - | - | - | |
| Similarities T Score | wasisimt | N | text | - | - | - | |
| Block Design Raw | wasibdraw | N | text | - | - | WASI Block Design | |
| Block Design Scaled | wasibdscl | N | text | - | - | - | |
| Block Design T Score | wasibdt | N | text | - | - | - | |
| Matrix Reasoning Raw | wasimtrxrsraw | N | text | - | - | WASI Matrix Reasoning | |
| Matrix Reasoning Scaled | wasimtrxrsscl | N | text | - | - | - | |
| Matrix Reasoning T Score | wasimtrxrst | N | text | - | - | - | |
| Subtests T-score Total | wasi4ttot | N | calc | ([wasivcbt] + [wasisimt] + [wasibdt] + [wasimtrxrst]) | - | Subtests IQ | |
| Estimated IQ | wasiiq | N | text | - | - | - | |
| Two Subtests T-Score Total | wasi2ttot | N | calc | [wasivcbt] + [wasimtrxrst] | vocab + matrix reasoning t-total | Two Subtests IQ | |
| Two Subtests Estimated IQ | wasi2iq | N | calc | if ([wasi2ttot]='40', 55, if ([wasi2ttot]='41', 56, if ([wasi2ttot]='42', 57, if ([wasi2ttot]='43', 58, if ([wasi2ttot]='44', 59, if ([wasi2ttot]='45', 60, if ([wasi2ttot]='46', 61, if ([wasi2ttot]='47', 62, if ([wasi2ttot]='48', 63, if ([wasi2ttot]='49', 63, if ([wasi2ttot]='50', 64, if ([wasi2ttot]='51', 65, if ([wasi2ttot]='52', 65, if ([wasi2ttot]='53', 66, if ([wasi2ttot]='54', 67, if ([wasi2ttot]='55', 68, if ([wasi2ttot]='56', 69, if ([wasi2ttot]='57', 69, if ([wasi2ttot]='58', 70, if ([wasi2ttot]='59', 71, if ([wasi2ttot]='60', 72, if ([wasi2ttot]='61', 73, if ([wasi2ttot]='62', 73, if ([wasi2ttot]='63', 74, if ([wasi2ttot]='64', 75, if ([wasi2ttot]='65', 75, if ([wasi2ttot]='66', 76, if ([wasi2ttot]='67', 76, if ([wasi2ttot]='68', 77, if ([wasi2ttot]='69', 77, if ([wasi2ttot]='70', 78, if ([wasi2ttot]='71', 78, if ([wasi2ttot]='72', 79, if ([wasi2ttot]='73', 79, if ([wasi2ttot]='74', 80, if ([wasi2ttot]='75', 81, if ([wasi2ttot]='76', 82, if ([wasi2ttot]='77', 83, if ([wasi2ttot]='78', 83, if ([wasi2ttot]='79', 84, if ([wasi2ttot]='80', 84, if ([wasi2ttot]='81', 85, if ([wasi2ttot]='82', 86, if ([wasi2ttot]='83', 86, if ([wasi2ttot]='84', 87, if ([wasi2ttot]='85', 88, if ([wasi2ttot]='86', 88, if ([wasi2ttot]='87', 89, if ([wasi2ttot]='88', 90, if ([wasi2ttot]='89', 90, if ([wasi2ttot]='90', 91, if ([wasi2ttot]='91', 92, if ([wasi2ttot]='92', 93, if ([wasi2ttot]='93', 94, if ([wasi2ttot]='94', 95, if ([wasi2ttot]='95', 96, if ([wasi2ttot]='96', 96, if ([wasi2ttot]='97', 97, if ([wasi2ttot]='98', 98, if ([wasi2ttot]='99', 99, if ([wasi2ttot]='100', 99, if ([wasi2ttot]='101', 100, if ([wasi2ttot]='102', 101, if ([wasi2ttot]='103', 102, if ([wasi2ttot]='104', 103, if ([wasi2ttot]='105', 104, if ([wasi2ttot]='106', 105, if ([wasi2ttot]='107', 106, if ([wasi2ttot]='108', 107, if ([wasi2ttot]='109', 108, if ([wasi2ttot]='110', 109, if ([wasi2ttot]='111', 109, if ([wasi2ttot]='112', 110, if ([wasi2ttot]='113', 111, if ([wasi2ttot]='114', 112, if ([wasi2ttot]='115', 113, if ([wasi2ttot]='116', 114, if ([wasi2ttot]='117', 115, if ([wasi2ttot]='118', 116, if ([wasi2ttot]='119', 117, if ([wasi2ttot]='120', 118, if ([wasi2ttot]='121', 118, if ([wasi2ttot]='122', 119, if ([wasi2ttot]='123', 120, if ([wasi2ttot]='124', 121, if ([wasi2ttot]='125', 122, if ([wasi2ttot]='126', 123, if ([wasi2ttot]='127', 124, if ([wasi2ttot]='128', 125, if ([wasi2ttot]='129', 126, if ([wasi2ttot]='130', 127, if ([wasi2ttot]='131', 128, if ([wasi2ttot]='132', 129, if ([wasi2ttot]='133', 130, if ([wasi2ttot]='134', 131, if ([wasi2ttot]='135', 132, if ([wasi2ttot]='136', 133, if ([wasi2ttot]='137', 134, if ([wasi2ttot]='138', 135, if ([wasi2ttot]='139', 136, if ([wasi2ttot]='140', 137, if ([wasi2ttot]='141', 138, if ([wasi2ttot]='142', 139, if ([wasi2ttot]='143', 140, if ([wasi2ttot]='144', 141, if ([wasi2ttot]='145', 142, if ([wasi2ttot]='146', 143, if ([wasi2ttot]='147', 144, if ([wasi2ttot]='148', 145, if ([wasi2ttot]='149', 146, if ([wasi2ttot]='150', 147, if ([wasi2ttot]='151', 148, if ([wasi2ttot]='152', 149, if ([wasi2ttot]='153', 150, if ([wasi2ttot]='154', 151, if ([wasi2ttot]='155', 152, if ([wasi2ttot]='156', 153, if ([wasi2ttot]='157', 154, if ([wasi2ttot]='158', 155, if ([wasi2ttot]='159', 156, if ([wasi2ttot]='160', 157, 99999))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) | vocab + matrix reasoning iq | - |