The report is a list of students' placement details. This report can be run at the school and the district office.
Output file name - Azella_[datestamp]
Selection Criteria
Selection criteria determine which database records are used in the report.
-
Student must not be excluded from state reporting.
-
Student must have an enrollment at the selected school.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
|
Field |
Description |
|
Schools to include |
|
|
Students to Include |
Indicate which students to include in the report by selecting one of the following options:
If running the report for a single student or group of students, select the students before running the report. |
|
Student Snapshot Date |
Select date to include students enrolled during the snapshot date. |
Report Output
|
Item |
Data Element |
Description |
[Table]FieldName |
Field Length |
|
1 |
District Name |
The name of the district. |
|
35 |
|
2 |
District Code |
The District Entity ID or the sub-district number.35 |
|
7 |
|
3 |
School Name |
The name of the student’s school. |
|
35 |
|
4 |
School Code |
The state-assigned 4-digit code for the school where the student attends classes. |
School Entity ID of the [Students]SchoolID, if blank then School Number |
7 |
|
5 |
Testing Group Name |
The student’s testing group name. |
[S_AZ_STU_AZELLA_X]Test_Group |
20 |
|
6 |
Print After Scan |
This field will be blank for students in grades 4 through 12. |
[S_AZ_STU_AZELLA_X]PAS |
13 |
|
7 |
UUID |
The test UUID. |
[S_AZ_STU_AZELLA_X]Test_UUID |
36 |
|
8 |
Speaking Response Identifier |
The speaking response identifier. |
[S_AZ_STU_AZELLA_X]Spec_Test_ver |
1 |
|
9 |
Filler174 |
|||
|
10 |
Test Date |
The date for the speaking portion of the the assessment. |
[S_AZ_STU_AZELLA_X]Test_Date |
8 |
|
11 |
Scan Date |
The scan date. In the format MMYY. This is blank for grades 4-12. |
[S_AZ_STU_AZELLA_X]Scan_Date |
4 |
|
12 |
Student Last Name |
The student’s last name. |
[StudentCoreFields]PSCore_Legal_Last_Name if unavailable [Students]LastFirst
|
50 |
|
13 |
Filler244 |
|||
|
14 |
Student First Name |
The student’s first name. |
[StudentCoreFields]PSCore_Legal_First_Name if unavailable [Students]First_Name |
50 |
|
15 |
Filler324 |
|||
|
16 |
Student Middle Initial |
The student’s middle initial. |
[StudentCoreFields]PSCore_Legal_Middle_Name if unavailable [Students]Middle_Name |
1 |
|
17 |
Birth Date |
The student’s date of birth. Note: This value is populated from the Demographics page. |
[Students]DOB |
8 |
|
18 |
Gender |
The student’s gender. |
[StudentCoreFields]PSCore_Legal_Gender [Students]Gender |
1 |
|
19 |
Hispanic or Latino |
The student’s ethnicity. Indicates whether the student is of Hispanic or Latino ethnicity. Valid values: Yes - Y No - N |
[StudentCoreFields]PSCore_Legal_Gender [Students]Gender |
1 |
|
20 |
White |
The student’s ethnicity. Indicates whether the student is of White White ethnicity. Valid values: Yes - Y No - N |
[StudentCoreFields]PSCore_Legal_Gender [Students]Gender |
1 |
|
21 |
Black or African American |
The student’s ethnicity. Indicates whether the student is of Black or African American ethnicity. Valid values: Yes - Y No - N |
[StudentCoreFields]PSCore_Legal_Gender [Students]Gender |
1 |
|
22 |
Asian |
The student’s ethnicity. Indicates whether the student is of Asian ethnicity. Valid values: Yes - Y No - N |
[StudentCoreFields]PSCore_Legal_Gender [Students]Gender |
1 |
|
23 |
American Indian or Alaskan Native |
The student’s ethnicity. Indicates whether the student is of American Indian or Alaskan Native ethnicity. Valid values: Yes - Y No - N |
[StudentCoreFields]PSCore_Legal_Gender [Students]Gender |
1 |
|
24 |
Native Hawaiian or Other Pacific Islander |
The student’s ethnicity. Indicates whether the student is of Native Hawaiian or Other Pacific Islander ethnicity. Valid values: Yes - Y No - N |
[StudentCoreFields]PSCore_Legal_Gender [Students]Gender |
1 |
|
25 |
Grade of Student |
Student’s grade. Valid values;
|
[Students]Grade |
|
|
26 |
Filler |
|
|
|
|
27 |
SSID Number |
|
|
|
|
28 |
Special Education |
Indicates whether this is a special education student. Valid values:
|
[S_AZ_STU_AZELLA_X]Special_Edu |
1 |
|
29 |
EL Classification |
The EL Classification number. Valid values:
|
[S_AZ_STU_AZELLA_X]EL_Class |
1 |
|
30 |
Migrant |
Indicates if student is a migrant. Valid values:
|
[S_AZ_STU_AZELLA_X]Migrant |
1 |
|
31 |
SES |
SES Valid values:
|
[S_AZ_STU_AZELLA_X]SES |
1 |
|
32 |
EL Services |
The EL Services description. Valid values:
|
[S_AZ_STU_AZELLA_X]EL_Services |
1 |
|
33 |
Primary Home Language |
The student’s primary home language: 1 - English
|
|
1 |
|
34 |
Student's Primary Language |
The student’s primary language: 1 - English
|
|
1 |
|
35 |
Student's First Language |
The student’s first language: 1 - English
|
|
1 |
|
36 |
Other Information |
Other information. Populate from:
|
[S_AZ_STU_AZELLA_X]Other |
10 |
|
37 |
Form Code - Unit 1 |
The Form Code - Unit 1:
|
[S_AZ_STU_AZELLA_X]FC_Unit1 |
5 |
|
38 |
Form Code - Unit 2 |
The Form Code - Unit 2:
|
[S_AZ_STU_AZELLA_X]FC_Unit2 |
5 |
|
39 |
Form Code - Unit 3 |
The Form Code - Unit 3:
|
[S_AZ_STU_AZELLA_X]FC_Unit3 |
5 |
|
40 |
Form Code - Unit 4 |
The Form Code - Unit 4:
|
[S_AZ_STU_AZELLA_X]FC_Unit4 |
5 |
|
41 |
Form Code - Unit 5 |
The Form Code - Unit 5:
|
[S_AZ_STU_AZELLA_X]FC_Unit5 |
5 |
|
42 |
Do Not Report |
Indicates whether this is a Do Not Report. Valid values:
|
[S_AZ_STU_AZELLA_X]DNR |
1 |
|
43 |
Do Not Report Reason |
The Do Not Report reason. Valid values: 1 = Student Error
|
[S_AZ_STU_AZELLA_X]DNR_Reason |
2 |
|
44 |
Filler406 |
|||
|
45 |
Pearson Use Only |
Pearson Use Only |
[S_AZ_STU_AZELLA_X]Status |
1 |
|
46 |
Document ID |
Doc ID |
[S_AZ_STU_AZELLA_X]Doc_ID |
9 |
|
47 |
Overall Proficiency Level |
The student’s overall proficiency level: Grade K:
Grades 1-12:
Status Code 2 is present for Cycle 12 only |
[S_AZ_STU_AZELLA_X]Overall_Prof_Level |
1 |
|
48 |
Total Raw Score |
The total raw score. This is blank for grades 1-12 Placement tests. |
|
3 |
|
49 |
Total Number of Points Possible |
The total points possible. This is blank for grades 1-12 Placement tests. |
|
3 |
|
50 |
Scale Score |
This is blank for grades 1-12 Placement tests. |
|
4 |
|
51 |
Status Code |
The student’s status code: Kindergarten:
Grades 1-12:
Students with a status code of 1, 2 will not have an Overall Proficiency Level or Total Proficiency Scale Score.
All grades:
|
|
|
|
52 |
Stopping Rules Determination |
1 - Full Test Administered
Blank for grades 1-12 |
|
|
|
53 |
Unit 1 Attempted |
Indicates whether Unit 1 is attempted. Valid values:
|
[S_AZ_STU_AZELLA_X]Unit1_Attempt |
1 |
|
54 |
Unit 2 Attempted |
Indicates whether Unit 2 is attempted. Valid values:
|
[S_AZ_STU_AZELLA_X]Unit2_Attempt |
1 |
|
55 |
Unit 3 Attempted |
Indicates whether Unit 3 is attempted. Valid values:
|
[S_AZ_STU_AZELLA_X]Unit3_Attempt |
1 |
|
56 |
Unit 4 Attempted |
Indicates whether Unit 4 is attempted. Valid values:
|
[S_AZ_STU_AZELLA_X]Unit4_Attempt |
1 |
|
57 |
Unit 5 Attempted |
Indicates whether Unit 5 is attempted. Valid values:
|
[S_AZ_STU_AZELLA_X]Unit5_Attempt |
1 |
|
58 |
Listening Attempted |
Indicate whether listening attempted. Valid values:
|
[S_AZ_STU_AZELLA_X]Listen_Attempt |
1 |
|
59 |
Listening Weighted Raw Score |
The Listening Weighted Raw Score. |
[S_AZ_STU_AZELLA_X]Listen_Weighted_Score Blank if Status Code is 1 |
3 |
|
60 |
Listening Weighted Points Possible |
The Listening Weighted Points Possible. |
[S_AZ_STU_AZELLA_X]Listen_Weighted_Points Blank if Status Code is 1 |
3 |
|
61 |
Listening Scale Score |
The Listening Scale Score. |
[S_AZ_STU_AZELLA_X]Listen_Scale_Score Blank if Status Code is 1 |
3 |
|
62 |
Listening Proficiency Level |
The Listening Proficiency Level:
|
[S_AZ_STU_AZELLA_X]Listen_Prof_Level |
1 |
|
63 |
Writing Attempted |
Indicates whether writing is attempted. Valid values:
|
[S_AZ_STU_AZELLA_X]Write_Attempt |
1 |
|
64 |
Writing Weighted Raw Score |
The Writing Weighted Raw Score. |
[S_AZ_STU_AZELLA_X]Write_Weighted_Score Blank if Status Code is 1 |
3 |
|
65 |
Writing Weighted Points Possible |
The Writing Weighted Points Possible. |
[S_AZ_STU_AZELLA_X]Write_Weighted_Points Blank if Status Code is 1 |
3 |
|
66 |
Writing Scale Score |
The Writing Scale Score. |
[S_AZ_STU_AZELLA_X]Write_Scale_Score Blank if Status Code is 1 |
3 |
|
67 |
Writing Proficiency Level |
The Writing Proficiency Level:
|
[S_AZ_STU_AZELLA_X]Write_Prof_Level |
1 |
|
68 |
Reading Attempted |
Indicate whether reading attempted. Valid values:
|
[S_AZ_STU_AZELLA_X]Read_Attempt |
1 |
|
69 |
Reading Weighted Raw Score |
The Reading Weighted Raw Score. |
[S_AZ_STU_AZELLA_X]Read_Weighted_Score Blank if Status Code is 1 |
3 |
|
70 |
Reading Weighted Points Possible |
The Reading Weighted Points Possible. |
[S_AZ_STU_AZELLA_X]Read_Weighted_Points Blank if Status Code is 1 |
3 |
|
71 |
Reading Scale Scores |
The Reading Scale Scores. |
[S_AZ_STU_AZELLA_X]Read_Scale_Score Blank if Status Code is 1 |
3 |
|
72 |
Reading Proficiency Level |
The Reading Proficiency Level:
|
[S_AZ_STU_AZELLA_X]Read_Prof_Level |
1 |
|
73 |
Speaking Attempted |
Indicates whether Speaking is attempted. Valid values:
|
[S_AZ_STU_AZELLA_X]Speak_Attempt |
1 |
|
74 |
Speaking Assessment Date |
The Speaking Assessment Date. If the Speaking Attempted is N the first day of window (01/27/25) is displayed. Otherwise, display the speaking assessment date. The date will be between the dates of 01/27/25 and 03/14/25. If the date is after 03/14/25, then 03/14/25 is displayed. |
[S_AZ_STU_AZELLA_X]Speak_Assess_Date |
8 |
|
75 |
Speaking Weighted Raw Score |
The Speaking Weighted Raw Score. |
[S_AZ_STU_AZELLA_X]Speak_Weighted_Score Blank if Status Code is 1 |
3 |
|
76 |
Speaking Weighted Points Possible |
The Speaking Weighted Points Possible. |
[S_AZ_STU_AZELLA_X]Speak_Weighted_Points Blank if Status Code is 1 |
3 |
|
77 |
Speaking Scale Score |
The Speaking Scale Score. |
[S_AZ_STU_AZELLA_X]Speak_Scale_Score Blank if Status Code is 1 |
3 |
|
78 |
Speaking Proficiency Level |
The Speaking Proficiency Level:
|
[S_AZ_STU_AZELLA_X]Speak_Prof_Level |
1 |
|
79 |
Receptive Communication Attempted |
Indicates whether Receptive Communication is attempted. Valid values:
|
[S_AZ_STU_AZELLA_X]RComm_Attempt |
1 |
|
80 |
Receptive Communication Weighted Raw Score |
The Receptive Communication Weighted Raw Score. |
[S_AZ_STU_AZELLA_X]RComm_Weighted_Score Blank if Receptive Communication Attempted is N
|
3 |
|
81 |
Receptive Communication Weighted Points Possible |
The Receptive Communication Weighted Points Possible. |
[S_AZ_STU_AZELLA_X]RComm_Weighted_Points Blank if Receptive Communication Attempted is N
|
3 |
|
82 |
Filler |
|
|
|
|
83 |
Receptive Communication Proficiency Level |
The Receptive Communication Proficiency Level:
|
[S_AZ_STU_AZELLA_X]RComm_Prof_Level |
1 |
|
84 |
Productive Communication Attempted |
Indicates whether Productive Communication is attempted. Valid values:
|
[S_AZ_STU_AZELLA_X]PComm_Attempt |
1 |
|
85 |
Productive Communication Weighted Raw Score |
The Productive Communication Weighted Raw Score.
|
[S_AZ_STU_AZELLA_X]PComm_Weighted_Score Blank if Productive Communication Attempted is N
|
3 |
|
86 |
Productive Communication Weighted Points Possible |
The Productive Communication Weighted Points Possible. |
[S_AZ_STU_AZELLA_X]PComm_Weighted_Points Blank if Productive Communication Attempted is N
|
3 |
|
87 |
Filler |
|
|
|
|
88 |
Productive Communication Proficiency Level |
The Productive Communication Proficiency Level:
|
[S_AZ_STU_AZELLA_X]PComm_Prof_Level |
1 |
|
89 |
Interactive Communication Attempted |
Indicates whether Interactive Communication is attempted. Valid values:
|
[S_AZ_STU_AZELLA_X]IComm_Attempt |
1 |
|
90 |
Interactive Communication Weighted Raw Score |
The Interactive Communication Weighted Raw Score. |
[S_AZ_STU_AZELLA_X]IComm_Weighted_Score Blank if Interactive Communication Attempted is N
|
3 |
|
91 |
Interactive Communication Weighted Points Possible |
The Interactive Communication Weighted Points Possible. |
[S_AZ_STU_AZELLA_X]IComm_Weighted_Points Blank if Interactive Communication Attempted is N
|
3 |
|
92 |
Filler |
|
|
|
|
93 |
Interactive Communication Proficiency Level |
The Interactive Communication Proficiency Level:
|
[S_AZ_STU_AZELLA_X]IComm_Prof_Level |
1 |
|
94 |
Language Attempted |
Indicate whether Language is attempted. Valid values:
|
[S_AZ_STU_AZELLA_X]Lang_Attempt |
1 |
|
95 |
Language Weighted Raw Score |
The Language Weighted Raw Score. |
[S_AZ_STU_AZELLA_X]Lang_Weighted_Score Blank if Language Attempted is N
|
3 |
|
96 |
Language Weighted Points Possible |
The Language Weighted Points Possible. |
[S_AZ_STU_AZELLA_X]Lang_Weighted_Points Blank if Language Attempted is N
|
3 |
|
97 |
Filler |
|
|
|
|
98 |
Language Proficiency Level |
The Language Proficiency Level:
|
[S_AZ_STU_AZELLA_X]Lang_Prof_Level |
1 |
|
99 |
Filler |
|||
|
100 |
Filler |
|||
|
101 |
Total Proficiency Scale Score |
The Total Proficiency Scale Score. |
[S_AZ_STU_AZELLA_X]Total_Prof_Score Blank if status code = 1, 2 |
4 |
|
102 |
Filler |
|
|
|
|
103 |
Reporting Cycle |
|
|
|
|
104 |
Special Test Version |
Indicates the special test version. Valid values:
|
[S_AZ_STU_AZELLA_X]Spec_Test_ver |
1 |
|
105 |
Adult Transcription |
Valid values:
|
|
|
|
106 |
Assistive Technology |
Indicates whether the student requires assistive technology. Valid values:
|
[S_AZ_STU_AZELLA_X]Assi_Assistive_tec |
1 |
|
107 |
Filler |
|
|
|
|
108 |
Sign Scripted Test Directions |
Indicates whether this is a Sign Scripted Test Directions. Valid values:
|
[S_AZ_STU_AZELLA_X]Sign_Test_dir |
1 |
|
109 |
PNP Answer Masking |
The PNP Answer Masking. Valid values:
|
[S_AZ_STU_AZELLA_X]PNP _Answer_mas |
1 |
|
110 |
PNP Line Reader |
The PNP Line Reader. Valid values:
|
[S_AZ_STU_AZELLA_X]PNP _Line_rea |
1 |
|
111 |
PNP Color Contrast |
The PNP Color Contrast. Valid values:
|
[S_AZ_STU_AZELLA_X]PNP _Color_con |
1 |
|
112 |
PNP Magnification |
The PNP Magnification. Valid values:
|
[S_AZ_STU_AZELLA_X]PNP _PNP_mag |
1 |
|
113 |
IEP Designated Magnification |
The IEP Designated Magnification. Valid values:
|
[S_AZ_STU_AZELLA_X]IEP _Designated_mag |
1 |
|
114 |
IEP Designated Line Reader |
The IEP Designated Line Reader. Valid values:
|
[S_AZ_STU_AZELLA_X]IEP _Line_rea |
1 |
|
115 |
IEP Large Print Test Book |
The IEP Large Print Test Book. Valid values:
|
[S_AZ_STU_AZELLA_X]IEP _Test_boo |
1 |
|
116 |
IEP Designated Color Overlay |
The IEP Designated Color Overlay. Valid values:
|
[S_AZ_STU_AZELLA_X]IEP _Color_ove |
1 |
|
117 |
IEP Designated Other ADE Approved |
The IEP Designated Other ADE Approved. Valid values:
|
[S_AZ_STU_AZELLA_X]IEP _ADE_app |
1 |
|
118 |
Proctor Name |
The Proctor Name. |
[S_AZ_STU_AZELLA_X]Proctor_name Populated for Special Paper Version |
100 |
|
119 |
Proctor Certified |
The Proctor Certified. Valid values:
|
[S_AZ_STU_AZELLA_X]Proctor_cert Populated for Special Paper Version |
1 |
|
120 |
Proctor Selected Magnification |
Indicates whether this is a Proctor Selected Magnification. Valid values:
|
[S_AZ_STU_AZELLA_X]Proc_Selected_mag Populated for Special Paper Version |
1 |
|
121 |
Proctor Selected Line Reader |
Indicates whether this is a Proctor Selected Line Reader. Valid values:
|
[S_AZ_STU_AZELLA_X]Proc_Line_rea Populated for Special Paper Version |
1 |
|
122 |
Proctor Selected Color Overlay |
Indicates whether this is a Proctor Selected Color Overlay. Valid values:
|
[S_AZ_STU_AZELLA_X]Proc_Color_ove Populated for Special Paper Version |
1 |
|
123 |
Proctor Selected Other ADE Approved |
Indicates whether this is Proctor Selected Other ADE Approved. Valid values:
|
[S_AZ_STU_AZELLA_X]Proc_ADE_app Populated for Special Paper Version |
1 |