SAM Reconciliation Report
The SAM Reconciliation Report is a very important tool for monitoring and managing all the order activity of an includED release cycle. The report becomes available once the Order Release Date has passed for the term selected and orders start flowing from SAM to SODA.
The reporting will contain entries for the term selected and any nested term created under the parent term once the relative Order Release Dates have passed. The report should contain one row per student per includED material to be delivered. For instance, one student enrolled in a course delivering 3 includED materials should represent 3 rows on the report.
The SAM Reconciliation report is most useful once it is exported into Excel. The sorting and filtering capabilities in Excel allow the user to review and analyze an includED fulfillment in a number of ways that can detect problems and measure the success of the process.
- Select Reports > SAM Reconciliation.
- Select the term you want included on the report.
-or-
Select the Display All Terms checkbox to display all terms.
The SAM Reconciliation grid is displayed.
Field Definitions| Field | Definition |
|---|---|
| Store Number | Store number identifier |
| Store Name | Store name |
| Term-Nested Term | Parent or nested term identifer |
| ACCESS ORD | Order release date from CourseTracks |
| Order Start Date | Order start date from CourseTracks |
| ACCESS LDTPD | Last day to process drops from CourseTracks for students to receive refunds |
| Order End Date | Order end date from CourseTracks |
| Class Start Date | Class start date from CourseTracks |
| Class End Date | Class end date from CourseTracks |
| Major Acct Name | Name on the major charge account from CARP |
| Major Acct # | Major charge account number from CARP |
| Customer Name | Customer name |
| Customer #/StudentID | Customer number or student ID number |
| Customer campus email | |
| DDCS | Division, department, course, and section identifier |
| Course Description | Description of the course from CourseTracks |
| Section Add Date | Date student was added to the section |
| Section Dropped Date | Date student was dropped from the section |
| SKU | Stock keeping unit (SKU) number from CourseTracks |
| SKU Description | SKU description from CourseTracks |
| Rental | Identifies whether the item is rentable or not, designated by Yes or No |
| Digital | Identifies whether the item is digital, designated by Yes or No. No indicates that the material delivered is a physical, print product. |
| Continuation | Identifies if the course is a continuation from a previous term, designated by Yes or No |
| Fulfilled Date | Date the orders were confirmed in SODA. Digital materials are automatically confirmed and this date populates once the process is complete. Print products require the store team to manually confirm the products in SODA before this date is populated. A blank in this field indicates orders that are not confirmed or may need to be reviewed in SODA as a possible exception. |
| SODA Order # | Identifies the SODA order number once the order has been confirmed in SODA. A blank in this field indicates orders that are not confirmed or may need to be reviewed in SODA as a possible exception. |
| WEB Order # | Identifies the web order number |
| Order Status | Provides visibility to where order is in the process. Note: See the Order Status Definitions in the SAM Reconciliation Report topic. |
| Return Date | Identifies date that a Follett ACCESS material was returned. Most stores use the POS to return materials which populates this field the day after the return is completed. Use this field to determine if there was a return of materials after a student dropped from their Follett ACCESS course. |
| Cancelled | Identifies if the order has been canceled in SODA or the course as a whole was canceled |
| Duplicate | Used to indicate if duplicate physical materials occur at the student level |
| Pricing Model Type | Displays the pricing model selected for the term – nested term |
| Student Type | Displays the pricing model code for the students for the term – nested term |
| Credit Hours(s) | Displays the number of credit hour(s) related to the section if a Credit Hour Pricing Model; if not, this column is blank. |
| Price Per Credit Hour | Displays the price per credit hour entered into the Credit Hour Pricing screen if a Credit Hour Pricing Model; if not, this column is blank. |
| Reg. Retail | Identifies the retail price of the item. This price may differ from the retail as defined in CourseTracks based on Follett ACCESS fee amount. If multiple materials are delivered, the Reg. Retail value may display an adjusted amount that allows them to total the fee amount. |
| Return Amount if Dropped | Identifies the amount of the returned item only if the material was returned. This amount is populated whether or not the student dropped from the course. |
| Total Cost of Student | If the campus is using a Student Fee model, this field contains the fee amount. |
| Total Student Charge | Total charge for the course section for each student |
| Opt-In Date | If the student opts-out and then opts back in, indicates when they opted back in |
| Opt-Out Date | If the student opts-out, indicates when they did |
| Dept Code | Identifies the department of the SKU |
| SKU Type | Identifies the course materials type of the SKU |
| Publisher | Identifies the publisher that provides the course materials |
| Download Provider | Identifies the digital provider that is delivering the materials |
| Duration | Identifies the duration in days of the digital material |
| ISBN | Identifies the ISBN in CourseTracks for the title |
| UPC | Follett unique identifier at the title level |
| Universal Indicator | Universal indicator value set in MTC |
| Pricing Indicator | Identifies what pricing indicator that was used from CourseTracks when the order was created: |
| Passcode | Identifies the passcode obtained from provisioning a digital material through COESP |
Order Status Definitions| Field | Description |
|---|---|
| In Process | Order has been created in SAM, but hasn't been sent to SODA or OMS. |
| Ordered | Order has been created in SAM and sent to SODA or OMS. |
| Fulfilled | SODA physical or digital order was successfully shipped and posted. |
| Refunded | SODA physical order was refunded successfully. |
| Canceled | SODA or OMS order was canceled successfully. |
| Email Sent | OMS digital order where an email was sent successfully, but the status of the order hasn't been received yet. |
| Email Failed | OMS digital order where an email was not sent successfully and the status of the order hasn't been received yet. |
Provisioning Successful | OMS digital order was successfully provisioned, but the status of the email hasn't been received yet. |
| Provisioning Successful and Email Not Required | OMS digital order was successfully provisioned and sending an email to the student is not required. |
| Provisioning Successful and Email Failed | OMS digital order was successfully provisioned, but the email to the student failed. |
| Provisioning Successful and Email Sent | OMS digital order was successfully provisioned and the email to the student was sent. |
| Provisioning Failed | OMS digital order provisioning failed. Order is listed in Manage Digital Orders with a Web Exception. |
| Revoking Successful | OMS digital order was refunded successfully. |
| Revoking Failed | OMS digital order refund has failed. Order is listed in Manage Digital Orders with a Web Exception. |
| Auto-Refunded | SODA order was refunded automatically. |
| Auto-Fulfilled | SODA order was fulfilled automatically. |
| Refund Rejected | SODA order refund sent from SAM, but was rejected in SODA. |
