Skip to main content

IP Codes — By Unique Serial Number

# Ip Codes

Add and manage investigational product Serial Numbers in the ClinicalDataS IMP module for PSP-mode studies tracking by unique serial number. Manual entry, bulk import via Excel/CSV, and list columns.

Serial Numbers (PSP mode, By Unique Serial Number)​

Serial numbers are the individual tracking units for investigational product in PSP-mode studies configured with Tracking = By Unique Serial Number. Unlike IP Codes in Randomization mode, a serial number has no treatment-arm concept — PSP-mode studies are not randomized, so there is no Study Group to assign.

Navigate: IMP → Products → Serial Number

Screenshot placeholder

Screenshot pending

What this should show: the Serial Number list for a PSP-mode study, with the table columns described below.

Serial Number table columns​

ColumnDescription
Serial NumberUnique serial number identifier
ProductProduct this serial number is associated with
UnitUnit of measure
StatusCurrent status (Available, Dispensed, Returned, …)
WarehouseCurrent warehouse holding the unit
SiteSite that received the unit (if delivered)
MethodManual or Import — how the record was created
Expiration DateOnly shown when the study uses expiration tracking
Created OnDate the record was added

There is no Study Group column and no Last Updated On column on this screen.


Add Serial Number (manual)​

Click Add Serial Number to open the add dialog.

FieldBehavior
ProductRequired. Select the product this serial number belongs to
UnitPre-set from the product's default unit; cannot be changed from this form
Serial NumberRequired. Enter the unique serial number
Expiration DateOnly shown when the study uses expiration tracking; optional when shown

Click Submit to save the record.


Import Batch (bulk)​

For large numbers of serial numbers, use Import Batch to upload a CSV or Excel file.

  1. Click Import Batch
  2. In the dialog, click Download template to get the required column format — the template also includes a reference sheet listing the study's products and their valid units
  3. Fill the template with your serial numbers (one per row)
  4. Upload the filled file using the file selector
  5. Click OK to import — a success notification confirms the batch was accepted

After import, the Serial Number list updates immediately with all new records.

CSV / Excel template columns​

ColumnRequiredExample value
ProductYesMatches a product name in the study exactly
UnitNoIf left blank, the product's default unit is used
Serial NumberYesSN-001
Expiration DateNo31/12/2026

The import is rejected for any row whose Product value does not match a study product, or whose Unit value does not match a valid unit for that product.


Export​

Click the export icon in the toolbar to download the current Serial Number list as CSV or Excel for audit or verification.