Man pages for idea-analytics/ideadata
Tools and Utilities for accessing IDEA's 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... |
| 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... |
| check_macos_linux | Check if OS is *Nix flavored |
| collector | Collect data from database to local environment piecemeal |
| create_connection | Create connection to database |
| disconnect | Disconnect from a database in the IDEA data warehouse |
| generate_schema | Generates server.database.dbo schema string |
| get_aees | Connect to 'ResultsView' View or other tables in 'AEES' on... |
| get_creds | Get's creds from environment variable |
| get_currently_enrolled_students | Connect to 'Students' table on 'PROD1' in 'Schools' schema... |
| get_db_url | retrieves database URL and server name |
| get_gptw | Connect to 'ResultsView' View or other tables in 'GPTW' on... |
| get_iabwa | Connect to 'IABWA' table on 'PROD2' in 'Assessments' schema |
| get_learning_location | Connect to 'LearningLocation' database 'RGVPDRA-DASQL' which... |
| get_persistence_code | Connect to 'PersistenceCode' table in 'Persistence' database... |
| get_persistence_code_historical | Connect to 'PersitenceCodeHistorical' (_sic_) table in... |
| get_persistence_historical | Connect to 'PersistenceHistorical' table in 'Persistence'... |
| get_persistence_reasons_codes | Connect to 'PersistenceReasonsCodes' table in 'Persistence'... |
| get_regions | Connect to 'Regions' table on 'PROD1' in 'Schools' schema |
| get_renstar_math | Connect to 'StarMathV2' or 'StarReadingV2' tables in 'SRC_AR'... |
| get_schools | Connect to 'Schools' table on 'PROD1' in 'Schools' schema |
| get_student_daily_attendance | Connect to 'Students' table on 'PROD1' in 'Attendance' schema... |
| get_student_engagement_attendance | Connect to 'StudentEngagementAttendance' table on 'PROD1' in... |
| get_students | Connect to 'Students' table on 'PROD1' in 'Schools' schema |
| get_students_academic_summary | Connect to 'StudentAcademicSummary' table on 'PROD1' in... |
| get_students_continuous_enrollment | Connect to 'StudentsContinuousEnrollment' table on 'PROD1' in... |
| get_table | Get an arbitrary table from the data warehouse (more... |
| 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... |
| kinit | Checks/Gets Kereberos Ticket-Getting-Tickets are |
| pipe | Pipe operator |
| setup_creds | Interactively update .Renviron file |
| update_uid | Update IDEA_RNA_DB_UID in .Renviron file |
| view_warehouse_metadata | View servers, schemas, databases, and tables currently... |
| warehouse_meta_data | table level details of all databases in IDEA's data warehouse |
