get_ftvorgn_data: get_ftvorgn_data

In iancj88/msuopa: Utility Functions for the MSU OPA Team

Description

ftvorgn data is used to calculate organization hierarchy via the logical structure of the organization codes. This validation table is maintained by the finance team and regularly updated with new organization codes and org. titles. For this reason, it is recommended to use this function to pull the most up-to-date ftvorgn table data directly from Banner. Requires Banner logon credentials.

Usage

get_ftvorgn_data(opt_banner_conn)

Arguments

opt_banner_conn

an active banner connection object typically derived from get_banner_conn(). If not provided will create a temp connection

Value

a dataframe containing all FTVORGN table variables. Depreciated rows are removed leaving only the most recent record if more than one record exists for a single ftvorgn organization code

iancj88/msuopa documentation built on May 17, 2019, 7:07 p.m.