Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Testing Phase

Import File and Data Validation

Issue: Admit and App Totals do not align

This issue was resolved by adding the methodology for removing duplicate deferral apps from the pool, as well as including the DF admit to future status.

Object:  StoredProcedure [SPS].[dbo].[load_ept_table]

Line 271:
       SUM (CASE SUBSTRING (ac.Manual_Decision_Code,1,1) when 'A' THEN 1 ELSE 0 END) Admits,

Suggested Modification:

SUM (CASE WHEN ((SUBSTRING(app.[Manual_Decision_Code],1,1)='A') -- normal Admits
    OR app.[Manual_Decision_Code]='DF')             -- count DF (Admit to Future) as an admit in the applying term
    AND (app.[Decision_Reply_Code]<>'D' OR app.[Decision_Reply_Code] IS NULL)  -- ignore duplicate deferral apps (old method)
    THEN 1 else 0 END) Admits,

Issue: Headcount totals do not align

Known issues that are causing the difference between methodologies:

  • TSTA table is not fully aligned with PROD in the DEV environment.
    • Updating an individual record in SPAAMS aligned it on both sides. (C004161335)
  • SPS EPT code strips away cases where the 'NW' entering term has zero dollars in tuition, effectively stripping that person from all cohorts.
    • Updating the SPS procedure aligned some of the records.
  • No labels