PSSR_State_StuNum_ImportLog (ver 14.9.0)
This table is a standalone table used to store the results of the BC PEN import process.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 14.9.0 | Number (10,0) | Primary key for the table. |
UserID | 14.9.0 | Number (10,0) | The user ID from the Users table for the person running the import process. |
SchoolID | 14.9.0 | Number (10,0) | The school ID from the import file for the school the student attends. |
| StudentNumber | 14.9.0 | Number (10,0) | The local PowerSchool Student Number contained in the import file used to match to [Students]Student_Number. |
| LineNumber | 14.9.0 | Number (10,0) | Contains the line (row) number from the original import file that this log entry is about. |
| ImportDate | 14.9.0 | Timestamp | The date and time the data row was imported into PowerSchool. |
| ImportText | 14.9.0 | Varchar2 (2000) | Displays the full row of data from the original import file for reference. |
| ErrorLog | 14.9.0 | Varchar2 (2000) | Displays the reason the data could not be imported if the import failed for that row. |
| Status | 14.9.0 | Varchar2 (10) | Success or Failure message showing the import status for this row of data from the import file. |