SSID Request Import (Utah)

PATH: UT State Reporting > SSID Request Import

Search Term: SSID Request Import

The SSID Request Import allows districts to import student identifier information from the State.

Importing Logic

  • Updates the Student State ID for each student in the file.
  • Matches on Last Name, First Name, Local Student Number (LEA Student Number)
  • When Match on Protected Identity is checked on the extract editor, logic compares the Protected Identity Information > Last Name and First Name when one exists for a student, in addition to the student's Local Student Number.
  • The imported file must be in CSV format.
  • When a student cannot be matched from the import file, a line number and validation/error message is provided.
  • When more than one student is matched in Infinite Campus from the Import file, a line number and validation/error message is provided and the tool does not update the student information.

Tool Rights

Users must have a least R(ead) tool rights assigned for this import in order to import files.

Importing the File

  1. Mark the Match on Protected Identity checkbox to have logic compare the Protected Identity Information > Last Name and First Name when one exists for a student, in addition to the student's Local Student Number. This checkbox is optional.
  2. Click Choose File and select the file from your local hard drive or network. 
  3. Once the file is selected, the file name should appear on the import editor. Click Upload. A report will appear indicating any errors or issues encountered. 

Report Data Elements

This is the upload format that will be imported in CSV format:

Seq

Data Element Label

Business Rules

Data Source GUI Path

Format

1File Line NumberFile Line NumberReturns the value from the Request file.8, Numeric
2SSIDUpdates the student's State Student IdentifierUpdates from the imported file: Census > People > Demographics > Person Identifiers > Student State ID10, Numeric
3School YearThe reporting school year – Such as "2005"Reports the calendar End Year.4, Numeric
4Last Name

The reporting student's last name.

Returns the value from the Request file.100, Alpha
5First Name

The reporting student's first name.

Returns the value from the Request file.100, Alpha
6Middle Name

The reporting student's middle name.

Returns the value from the Request file.100, Alpha
7Birth DateMinimum age is 0, maximum age is 24Returns the value from the Request file.10, MM/DD/YYYY
8GenderGenderReturns the value from the Request file.M, F
9LEA NumberLEA numberReturns the value from the Request file.3, Alphanumeric
10School NumberLEA School NumberReturns the value from the Request file.4, Alphanumeric
11LEA Student NumberLEA definedReturns the value from the Request file.10, Alphanumeric
12Request TypeIndicates the Request Type:
  • N-New
  • R-Retrieve
  • V-Verify
  • U-Update
Returns the value from the Request file.N, R, U, V
13Row StatusRow Process StatusCode provided by the State indicating either blank (no error), E (error), P (posted) or X (cancelled).2
14Error CodeRow Error CodeCode provided by the State.4, Numeric
15Error DescriptionRow Error DescriptionDescription provided by the State.255, Alpha/Numeric
16Process Date & Time

Date and time that the SSID was posted or canceled in the SSID system

Date and time provided by the State.YYYY/MM/DD hh:mm:ss