Looking for table for SBAC Interim assessment blocks.

Follow

Margarita Rodriguez

March 06, 2019 20:33

Does anyone know where this data is saved?

0

• Official comment

  

  Franck Reyherme March 07, 2019 00:32

   

  Roger that. In that case, the interim assessment blocks are in the exact same table as your summative casspp data. To hone in on those interim assessment blocks, you’ll need to filter by assessment type. Here’s an example:

  SELECT *
  FROM state_data_ca.caaspp_2018_ela
  WHERE "caaspp_2018_assessType" = 'INTERIM ASSESSMENT BLOCKS'
  

  Does that help?

  ​

  Comment actions Permalink
• 

  Franck Reyherme March 07, 2019 00:00

  Hi Margarita,

   

  Are you using SQL or custom reporting?

  0

  Comment actions Permalink
• 

  Margarita Rodriguez March 07, 2019 00:02

  Hi Franck!  I'm using SQL

  0

  Comment actions Permalink
• 

  Margarita Rodriguez March 07, 2019 00:34

  Immensely!  Thank you Franck, you are my hero

   

   

  0

  Comment actions Permalink
• 

  Franck Reyherme March 07, 2019 00:46

  Happy to help!

  0

  Comment actions Permalink
• 

  Margarita Rodriguez March 07, 2019 17:47

  Franck, 

  It appears 2018 tables has data for SY 17-18 but when I use 2019 i get this weird permission error

   

  

  0

  Comment actions Permalink
• 

  Franck Reyherme March 07, 2019 23:26

  That's totally normal.  All that means is your ODBC credentials/permissions were created before the 2019 tables were created.  When your ODBC credentials are created, we give you access to all existing tables, but when new tables are created (as they are every year for new years of state data), if you want to access these new tables, you'll have to submit a help ticket requesting that we refresh your credentials.  

  I know this is inconvenient, but it ensures the highest level of security for the sensitive data in your Illuminate database.  

  Please send an email to help@illuminateed.com asking us to refresh your ODBC credentials/permissions.  Feel free to CC me on the email.  We will refresh your ODBC access and then you'll have access to these tables as well!

  0

  Comment actions Permalink
• 

  Margarita Rodriguez March 07, 2019 23:57

  Thank you Franck.  You rock!

  0

  Comment actions Permalink

Please sign in to leave a comment.