...
This is a Health SUDS process where data stewards can modify degree mappings used to translate the Health Banner Degrees into SUDS degree codes for the annual ADM files produced by IT.
SUDS_InputDegree.xls has the mapping of Banner degree to SUDS Value. If 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.
has list of all banner degrees with a missing SUDS Value. This file is supplementary to the Health Banner Applicant Data Quality in the list of Degree Not Mapped for SUDS on the Highest Degree tab, but shows only the degrees that are unmapped.
Location of Files
\\hscetl\SUDS
...
- SUDS_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
- Must have a Banner Degree for each record.
- Must have a valid SUDS Value for every Banner Degree.
Identify New Degree Requiring Mapping
...
New Degree Update Process
...
- Go to the folder location.
- Open the SUDS_InputDegree.xls file.
- Add new row with the Banner Degree, suds mapping, banner description, suds description at the end of the file .
- The file should be saved.
- Make sure to close out of the excel file when finished.
...