Montana AIM Career and Technical Education Collection – Fall or EOY
Contents
Introduction
This report includes records of students that are CTE concentrators or participants in an approved Montana Pathway program at the end of the school year. It also provides records of follow-up information on graduate students who were CTE Concentrators from the previous school year.
The report is run for the current school year. However, it selects CTE students from the previous or the current school year depending on the Fall (previous year students) or the EOY collection (current year students) collection.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to the selection criteria for analysis when the report does not return the correct records.
Student Selection - Fall
The report selects records from the [Students] and [ReEnrollments] tables for students who were enrolled in the previous year based on the following criteria:
The student must have been a CTE Concentrator.
The date contacted must be between 10/1/YYYY and 12/31/YYYY of the current school calendar.
For example, if the current school year is 2021-2022, the contact must have occurred between 10/1/2021 and 12/31/2021.
Student Selection - EOY
The report selects records from the [Students] table for students who are enrolled in the current year based on the following criteria:
The student must be enrolled in a Montana Pathway.
The student must be either a CTE concentrator or a participant.
The students must be in high school grade levels 9 through 12.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Students to Include | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students before running the report. |
Destination | Choose the destination for the report file from the pop-up menu:
|
Processing Options | Choose a time to run the report from the pop-up menu:
|
Specific Date/Time | Enter a date using the format mm/dd/yyyy or mm-dd-yyyy to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM : 05. |
School Year | Choose the school year for the reporting period from the pop-up menu. The school year is dynamically populated based on the term selected at the top of the page. To change the term, click Term at the top of the page and choose the appropriate term from the pop-up menu. |
Calendar Number | Enter the school calendar number. If the school has more than one calendar, this value indicates which calendar is used for this report. |
Collection Type | Select Fall or EOY from the list. |
| Include Column Header | Select Yes or No. If you select Yes, the report will extract the column header names. |
Report Output
The fields in the report output are described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # | Data Element | Description | [Table]FieldName | Field Type | Field Length |
1 | Record Type | The file type abbreviation. Always “CE” | Extracted as ‘CE’ | CE | 2 |
2 | District Number | This is the unique system number assigned by the OPI. This is not the Legal Entity (LE) Number. This is the district number in PowerSchool. See the AIM - Achievement In Montana website to identify your District Number, Reporting Entity Number, and School Number. | [Prefs]Value where [Prefs]Name=districtnumber | String | 4 |
3 | Student’s State ID | The unique nine-digit state-assigned student ID. | [Students]State_StudentNumber | String | 9 |
4 | Student’s Local ID | The locally assigned student number. This field is not required. | [Students]Student_Number | String | 15 |
5 | Last Name | The student’s legal last name. This field is not required. | [Students]Last_Name | String | 50 |
6 | First Name | The student’s legal first name. This field is not required. | [Students]First_Name | String | 50 |
| 7 | Pathway | The Career and Technical Education Pathway the student is following. AM: Advanced Manufacturing AFN: Agriculture, Food and Natural Resources AMC: Agriculture, Mechanics and Construction AAC: Arts, A/V Technology, Communication BM: Business Management DCFC: Design and Construction (FCS) DCIT: Design and Construction (ITE) ED: Education FI: Finance HP: Health Profession HT: Hospitality and Tourism HS: Human Services IT: Information Technology MK: Marketing STEM: Science, Technology, Engineering and Mathematics TDL: Transportation, Distribution, and Logistics WF: Welding and Fabrication | [S_MT_STU_Academics_X]PathwayIndicator | ||
8 | Concentrator | The student’s CTE Concentrator status. | [S_MT_STU_Academics_X]CTEInd | String | 1 |
| 9 | Single Parent | Indicates the CTE student is unmarried or legally separated and has custody or joint custody of a minor child(ren) or is pregnant. | [S_MT_STU_Demographics_X] StudentSingleParent | ||
| 10 | Pathway Credits | Indicates the CTE student's Pathway Credits. | [S_MT_STU_Academics_X]Pathway_Credits | ||
| 11 | District Credits | The credits earned for pathway in the district. | [S_MT_STU_Academics_X]Pathway_Credits_District | ||
| 12 | Non-District Credits | The credits earned for pathway outside the district. | [S_MT_STU_Academics_X]Pathway_Credits_NonDistrict | ||
| 13 | l Number | The unique school number assigned by the OPI. This is the OPI School Number in PowerSchool on the Edit School page. | [S_MT_SCH_X]OPISchoolNumber | String | 4 |
14 | Calendar Number | The school calendar number. If the school has more than one calendar, this value indicates which calendar is used for this report. The value is entered on the report page at runtime. | Set to the value entered at report run time. | Number | 3 |
15 | Student’s State ID | The unique nine-digit state-assigned student ID. | [Students]State_StudentNumber | String | 9 |
16 | Student’s Local ID | The locally assigned student number. This field is not required. | [Students]Student_Number | String | 15 |
17 | Last Name | The student’s legal last name. This field is not required. | [Students]Last_Name | String | 50 |
18 | First Name | The student’s legal first name. This field is not required. | [Students]First_Name | String | 50 |
19 | CTE Concentrator | The student’s CTE Concentrator status. Indicates if the student is a Concentrator in the pathway. Student must have earned 2 credits or more to be considered a Concentrator, if not, they are considered a Participant. | [S_MT_STU_Academics_X]CTEInd | String | 1 |
| 20 | Pathway Credits | Total CTE credits earned in a pathway. This is a combination of total district credits plus any out of district credits. Credits must equal Pathway Credits total. If a pathway record already exists for the student and contains credits and you are adding credits to that pathway, include cumulative credits in this total. | Calculated | String | 4 |
| 21 | District Credits | Total number of credits the student earned for the pathway within the current district. | [S_MT_STU_Academics_X]District_Credits | String | 4 |
| 22 | Non-District Credits | Total number of credits the student earned for the pathway in schools outside of the current district. If a pathway record already exists for the student and contains credits and you are adding credits to that pathway, include cumulative credits in this total. | [S_MT_STU_Academics_X]Non_District_Credits | String | 4 |
| 23 | Dual Enrollment Credits | Total Dual Enrollment credits earned in the pathway. | String | 4 | |
| 24 | Work Based Learning Credits | Total Work Based Learning credits earned in the pathway. | String | 4 | |
| 25 | Filler | Filler | N/A | 4 | |
| 26 | Year | The school calendar year. This value is reported from the last day of the full year on the Years & Terms page. For 2021-2022, this is 2022. | Terms | Number | 4 |