SB3 PowerSchool SIS Texas
SB3 PowerSchool SIS Texas
Breadcrumbs

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.

     

    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 

    Assessment Type

    Choose the assessment type.

    Administration Date

    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

    • Manual Import: Output file for Quick Import by District

    • Auto Import: Automatically import Student Portal Access Codes

    Test administration file from the State

    Browse and select the Test administration file from the State and then click Process File. 

    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