Back to Home

Inventory Management

1. Reallocation On Demand

Although there is an auto-reallocation job scheduled on the last day of the feed, the inventory needs to be refilled due to, not having enough for the strata as the audits get deleted.

Prerequisites

1. If the audit is E2E, PA, or CE2E, Bud schedules reallocation
2. PBC only needs to do this for PG and FPG

Steps

1. Open PG_Rellocation.sql PG_Reallocation.sql for PG sample type, FPG_Reallocation.sql for FPG Sample type.
2. Update report month.
3. Update SampleNo from the select query.
4. Save the script as the YYYYMMDD_SAMPLETITLE.sql and send out to Bud and Alexandra to be sent to DEVOPS.
5. Go into the inventory report and check if the audits are loaded.