Assessment Portal Access Code Extract and Import
On this page:
Introduction
This report extracts Student Portal Access Codes (PAC's) from the Cambium student test score reporting files. The Portal Access Code is required for parents to access their child's test score histories on the Texas Student Assessment Family Portal. A direct link to the Family Portal with single sign-on for parents is available in the PowerSchool Parent Portal.
Required Source Files
The input files for the Assessment Portal Extract and Import tool are the same student data reporting files as provided by the state for student test score results. The .txt version files for the following assessments must be used. The PAC import is not supported for the .csv version files.
- STAAR 3-8
- STAAR Alternate 2 3-8
- STAAR EOC
- STAAR EOC Alternate 2
- TELPAS
- TELPAS Alternate
Select one of these two Student Portal Access Code Import Options when running the report. Both options produce a zip file containing two files
- Manual Import: Output File for Quick Import by District (Quick Import File and Excluded Records File)
- Auto Import: Automatically Import Student Assessment Portal Codes (List of imported Students and Excluded Records File)
The Excluded Records file contains records with the following error messages.
Records flagged with validation errors are excluded from the Quick Import and Auto Import output files unless corrected. As needed, update the records in the source file and re-run the Import Portal Access Code Tool.
- Student Number not found in PowerSchool
- Unique ID not found in PowerSchool
- Duplicate records in file for same student
Once the PAC’s have been imported, you must enable this preference for each school to activate the single sign-on buttons in the PowerSchool Parent portal.
- Go to District, Schools/School Info, Additional Texas Data Collection, and Enable Texas State Assessment Portal Link (S_TX_SCH_SCHOOLS_X.ENABLE_ASSESSMENT_PORTAL)
The report and import process are updated to remove the encryption process for the student portal access codes.
Districts can continue to use this state report to import the student PAC’s from the .txt version of the student state assessment data reporting files.
Districts now also have the option of doing a direct import into PowerSchool using the Quick Import tool and a district-defined import file. This file must contain the local student number and the student PAC code; no other fields are required.
When using the Assessment Portal Access Code Extract and Import:
When the Manual Import option is selected, the CSV Quick Import output file now contains non-encrypted PAC’s as they appear in the state assessment files.
When the Auto Import option is selected, the PAC’s are imported into the target field without encryption.
Both options also include an Excluded Students file.
The Texas Family Portal single sign-on feature in the PowerSchool Parent Portal is also updated to remove the de-encryption routine when the log-on credentials are passed to the state assessment website.
Report Input
| Field | Description | |
|---|---|---|
| Choose the assessment type. | ||
Select the Assessment School Year. Note: December EOC re-tests belong to the prior school year. If importing results for December 2022, select the 2021-22 school year. | ||
| Student Portal Access Code Import Option |
| |
Note: If the Auto Import option was selected, student Portal Access Codes are automatically imported into PowerSchool and a confirmation file of the imported records is produced instead of a Quick Import file. | ||
Report Output
For help with report navigation and generation, see Generate Reports.
Quick Import File
Data Element | Description | [Table]Field Name | Data Type |
|---|---|---|---|
| Student Number | The local student number. | [S_TX_PAC_IMPORT_S]Student_Number | N/A |
| Test Type | The test type. | [S_TX_PAC_IMPORT_S]Test_Type | VarChar(15) |
| Test Date | The test date. | [S_TX_PAC_IMPORT_S]Test_Date | Date |
| Portal Access Code | Portal access code of the student. | [S_TX_PAC_IMPORT_S]Portal_Access_Code | VarChar(200) |
| Import File Row Number | The import file row number. | [S_TX_PAC_IMPORT_S]Import_File_Row_Number | Number |
| Include In Import | Include in import. | [S_TX_PAC_IMPORT_S]Include_In_Import | Boolean |
| Import Message | The import message. | [S_TX_PAC_IMPORT_S]Import_Message | VarChar(4000) |
| Import Filename | The import filename. | [S_TX_PAC_IMPORT_S]Import_Filename | VarChar(260) |
Excluded File
Data Element | Description | [Table]Field Name | Data Type |
|---|---|---|---|
| Student Number | The local student number. | [S_TX_PAC_IMPORT_S]Student_Number | N/A |
| Unique ID | The student's state unique identifier. | [Students]State_StudentNumber | Number(10) |
| Last Name | The student's last name. | [Students]Last_Name | Varcha(60) |
| First Name | The student's first name. | [Students]First_Name | Varcha(60) |
| Reason for Exclusion | Reason for Exclusion | [S_TX_PAC_IMPORT_S]Reason_For_Exclusion |