Versions Compared

Old Version 8

changes.mady.by.user Kalpana Rupani

Saved on

compared with

New Version Current

changes.mady.by.user Thomas Reed

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Replaced HSCETL with TUP-SAPETLPROD.FOREST.USF.EDU

Description

This is a Health SUDS process where

...

data stewards can modify

...

SUDS_InputDegree.xls has the mapping of Banner degree to SUDS Value.  If a new degree shows up in Banner that is not mapped to an equivalent SUDS degree it will show up in the Health Banner Applicant Data Quality in the list of Degree Not Mapped for SUDS on the Highest Degree tab.  To map a new degree to suds open the SUDS_InputDegree.xls file and add a new row that has the Banner Degree, the SUDS mapping, the Banner Description and the SUDS description.  Make sure to close out of the excel file when finished. 

...

degree mappings used to translate the Health Banner Degrees into SUDS degree codes for the annual ADM files produced by IT.

Location of Files

...

\\

...

The AD group IT BIA HSCETL SUDS Share-Modify has permissions to view and modify files in the share.

TUP-SAPETLPROD.FOREST.USF.EDU\SUDS

The above shared drive folder has the following sub-foldersfiles:

    • Loading Area - Folder where the data files need to be placed for loading.
    • Required File Format - 
    • Image RemovedSUDS_InputDegree.xls - File that is used by SUDS to map the degrees. Do not add or remove columns from this file.
    • SUDS_OutputDegree.csv - Secondary listing of currently unmapped Health Banner degree codes.

Rules for Data

  1. Must have a Banner Degree for each record.
  2. Must have a valid SUDS Value for every Banner Degree.

Identify New Degree

...

Requiring Mapping

  1. Open the HBDQ-Applicant Information report in Power BI.

  2. Go to the Highest Degrees tab.

  3. Filter the page for the most recent run month and your program.

  4. Select the bar in the Degree Not Mapped for SUDS visualization.

  5. The list of unmapped degrees will appear in the Applicant Details table at the bottom of the report.

New Degree Update Process

  1. Go to the folder location.
  2. Open the SUDSthe SUDS_InputDegree.xls  filexls file.
  3. Add new row that has banner degreewith the Banner Degree, suds mapping  mapping, banner description, suds description  at the end of the file .
  4. The file should be  saved. 
  5. Make sure to close out of the excel file when finished. 

...