SAM Import Errors Report
The SAM Import Errors report allows a review of the enrollment records as provided by the campus to SAM. Whether the data transmission uses Connect Once or flat file method, the SAM Import Error report is a great investigative tool to determine when the most recent enrollment records were submitted by the campus and if there were errors associated with any of those records.
By using the Show All Rows checkbox before selecting a line to analyze, the user can inspect in detail all rows submitted. Further detail is available after selection of a row by using the Click to display all data checkbox to expand the detail displayed for each enrollment record.
Carefully examine the Status and Status Detail columns to determine the cause of any error and the recommended support path. View the SAM Import Errors - Detail screen below.
- Select Reports > SAM Import Errors.
- Enter the start and end dates to search for import errors.
- Click Go.
If there are no enrollment records within the date range provided, a message "No Results Found" is displayed.
|Select||Use the Select link to provide details of that row. If there are “0” row errors SAM will return a “No row errors returned” message unless the “Show All Rows” checkbox is selected. All rows are displayed once this checkbox is used.|
|File Name||Identifies the name of the file.|
Identifies the status of the file. Statuses are:
Pending Validation – The file is currently being validated and is not complete or ready for review in this menu.
Success – File was submitted successfully and passed validation with no error rows detected
Error – Submitted file has passed validation and at least one error row was found.
|CreateDate||Date/Time file was submitted to SAM based on the time stamp in SAM file submitted.|
|FileCreateDate||Date the file was created.|
|FileVersion||Identifies the version of the file if a SAM file method is used. This field is blank if the campus uses Connect Once.|
|Rows||Identifies how many rows are in the file.|
|Row Errors||Identifies how many rows contain errors.|
- Click the Select link next to the entry to receive more detail on the errors or review all enrollment records by selecting the checkbox “Show All Rows” before clicking the Select link. After the results are displayed, check the “Click to display all data” box to expand the results to include more data on each enrollment record.
All fields described below with the exception of the Status field are values provided by the campus either through ConnectOnce or via SAM flat file submission.
|*Indicates a field that is only visible by checking the Click to display all data checkbox.|
|Store #||Identifies the store number.|
|Last Name||Identifies the student's last name.|
|*Middle Name||Identifies the student's middle name.|
|First Name||Identifies the student's first name.|
|StudentID||Identifies the student's ID number.|
|*SISUserID||Identifies the student’s Student Information System user ID.|
|Identifies the student's email address.|
|*Person Type||Identifies the person as either student or instructor.|
|*Campus||Campus name that should match the appropriate campus in CourseTracks.|
|Term||Identifies the term of the student’s enrollment record.|
|Division||Identifies the division (if used).|
|Department||Identifies the department.|
|Course||Identifies the course.|
|Section||Identifies the section of the course.|
|*Course Reference Number||Identifies the course reference number which may be used in place of DDCS matching.|
|Action||Identifies the action of the enrollment record. Actions are: A - Add the student to the DDCS specified. D- Drop the student from the DDCS specified.|
|*Student Pricing Model||If a Student Pricing model is used for the campus valid values are: FT – Full-Time PT – Part Time For a Course Pricing model this field is blank.|
|*Registration Date||The date/time of the student’s registration record.|
|Status||Error – (Brief description of error) Success – Data Moved to Transaction Tables|
|Status Detail||A detailed description of the error or of the successful action taken for records without error.|
|*Shipping Preference||Indication of shipping preferences are: S-Ship materials P- Pickup from bookstore|
|*Shipping Address Related Information||Address data including city, state and zip code.|
|*Phone Number||Phone numbers as provided or “0000000001” where not available.|