External Institution Autofill Keyset Query

We populate the Institutions using the Following parameters:

We create a view in Colleague to pull information from the following tables: 

  • Institutions 
  • Corp_funds 
  • person 
  • address

We filter the 4 table combination with the following:

INST_TYPE != DNU
INST_FUND_BY != N
PERSON_STATUS != D

After this is compiled, we run a script that looks for the following:

INST_TYPE = '05', '07', '08', '10', '11', '15', 'COLL', 'UNPR', or 'UNPB'

 

Details

Article ID: 82797
Created
Wed 7/10/19 10:54 AM
Modified
Wed 7/10/19 2:51 PM