Get Serial Number History

Select the Queries drop-down in the left-hand panel.

• Retrieve a serial number's event history, which is a summary of each event performed on the serial number as it moves thorough the supply chain and includes the location, status, and transaction information for each event.
• Retrieve information about a serial number and the item it represents from the Serialized Operations Manager repository.

When scanning, entering, or uploading a file to populate serial numbers, each number must be:

• On a separate row.
• Without any special characters.
• In one of the formats below:

SGTIN Serial Numbers

Used for:

• Items
• Innerpacks
• Bundles
• Cases and Shippers

The format is the AI(01)(21) serial number in barcode format:

1. First is the 01 Application Identifier
2. Followed by the GTIN-14 number
3. Followed by the 21 Application Identifier
4. Followed by the serial number

   Example: 010088202401033921725368249416

SSCC Serial Numbers

Used for:

• Pallets
• Mixed cases

The format is the AI(00) serial number in barcode format:

1. First is the 00 Application Identifier
2. Followed by the SSCC-18 code

   Example: 00008820200000050254

China EDMC Codes

Used for:

• Items
• Innerpacks
• Bundles
• Cases and Shippers

The format is the full 20-digit China serial number, as in this example: 81102302020117515452

Watch how to preserve leading zeros!

• Serial Number - The parent or child serial number to run the query against. Displays only if the REQUEST SERIAL NUMBER HISTORY button is selected.

• Created On Or After - The start date for the report results. Default is the "Current Date 12:00 AM."
• Created On Or Before - The end date for the report results. Default is the "Current Date 11:59 PM."

• Date Created - The original report's creation date and time.
• File Name - Displays the name of the report file. Select the link in the File Name column of the results table to view the Serial Number Information for that particular serial number.
• File Size - Displays the size of the corresponding file.

• Serial Number - The serial number for the query.
• Encoding Type - The encoding format of the serial number.
• AI(01)+AI(21) for serialized GTIN and NTIN numbers
• AI(00) for SSCC codes
• CN_EDMC for China numbers
• Commissioning Location - The site-level SGLN of the location where the serial number was commissioned. Defaults to the parent company if no location is provided.
• Serial Number Status - The current serialization state of the serial number.
  • Commissioned - The serial number is associated to a lot and product.
  • Commissioned and Registered - The serial number is registered in the Owners repository and associated to a lot and product.
  • Deactivated - The serial number is deactivated. Only serial numbers in reserved or encoded states may be deactivated. If numbers have been commissioned, then they are either decommissioned or destroyed.
  • Decommissioned - The product no longer associates with a serial number.
  • Destroyed - The termination of a product and related serial numbers.
  • Encoded - The serial number is encoded. This state typically applies to label or carton pre-printing. This state comes after reserved and before commissioned.
  • Reserved - An assignment of the serial number's packaging location.
  • Unreserved - The removal of the serial number's packaging location assignment.
  • Commissioned - The product associates to a serial number and lot.
  • Commissioned and Registered - The product associates to a lot and a serial number that is registered in Owners repository.
• Item Status - The state of the serialized item.

  Only displays if Serial Number Status is not "decommission" or "destroy".

  • Available - The item is available for picking.
  • Blocked - The item is unavailable for picking.
  • Pending Receipt - The transfer of ownership is in an interim state because the shipment awaits receipt confirmation at the receiving location.
  • Picked - There is an item reservation against a specific outbound delivery indicating item picking is complete.
  • Received - There is an item reservation against a specific outbound delivery indicating items are received.
  • Shipped - The transfer of ownership is in an interim state because the shipment is in transit to the receiving location.
  • Under Investigation - The item is quarantined or in a holding state due to a product investigation. The serial number cannot be included in a sales shipment.
• Market Release Markets - A list of Target Markets that the serial number is released into for distribution.

  This field displays only if the product has been released into at least one market.

• Product Recall Markets - A list of Target Markets that the serial number has been recalled from.

  This field displays only if the product has been recalled from at least one market.

• Market Withdrawal Markets – A list of Target Markets that the serial number has been withdrawn from.

  This field displays only if the product has been withdrawn from at least one market.

• Item Code - The packaging level item code that associates with the serial number.
  • CN-Subtype Code
  • GS1 Company Prefix (for SSCCs)
  • GTIN-14
  • NTIN
• Lot Number - The lot number that associates with the Internal Material Code, Packaging Item Code, or Country Drug Code which identifies the serial numbers.

  SSCCs might not have a lot number.

• Expiration Date - The lot's expiration date.
• Manufacturing Date - The date of manufacture associated with the serial number.
• Packaging Level - The packaging level that associates with the serial number.
  • CA (Case / Shipper)
  • EA (Each)
  • PK (Inner Pack / Bundle)
  • PL (Pallet)
• Reason Code - A preset reason for the update.
  • Damaged – The product is damaged.
  • Defective - The product does not function as intended.
  • Dispensed - The product is dispensed.
  • Disposed – The product is disposed.
  • Expired - The product reached its expiration date.
  • Misplaced – The product is missing.
  • Inappropriately Stored - The product has been stored improperly and is no longer fit for sale.
  • Market Released – The product is released into one or more target markets for distribution.
  • Recalled - The product is recalled by the Pharmaceutical Manufacturer.
  • Repackaged - The product is repackaged from a different source product.
  • Returned - The product has been returned and cannot be resold.
  • Sampled – The product is sampled for quality testing.
  • Sampled - Archival - The product is sampled to store as a record.
  • Sampled - Clinical Study - The product is sampled for a clinical study.
  • Sampled - Customs Control - The product is sampled for inspection control by customs authorities.
  • Sampled - Marketing Demonstration - The product is used in a marketing demonstration.
  • Sampled by Authorities - The product is sampled by government authorities.
  • Sampled - Pharmaceutical Study - The product is sampled for a post-registration pharmaceutical study, to support submitted changes to a dossier.
  • Sampled - Federal Inspection - The product is sampled for federal inspection.
  • Sampled - Selective Control - The product is sampled by health authorities as needed to ensure quality standards.
  • Stolen – The product is stolen.
  • Spoilage - The product is spoiled due to exposure (e.g. heat, oxygen, moisture, microrganisms).
  • Withdrawn - The product is removed from the market by the Pharmaceutical Manufacturer.
  • Withdrawn - Experiment - The product is withdrawn from the market during the course of an experiment.
  • Other - The product is decommissioned or destroyed for a reason that is not listed.
• Package Size/Spec - The number of individual doses in the pack as defined in Product Master Data.
• Product Name – The name of the product as defined in Product Master Data.
• Product Description – Typically includes the product name, dosage, form, and the number of doses as defined in Product Master Data.
• Strength - The strength of the product (e.g. 100 mg) as defined in Product Master Data.
• Dosage Form - The from the product is dispensed in (e.g. tablet or pill) as defined in Product Master Data.

• Occurred - This column displays static text of both date and time of the event in DD Mmm YYYY xx:xx AM/PM GMT format.
• Event Details and Extensions - Certain descriptive labels in this column always display, but others might show a blank "--" or not display anything at all (see below for event-specific fields).
  • Event - Some fields that display for each Event are dependent on the type of Event. Each Event option below also lists the fields that display for that type of Event.
    • Commissioned
    • Packed
      • Parent Container - [Parent Container Number (link to run Get Serial Number Status search for Parent Number)]
    • Provisioned
    • Received

      • From- [Shipped From Business Name], [City], [State]

      • To - [Shipped To Business Name], [City], [State]
      • Distribution Type - [Shipment Type | Receipt Type]
        • Available Shipment Types:
        • Return - Export - A shipment of goods returned to the supplier, shipped from one country to another.
        • Return - In Country - A shipment of goods returned to the supplier, shipped within the same country.
        • Sale - Export - A sale and distribution made from one country to another.
        • Sale - In Country - A sale and distribution made within the same country.
        • Transfer - Export - A transfer within a company or with a Partner, such as 3PL or contract manufacturer/packager, made from one country to another.
        • Transfer - In Country - A transfer within a company or with a Partner, such as 3PL or contract manufacturer/packager, occurring within the same country.
        • Available Receipt Types:
        • Purchase - Import - A purchase into one country from another.
        • Purchase - In Country - A purchase within the same country.
        • Return - Import - A return into one country from another.
        • Return - In Country - A return within the same country.
        • Transfer - Import - A transfer into one country from another.
        • Transfer - In Country - A transfer within the same country.
    • Registered - The source product serial number was registered during repackaging.
    • Shipped

      • From - [Shipped From Business Name], [City], [State]

      • To - [Shipped To Business Name], [City], [State]
      • Distribution Type- [Shipment Type | Receipt Type]
        • Available Shipment Types:
        • Return - Export - A shipment of goods returned to the supplier, shipped from one country to another.
        • Return - In Country - A shipment of goods returned to the supplier, shipped within the same country.
        • Sale - Export - A sale and distribution made from one country to another.
        • Sale - In Country - A sale and distribution made within the same country.
        • Transfer - Export - A transfer within a company or with a Partner, such as 3PL or contract manufacturer/packager, made from one country to another.
        • Transfer - In Country - A transfer within a company or with a Partner, such as 3PL or contract manufacturer/packager, occurring within the same country.
        • Available Receipt Types:
        • Purchase - Import - A purchase into one country from another.
        • Purchase - In Country - A purchase within the same country.
        • Return - Import - A return into one country from another.
        • Return - In Country - A return within the same country.
        • Transfer - Import - A transfer into one country from another.
        • Transfer - In Country - A transfer within the same country.
    • Status Updated (includes all forms of status update functions)

      • Reason Code - The reason for the status update.

      • Update Type - [Update Type for the status update]
      • Description - [Reason Description Text] - If there is not a Reason Description, TraceLink does not display the Description field.
    • Repackaged - The source product was consumed and a new number was assigned to the product during repackaging.
    • Unpacked
      • Parent Container - [Parent Container Number (link to run Get Serial Number Status search for Parent Number)]
  • Business Step - The step within the business process at the time of the event (e.g. commissioning, destroying, packing, shipping, receiving).
  • Disposition - The status that results from the event (e.g. active, destroyed, in_transit).
  • Business Location - [Location GLN Identifier] [(Location Name)]

  • Last Delivery Number – The unique identifier of the shipment that the serial number is included in. The link navigates to the serial number's associated shipment on the View Submitted Delivery screen or receipt on the View Submitted Receipt screen, depending on serial number's Item Status.

    Displays one of the following delivery number types:

    • The shipment delivery number displays if the serial number's Item Status is Shipped, Picked, or if there is not a receipt delivery number.
    • The receipt delivery number displays if the serial number's Item Status is Available, Pending Receipt, Received, Blocked, Under Investigation, or if there is not an order delivery number.
    • When multiple deliveries are received in a single receipt, Delivery Number displays all delivery numbers contained in the receipt with a space as a separator.
  • Transactions - [BizTransaction type and value], such as PO A234567.
    • If a business message document for the event does not exist, TraceLink displays "--."
    • If there are multiple business message documents, TraceLink displays one document on each line.
  • Performed By - [First and Last Name | System ID]. Only displays if the First and Last Name of the user or system id that generates the event is available. If unavailable, TraceLink does not display the Performed By label.

Events are listed in this table, sorted by date in descending order.

1. Select the desired entity in the Show Data From drop-down at the top of the screen.
2. Select the REQUEST SERIAL NUMBER HISTORY button.

   The "Request Serial Number History" dialog box displays.

3. Enter the parent or child serial number in the Serial Number field.
4. Select the Submit button.

   The following message displays on the Serialized Operations Manager screen: “TraceLink is exporting the serial number history. The serial number history will be available in the table when it is ready.”

1. Select the desired entity in the Show Data From drop-down at the top of the screen.
2. Select the Created On Or After date from the date picker.
3. Select the Created On Or Before date from the date picker.
4. Select the Search button.

   The results table displays all available reports Reports already generated..

• Select the File Name link in the table.

  The View Serial Number History screen displays with the query results.

• Select the Export Results to CSV link above the table.

  The file downloads.

  See the Export a CSV File to Excel drop-down in the How-Tos.

Errors either display at the top of the screen or are found in Info Exchange (may vary):