LSACalculated.csv: unexpected Population IDs are reported for Universe 10 report row 55

[nataliesus]

Hi @MollyMcEvilley ,

According to Spec, ProjectID (Universe 10) report row 55 is required for Population IDs [50, 53, 1176, 1177, 1276, 1277] only.

LSACalculated.csv from Sample Output has a lot more Population IDs reported (i.e. 55, 56 etc) that shouldn't be there:

It looks like there is an issue in Sample Code step 9.4.1 so ((rv.Universe = 10 and rp.ByProject = 1) or rp.ByProject is NULL) should be replaced with if(rv.Universe = 10, rp.ByProject = 1, rp.ByProject is NULL) :

Could you please take a look?

Thank you!
Natalie

[nataliesus]

Hi @JulesABrown ,

I just wonder if there are any flags that report impossible combinations such as those described above.

[JulesABrown]

@nataliesus We do not have any flags about LSACalculated having "too many" rows at this time and don't have a plan to add them at this time. Unless the file gets so big that it can't be managed, there's no real harm in having more info about those pop groups.