Back to Home

Retro Sampling

1. Manual Pull and Load

If the feed source is not PMHS or Proclaim. If there is no population previous month.

Steps

1. Run "Check Population" part from Manual_Pull_(Feed Source Name).sql by using the filters specified in the script.
   • Manual_Pull_DentaCom.sql
   • Manual_Pull_PMHS.sql
   • Manual_Pull_PROC.sql
2. From SAM3.sql "Get strata update from SAM3" part, run the query and replace Update query under �Set StrataNo� and run with Alter table query.
3. From "GET Population" part, update the @SampleNo, copy the results and replace select query from SAM3_Projection.sql
4. Save the script as YYYYMMDD_SAMPLETITLE_Projection.sql and send out to Bud and Alexandra to be sent to DEVOPS.
5. After the script run, run "GET Projection" from SAM3.sql
6. From the "Get Claims" part, update the strata cursor to desired counts and run the query.
7. Copy the result, and paste into Load_To_SAM3_(PG if Sample Type is PG, E2E if E2E, UN if PA/FPG/CE2E).sql
   • Load To SAM3 E2E.sql
   • Load To SAM3 PG.sql
   • Load To SAM3 UN.sql
8. Update @SampleNo and @ReportMonth to the report month that's being loaded.
9. Save the script as the YYYYMMDD_SAMPLETITLE.sql and send out to Bud and Alexandra to be sent to DEVOPS.
10. Go into the inventory report and check if the audits are loaded.