Summary: ODS MST_GPA results?
Description: According to the ODS Meta Data, the ODS MST_GPA table key and frequency is as follows:
One row per person per GPA time indicator (time based or not) per GPA group (cumulative or period) per academic study area (level) per GPA type (institution or transfer) per academic period. The above combination should then yield one result.
We, however, have a scenario where the above combination yields two results (versus one) for a particular person/pidm. Does that mean that our ODS MSTGPA table is being utilized/loaded improperly? We have traced the two records to the Student SHRTGPA table. However, the two records for the particular shrtgpagpatypeind, shrtgpapidm, shrtgpalevlcode, and shrtgpatermcode have different results for:
SHRTGPATRITSEQNO, SHRTGPAHOURSATTEMPTED, SHRTGPAHOURSEARNED, GPAHOURS, QUALITYPOINTS. The Activity Date is identical.