12.0

What's Changed

• Feature/ciid 6615 by @jwheaton2963 in #378
• Feature/ciid 6885 by @AEMJohnnyCunningham in #388
• Feature/ciid 6530 by @AEMJohnnyCunningham in #389
• Staging table changes + by @AEMJohnnyCunningham in #390
• more changes for 12.0 by @AEMJohnnyCunningham in #391
• Feature/ciid 6851 by @AEMJohnnyCunningham in #392
• 12.0 changes. by @svuyuru in #393
• added long-term status by @AEMJohnnyCunningham in #394
• table cleanup by @AEMJohnnyCunningham in #395
• Feature/ciid 6850 by @jwheaton2963 in #397
• Updated for test prep for new files, fixed bug in runEndToEndTest by @AEMGenapeth in #398
• Feature/ciid 6888 by @AEMJohnnyCunningham in #399
• issue with VersionScripts by @AEMJohnnyCunningham in #400
• clean out duplicates coming from CedsOptionSetMapping by @AEMJohnnyCunningham in #401
• Feature/ciid 6572 by @WeiningLu2 in #396
• Feature/ciid 6585 by @svuyuru in #402
• Feature/ciid 6615 by @jwheaton2963 in #403
• clean up the junk table population by @AEMJohnnyCunningham in #404
• Feature/ciid 6567 by @WeiningLu2 in #405
• The test view files for FS220 by @WeiningLu2 in #406
• Test view files for FS221 by @WeiningLu2 in #408
• Feature/ciid 6595 by @svuyuru in #407
• cleanup by @AEMJohnnyCunningham in #411
• Feature/ciid 6565 by @svuyuru in #412
• Test view files: NorD. Remove join Staging.ProgramParticipationTitleI by @WeiningLu2 in #410
• Feature/ciid 6615 by @jwheaton2963 in #409
• Feature/ciid 6615 by @jwheaton2963 in #413
• Feature/ciid 6616 by @aemnathanclinton in #414
• Updated JunkTablePopulationScript with new N or D fields. by @aemnathanclinton in #415
• Fix creation issue by @AEMJohnnyCunningham in #416
• Resolve issue with JTPS. by @aemnathanclinton in #417
• NorD Assessment Changes Done. by @jwheaton2963 in #419
• Added logic for NeglectedOrDelinquentStatus by @jwheaton2963 in #420
• View changes for testing by @jwheaton2963 in #421
• Feature/ciid 6560 by @svuyuru in #418
• remove ExitOutcomeDate by @AEMJohnnyCunningham in #423
• Feature/ciid 6616 by @aemnathanclinton in #422
• Fixed fact type by @jwheaton2963 in #424
• Standardized naming convention for end to end tests by @jwheaton2963 in #425
• Test views for reports C224 and 225 by @AEMGenapeth in #426
• Various changes by @jwheaton2963 in #427
• Feature/ciid 6849 by @AEMJohnnyCunningham in #428
• Fixed fact type by @jwheaton2963 in #429
• add school year to NorD Fact view by @AEMJohnnyCunningham in #430
• Fixed reference to column that was deleted from fact table. by @jwheaton2963 in #431
• Feature/ciid 6616 by @aemnathanclinton in #432
• Feature/ciid 6615 by @jwheaton2963 in #433
• Added additional columns as needed by @jwheaton2963 in #434
• Feature/ciid 6616 by @aemnathanclinton in #435
• Final changes to get everything to work. by @jwheaton2963 in #436
• clean up by @AEMJohnnyCunningham in #437
• More debugging & updated views for Assessment 224 and 225. by @aemnathanclinton in #438
• Feature/ciid 6616 by @aemnathanclinton in #439
• Final test changes and opening them up in Test_DMC by @AEMJohnnyCunningham in #440
• changes for UI migrations by @AEMJohnnyCunningham in #441
• cleanup for running migrations by @AEMJohnnyCunningham in #442
• Feature/ciid 6616 by @aemnathanclinton in #443
• cleanup by @AEMJohnnyCunningham in #444
• Add LeaId so we can exclude on Operational Status by @AEMJohnnyCunningham in #445
• fix the fix by @AEMJohnnyCunningham in #446
• Build out the fact views for 226 by @AEMJohnnyCunningham in #448
• Feature/ciid 6616 by @aemnathanclinton in #447
• assessment testing by @AEMJohnnyCunningham in #449
• This was created several months ago but never got into version 11.4. … by @jwheaton2963 in #450
• Removing this outdated procedure to avoid confusion. by @jwheaton2963 in #451
• CIID-4799 by @WeiningLu2 in #452
• Removed references to Staging.ValidationErrors by @jwheaton2963 in #454
• Fix by @jwheaton2963 in #453
• fix 029 test by @AEMJohnnyCunningham in #455
• fix the membership migration by @AEMJohnnyCunningham in #456
• add exclusions for 129 by @AEMJohnnyCunningham in #458
• add file specs to FactTypeDescripion in DimFactTypes by @AEMJohnnyCunningham in #459
• trying to get past Quoted_Identifier issues by @AEMJohnnyCunningham in #460
• Feature/ciid 6912 by @AEMJohnnyCunningham in #461
• test cleanup by @AEMJohnnyCunningham in #462
• working on failed tests by @AEMJohnnyCunningham in #464
• CIID-6512 by @WeiningLu2 in #463
• Fixed view and now test cases match. by @jwheaton2963 in #465
• CIID-6925 : c035 fix. by @svuyuru in #466
• CIID-6898 : Modified the date format. by @svuyuru in #467
• clean up 118 test by @AEMJohnnyCunningham in #468
• Feature/ciid 5224 by @svuyuru in #469
• CIID-6918 : FS 129 Metadata. by @svuyuru in #470
• Feature/ciid 6883 by @aemnathanclinton in #472
• Deduplicate students correctly by @AEMJohnnyCunningham in #471
• CIID-6900 : Membership data changes. by @svuyuru in #473
• remove nord statuses from junk table population by @AEMJohnnyCunningham in #474
• CIID-6931 : Fix Miscellaneous migration issues. by @svuyuru in #475
• Exclude Reportable Programs for 052 by @AEMJohnnyCunningham in #476
• Fix Build Issues. by @svuyuru in #478
• Feature/ciid 6947 by @svuyuru in #479
• CIID-6931 : Migration Changes. by @svuyuru in #480
• Fix Assessment Fact Type Description. by @svuyuru in #481
• Cleaning up the staging table script by @AEMJohnnyCunningham in #482
• Fix issue with selecting from Staging.StateDetail by @AEMJohnnyCunningham in #477
• Feature/ciid 6960 by @svuyuru in #483
• CIID-6962 : Update Fact Type Description. by @svuyuru in #484
• handle NULL FTE in Staff migration by @AEMJohnnyCunningham in #486
• CIID-6929 : Update c129 report. by @svuyuru in #485
• Add the 11.4 hotfix changes by @AEMJohnnyCunningham in #487
• Update reportable program logic for 052 by @AEMJohnnyCunningham in #488
• Fix the view for c086 by @AEMJohnnyCunningham in #489
• update the utility to use the new metadata table by @AEMJohnnyCunningham in #490
• Add CohortYear and CohortGradYear to FactK12StudentCounts by @AEMJohnnyCunningham in #491
• Feature/ciid 4886 by @svuyuru in #493
• Set the FactTypeId in DataMigrationTasks by @AEMJohnnyCunningham in #492
• Add 052 exclusion logic to 033 by @AEMJohnnyCunningham in #494
• CIID-5657 : Use new toggle questions for c009 files. by @svuyuru in #496
• fix isnull default value for staff fte by @AEMJohnnyCunningham in #495
• Add cohort and cohortGradution Years to Staging-to-RDS code by @AEMJohnnyCunningham in #497
• Fix the logic for 059 by @AEMJohnnyCunningham in #498
• CIID-6985 : Metadata Population by @svuyuru in #500
• Feature/ciid 7019 by @svuyuru in #501
• Feature/ciid 7019 by @svuyuru in #502
• Correct issue with multiple years of data in StateDetail by @AEMJohnnyCunningham in #503
• Handle LEA grades for schools that are Reportable Programs by @AEMJohnnyCunningham in #504
• need to add the changes to version scripts by @AEMJohnnyCunningham in #506
• Fix homeless date handling for DimLeas and DimK12Schools by @AEMJohnnyCunningham in #507
• Added delete for unused sections in Toggle. by @jwheaton2963 in #505
• Fix version scripts by @AEMJohnnyCunningham in #508
• fix cleanup_grades_offered utility by @AEMJohnnyCunningham in #510
• CIID-7063: Change FactType for C207 by @WeiningLu2 in #509
• Initial checkin by @jwheaton2963 in #499
• Feature/ciid 7042 by @AEMJohnnyCunningham in #511
• Handle formatting in org phone numbers by @AEMJohnnyCunningham in #512
• update version scripts by @AEMJohnnyCunningham in #513
• update the 029 test for these changes by @AEMJohnnyCunningham in #514
• CIID-7130 : Generate 12.0 release. by @svuyuru in #515
• Remove duplicate questions by @AEMJohnnyCunningham in #516
• remove 150 and 151 from TitleIIIELOct by @AEMJohnnyCunningham in #517
• correct file specs 150 and 151 by @AEMJohnnyCunningham in #518
• bug fixes by @AEMJohnnyCunningham in #519
• Remove GO Statements in scripts. by @svuyuru in #520
• correct upgrade issue for v12 by @AEMJohnnyCunningham in #522
• V12.0 Release by @aemnathanclinton in #523

Full Changelog: 11.4...12.0