Projected Supply (Unblinded) report

As a clinical supply manager, this report helps you ensure that sites in your study have enough investigational product. This is especially useful to account for shutdown or non-shipment periods, when scheduled drug shipments typically stop.

Note:

The predicted numbers displayed in this report don't consider any dynamic visits or visit branches that haven't been triggered in a subject's visit schedule yet. The projection of kits is only based on a subject's scheduled visits and their current status in the study.

Modes

Available in all 3 modes: Testing, Training, and Production

Permission required to run the report

Any user who's assigned the Run the Supply Prediction Report permission can generate this report.

Filters

Tip:

Do you have to run the Projected Supplies (Unblinded) report at a specific time? You can schedule your report. For more information, see Schedule a report.

Filter	Description
Projection To Date	Note: You can only set projected data in this report for up to one year from the date of the generated report. Select the date for when your projection of supplies should end. For example, select any date in the future to see projected supplies from the current date until the selected date.
Project Locally Sourced Kits	Select Yes to view the projected kit count and projected supply need for locally sourced sites. Note: This filter is set to Yes by default. Select No to hide any projected supply quantity for locally sourced sites. The Projected Kit Count and Projected Need column data displays a value of zero (0).
File Type	Choose the only output type for the report: XLSX.

Filter

Description

Projection To Date

Note: You can only set projected data in this report for up to one year from the date of the generated report.

Select the date for when your projection of supplies should end.

For example, select any date in the future to see projected supplies from the current date until the selected date.

Project Locally Sourced Kits

Select Yes to view the projected kit count and projected supply need for locally sourced sites.

Note: This filter is set to Yes by default.
Select No to hide any projected supply quantity for locally sourced sites. The Projected Kit Count and Projected Need column data displays a value of zero (0).

File Type

Choose the only output type for the report: XLSX.

Field descriptions

Note:

Fields that don't have any corresponding values are marked as N/A in the report.
All dates and times in the report are displayed in the UTC format.
You can order columns in the report by Country or Site ID.

Table 2-1 Columns included in the report's header

Initial fields	Description
Customer Name	A customer's name used to purchase the cloud subscription.
Study Name	A study's ID as entered by the study manager when they created the study.
Mode	The mode in which you ran this report. For example, you may run a report in Testing mode to verify the data before going live with your study.
Report Generated By	Username of the user who generated this report.
Created Date	The date this report was run.
Projected Date	The projected time period as selected when generating this report.

Table 2-2 Columns included on the Sites tab

Fields in this report	Description
Country	A site's country as entered by the site manager when they created or last modified the site.
Site ID	A site's ID as entered by the site manager when they created the site. This column only displays the ID of an active site.
Site Name	A site's name as entered by the site manager when they created the site.
Subjects Screened Count	Displays the number of subjects that are screened or enrolled in a study but not randomized, screen failed, withdrawn, or completed.
Subjects Randomized Count	Displays the number of subjects that are randomized but not withdrawn or completed.
Resupply Type	Indicates the title of the resupply strategy.
Min Buffer	The minimum number of drug units needed to account for unpredictable events, such as new subjects who need to be randomized and lost or damaged supplies.
Max Buffer	The maximum number of drug units needed to account for unpredictable events, such as new subjects who need to be randomized and lost or damaged supplies.
Days Projected	Indicates the number of projected days that would require dispensation of kits.
Kit ID	The unique identifier of each kit in the study.
Kit Description	Indicates a kit's short description. This description is either visible (unblinded distribution) or hidden from site users based on the study design.
Locally Sourced	Indicates whether or not the kit is locally sourced.
Projected Kit Count	Indicates the number of kits required for dispensation during the projected time period of the report. This count includes the number of locally sourced kits and pooled kits.
Count of Available Kits	Indicates the number of available kits for the selected time period. This count doesn't includes sites that only dispense locally sourced kits.
Count In Transit	Indicates the number of kits that have a status of In Transit for the selected time period. This count includes the number of pooled kits included in a shipment with a status of Pending.
Projected Need	Indicates the number of kits that might be needed for the selected time period. In this number, kits with a status of Available and In Transit are considered, while kits with a status of Prequarantined are not considered. Note: While taking future dispensation visits into account, this number doesn't include any possible dose holds a subject may require.
Count of Temporarily Unavailable Kits	Indicates the number of kits that have a status of Temporarily Unavailable.
Count of Quarantined Kits	Indicates the number of kits that have a status of Quarantined.
Manufacturing Lot	Note: This column is displayed for each lot associated with kits in your study, at the end of the report file. Indicates a manufacturing lot's ID as entered by a clinical supply manager when they created the lot.
Available Count by Lot	Note: This column is displayed for each lot associated with kits in your study, at the end of the report file. Indicates the number of kits with a status of Available included in a specific lot.
Manufacturing Lot Expiration Date	Notes: This column is displayed for each lot associated with kits in your study, at the end of the report file. The report displays the manufacturing lot but if a blinded lot is also associated in your study, this column indicates the earliest expiry date of the blinded lot. Indicates the earliest expiry date of the manufacturing lot associated with the kits in your study.

Table 2-3 Columns included on the Country Tab

Fields in this report	Description
Country	A site's country as entered by the site manager when they created or last modified the site.
Subjects Screened Count	Displays the number of subjects that are screened or enrolled in a study but not randomized, screen failed, withdrawn, or completed.
Subjects Randomized Count	Displays the number of subjects that are randomized but not withdrawn or completed.
Days Projected	Indicates the number of projected dates that would require dispensation of kits.
Kit ID	The unique identifier of each kit in the study.
Kit Description	Indicates a kit's short description. This description is either visible (unblinded distribution) or hidden from site users based on the study design.
Projected Kit Count	Indicates the projected number of kits required for dispensation during the projected time period of the report. This count includes the number of locally sourced kits and pooled kits.
Count of Available Kits	Indicates the number of available kits for the selected time period. This count doesn't includes sites that only dispense locally sourced kits.
Count in Transit	Indicates the number of kits that have a status of In Transit for the selected time period. This count includes the number of pooled kits included in a shipment with a status of Pending.
Projected Need	Indicates the number of kits that might be needed for the selected time period. In this number, kits with a status of Available and In Transit are considered, while kits with a status of Prequarantined are not considered. Note: While taking future dispensation visits into account, this number doesn't include any possible dose holds a subject may require.
Count of Temporarily Unavailable Kits	Indicates the number of kits that have a status of Temporarily Unavailable.
Count of Quarantined Kits	Indicates the number of kits that have a status of Quarantined.
Manufacturing Lot	Note: This column is displayed for each lot associated with kits in your study, at the end of the report file. Indicates a manufacturing lot's ID as entered by a clinical supply manager when they created the lot.
Available County by Lot	Note: This column is displayed for each lot associated with kits in your study, at the end of the report file. Indicates the number of kits with a status of Available included in a specific lot.
Manufacturing Lot Expiration Date	Notes: This column is displayed for each lot associated with kits in your study, at the end of the report file. The report displays the manufacturing lot but if a blinded lot is also associated in your study, this column indicates the earliest expiry date of the blinded lot.

Table 2-4 Columns included on the Depot Tab

Fields in this report	Description
Country	A depot's country as entered by the clinical supply manager when they created or last modified the site.
Depot ID	A depot's ID as entered by the clinical supply manager when they created the depot.
Depot Name	A depot's name as entered by the clinical supply manager who created the depot.
Kit ID	The unique identifier of each kit in the study.
Kit Description	Indicates a kit's short description. This description is either visible (unblinded distribution) or hidden from site users based on the study design.
Count of Available Kits	Indicates the number of available kits for the selected time period.
Count of Temporarily Unavailable Kits	Indicates the number of kits that have a status of Temporarily Unavailable.
Count of Quarantined Kits	Indicates the number of kits that have a status of Quarantined.
Manufacturing Lot	Note: This column is displayed for each lot associated with kits in your study, at the end of the report file. Indicates a manufacturing lot's ID as entered by a clinical supply manager when they created the lot.
Available County by Lot	Note: This column is displayed for each lot associated with kits in your study, at the end of the report file. Indicates the expiry date of the manufacturing lot associated with the kits in your study.
Manufacturing Lot Expiration Date	Notes: This column is displayed for each lot associated with kits in your study, at the end of the report file. The report displays the manufacturing lot but if a blinded lot is also associated in your study, this column indicates the earliest expiry date of the blinded lot.