Function reference • ideadata

Get connection functions Get connections to tables in IDEA’s warehouse. These functions return direct connections to as `tbl` objects and are ready to use with `dplyr` verbs
The workhorse function
`get_table()`	Get an arbitrary table from the data warehouse (more axccurate if database and schema are given)
PowerSchool-based descriptive data
`get_currently_enrolled_students()`	Connect to `Students` table on `PROD1` in `Schools` schema only pull currently enrolled students
`get_student_daily_attendance()`	Connect to `Students` table on `PROD1` in `Attendance` schema which has membership (i.e., enrollment) and attendance data
`get_student_engagement_attendance()`	Connect to `StudentEngagementAttendance` table on `PROD1` in `Attendance` schema which has the "learning environment" of students (i.,e remote vs in-person) for each day
`get_students()`	Connect to `Students` table on `PROD1` in `Schools` schema
`get_students_academic_summary()`	Connect to `StudentAcademicSummary` table on `PROD1` in `Schools` schema which has
`get_students_continuous_enrollment()`	Connect to `StudentsContinuousEnrollment` table on `PROD1` in `Attendance` schema which has the "learing environment" of students (i.,e remote vs in-person) for each day
`get_schools()`	Connect to `Schools` table on `PROD1` in `Schools` schema
`get_regions()`	Connect to `Regions` table on `PROD1` in `Schools` schema
Assessment Data
`get_iabwa()`	Connect to `IABWA` table on `PROD2` in `Assessments` schema
`get_renstar_math()` `get_renstar_reading()`	Connect to `StarMathV2` or `StarReadingV2` tables in `SRC_AR` on `RGVPDSD-DWSRC4`
Annual Employee Experience Survey (AEES) and Great Places to Work (GPTW) Data
`get_aees()` `get_aees_oe_questions()` `get_aees_oe_responses()` `get_aees_questions()` `get_aees_results()` `get_aees_sections()`	Connect to `ResultsView` View or other tables in `AEES` on `RGVPDRA-DASQL` which provides a tidy (i.e. a long ) view of non-OE responses from the 2020-21 AEES survey
`get_gptw()` `get_gptw_oe_questions()` `get_gptw_oe_responses()` `get_gptw_questions()` `get_gptw_results()` `get_gptw_sections()`	Connect to `ResultsView` View or other tables in `GPTW` on `RGVPDRA-DASQL` which provides a tidy (i.e. a long ) view of non-OE responses from the 2020-21 GPTW survey
Learning location data (i.e, remote vs in-school)
`get_learning_location()`	Connect to `LearningLocation` database `RGVPDRA-DASQL` which provides daily learning location (i.e, remote or in-person) for every student on ever day
Student Persistence
`get_persistence_code()`	Connect to `PersistenceCode` table in `Persistence` database on `RGVPDSD-DWPRD1`
`get_persistence_code_historical()`	Connect to `PersitenceCodeHistorical` (sic) table in `Persistence` database on `RGVPDSD-DWPRD1`
`get_persistence_historical()`	Connect to `PersistenceHistorical` table in `Persistence` database on `RGVPDSD-DWPRD1`
`get_persistence_reasons_codes()`	Connect to `PersistenceReasonsCodes` table in `Persistence` database on `RGVPDSD-DWPRDS`
Useful utilities
`setup_creds()`	Interactively update .Renviron file
`collector()`	Collect data from database to local environment piecemeal
`disconnect()`	Disconnect from a database in the IDEA data warehouse
`calc_elapsed_weeks()`	Calculate the weeks elapsed from a reference date
`calc_ps_termid()`	Calculate 4 digit PowerSchool TermID given first year of a school year
`get_db_url()`	retrieves database URL and server name
`generate_schema()`	Generates server.database.dbo schema string
Data about databases
`view_warehouse_metadata()`	View servers, schemas, databases, and tables currently available in IDEA's data warehouse
`warehouse_meta_data`	table level details of all databases in IDEA's data warehouse
Not very useful functions These are useful functions for the package internals, but are not very interesting for regular, intreractive use. Use these with caution!
`get_creds()`	Get's creds from environment variable
`update_uid()` `update_pwd()` `update_driver()`	Update IDEA_RNA_DB_UID in .Renviron file
`kinit()`	Checks/Gets Kereberos Ticket-Getting-Tickets are
`check_get_connection()`	Check if DB connections available and valid or create new one
`check_get_hidden_connection()`	Check "hidden" DB connections available and valid or create new one
`create_connection()`	Create connection to database
`check_macos_linux()`	Check if OS is *Nix flavored
`get_warehouse_meta_data()`	Gets warehouse meta data from R&A Documentation data base
`id_tables_in_dbs()`	Identify rows with given table name, database name, or schema in the MetaData table in the R&A's documentation database.

Reference

Get connection functions

The workhorse function

PowerSchool-based descriptive data

Assessment Data

Annual Employee Experience Survey (AEES) and Great Places to Work (GPTW) Data

Learning location data (i.e, remote vs in-school)

Student Persistence

Useful utilities

Data about databases

Not very useful functions