Man pages for PHSKC-APDE/apde
Common functions used in APDE's work

add_indexAdd an index to a SQL table
apde_keyring_check_fCheck and Create Keyring if Needed
apde_keyring_set_fSet or Update a Keyring
apde_notify_address_create_fCreate a New APDE Notify Address
apde_notify_address_delete_fDelete an APDE Notify Address
apde_notify_addresses_get_fRetrieve All APDE Notify Addresses
apde_notify_address_get_fRetrieve a Specific APDE Notify Address
apde_notify_address_id_get_fGet APDE Notify Address ID
apde_notify_address_set_fUpdate an APDE Notify Address
apde_notify_fSend APDE Notification
apde_notify_list_get_fRetrieve APDE Notify List for a Message
apde_notify_list_set_fSet APDE Notify List for a Message
apde_notify_menu_fLaunch APDE Notify Menu
apde_notify_msg_get_fRetrieve a Specific APDE Notify Message
apde_notify_msg_id_get_fGet APDE Notify Message ID
apde_notify_msg_set_fSet or Update APDE Notify Message
apde_notify_msgs_get_fRetrieve APDE Notify Messages
apde_notify_set_cred_fSet Outlook Credentials for APDE Notify
copy_into_fCopy Data from the Data Lake to the Data Warehouse
create_db_connectionCreate Database Connection Function
create_tableCreate a SQL table
deduplicate_addressesClean up reference address tables
etl_qa_export_resultsExport tables and graphs of ETL QA pipeline results
etl_qa_final_resultsFinal QA results for ETL QA pipeline
etl_qa_initial_resultsInitial QA results for ETL QA pipeline
etl_qa_run_pipelineRun ETL Quality Assurance Pipeline
etl_qa_setup_configSet up configuration for ETL QA pipeline
external_table_check_fCompare external table to source table to find changes
load_df_bcp_fLoad an R Data.Frame to SQL Server Using BCP (Bulk Copy...
load_table_from_fileLoad a data file to a SQL table
load_table_from_sql_fLoad data from one SQL table to another
table_duplicate_delete_fDelete tables based on suffix
table_duplicate_fcopy a (smaller) SQL table from server to another
PHSKC-APDE/apde documentation built on April 14, 2025, 10:46 a.m.