Function reference • utDataStoR

All functions

create_sql_dir(): Generate Helper Functions

display_sql_with_comments(): Display sql with comments

make_headcount_sql(): Generate headcount Sql

make_retention_sql(): Generate Retention Sql

sql_fte(): Generate FTE SQL

sql_validate_buildings(): sql_validate_buildings will generate the standard sql query for pulling Building Validations from Edify. Validations are done through Edify.

sql_validate_courses(): sql_validate_courses will generate the standard sql query for pulling Course Validations from Edify. Validations are done through Edify.

sql_validate_graduation(): sql_validate_graduation will generate the standard sql query for pulling Graduation Validations from Edify. Validations are done through Edify.

sql_validate_rooms(): sql_validate_rooms will generate the standard sql query for pulling Rooms Validations from Edify. Validations are done through Edify.

sql_validate_student(): Generate Validation SQL

sql_validate_student_courses(): sql_validate_student_courses will generate the standard sql query for pulling Student Course Validations from Edify. Validations are done through Edify.

write_sql_file(): Write SQL Files Functions