| add_arc_species_code | Adds arc_species_code for each animal in character vector id... |
| add_birth_date | Returns dataframe with POSIXct date vector of birth dates for... |
| add_colony | Returns dataframe with colony for each animal in character... |
| add_common_name | Returns dataframe with and additional column (common_name)... |
| add_death_date | Returns dataframe with POSIXct date vector of death dates for... |
| add_departure_date | Returns dataframe with POSIXct date vector of departure dates... |
| add_sex | Returns dataframe with sex for each animal in character... |
| alias_id_to_snprc_id | Converts an alias (alternate) animal Id to an animal Id. |
| begin_tran | Begins a transaction |
| commit_tran | Commits a database transaction |
| create_age_location_sex_species_view | Creates v_animal_age_location_sex_species as a view in animal... |
| create_Xhalfaversary | Create the database table 'animal.dbl.Xhalfaversary' |
| delete_database_record_by_object_id | Returns logical vector indicating TRUE if record was deleted. |
| delete_database_tbl | Returns TRUE if the database table was successfully deleted. |
| delete_id_from_tbl | Returns the number of rows deleted from a database table when... |
| delete_offspring_from_offspring_table | Returns the number of rows deleted from the offspring table |
| disable_trigger | Has the side effect of disabling a specific trigger as... |
| drop_Xhalfaversary | Drops Xhalfaversary table and returns TRUE if the database... |
| enable_trigger | Has the side effect of enabling a specific trigger as defined... |
| fill_halfaversary_tbl | Fill the database table 'animal.dbl.Xhalfaversary' |
| get_age_dist | Get the maximum age within a species for a specific date... |
| get_assignments_to_iacuc | Returns dataframe with the animals with a status of assigned,... |
| get_audit_proc_df | Returns dataframe with audit table data for... |
| get_audit_vitals_df | Returns dataframe with audit table data for audit_vitals... |
| get_audit_weight_df | Returns dataframe with audit_weight data of animals from... |
| get_average_number_of_cagemates | Returns the average number of cagemates each animal has for... |
| get_births_in_iacuc | Returns a dataframe containing the id, sex, and birth date of... |
| get_cagemates | Returns the cagemates and total number of days together for... |
| get_charge_account_table | Get charge_account table contents |
| get_column_names | Returns a character vector containing all of the column names... |
| get_common_name_for_arc_species_codes | Get common name for arc_species_codes |
| get_common_name_for_genus | Make a named vector to translate three letter genus and... |
| get_common_name_for_species_code | Returns a character vector of common names using a vector of... |
| get_dams_with_infants | Dams with infants within a specified date range of provided. |
| get_direct_ancestors | Get direct ancestors for supplied IDs. |
| get_dispositions_for_iacuc | Returns dataframe with the disposition code, disposition... |
| get_female_exposed_to_male_days | Get number of days females were exposed to fertile males. |
| get_first_offspring | Get the first offspring for animals of a specified sex and... |
| get_id_active_IACUC | Get IACUCs active for an animal on a specified date. |
| get_id_clinical_admit | Get clinical admissions active for an animal on a specified... |
| get_ids_having_specific_char | Returns dataframe with animals having a specific character in... |
| get_id_str | Returns the character string corresponding to the animal Id... |
| get_location_on_date | Get location from 'animal.dbo.location' for each animal on... |
| get_maintenance_iacuc | Get dataframe with maintenance IACUC protocols including... |
| get_max_age | Get the maximum age within a species for a specific date... |
| get_non_productive_animals | Get non-productive animals of a specified sex,... |
| get_number_of_cagemates | Returns the number of cagemates each animal has for each day... |
| get_object_ids_in_tbl | Returns a character vector of OBJECT_ID values from a... |
| get_object_ids_not_in_tbl | Returns a character vector of OBJECT_ID values from a... |
| get_proc_df | Get procedure data for animals within date ranges. |
| get_rearing | Get rearing code and rearing description for Ids provided. |
| get_relatives | Returns a data frame containing four columns: id, sire_id,... |
| get_siblings | Returns data frame with specified siblings for Ids provided. |
| get_table_names | Returns a character vector of table names for the database... |
| get_table_names_w_id_col | Returns a character vector of table names for the database... |
| get_tables_and_columns | Get tables and columns for a database connection. |
| get_tables_views_and_columns | Get tables, views, and columns for a database connection. |
| get_tables_with_data | Returns a dataframe with a character vector listing the table... |
| get_table_w_col | Returns a character vector of tables names for the database... |
| get_tran_count | Get TRANSACTION count |
| get_trigger_name | Returns a character vector with one trigger name af a... |
| get_vasectomized_males | Get vasectomized males of a specified arc_species_code that... |
| get_view_names | Returns a character vector of view names for the database... |
| get_vitals_df | Returns dataframe with vitals, date_tm of collection, user... |
| get_weight_df | Returns dataframe with weights, date_tm of collection, user... |
| has_id_column | Returns a logical vector indicating whether or not each table... |
| is_animal_alive | Returns logical vector indicating if id is animal in master... |
| is_animal_id | Returns logical vector indicating if animal ids are in... |
| is_bad_animal_id | Returns the proported animal Id(s) that cannot be found in... |
| is_database_tbl | Returns TRUE if table exist and FALSE if it does not |
| is_database_view | Returns TRUE if view exist and FALSE if it does not |
| is_location | Returns logical vector indicating if a location exists. |
| is_primate_id | Returns logical vector indicating if animal ids represent a... |
| remove_housekeeping_columns | Returns a character vector with the column_names vector... |
| rollback_tran | Rollsback a transaction, returns FALSE if there is not a... |
| row_exist | Returns logical vector of length one indication whether or... |
| rows_with_id_in_table | Returns integer vector of length one indicating the number of... |
| update_ids_in_tables_by_id | Returns the number of rows updated when old Ids are replaced... |
| Xhalfaversary_insert | Inserts animal Ids of all primates with each half birth day... |
